APPS.CSM_MTL_SEC_INV_EVENT_PKG dependencies on CSM_MTL_SEC_INV_ACC

Line 16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC';

12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_SEC_INVENTORIES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SEC_INVENTORIES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_NAME';

Line 17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';

13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_SEC_INVENTORIES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_INV_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SEC_INVENTORIES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY_NAME';
21: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 152: csm_mtl_sec_inv_acc acc

148: CURSOR l_upd_mtl_sec_inv_csr(p_last_upd_date IN date)
149: IS
150: SELECT acc.access_id, acc.user_id
151: FROM mtl_secondary_inventories msi,
152: csm_mtl_sec_inv_acc acc
153: WHERE msi.secondary_inventory_name = acc.secondary_inventory_name
154: AND msi.organization_id = acc.organization_id
155: AND msi.last_update_date >= p_last_upd_date;
156: