DBA Data[Home] [Help]

APPS.ICX_LOAD_REQ_INTERFACE dependencies on PO_REQUISITIONS_INTERFACE

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 ,

Line 29: insert into po_requisitions_interface

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 ,
32: SOURCE_TYPE_CODE ,
33: REQUISITION_TYPE ,