DBA Data[Home] [Help]

APPS.GR_WF_UTIL_PVT dependencies on GR_ITEMS_REQUESTED

Line 241: INSERT INTO gr_items_requested

237: IS
238:
239: begin
240:
241: INSERT INTO gr_items_requested
242: (
243: MESSAGE_ICN,
244: ORGANIZATION,
245: FROM_ITEM,

Line 1313: FROM gr_items_requested

1309: l_to_item VARCHAR2(40);
1310:
1311: CURSOR cur_get_details IS
1312: SELECT organization, from_item, to_item
1313: FROM gr_items_requested
1314: WHERE message_icn = p_message_icn;
1315:
1316: BEGIN
1317:

Line 1385: delete from gr_items_requested where message_icn = p_message_icn;

1381:
1382: /* start the Workflow process */
1383: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,
1384: itemkey => l_itemkey);
1385: delete from gr_items_requested where message_icn = p_message_icn;
1386:
1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: wf_core.context ('GR_REG_ITEM_REQ_WF',