DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on RCV_HEADERS_INTERFACE

Line 121: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into rcv_headers_interface');

117: RAISE no_data_found;
118: END IF;
119:
120: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
121: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into rcv_headers_interface');
122: END IF;
123:
124: -- populate the rcv transactions header.
125: SELECT rcv_interface_groups_s.NEXTVAL INTO x_request_group_id FROM dual;

Line 131: INSERT INTO rcv_headers_interface (

127: l_hdr_interface_id.EXTEND(l_shipment_num.COUNT);
128:
129: FOR k IN l_shipment_num.FIRST ..l_shipment_num.LAST
130: LOOP
131: INSERT INTO rcv_headers_interface (
132: header_interface_id,
133: group_id,
134: ship_to_organization_id,
135: expected_receipt_date, last_update_date,

Line 141: VALUES (rcv_headers_interface_s.NEXTVAL,

137: created_by, validation_flag, processing_status_code,
138: receipt_source_code, transaction_type,
139: shipped_Date,
140: shipment_num)
141: VALUES (rcv_headers_interface_s.NEXTVAL,
142: x_request_group_id,
143: l_to_org_id,
144: SYSDATE,SYSDATE,
145: fnd_global.user_id,fnd_global.login_id,SYSDATE,