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.CSM_MTL_SEC_LOCATORS_EVENT_PKG dependencies on CSM_ACC_PKG

Line 17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_LOCATORS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SECONDARY_LOCATORS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_LOCATOR';
21: g_pk3_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SECONDARY_LOCATORS');

14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_SEC_LOCATORS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_SECONDARY_LOCATORS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_LOCATOR';
21: g_pk3_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
22: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_SECONDARY_LOCATORS';

Line 117: CSM_ACC_PKG.Delete_acc

113: CLOSE l_last_run_date_csr;
114:
115: -- process deletes
116: FOR r_mtl_sec_loc_del_rec IN l_mtl_sec_loc_del_csr LOOP
117: CSM_ACC_PKG.Delete_acc
118: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
119: ,P_ACC_TABLE_NAME => g_acc_table_name1
120: ,P_PK1_NAME => g_pk1_name1
121: ,P_PK1_NUM_VALUE => r_mtl_sec_loc_del_rec.inventory_item_id

Line 132: CSM_ACC_PKG.Update_acc

128: END LOOP;
129:
130: -- process updates
131: FOR r_mtl_sec_loc_upd_rec IN l_mtl_sec_loc_upd_csr(l_prog_update_date) LOOP
132: CSM_ACC_PKG.Update_acc
133: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
134: ,P_ACC_TABLE_NAME => g_acc_table_name1
135: ,P_ACCESS_ID => r_mtl_sec_loc_upd_rec.access_id
136: ,P_USER_ID => r_mtl_sec_loc_upd_rec.user_id

Line 142: CSM_ACC_PKG.Insert_Acc

138: END LOOP;
139:
140: -- process inserts
141: FOR r_mtl_sec_loc_ins_rec IN l_mtl_sec_loc_ins_csr LOOP
142: CSM_ACC_PKG.Insert_Acc
143: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
144: ,P_ACC_TABLE_NAME => g_acc_table_name1
145: ,P_SEQ_NAME => g_acc_sequence_name1
146: ,P_PK1_NAME => g_pk1_name1