APPS.CSM_SR_CONTACT_EVENT_PKG dependencies on CSM_ACC_PKG

Line 8: g_srcntacts_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

4: g_srcntacts_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_SR_CONTACTS_ACC';
5: g_srcntacts_table_name CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';
6: g_srcntacts_seq_name CONSTANT VARCHAR2(30) := 'CSM_SR_CONTACTS_ACC_S' ;
7: g_srcntacts_pk1_name CONSTANT VARCHAR2(30) := 'SR_CONTACT_POINT_ID';
8: g_srcntacts_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSF_M_SR_CONTACTS');
10:
11: l_markdirty_failed EXCEPTION;
12:

Line 9: CSM_ACC_PKG.t_publication_item_list('CSF_M_SR_CONTACTS');

5: g_srcntacts_table_name CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';
6: g_srcntacts_seq_name CONSTANT VARCHAR2(30) := 'CSM_SR_CONTACTS_ACC_S' ;
7: g_srcntacts_pk1_name CONSTANT VARCHAR2(30) := 'SR_CONTACT_POINT_ID';
8: g_srcntacts_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSF_M_SR_CONTACTS');
10:
11: l_markdirty_failed EXCEPTION;
12:
13: PROCEDURE SR_CNTACT_MDIRTY_U_FOREACHUSER(p_sr_contact_point_id IN NUMBER)

Line 44: CSM_ACC_PKG.Update_Acc

40: -- get users who have access to this SR_CONTACT_POINT_ID
41: FOR l_user_rec IN l_user_csr(p_sr_contact_point_id) LOOP
42:
43: -- Call Update
44: CSM_ACC_PKG.Update_Acc
45: ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name
46: ,P_ACC_TABLE_NAME => g_srcntacts_acc_table_name
47: ,P_USER_ID => l_user_rec.user_id
48: ,P_ACCESS_ID => l_user_rec.access_id

Line 76: CSM_ACC_PKG.Insert_Acc

72: BEGIN
73: CSM_UTIL_PKG.LOG('Entering SR_CNTACT_MDIRTY_I for sr_contact_point_id: ' || p_sr_contact_point_id,
74: 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_I',FND_LOG.LEVEL_PROCEDURE);
75:
76: CSM_ACC_PKG.Insert_Acc
77: ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name
78: ,P_ACC_TABLE_NAME => g_srcntacts_acc_table_name
79: ,P_SEQ_NAME => g_srcntacts_seq_name
80: ,P_PK1_NAME => g_srcntacts_pk1_name

Line 153: CSM_ACC_PKG.Delete_Acc

149: BEGIN
150: CSM_UTIL_PKG.LOG('Entering SR_CNTACT_MDIRTY_D for sr_contact_point_id: ' || p_sr_contact_point_id,
151: 'CSM_SR_CONTACT_EVENT_PKG.SR_CNTACT_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
152:
153: CSM_ACC_PKG.Delete_Acc
154: ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name
155: ,P_ACC_TABLE_NAME => g_srcntacts_acc_table_name
156: ,P_PK1_NAME => g_srcntacts_pk1_name
157: ,P_PK1_NUM_VALUE => p_sr_contact_point_id

Line 249: CSM_ACC_PKG.Update_Acc

245:
246: -- get users who have access to this contact_point_id and there may be more than one record for this contact_point_id
247: FOR l_user_rec IN l_user_csr(l_contact_point_id) LOOP
248: -- Call Update
249: CSM_ACC_PKG.Update_Acc
250: ( P_PUBLICATION_ITEM_NAMES => g_srcntacts_pubi_name
251: ,P_ACC_TABLE_NAME => g_srcntacts_acc_table_name
252: ,P_USER_ID => l_user_rec.user_id
253: ,P_ACCESS_ID => l_user_rec.access_id