APPS.PORCPTWF dependencies on DUAL

Line 167: FROM sys.dual;

163: BEGIN
164:
165: SELECT rcv_interface_groups_s.nextval
166: INTO x_group_id
167: FROM sys.dual;
168:
169: if x_allow_inv_dest_receipts is NULL then
170: x_allow_inv_dest_receipts := 'N';
171: end if;

Line 474: select sysdate into x_sys_date from dual;

470: Process_Auto_Receive(x_po_header_id,
471: x_requester_id,
472: x_exp_receipt_date);
473: ELSE
474: select sysdate into x_sys_date from dual;
475:
476: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||
477: to_char(x_requester_id) || ';' ||
478: to_char(x_sys_date,'DD-MON-YYYY:HH24:MI');

Line 598: FROM sys.dual;

594: BEGIN
595:
596: SELECT rcv_interface_groups_s.nextval
597: INTO x_group_id
598: FROM sys.dual;
599:
600: if x_allow_inv_dest_receipts is NULL then
601: x_allow_inv_dest_receipts := 'N';
602: end if;

Line 1818: FROM sys.dual;

1814: aname => 'NTF_TRIGGERED_DATE');
1815:
1816: SELECT rcv_interface_groups_s.nextval
1817: INTO x_group_id
1818: FROM sys.dual;
1819:
1820:
1821: if x_allow_inv_dest_receipts is NULL then
1822: x_allow_inv_dest_receipts := 'N';

Line 2883: FROM sys.dual;

2879:
2880:
2881: SELECT rcv_interface_groups_s.nextval
2882: INTO x_group_id
2883: FROM sys.dual;
2884:
2885:
2886: if x_allow_inv_dest_receipts is NULL then
2887: x_allow_inv_dest_receipts := 'N';

Line 3849: FROM sys.dual;

3845: aname => 'REQUESTER_ID');
3846:
3847: SELECT rcv_interface_groups_s.nextval
3848: INTO x_group_id
3849: FROM sys.dual;
3850:
3851: OPEN Porcpt_Shipment for
3852: SELECT po_header_id,
3853: po_line_location_id,

Line 4001: from dual;

3997: itemkey => itemkey,
3998: aname => 'PO_NUM_REL_NUM');
3999: select sysdate
4000: into x_sys_date
4001: from dual;
4002:
4003: -- Create a new item key
4004: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||
4005: to_char(x_requester_id) || ';' ||