eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GML_RCV_COMMON_APIS dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 8: PROCEDURE insert_mtlt(p_mtlt_rec mtl_transaction_lots_temp%ROWTYPE) IS

4: -- Global constant holding the package name
5: g_pkg_name CONSTANT VARCHAR2(30) := 'GML_RCV_COMMON_APIS';
6:
7:
8: PROCEDURE insert_mtlt(p_mtlt_rec mtl_transaction_lots_temp%ROWTYPE) IS
9: BEGIN
10: INSERT INTO mtl_transaction_lots_temp
11: (
12: transaction_temp_id

Line 10: INSERT INTO mtl_transaction_lots_temp

6:
7:
8: PROCEDURE insert_mtlt(p_mtlt_rec mtl_transaction_lots_temp%ROWTYPE) IS
9: BEGIN
10: INSERT INTO mtl_transaction_lots_temp
11: (
12: transaction_temp_id
13: , last_update_date
14: , last_updated_by

Line 207: FUNCTION break_lots_only(p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE, p_new_transactions_tb IN trans_rec_tb_tp)

203: , p_mtlt_rec.vendor_name
204: );
205: END insert_mtlt;
206:
207: FUNCTION break_lots_only(p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE, p_new_transactions_tb IN trans_rec_tb_tp)
208: RETURN BOOLEAN IS
209: CURSOR c_lots IS
210: SELECT ROWID
211: , transaction_temp_id

Line 304: FROM mtl_transaction_lots_temp

300: , n_attribute8
301: , n_attribute9
302: , n_attribute10
303: , vendor_name
304: FROM mtl_transaction_lots_temp
305: WHERE transaction_temp_id = p_original_tid
306: ORDER BY DECODE(
307: inv_rcv_common_apis.g_order_lots_by
308: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date

Line 316: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;

312:
313: --Changed the order by for bug 2422193
314: --ORDER BY lot_expiration_date,creation_date;
315:
316: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
317: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
318: l_new_primary_quantity NUMBER; -- the quanity user wants to split
319: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
320: l_primary_quantity NUMBER; -- the primary qty for lot

Line 317: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;

313: --Changed the order by for bug 2422193
314: --ORDER BY lot_expiration_date,creation_date;
315:
316: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
317: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
318: l_new_primary_quantity NUMBER; -- the quanity user wants to split
319: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
320: l_primary_quantity NUMBER; -- the primary qty for lot
321: l_secondary_quantity NUMBER; -- the primary qty for lot

Line 319: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;

315:
316: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
317: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
318: l_new_primary_quantity NUMBER; -- the quanity user wants to split
319: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
320: l_primary_quantity NUMBER; -- the primary qty for lot
321: l_secondary_quantity NUMBER; -- the primary qty for lot
322: l_transaction_quantity NUMBER;
323: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;

Line 323: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;

319: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
320: l_primary_quantity NUMBER; -- the primary qty for lot
321: l_secondary_quantity NUMBER; -- the primary qty for lot
322: l_transaction_quantity NUMBER;
323: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;
324: l_sublot_number mtl_transaction_lots_temp.sublot_num%TYPE;
325: l_item_no VARCHAR2(40);
326: l_unit_of_measure VARCHAR2(100);
327:

Line 324: l_sublot_number mtl_transaction_lots_temp.sublot_num%TYPE;

320: l_primary_quantity NUMBER; -- the primary qty for lot
321: l_secondary_quantity NUMBER; -- the primary qty for lot
322: l_transaction_quantity NUMBER;
323: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;
324: l_sublot_number mtl_transaction_lots_temp.sublot_num%TYPE;
325: l_item_no VARCHAR2(40);
326: l_unit_of_measure VARCHAR2(100);
327:
328: --BUG 2673970

Line 485: UPDATE mtl_transaction_lots_temp

481: x_secondary_quantity => l_secondary_quantity);
482: END IF;
483:
484: IF l_sublot_number IS NULL OR l_sublot_number = '' THEN
485: UPDATE mtl_transaction_lots_temp
486: SET primary_quantity = l_primary_quantity
487: , transaction_quantity = l_transaction_quantity
488: , secondary_quantity = l_secondary_quantity
489: WHERE transaction_temp_id = l_transaction_temp_id

Line 493: UPDATE mtl_transaction_lots_temp

489: WHERE transaction_temp_id = l_transaction_temp_id
490: AND lot_number = l_lot_number
491: AND ROWID = l_rowid;
492: ELSE
493: UPDATE mtl_transaction_lots_temp
494: SET primary_quantity = l_primary_quantity
495: , transaction_quantity = l_transaction_quantity
496: , secondary_quantity = l_secondary_quantity
497: WHERE transaction_temp_id = l_transaction_temp_id

Line 513: UPDATE mtl_transaction_lots_temp

509:
510:
511: IF l_sublot_number IS NULL OR l_sublot_number = '' THEN
512: -- Update the lot rec with new transaction interface ID
513: UPDATE mtl_transaction_lots_temp
514: SET transaction_temp_id = l_new_transaction_temp_id
515: WHERE transaction_temp_id = l_transaction_temp_id
516: AND lot_number = l_lot_number
517: AND ROWID = l_rowid;

Line 519: UPDATE mtl_transaction_lots_temp

515: WHERE transaction_temp_id = l_transaction_temp_id
516: AND lot_number = l_lot_number
517: AND ROWID = l_rowid;
518: ELSE
519: UPDATE mtl_transaction_lots_temp
520: SET transaction_temp_id = l_new_transaction_temp_id
521: WHERE transaction_temp_id = l_transaction_temp_id
522: AND lot_number = l_lot_number
523: AND sublot_num = l_sublot_number

Line 534: UPDATE mtl_transaction_lots_temp

530: -- exact match
531:
532: IF l_sublot_number IS NULL OR l_sublot_number = '' THEN
533: -- Update the lot rec with new transaction interface ID
534: UPDATE mtl_transaction_lots_temp
535: SET transaction_temp_id = l_new_transaction_temp_id
536: WHERE transaction_temp_id = l_transaction_temp_id
537: AND lot_number = l_lot_number
538: AND ROWID = l_rowid;

Line 541: UPDATE mtl_transaction_lots_temp

537: AND lot_number = l_lot_number
538: AND ROWID = l_rowid;
539:
540: ELSE
541: UPDATE mtl_transaction_lots_temp
542: SET transaction_temp_id = l_new_transaction_temp_id
543: WHERE transaction_temp_id = l_transaction_temp_id
544: AND lot_number = l_lot_number
545: AND sublot_num = l_sublot_number

Line 568: p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE

564: END break_lots_only;
565:
566:
567: PROCEDURE BREAK(
568: p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE
569: , p_new_transactions_tb IN trans_rec_tb_tp
570: , p_lot_control_code IN NUMBER
571: , p_serial_control_code IN NUMBER
572: ) IS