APPS.QA_SAMPLING_PKG dependencies on QA_RCV_LOT_SER_TEMP

Line 89: -- Bug 3229571. This procedure populates the qa_rcv_lot_ser_temp temp

85:
86: END upd_insp_coll_dtl_result;
87:
88:
89: -- Bug 3229571. This procedure populates the qa_rcv_lot_ser_temp temp
90: -- table with the lot and serial info from supply tables.
91: -- Called from launch_shipment_action_int ().
92:
93: PROCEDURE populate_lot_serial_temp(p_transaction_id IN NUMBER) IS

Line 132: insert into qa_rcv_lot_ser_temp

128:
129: -- The value for valid_flag is passes as 1 initally to indicate that the
130: -- record is valid.
131:
132: insert into qa_rcv_lot_ser_temp
133: (rcv_txn_id,
134: lot_num,
135: serial_num,
136: quantity,

Line 175: from qa_rcv_lot_ser_temp

171: l_qty_rem NUMBER;
172:
173: CURSOR lot_ser_dtl IS
174: select quantity
175: from qa_rcv_lot_ser_temp
176: where rcv_txn_id = p_transaction_id
177: and nvl(lot_num, '@@') = nvl(l_lot_number, '@@')
178: and nvl(serial_num, '@@') = nvl(l_serial_number, '@@');
179:

Line 229: update qa_rcv_lot_ser_temp

225: -- If the qty is not zero, update, the remaining qty onto the temp table.
226:
227: IF (l_qty_rem = 0) THEN
228:
229: update qa_rcv_lot_ser_temp
230: set valid_flag = 2
231: where rcv_txn_id = p_transaction_id
232: and nvl(lot_num, '@@') = nvl(l_lot_number, '@@')
233: and nvl(serial_num, '@@') = nvl(l_serial_number, '@@');

Line 237: update qa_rcv_lot_ser_temp

233: and nvl(serial_num, '@@') = nvl(l_serial_number, '@@');
234:
235: ELSE
236:
237: update qa_rcv_lot_ser_temp
238: set quantity = l_qty_rem
239: where rcv_txn_id = p_transaction_id
240: and nvl(lot_num, '@@') = nvl(l_lot_number, '@@')
241: and nvl(serial_num, '@@') = nvl(l_serial_number, '@@');

Line 293: from qa_rcv_lot_ser_temp

289:
290:
291: CURSOR lot_ser_cur IS
292: select lot_num, serial_num, quantity
293: from qa_rcv_lot_ser_temp
294: where rcv_txn_id = p_parent_txn_id
295: and valid_flag = 1;
296:
297:

Line 302: -- the lot and serial info from the qa_rcv_lot_ser_temp temp table.

298: BEGIN
299:
300: -- Assigning rcv_transaction_id of the inspection record to a local variable.
301: -- The parent transaction id value is stored in p_parent_txn_id to retrieve
302: -- the lot and serial info from the qa_rcv_lot_ser_temp temp table.
303:
304: l_rti_txn_id := p_transaction_id;
305:
306:

Line 536: -- and serial info for the receiving txn onto qa_rcv_lot_ser_temp.

532:
533: post_insp_coll_details(p_collection_id);
534:
535: -- Bug 3229571. Once the Inspection details are posted, post the lot
536: -- and serial info for the receiving txn onto qa_rcv_lot_ser_temp.
537:
538: populate_lot_serial_temp(p_transaction_id);
539:
540: -- Bug 3229571. Synch the qa_rcv_lot_ser_temp with the lot and serial

Line 540: -- Bug 3229571. Synch the qa_rcv_lot_ser_temp with the lot and serial

536: -- and serial info for the receiving txn onto qa_rcv_lot_ser_temp.
537:
538: populate_lot_serial_temp(p_transaction_id);
539:
540: -- Bug 3229571. Synch the qa_rcv_lot_ser_temp with the lot and serial
541: -- numbers already used in Inspection.
542:
543: modify_lot_serial_temp(p_transaction_id,
544: p_collection_id);