DBA Data[Home] [Help]

APPS.RCV_INSERT_FROM_INL dependencies on DUAL

Line 136: FROM dual;

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

Line 140: FROM dual;

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

Line 253: FROM dual;

249: END;
250:
251: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
252: INTO l_interface_transaction_id
253: FROM dual;
254:
255: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
256: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
257: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);