APPS.CSL_MTL_UNIT_TRANS_ACC_PKG dependencies on MTL_UNIT_TRANSACTIONS

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_UNIT_TRANSACTIONS');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_MTL_UNIT_TRANS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_UNIT_TRANSACTIONS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_UNIT_TRANSACTIONS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
10: g_pk2_name CONSTANT VARCHAR2(30) := 'SERIAL_NUMBER';
11: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook

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

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_MTL_UNIT_TRANS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_UNIT_TRANSACTIONS');
8: g_table_name CONSTANT VARCHAR2(30) := 'MTL_UNIT_TRANSACTIONS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TRANSACTION_ID';
10: g_pk2_name CONSTANT VARCHAR2(30) := 'SERIAL_NUMBER';
11: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
12: g_debug_level NUMBER; -- debug level

Line 29: FROM MTL_UNIT_TRANSACTIONS

25: ,b_organization_id NUMBER
26: ,b_subinventory_code VARCHAR2)
27: IS
28: SELECT TRANSACTION_ID, SERIAL_NUMBER
29: FROM MTL_UNIT_TRANSACTIONS
30: WHERE TRANSACTION_ID = b_transaction_id
31: AND INVENTORY_ITEM_ID = b_inventory_item_id
32: AND ORGANIZATION_ID = b_organization_id
33: AND SUBINVENTORY_CODE = b_subinventory_code;

Line 129: FROM MTL_UNIT_TRANSACTIONS

125: ,b_organization_id NUMBER
126: ,b_subinventory_code VARCHAR2)
127: IS
128: SELECT TRANSACTION_ID, SERIAL_NUMBER
129: FROM MTL_UNIT_TRANSACTIONS
130: WHERE TRANSACTION_ID = b_transaction_id
131: AND INVENTORY_ITEM_ID = b_inventory_item_id
132: AND ORGANIZATION_ID = b_organization_id
133: AND SUBINVENTORY_CODE = b_subinventory_code;