APPS.CSM_CSI_ITEM_ATTR_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_CSI_ITEM_ATTR';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_CSI_ITEM_ATTR');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
21:

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

14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_CSI_ITEM_ATTR');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
21:
22: PROCEDURE Refresh_Acc (p_status OUT NOCOPY VARCHAR2,

Line 118: CSM_ACC_PKG.Delete_acc

114: CLOSE l_last_run_date_csr;
115:
116: -- process deletes
117: FOR r_csi_iea_values_del_rec IN l_csi_iea_values_del_csr LOOP
118: CSM_ACC_PKG.Delete_acc
119: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
120: ,P_ACC_TABLE_NAME => g_acc_table_name1
121: ,P_PK1_NAME => g_pk1_name1
122: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id

Line 129: CSM_ACC_PKG.Update_acc

125: END LOOP;
126:
127: -- process updates
128: FOR r_csi_iea_values_upd_rec IN l_csi_iea_values_upd_csr(l_prog_update_date) LOOP
129: CSM_ACC_PKG.Update_acc
130: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
131: ,P_ACC_TABLE_NAME => g_acc_table_name1
132: ,P_ACCESS_ID => r_csi_iea_values_upd_rec.access_id
133: ,P_USER_ID => r_csi_iea_values_upd_rec.user_id

Line 139: CSM_ACC_PKG.Insert_Acc

135: END LOOP;
136:
137: -- process inserts
138: FOR r_csi_iea_values_ins_rec IN l_csi_iea_values_ins_csr LOOP
139: CSM_ACC_PKG.Insert_Acc
140: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
141: ,P_ACC_TABLE_NAME => g_acc_table_name1
142: ,P_SEQ_NAME => g_acc_sequence_name1
143: ,P_PK1_NAME => g_pk1_name1