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 109: CSM_ACC_PKG.Insert_Acc

105: END IF;
106:
107: /* --insert into acc
108: FOR i IN 1..l_inventory_items_tbl.count LOOP
109: CSM_ACC_PKG.Insert_Acc
110: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
111: ,P_ACC_TABLE_NAME => g_acc_table_name1
112: ,P_SEQ_NAME => g_acc_sequence_name1
113: ,P_PK1_NAME => g_pk1_name1

Line 178: CSM_ACC_PKG.Update_Acc

174:
175: IF l_access_id_tbl.count > 0 THEN
176: -- make dirty calls
177: FOR i IN 1..l_access_id_tbl.count LOOP
178: CSM_ACC_PKG.Update_Acc
179: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
180: ,P_ACC_TABLE_NAME => g_acc_table_name1
181: ,P_ACCESS_ID => l_access_id_tbl(i)
182: ,P_USER_ID => p_user_id

Line 254: CSM_ACC_PKG.Delete_Acc

250:
251: IF l_inventory_items_tbl.count > 0 THEN
252: -- make dirty calls
253: FOR i IN 1..l_inventory_items_tbl.count LOOP
254: CSM_ACC_PKG.Delete_Acc
255: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
256: ,P_ACC_TABLE_NAME => g_acc_table_name1
257: ,P_PK1_NAME => g_pk1_name1
258: ,P_PK1_NUM_VALUE => l_inventory_items_tbl(i)

Line 421: CSM_ACC_PKG.Delete_acc

417: CLOSE l_last_run_date_csr;
418:
419: -- process deletes
420: FOR r_del_mtl_item_subinv_rec IN l_del_mtl_item_subinv_csr LOOP
421: CSM_ACC_PKG.Delete_acc
422: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
423: ,P_ACC_TABLE_NAME => g_acc_table_name1
424: ,P_PK1_NAME => g_pk1_name1
425: ,P_PK1_NUM_VALUE => r_del_mtl_item_subinv_rec.inventory_item_id

Line 436: CSM_ACC_PKG.Update_acc

432: END LOOP;
433:
434: -- process updates
435: FOR r_upd_mtl_item_subinv_rec IN l_upd_mtl_item_subinv_csr(l_prog_update_date) LOOP
436: CSM_ACC_PKG.Update_acc
437: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
438: ,P_ACC_TABLE_NAME => g_acc_table_name1
439: ,P_ACCESS_ID => r_upd_mtl_item_subinv_rec.access_id
440: ,P_USER_ID => r_upd_mtl_item_subinv_rec.user_id

Line 446: CSM_ACC_PKG.Insert_Acc

442: END LOOP;
443:
444: -- process inserts
445: FOR r_ins_mtl_item_subinv_rec IN l_ins_mtl_item_subinv_csr LOOP
446: CSM_ACC_PKG.Insert_Acc
447: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
448: ,P_ACC_TABLE_NAME => g_acc_table_name1
449: ,P_SEQ_NAME => g_acc_sequence_name1
450: ,P_PK1_NAME => g_pk1_name1