APPS.CSM_MTL_TXN_LOT_NUM_ACC_PKG dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 14: TYPE TRANS_idTab IS TABLE OF MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;

10: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
11: g_pk2_name CONSTANT VARCHAR2(30) := 'LOT_NUMBER';
12: g_old_user_id NUMBER; -- variable containing old user_id; populated in Pre_Update hook
13: g_debug_level NUMBER; -- debug level
14: TYPE TRANS_idTab IS TABLE OF MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE LOT_idTab IS TABLE OF MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16: l_transaction_id_lst TRANS_idTab;
17: l_lot_number_lst LOT_idTab;
18:

Line 15: TYPE LOT_idTab IS TABLE OF MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER%TYPE INDEX BY BINARY_INTEGER;

11: g_pk2_name CONSTANT VARCHAR2(30) := 'LOT_NUMBER';
12: g_old_user_id NUMBER; -- variable containing old user_id; populated in Pre_Update hook
13: g_debug_level NUMBER; -- debug level
14: TYPE TRANS_idTab IS TABLE OF MTL_TRANSACTION_LOT_NUMBERS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE LOT_idTab IS TABLE OF MTL_TRANSACTION_LOT_NUMBERS.LOT_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16: l_transaction_id_lst TRANS_idTab;
17: l_lot_number_lst LOT_idTab;
18:
19: PROCEDURE Insert_MTL_trans_lot_num

Line 27: FROM MTL_TRANSACTION_LOT_NUMBERS

23:
24: CURSOR c_transaction_lot_number( b_transaction_id NUMBER )
25: IS
26: SELECT TRANSACTION_ID, LOT_NUMBER
27: FROM MTL_TRANSACTION_LOT_NUMBERS
28: WHERE TRANSACTION_ID = b_transaction_id;
29:
30: BEGIN
31: CSM_UTIL_PKG.LOG

Line 85: FROM MTL_TRANSACTION_LOT_NUMBERS

81: IS
82: CURSOR c_transaction_lot_number(b_transaction_id NUMBER)
83: IS
84: SELECT TRANSACTION_ID, LOT_NUMBER
85: FROM MTL_TRANSACTION_LOT_NUMBERS
86: WHERE TRANSACTION_ID = b_transaction_id;
87:
88: l_acc_id NUMBER;
89: