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 156: CSM_ACC_PKG.Delete_acc

152: CLOSE l_last_run_date_csr;
153:
154: -- process deletes
155: FOR r_mtl_sec_loc_del_rec IN l_mtl_sec_loc_del_csr LOOP
156: CSM_ACC_PKG.Delete_acc
157: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
158: ,P_ACC_TABLE_NAME => g_acc_table_name1
159: ,P_PK1_NAME => g_pk1_name1
160: ,P_PK1_NUM_VALUE => r_mtl_sec_loc_del_rec.inventory_item_id

Line 171: CSM_ACC_PKG.Update_acc

167: END LOOP;
168:
169: -- process updates
170: FOR r_mtl_sec_loc_upd_rec IN l_mtl_sec_loc_upd_csr(l_prog_update_date) LOOP
171: CSM_ACC_PKG.Update_acc
172: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
173: ,P_ACC_TABLE_NAME => g_acc_table_name1
174: ,P_ACCESS_ID => r_mtl_sec_loc_upd_rec.access_id
175: ,P_USER_ID => r_mtl_sec_loc_upd_rec.user_id

Line 181: CSM_ACC_PKG.Insert_Acc

177: END LOOP;
178:
179: -- process inserts
180: FOR r_mtl_sec_loc_ins_rec IN l_mtl_sec_loc_ins_csr LOOP
181: CSM_ACC_PKG.Insert_Acc
182: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
183: ,P_ACC_TABLE_NAME => g_acc_table_name1
184: ,P_SEQ_NAME => g_acc_sequence_name1
185: ,P_PK1_NAME => g_pk1_name1