APPS.CSM_SYSTEM_ITEM_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_SYSTEM_ITEMS_B';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_SYSTEM_ITEMS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
21: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_SYSTEM_ITEMS';

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

14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_SYSTEM_ITEMS_B';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_SYSTEM_ITEMS_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_SYSTEM_ITEMS');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
21: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_SYSTEM_ITEMS';
22:

Line 26: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

22:
23: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
24: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
28: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
29: g_pub_item2 CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';
30:

Line 27: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');

23: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
24: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
28: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
29: g_pub_item2 CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';
30:
31: -- below procedure is called from csm_mtl_system_items where there is an org change

Line 1317: CSM_ACC_PKG.Insert_Acc

1313: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
1314:
1315: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1316: -- insert into csm_system_items_acc
1317: CSM_ACC_PKG.Insert_Acc
1318: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1319: ,P_ACC_TABLE_NAME => g_acc_table_name1
1320: ,P_SEQ_NAME => g_acc_sequence_name1
1321: ,P_PK1_NAME => g_pk1_name1

Line 1356: CSM_ACC_PKG.Delete_Acc

1352: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
1353:
1354: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1355: -- delete from csm_system_items_acc
1356: CSM_ACC_PKG.Delete_Acc
1357: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1358: ,P_ACC_TABLE_NAME => g_acc_table_name1
1359: ,P_PK1_NAME => g_pk1_name1
1360: ,P_PK1_NUM_VALUE => p_inventory_item_id