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.INV_RCV_COMMON_APIS dependencies on MTL_TRANSACTION_LOTS_TEMP

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

105: l_to_ser := SUBSTR(p_from_ser, 1, LENGTH(p_from_ser) - LENGTH(l_number)) || l_number;
106: RETURN l_to_ser;
107: END get_to_serial_number;
108:
109: PROCEDURE insert_mtlt(p_mtlt_rec mtl_transaction_lots_temp%ROWTYPE) IS
110: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
111: BEGIN
112: INSERT INTO mtl_transaction_lots_temp
113: (

Line 112: INSERT INTO mtl_transaction_lots_temp

108:
109: PROCEDURE insert_mtlt(p_mtlt_rec mtl_transaction_lots_temp%ROWTYPE) IS
110: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
111: BEGIN
112: INSERT INTO mtl_transaction_lots_temp
113: (
114: transaction_temp_id
115: , last_update_date
116: , last_updated_by

Line 598: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;

594:
595: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
596: l_new_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;
597: l_new_primary_quantity NUMBER; -- the quanity user wants to split
598: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
599: l_from_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;
600: l_to_ser mtl_serial_numbers_temp.to_serial_number%TYPE;
601: l_new_ser mtl_serial_numbers_temp.fm_serial_number%TYPE;
602: l_from_ser_num NUMBER; -- number part of from serial

Line 682: FUNCTION break_lots_only(p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE,

678:
679: RAISE;
680: END break_serials_only;
681:
682: FUNCTION break_lots_only(p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE,
683: p_new_transactions_tb IN trans_rec_tb_tp)
684: RETURN BOOLEAN IS
685: CURSOR c_lots IS
686: SELECT ROWID

Line 775: FROM mtl_transaction_lots_temp

771: , n_attribute8
772: , n_attribute9
773: , n_attribute10
774: , vendor_name
775: FROM mtl_transaction_lots_temp
776: WHERE transaction_temp_id = p_original_tid
777: ORDER BY DECODE(
778: inv_rcv_common_apis.g_order_lots_by
779: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date

Line 787: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;

783:
784: --Changed the order by for bug 2422193
785: --ORDER BY lot_expiration_date,creation_date;
786:
787: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
788: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
789: l_new_primary_quantity NUMBER; -- the quanity user wants to split
790: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
791: l_primary_quantity NUMBER; -- the primary qty for lot

Line 788: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;

784: --Changed the order by for bug 2422193
785: --ORDER BY lot_expiration_date,creation_date;
786:
787: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
788: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
789: l_new_primary_quantity NUMBER; -- the quanity user wants to split
790: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
791: l_primary_quantity NUMBER; -- the primary qty for lot
792: l_transaction_quantity NUMBER;

Line 790: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;

786:
787: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
788: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
789: l_new_primary_quantity NUMBER; -- the quanity user wants to split
790: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
791: l_primary_quantity NUMBER; -- the primary qty for lot
792: l_transaction_quantity NUMBER;
793: l_sec_transaction_quantity NUMBER; --invconv kkillams
794: l_new_secondary_quantity NUMBER; -- the quanity user wants to split

Line 795: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;

791: l_primary_quantity NUMBER; -- the primary qty for lot
792: l_transaction_quantity NUMBER;
793: l_sec_transaction_quantity NUMBER; --invconv kkillams
794: l_new_secondary_quantity NUMBER; -- the quanity user wants to split
795: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;
796: --BUG 2673970
797: l_rowid ROWID;
798: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
799: BEGIN

Line 924: print_debug('Update 1 mtl_transaction_lots_temp',1);

920: IF ( NVL(l_sec_transaction_quantity,-9999) > 0 ) THEN --9527367
921: l_sec_transaction_quantity := l_sec_transaction_quantity - l_mtlt_rec.secondary_quantity ;
922: END IF;
923:
924: print_debug('Update 1 mtl_transaction_lots_temp',1);
925: -- Update the existing lot rec with reduced quantity
926: UPDATE mtl_transaction_lots_temp
927: SET primary_quantity = l_primary_quantity
928: , transaction_quantity = l_transaction_quantity

Line 926: UPDATE mtl_transaction_lots_temp

922: END IF;
923:
924: print_debug('Update 1 mtl_transaction_lots_temp',1);
925: -- Update the existing lot rec with reduced quantity
926: UPDATE mtl_transaction_lots_temp
927: SET primary_quantity = l_primary_quantity
928: , transaction_quantity = l_transaction_quantity
929: , secondary_quantity = l_sec_transaction_quantity
930: WHERE transaction_temp_id = l_transaction_temp_id

Line 941: print_debug('Update 2 mtl_transaction_lots_temp',1);

937: -- lot qty is exhausted
938: -- need to continue lot loop in this case
939:
940: -- Update the lot rec with new transaction interface ID
941: print_debug('Update 2 mtl_transaction_lots_temp',1);
942: UPDATE mtl_transaction_lots_temp
943: SET transaction_temp_id = l_new_transaction_temp_id
944: WHERE transaction_temp_id = l_transaction_temp_id
945: AND lot_number = l_lot_number

Line 942: UPDATE mtl_transaction_lots_temp

938: -- need to continue lot loop in this case
939:
940: -- Update the lot rec with new transaction interface ID
941: print_debug('Update 2 mtl_transaction_lots_temp',1);
942: UPDATE mtl_transaction_lots_temp
943: SET transaction_temp_id = l_new_transaction_temp_id
944: WHERE transaction_temp_id = l_transaction_temp_id
945: AND lot_number = l_lot_number
946: AND ROWID = l_rowid;

Line 954: print_debug('Update 3 mtl_transaction_lots_temp',1);

950: l_new_secondary_quantity := l_new_secondary_quantity - l_sec_transaction_quantity; --invconv kkillams
951: ELSIF(l_primary_quantity = l_new_primary_quantity) THEN
952: -- exact match
953:
954: print_debug('Update 3 mtl_transaction_lots_temp',1);
955: -- Update the lot rec with new transaction interface ID
956: UPDATE mtl_transaction_lots_temp
957: SET transaction_temp_id = l_new_transaction_temp_id
958: WHERE transaction_temp_id = l_transaction_temp_id

Line 956: UPDATE mtl_transaction_lots_temp

952: -- exact match
953:
954: print_debug('Update 3 mtl_transaction_lots_temp',1);
955: -- Update the lot rec with new transaction interface ID
956: UPDATE mtl_transaction_lots_temp
957: SET transaction_temp_id = l_new_transaction_temp_id
958: WHERE transaction_temp_id = l_transaction_temp_id
959: AND lot_number = l_lot_number
960: AND ROWID = l_rowid;

Line 980: p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE

976: RAISE;
977: END break_lots_only;
978:
979: FUNCTION break_lots_serials(
980: p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE
981: , p_new_transactions_tb IN trans_rec_tb_tp
982: )
983: RETURN BOOLEAN IS
984: CURSOR c_lots IS

Line 1074: FROM mtl_transaction_lots_temp

1070: , n_attribute8
1071: , n_attribute9
1072: , n_attribute10
1073: , vendor_name
1074: FROM mtl_transaction_lots_temp
1075: WHERE transaction_temp_id = p_original_tid
1076: ORDER BY DECODE(
1077: inv_rcv_common_apis.g_order_lots_by
1078: , inv_rcv_common_apis.g_order_lots_by_exp_date, lot_expiration_date

Line 1085: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;

1081: );
1082:
1083: --Changed the order by for bug 2422193
1084: --ORDER BY lot_expiration_date,creation_date;
1085: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
1086: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
1087: l_new_primary_quantity NUMBER; -- the quanity user wants to split
1088: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
1089: l_primary_quantity NUMBER; -- the transaction qty for lot

Line 1086: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;

1082:
1083: --Changed the order by for bug 2422193
1084: --ORDER BY lot_expiration_date,creation_date;
1085: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
1086: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
1087: l_new_primary_quantity NUMBER; -- the quanity user wants to split
1088: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
1089: l_primary_quantity NUMBER; -- the transaction qty for lot
1090: l_transaction_quantity NUMBER;

Line 1088: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;

1084: --ORDER BY lot_expiration_date,creation_date;
1085: l_mtlt_rec mtl_transaction_lots_temp%ROWTYPE;
1086: l_new_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
1087: l_new_primary_quantity NUMBER; -- the quanity user wants to split
1088: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
1089: l_primary_quantity NUMBER; -- the transaction qty for lot
1090: l_transaction_quantity NUMBER;
1091: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;
1092: l_serial_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;

Line 1091: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;

1087: l_new_primary_quantity NUMBER; -- the quanity user wants to split
1088: l_transaction_temp_id mtl_transaction_lots_temp.transaction_temp_id%TYPE;
1089: l_primary_quantity NUMBER; -- the transaction qty for lot
1090: l_transaction_quantity NUMBER;
1091: l_lot_number mtl_transaction_lots_temp.lot_number%TYPE;
1092: l_serial_transaction_temp_id mtl_serial_numbers_temp.transaction_temp_id%TYPE;
1093: l_tran_rec_tb trans_rec_tb_tp;
1094: l_sec_transaction_quantity NUMBER; --invconv kkillams
1095: l_new_secondary_quantity NUMBER; -- the quanity user wants to split

Line 1235: UPDATE mtl_transaction_lots_temp

1231: l_transaction_quantity := l_transaction_quantity - l_mtlt_rec.transaction_quantity;
1232: l_sec_transaction_quantity := l_sec_transaction_quantity - l_mtlt_rec.secondary_quantity;
1233:
1234: -- Update the existing lot rec with reduced quantity
1235: UPDATE mtl_transaction_lots_temp
1236: SET primary_quantity = l_primary_quantity
1237: , transaction_quantity = l_transaction_quantity
1238: , secondary_quantity = l_sec_transaction_quantity
1239: WHERE transaction_temp_id = l_transaction_temp_id

Line 1250: UPDATE mtl_transaction_lots_temp

1246: -- lot qty is exhausted
1247: -- need to continue lot loop in this case
1248:
1249: -- Update the lot rec with new transaction interface ID
1250: UPDATE mtl_transaction_lots_temp
1251: SET transaction_temp_id = l_new_transaction_temp_id
1252: WHERE transaction_temp_id = l_transaction_temp_id
1253: AND lot_number = l_lot_number
1254: AND ROWID = l_rowid;

Line 1263: UPDATE mtl_transaction_lots_temp

1259: ELSIF(l_primary_quantity = l_new_primary_quantity) THEN
1260: -- exact match
1261:
1262: -- Update the lot rec with new transaction interface ID
1263: UPDATE mtl_transaction_lots_temp
1264: SET transaction_temp_id = l_new_transaction_temp_id
1265: WHERE transaction_temp_id = l_transaction_temp_id
1266: AND lot_number = l_lot_number
1267: AND ROWID = l_rowid;

Line 1287: p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE

1283: RAISE;
1284: END break_lots_serials;
1285:
1286: PROCEDURE BREAK(
1287: p_original_tid IN mtl_transaction_lots_temp.transaction_temp_id%TYPE
1288: , p_new_transactions_tb IN trans_rec_tb_tp
1289: , p_lot_control_code IN NUMBER
1290: , p_serial_control_code IN NUMBER
1291: ) IS

Line 3367: -- This api creates a record in the mtl_transaction_lots_temp

3363:
3364: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_msg_data);
3365: END create_lpn;
3366:
3367: -- This api creates a record in the mtl_transaction_lots_temp
3368: -- It checks if the p_transaction_temp_id is null, if it is, then it
3369: -- generates a new id and returns that.
3370: PROCEDURE insert_lot(
3371: p_transaction_temp_id IN OUT NOCOPY NUMBER

Line 3411: FROM mtl_transaction_lots_temp

3407: SELECT 1
3408: , serial_transaction_temp_id
3409: INTO l_count
3410: , x_serial_transaction_temp_id
3411: FROM mtl_transaction_lots_temp
3412: WHERE transaction_temp_id = p_transaction_temp_id
3413: AND lot_number = p_lot_number
3414: AND ROWNUM = 1;
3415: EXCEPTION

Line 3434: UPDATE mtl_transaction_lots_temp

3430: IF (l_debug = 1) THEN
3431: print_debug('Updating mtlt existing rec', 4);
3432: END IF;
3433:
3434: UPDATE mtl_transaction_lots_temp
3435: SET transaction_quantity = transaction_quantity + p_transaction_qty
3436: , primary_quantity = primary_quantity + p_primary_qty
3437: WHERE transaction_temp_id = p_transaction_temp_id
3438: AND lot_number = p_lot_number;

Line 3560: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

3556:
3557: BEGIN
3558: SELECT 1
3559: INTO l_count
3560: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
3561: WHERE (
3562: (p_from_serial BETWEEN msnt.fm_serial_number AND msnt.to_serial_number
3563: AND get_serial_Length(p_from_serial) = get_serial_Length(msnt.fm_serial_number)
3564: AND get_serial_Length(msnt.fm_serial_number) = get_serial_Length(Nvl(msnt.to_serial_number,msnt.fm_serial_number)))