EGO_ITEM_PUB not working
HI Guys,
When I am running following code from Oracle Applications, its not working but within PL/SQL, it works fine:
--select * from fnd_user where upper(user_name) like '%ALI%S%';
DECLARE
l_item_tbl_typ ego_item_pub.item_tbl_type;
x_item_tbl_typ ego_item_pub.item_tbl_type;
x_return_status VARCHAR2 (100);
x_msg_count NUMBER;
x_message_list error_handler.error_tbl_type;
BEGIN
fnd_global.apps_initialize (20081--21752
, 51886
, 401
);
l_item_tbl_typ (1).transaction_type := ego_item_pub.g_ttype_update;
l_item_tbl_typ (1).inventory_item_id := 960614;
l_item_tbl_typ (1).organization_id := 172;