APPS.RCV_TRX_INTERFACE_INSERT_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 175: CURSOR C IS SELECT rowid FROM RCV_TRANSACTIONS_INTERFACE

171: X_unit_landed_cost NUMBER DEFAULT NULL, -- lcm changes
172: X_project_id NUMBER DEFAULT NULL, -- Bug 9226303
173: X_task_id NUMBER DEFAULT NULL -- Bug 9226303
174: ) IS
175: CURSOR C IS SELECT rowid FROM RCV_TRANSACTIONS_INTERFACE
176: WHERE interface_transaction_id = X_Interface_Transaction_Id;
177:
178:
179:

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

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

Line 191: INSERT INTO RCV_TRANSACTIONS_INTERFACE(

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

Line 569: from rcv_transactions_interface RTI

565: */
566:
567: select count(count(vendor_site_id))
568: into x_site_id_count
569: from rcv_transactions_interface RTI
570: where RTI.group_id = x_group_id
571: group by vendor_site_id;
572:
573:

Line 584: from rcv_transactions_interface RTI

580: if (x_site_id_count = 1) then
581:
582: select distinct vendor_site_id
583: into x_vendor_site_id
584: from rcv_transactions_interface RTI
585: where RTI.group_id = x_group_id;
586:
587: IF (X_ADD_RECEIPT = 'NEW') THEN
588: hdr_vendor_site_id := x_vendor_site_id;