APPS.CSM_NOTES_EVENT_PKG dependencies on CSM_ACC_PKG

Line 20: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

16: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';
17: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
18: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';
19: g_notes_pk1_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
20: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');
22:
23: g_omappings_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_OBJECT_MAPPINGS_ACC';
24: g_omappings_table_name CONSTANT VARCHAR2(30) := 'JTF_OBJECT_MAPPINGS';

Line 21: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');

17: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
18: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';
19: g_notes_pk1_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
20: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');
22:
23: g_omappings_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_OBJECT_MAPPINGS_ACC';
24: g_omappings_table_name CONSTANT VARCHAR2(30) := 'JTF_OBJECT_MAPPINGS';
25: g_omappings_seq_name CONSTANT VARCHAR2(30) := 'CSM_OBJECT_MAPPINGS_ACC_S';

Line 27: g_omappings_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

23: g_omappings_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_OBJECT_MAPPINGS_ACC';
24: g_omappings_table_name CONSTANT VARCHAR2(30) := 'JTF_OBJECT_MAPPINGS';
25: g_omappings_seq_name CONSTANT VARCHAR2(30) := 'CSM_OBJECT_MAPPINGS_ACC_S';
26: g_omappings_pk1_name CONSTANT VARCHAR2(30) := 'MAPPING_ID';
27: g_omappings_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_OBJECT_MAPPINGS');
29:
30: PROCEDURE INSERT_CSM_NOTES_ACC (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE,
31: p_user_id fnd_user.user_id%TYPE)

Line 28: CSM_ACC_PKG.t_publication_item_list('CSF_M_OBJECT_MAPPINGS');

24: g_omappings_table_name CONSTANT VARCHAR2(30) := 'JTF_OBJECT_MAPPINGS';
25: g_omappings_seq_name CONSTANT VARCHAR2(30) := 'CSM_OBJECT_MAPPINGS_ACC_S';
26: g_omappings_pk1_name CONSTANT VARCHAR2(30) := 'MAPPING_ID';
27: g_omappings_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_OBJECT_MAPPINGS');
29:
30: PROCEDURE INSERT_CSM_NOTES_ACC (p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE,
31: p_user_id fnd_user.user_id%TYPE)
32: IS

Line 36: CSM_ACC_PKG.Insert_Acc

32: IS
33:
34: BEGIN
35:
36: CSM_ACC_PKG.Insert_Acc
37: ( P_PUBLICATION_ITEM_NAMES => g_notes_pubi_name
38: ,P_ACC_TABLE_NAME => g_notes_acc_table_name
39: ,P_SEQ_NAME => g_notes_seq_name
40: ,P_PK1_NAME => g_notes_pk1_name

Line 243: CSM_ACC_PKG.Update_Acc

239: l_jtf_note_id := p_jtf_note_id;
240:
241: -- update for all the affected users
242: for l_csm_notes_foreachuser_rec in l_csm_notes_foreachuser_csr(l_jtf_note_id) loop
243: CSM_ACC_PKG.Update_Acc
244: ( P_PUBLICATION_ITEM_NAMES => g_notes_pubi_name
245: ,P_ACC_TABLE_NAME => g_notes_acc_table_name
246: ,P_USER_ID => l_csm_notes_foreachuser_rec.user_id
247: ,p_ACCESS_ID => l_csm_notes_foreachuser_rec.access_id

Line 330: CSM_ACC_PKG.Delete_Acc

326: FOR l_notes_by_task_rec IN l_notes_by_task_csr(p_sourceobjectcode,
327: p_sourceobjectid,
328: p_userid) LOOP
329:
330: CSM_ACC_PKG.Delete_Acc
331: ( P_PUBLICATION_ITEM_NAMES => g_notes_pubi_name
332: ,P_ACC_TABLE_NAME => g_notes_acc_table_name
333: ,P_PK1_NAME => g_notes_pk1_name
334: ,P_PK1_NUM_VALUE => l_notes_by_task_rec.jtf_note_id