APPS.CSM_MTL_UNIT_TXN_ACC_PKG dependencies on MTL_UNIT_TRANSACTIONS

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_UNIT_TRANSACTIONS';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_MTL_UNIT_TXN_ACC';
6: g_publication_item_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
7: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_UNIT_TXNS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_UNIT_TRANSACTIONS';
9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_MTL_UNIT_TXN_ACC_S';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
11: g_pk2_name CONSTANT VARCHAR2(30) := 'SERIAL_NUMBER';
12: g_old_user_id NUMBER; -- variable containing old user_id; populated in Pre_Update hook

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

10: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
11: g_pk2_name CONSTANT VARCHAR2(30) := 'SERIAL_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_UNIT_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE SERIAL_idTab IS TABLE OF MTL_UNIT_TRANSACTIONS.SERIAL_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16: l_transaction_id_lst TRANS_idTab;
17: l_serial_lst SERIAL_idTab;
18:

Line 15: TYPE SERIAL_idTab IS TABLE OF MTL_UNIT_TRANSACTIONS.SERIAL_NUMBER%TYPE INDEX BY BINARY_INTEGER;

11: g_pk2_name CONSTANT VARCHAR2(30) := 'SERIAL_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_UNIT_TRANSACTIONS.TRANSACTION_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE SERIAL_idTab IS TABLE OF MTL_UNIT_TRANSACTIONS.SERIAL_NUMBER%TYPE INDEX BY BINARY_INTEGER;
16: l_transaction_id_lst TRANS_idTab;
17: l_serial_lst SERIAL_idTab;
18:
19: PROCEDURE Insert_MTL_Unit_Trans( p_user_id NUMBER,

Line 26: FROM MTL_UNIT_TRANSACTIONS

22: IS
23: CURSOR c_mtl_unit_trans(b_transaction_id NUMBER)
24: IS
25: SELECT TRANSACTION_ID, SERIAL_NUMBER
26: FROM MTL_UNIT_TRANSACTIONS
27: WHERE TRANSACTION_ID = b_transaction_id;
28:
29: BEGIN
30: CSM_UTIL_PKG.LOG