APPS.CSM_NOTES_EVENT_PKG dependencies on JTF_OBJECT_MAPPINGS

Line 24: g_omappings_table_name CONSTANT VARCHAR2(30) := 'JTF_OBJECT_MAPPINGS';

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 :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_OBJECT_MAPPINGS');

Line 54: p_mapping_id jtf_object_mappings.mapping_id%TYPE

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;
58: BEGIN

Line 365: FROM jtf_object_mappings jom

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
369: (SELECT 1