APPS.CSM_NOTES_EVENT_PKG dependencies on CSM_OBJECT_MAPPINGS_ACC

Line 23: g_omappings_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_OBJECT_MAPPINGS_ACC';

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';
26: g_omappings_pk1_name CONSTANT VARCHAR2(30) := 'MAPPING_ID';
27: g_omappings_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 25: g_omappings_seq_name CONSTANT VARCHAR2(30) := 'CSM_OBJECT_MAPPINGS_ACC_S';

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';
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:

Line 53: PROCEDURE INSERT_CSM_OBJECT_MAPPINGS_ACC (p_access_id IN NUMBER,

49: RAISE;
50:
51: END;-- end INSERT_CSM_NOTES_ACC;
52:
53: PROCEDURE INSERT_CSM_OBJECT_MAPPINGS_ACC (p_access_id IN NUMBER,
54: p_mapping_id jtf_object_mappings.mapping_id%TYPE
55: )
56: IS
57: l_sysdate date;

Line 61: INSERT INTO csm_object_mappings_acc (access_id,

57: l_sysdate date;
58: BEGIN
59: l_sysdate := SYSDATE;
60:
61: INSERT INTO csm_object_mappings_acc (access_id,
62: mapping_id,
63: created_by,
64: creation_date,
65: last_updated_by,

Line 82: END;-- end INSERT_CSM_OBJECT_MAPPINGS_ACC;

78: EXCEPTION
79: WHEN others THEN
80: RAISE;
81:
82: END;-- end INSERT_CSM_OBJECT_MAPPINGS_ACC;
83:
84: -- Bug 5532961
85: PROCEDURE NOTES_MAKE_DIRTY_I_FOREACHUSER(p_jtf_note_id IN NUMBER,
86: p_error_msg OUT NOCOPY VARCHAR2,

Line 364: SELECT CSM_OBJECT_MAPPINGS_ACC_S.NEXTVAL access_id, jom.mapping_id

360: l_null_access_list asg_download.access_list;
361:
362: CURSOR l_mappings_csr
363: IS
364: SELECT CSM_OBJECT_MAPPINGS_ACC_S.NEXTVAL access_id, jom.mapping_id
365: FROM jtf_object_mappings jom
366: WHERE jom.source_object_code IN ('PARTY', 'TASK', 'SR', 'CP','OKS_COV_NOTE','SD')
367: AND NVL(end_date, SYSDATE) >= SYSDATE
368: AND NOT EXISTS

Line 370: FROM csm_object_mappings_acc acc

366: WHERE jom.source_object_code IN ('PARTY', 'TASK', 'SR', 'CP','OKS_COV_NOTE','SD')
367: AND NVL(end_date, SYSDATE) >= SYSDATE
368: AND NOT EXISTS
369: (SELECT 1
370: FROM csm_object_mappings_acc acc
371: WHERE acc.mapping_id = jom.mapping_id);
372:
373: BEGIN
374: --get mfs users

Line 378: -- insert into csm_object_mappings_acc

374: --get mfs users
375: l_omfs_palm_user_list := l_null_user_list;
376: l_omfs_palm_user_list := csm_util_pkg.get_all_omfs_palm_user_list;
377:
378: -- insert into csm_object_mappings_acc
379: FOR r_mappings_rec IN l_mappings_csr LOOP
380:
381: --nullify the access list
382: l_single_access_id_list := l_null_access_list;

Line 387: INSERT_CSM_OBJECT_MAPPINGS_ACC(r_mappings_rec.access_id, r_mappings_rec.mapping_id);

383: FOR i in 1 .. l_omfs_palm_user_list.COUNT LOOP
384: l_single_access_id_list(i) := r_mappings_rec.access_id;
385: END LOOP;
386:
387: INSERT_CSM_OBJECT_MAPPINGS_ACC(r_mappings_rec.access_id, r_mappings_rec.mapping_id);
388:
389: --mark dirty the SDQ for all users
390: IF l_single_access_id_list.count > 0 THEN
391: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_OBJECT_MAPPINGS',