APPS.CSD_INTERNAL_ORDERS_PVT dependencies on RCV_TRANSACTIONS

Line 124: -- populate the rcv transactions header.

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;
126:
127: l_hdr_interface_id.EXTEND(l_shipment_num.COUNT);
128:

Line 163: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into rcv_transactions_interface');

159: csd_receive_util.get_employee_id (fnd_global.user_id, l_emp_id);
160:
161:
162: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
163: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into rcv_transactions_interface');
164: END IF;
165:
166: -- 3. insert into rcv transactions interface table.
167: l_intf_txn_id.EXTEND(l_shipment_header_id.COUNT);

Line 166: -- 3. insert into rcv transactions interface table.

162: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
163: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Inserting into rcv_transactions_interface');
164: END IF;
165:
166: -- 3. insert into rcv transactions interface table.
167: l_intf_txn_id.EXTEND(l_shipment_header_id.COUNT);
168:
169: FOR i IN l_shipment_header_id.FIRST ..l_shipment_header_id.LAST
170: LOOP

Line 171: INSERT INTO rcv_transactions_interface

167: l_intf_txn_id.EXTEND(l_shipment_header_id.COUNT);
168:
169: FOR i IN l_shipment_header_id.FIRST ..l_shipment_header_id.LAST
170: LOOP
171: INSERT INTO rcv_transactions_interface
172: (interface_transaction_id,
173: header_interface_id,
174: GROUP_ID,
175: transaction_date,

Line 222: VALUES (rcv_transactions_interface_s.NEXTVAL,

218: shipment_header_id,
219: shipment_line_id,
220: org_id
221: )
222: VALUES (rcv_transactions_interface_s.NEXTVAL,
223: l_hdr_interface_id(i),
224: x_request_group_id,
225: SYSDATE,
226: l_quantity(i),

Line 1830: rcv_transactions rt

1826: FROM csd_product_transactions cpt,
1827: po_requisition_lines_all prl,
1828: rcv_shipment_headers rsh,
1829: rcv_shipment_lines rsl,
1830: rcv_transactions rt
1831: WHERE cpt.product_transaction_id = p_product_txn_id
1832: AND cpt.req_header_id = prl.requisition_header_id
1833: AND rsl.requisition_line_id = prl.requisition_line_id
1834: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 1920: -- find out the transacted quantity from the rcv_transactions.

1916: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1917: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Updating csd_product_transactions.received_quantity');
1918: END IF;
1919:
1920: -- find out the transacted quantity from the rcv_transactions.
1921: SELECT SUM(quantity)
1922: INTO l_received_quantity
1923: FROM rcv_transactions
1924: WHERE group_id = x_request_group_id

Line 1923: FROM rcv_transactions

1919:
1920: -- find out the transacted quantity from the rcv_transactions.
1921: SELECT SUM(quantity)
1922: INTO l_received_quantity
1923: FROM rcv_transactions
1924: WHERE group_id = x_request_group_id
1925: AND transaction_type = 'RECEIVE';
1926:
1927: UPDATE csd_product_transactions SET quantity_received = (