Page 1 of 1

Defaulting Rules using PL/SQL API

Posted: Fri May 02, 2008 1:10 am
by Sarvasiddi
Hi,

I am working on OM Defaulting Rules using PL/SQL API as my Source Type. But PL/SQL API will take arguments like Package name, function name and attribute code. For this I wrote one custom package. But my function is accepting two arguments only. 1. database_object_name and attribute_code. But I want to pass inventory_item_id as one more argument. Can any one suggest me, Is it possible to pass one more argument.

Regards,
Sateesh Kumar S

Posted: Sat May 31, 2008 11:25 am
by superarcan
Hi, i have same problem [:D]
I solve this with help from here
http://forums.oracle.com/forums/thread. ... &tstart=29
http://forums.oracle.com/forums/message ... ID=2478124
this help:

Code: Select all

l_line_type_rec := oe_order_cache.load_line_type (ont_line_def_hdlr.g_record.line_type_id);
l_item_id:= ONT_LINE_DEF_HDLR.g_record.inventory_item_id;
with the right change.
have fun

PS I register to this forum just to write this [}:)] with 1 mounth of delay.