APPS.RCV_TRX_INTERFACE_INSERT_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 173: CURSOR C IS SELECT rowid FROM RCV_TRANSACTIONS_INTERFACE

169: X_from_locator_id NUMBER DEFAULT NULL, --Added bug # 6529950
170: X_lcm_shipment_line_id NUMBER DEFAULT NULL, -- lcm changes
171: X_unit_landed_cost NUMBER DEFAULT NULL -- lcm changes
172: ) IS
173: CURSOR C IS SELECT rowid FROM RCV_TRANSACTIONS_INTERFACE
174: WHERE interface_transaction_id = X_Interface_Transaction_Id;
175:
176:
177:

Line 180: CURSOR C2 IS SELECT rcv_transactions_interface_s.nextval FROM sys.dual;

176:
177:
178:
179:
180: CURSOR C2 IS SELECT rcv_transactions_interface_s.nextval FROM sys.dual;
181:
182: BEGIN
183: if (X_Interface_Transaction_Id is NULL) then
184: OPEN C2;

Line 189: INSERT INTO RCV_TRANSACTIONS_INTERFACE(

185: FETCH C2 INTO X_Interface_Transaction_Id;
186: CLOSE C2;
187: end if;
188:
189: INSERT INTO RCV_TRANSACTIONS_INTERFACE(
190: interface_transaction_id,
191: group_id,
192: last_update_date,
193: last_updated_by,

Line 563: from rcv_transactions_interface RTI

559: */
560:
561: select count(count(vendor_site_id))
562: into x_site_id_count
563: from rcv_transactions_interface RTI
564: where RTI.group_id = x_group_id
565: group by vendor_site_id;
566:
567:

Line 578: from rcv_transactions_interface RTI

574: if (x_site_id_count = 1) then
575:
576: select distinct vendor_site_id
577: into x_vendor_site_id
578: from rcv_transactions_interface RTI
579: where RTI.group_id = x_group_id;
580:
581: IF (X_ADD_RECEIPT = 'NEW') THEN
582: hdr_vendor_site_id := x_vendor_site_id;