DBA Data[Home] [Help]

APPS.ICX_LOAD_REQ_INTERFACE dependencies on DUAL

Line 26: select po_ri_dist_sequence_s.nextval into l_dist_seq_id from dual;

22: -- fnd_client_info.set_org_context(to_char(l_org_id));
23:
24: for prec in get_cart_line_id(l_cart_id,l_org_id) loop
25:
26: select po_ri_dist_sequence_s.nextval into l_dist_seq_id from dual;
27: select po_requisitions_interface_s.nextval into l_trans_id from dual;
28:
29: insert into po_requisitions_interface
30: (TRANSACTION_ID ,

Line 27: select po_requisitions_interface_s.nextval into l_trans_id from dual;

23:
24: for prec in get_cart_line_id(l_cart_id,l_org_id) loop
25:
26: select po_ri_dist_sequence_s.nextval into l_dist_seq_id from dual;
27: select po_requisitions_interface_s.nextval into l_trans_id from dual;
28:
29: insert into po_requisitions_interface
30: (TRANSACTION_ID ,
31: INTERFACE_SOURCE_CODE ,