APPS.CSM_MTL_ITEM_SUBINV_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) := 'MTL_ITEM_SUB_INVENTORIES';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_SUBINV_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_SUBINV_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_SUBINV');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
21: g_pk3_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY';

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

14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_ITEM_SUB_INVENTORIES';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_SUBINV_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_SUBINV_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_SUBINV');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
21: g_pk3_name1 CONSTANT VARCHAR2(30) := 'SECONDARY_INVENTORY';
22: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_SUBINV';

Line 103: CSM_ACC_PKG.Insert_Acc

99: END IF;
100:
101: /* --insert into acc
102: FOR i IN 1..l_inventory_items_tbl.count LOOP
103: CSM_ACC_PKG.Insert_Acc
104: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
105: ,P_ACC_TABLE_NAME => g_acc_table_name1
106: ,P_SEQ_NAME => g_acc_sequence_name1
107: ,P_PK1_NAME => g_pk1_name1

Line 172: CSM_ACC_PKG.Update_Acc

168:
169: IF l_access_id_tbl.count > 0 THEN
170: -- make dirty calls
171: FOR i IN 1..l_access_id_tbl.count LOOP
172: CSM_ACC_PKG.Update_Acc
173: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
174: ,P_ACC_TABLE_NAME => g_acc_table_name1
175: ,P_ACCESS_ID => l_access_id_tbl(i)
176: ,P_USER_ID => p_user_id

Line 248: CSM_ACC_PKG.Delete_Acc

244:
245: IF l_inventory_items_tbl.count > 0 THEN
246: -- make dirty calls
247: FOR i IN 1..l_inventory_items_tbl.count LOOP
248: CSM_ACC_PKG.Delete_Acc
249: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
250: ,P_ACC_TABLE_NAME => g_acc_table_name1
251: ,P_PK1_NAME => g_pk1_name1
252: ,P_PK1_NUM_VALUE => l_inventory_items_tbl(i)

Line 375: CSM_ACC_PKG.Delete_acc

371: CLOSE l_last_run_date_csr;
372:
373: -- process deletes
374: FOR r_del_mtl_item_subinv_rec IN l_del_mtl_item_subinv_csr LOOP
375: CSM_ACC_PKG.Delete_acc
376: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
377: ,P_ACC_TABLE_NAME => g_acc_table_name1
378: ,P_PK1_NAME => g_pk1_name1
379: ,P_PK1_NUM_VALUE => r_del_mtl_item_subinv_rec.inventory_item_id

Line 390: CSM_ACC_PKG.Update_acc

386: END LOOP;
387:
388: -- process updates
389: FOR r_upd_mtl_item_subinv_rec IN l_upd_mtl_item_subinv_csr(l_prog_update_date) LOOP
390: CSM_ACC_PKG.Update_acc
391: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
392: ,P_ACC_TABLE_NAME => g_acc_table_name1
393: ,P_ACCESS_ID => r_upd_mtl_item_subinv_rec.access_id
394: ,P_USER_ID => r_upd_mtl_item_subinv_rec.user_id

Line 400: CSM_ACC_PKG.Insert_Acc

396: END LOOP;
397:
398: -- process inserts
399: FOR r_ins_mtl_item_subinv_rec IN l_ins_mtl_item_subinv_csr LOOP
400: CSM_ACC_PKG.Insert_Acc
401: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
402: ,P_ACC_TABLE_NAME => g_acc_table_name1
403: ,P_SEQ_NAME => g_acc_sequence_name1
404: ,P_PK1_NAME => g_pk1_name1