DBA Data[Home] [Help]

APPS.POS_ASN dependencies on DUAL

Line 1016: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_request_id from dual;

1012:
1013: PROCEDURE create_rcv_header IS
1014: BEGIN
1015:
1016: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_request_id from dual;
1017:
1018: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_header_id from dual;
1019:
1020: insert into rcv_headers_interface

Line 1018: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_header_id from dual;

1014: BEGIN
1015:
1016: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_request_id from dual;
1017:
1018: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_header_id from dual;
1019:
1020: insert into rcv_headers_interface
1021: (HEADER_INTERFACE_ID ,
1022: GROUP_ID ,

Line 1130: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_line_id from dual;

1126: BEGIN
1127:
1128: FOR c_rec in c_lines LOOP
1129:
1130: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_line_id from dual;
1131:
1132: insert into rcv_transactions_interface
1133: ( INTERFACE_TRANSACTION_ID ,
1134: HEADER_INTERFACE_ID ,