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

1102: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
1103:
1104: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1105: -- insert into csm_system_items_acc
1106: CSM_ACC_PKG.Insert_Acc
1107: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1108: ,P_ACC_TABLE_NAME => g_acc_table_name1
1109: ,P_SEQ_NAME => g_acc_sequence_name1
1110: ,P_PK1_NAME => g_pk1_name1

Line 1145: CSM_ACC_PKG.Delete_Acc

1141: 'CSM_SYSTEM_ITEM_EVENT_PKG.SYSTEM_ITEM_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
1142:
1143: IF p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL THEN
1144: -- delete from csm_system_items_acc
1145: CSM_ACC_PKG.Delete_Acc
1146: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
1147: ,P_ACC_TABLE_NAME => g_acc_table_name1
1148: ,P_PK1_NAME => g_pk1_name1
1149: ,P_PK1_NUM_VALUE => p_inventory_item_id