APPS.CSM_MTL_ITEM_LOC_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_ITEM_LOCATIONS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_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_ITEM_LOCATIONS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_LOCATION_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
21: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';

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

14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS_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_ITEM_LOCATIONS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_LOCATION_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
21: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_LOCATIONS';
22:

Line 113: CSM_ACC_PKG.Delete_acc

109: CLOSE l_last_run_date_csr;
110:
111: -- process deletes
112: FOR r_mtl_item_loc_del_rec IN l_mtl_item_loc_del_csr LOOP
113: CSM_ACC_PKG.Delete_acc
114: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
115: ,P_ACC_TABLE_NAME => g_acc_table_name1
116: ,P_PK1_NAME => g_pk1_name1
117: ,P_PK1_NUM_VALUE => r_mtl_item_loc_del_rec.inventory_location_id

Line 126: CSM_ACC_PKG.Update_acc

122: END LOOP;
123:
124: -- process updates
125: FOR r_mtl_item_loc_upd_rec IN l_mtl_item_loc_upd_csr(l_prog_update_date) LOOP
126: CSM_ACC_PKG.Update_acc
127: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
128: ,P_ACC_TABLE_NAME => g_acc_table_name1
129: ,P_ACCESS_ID => r_mtl_item_loc_upd_rec.access_id
130: ,P_USER_ID => r_mtl_item_loc_upd_rec.user_id

Line 136: CSM_ACC_PKG.Insert_Acc

132: END LOOP;
133:
134: -- process inserts
135: FOR r_mtl_item_loc_ins_rec IN l_mtl_item_loc_ins_csr LOOP
136: CSM_ACC_PKG.Insert_Acc
137: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
138: ,P_ACC_TABLE_NAME => g_acc_table_name1
139: ,P_SEQ_NAME => g_acc_sequence_name1
140: ,P_PK1_NAME => g_pk1_name1