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 472: select sysdate into x_sys_date from dual;

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

Line 596: FROM sys.dual;

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

Line 1815: FROM sys.dual;

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

Line 2838: FROM sys.dual;

2834:
2835:
2836: SELECT rcv_interface_groups_s.nextval
2837: INTO x_group_id
2838: FROM sys.dual;
2839:
2840:
2841: if x_allow_inv_dest_receipts is NULL then
2842: x_allow_inv_dest_receipts := 'N';

Line 3789: FROM sys.dual;

3785: aname => 'REQUESTER_ID');
3786:
3787: SELECT rcv_interface_groups_s.nextval
3788: INTO x_group_id
3789: FROM sys.dual;
3790:
3791: OPEN Porcpt_Shipment for
3792: SELECT po_header_id,
3793: po_line_location_id,

Line 3941: from dual;

3937: itemkey => itemkey,
3938: aname => 'PO_NUM_REL_NUM');
3939: select sysdate
3940: into x_sys_date
3941: from dual;
3942:
3943: -- Create a new item key
3944: x_WF_ItemKey := to_char(x_po_header_id) || ';' ||
3945: to_char(x_requester_id) || ';' ||