DBA Data[Home] [Help]

APPS.RCV_INSERT_FROM_INL dependencies on DUAL

Line 138: FROM dual;

134: asn_debug.put_line ('ship line group id: '||p_int_rec(i).ship_line_group_id);
135:
136: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL
137: INTO l_header_interface_id
138: FROM dual;
139:
140: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
141: INTO l_group_id
142: FROM dual;

Line 142: FROM dual;

138: FROM dual;
139:
140: SELECT RCV_INTERFACE_GROUPS_S.NEXTVAL
141: INTO l_group_id
142: FROM dual;
143:
144: l_notice_creation_date := SYSDATE;
145: l_transaction_type := 'NEW';
146: l_processing_status_code := 'PENDING';

Line 279: FROM dual;

275:
276:
277: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
278: INTO l_interface_transaction_id
279: FROM dual;
280:
281: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
282: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
283: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);