DBA Data[Home] [Help]

APPS.CSM_NOTES_EVENT_PKG dependencies on CSM_OBJECT_MAPPINGS_ACC_S

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 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