DBA Data[Home] [Help]

APPS.AP_XML_INVOICE_INBOUND_PKG dependencies on DUAL

Line 278: select ap_p2p_inbound_notification_s.nextval into l_item_key from dual;

274: ap_debug_pkg.print('Y','Creating adhoc role(-)');
275: --
276: -- Creating a workflow process
277: --
278: select ap_p2p_inbound_notification_s.nextval into l_item_key from dual;
279: ap_debug_pkg.print('Y','Creating a workflow process(+)');
280: WF_ENGINE.createProcess('P2P',l_item_key, 'PROCESS_FOR_NOTIFICATION');
281:
282: ap_debug_pkg.print('Y','Creating a workflow process(-)');

Line 678: select ap_p2p_inbound_notification_s.nextval into l_item_key from dual;

674: ap_debug_pkg.print('Y','Creating adhoc role(-)');
675: --
676: -- Creating a workflow process
677: --
678: select ap_p2p_inbound_notification_s.nextval into l_item_key from dual;
679: ap_debug_pkg.print('Y','Creating a workflow process(+)');
680: WF_ENGINE.createProcess('P2P',l_item_key,
681: 'PROCESS_FOR_NOTIFICATION');
682:

Line 694: from dual;

690:
691: select NVL(TO_NUMBER(DECODE(SUBSTRB( USERENV('CLIENT_INFO'),1,1),' ',
692: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
693: into l_org_id
694: from dual;
695:
696: if (l_org_id is not null) then
697: l_temp_string := l_temp_string ||
698: '('||mo_utils.get_ledger_name(l_org_id) ||')';