APPS.CSM_SR_CONTACT_EVENT_PKG dependencies on CSM_SR_CONTACTS_ACC

Line 4: g_srcntacts_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_SR_CONTACTS_ACC';

1: PACKAGE BODY CSM_SR_CONTACT_EVENT_PKG AS
2: /* $Header: csmesrcb.pls 120.1 2005/07/25 00:22:12 trajasek noship $ */
3: /*** Globals ***/
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 :=

Line 6: g_srcntacts_seq_name CONSTANT VARCHAR2(30) := 'CSM_SR_CONTACTS_ACC_S' ;

2: /* $Header: csmesrcb.pls 120.1 2005/07/25 00:22:12 trajasek noship $ */
3: /*** Globals ***/
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:

Line 22: FROM csm_sr_contacts_acc

18: l_user_id NUMBER;
19:
20: CURSOR l_user_csr (p_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%type) IS
21: SELECT access_id, user_id
22: FROM csm_sr_contacts_acc
23: WHERE sr_contact_point_id = p_sr_contact_point_id;
24:
25: l_user_rec l_user_csr% ROWTYPE;
26: l_sqlerrno VARCHAR2(20);

Line 114: FROM csm_sr_contacts_acc cont_acc

110: WHERE srcp.sr_contact_point_id = p_sr_contact_point_id
111: AND acc.incident_id = srcp.incident_id
112: AND NOT EXISTS
113: (SELECT 1
114: FROM csm_sr_contacts_acc cont_acc
115: WHERE cont_acc.sr_contact_point_id = srcp.sr_contact_point_id
116: AND cont_acc.user_id = acc.user_id)
117: ;
118:

Line 190: FROM csm_sr_contacts_acc cont_acc

186: WHERE srcp.sr_contact_point_id = p_sr_contact_point_id
187: AND acc.incident_id = srcp.incident_id
188: AND EXISTS
189: (SELECT 1
190: FROM csm_sr_contacts_acc cont_acc
191: WHERE cont_acc.sr_contact_point_id = srcp.sr_contact_point_id
192: AND cont_acc.user_id = acc.user_id)
193: ;
194:

Line 231: FROM csm_sr_contacts_acc acc,

227: CURSOR l_user_csr (p_contact_point_id hz_contact_points.contact_point_id%TYPE)
228: IS
229: SELECT acc.user_id,
230: acc.access_id
231: FROM csm_sr_contacts_acc acc,
232: cs_hz_sr_contact_points pts
233: WHERE acc.sr_contact_point_id = pts.sr_contact_point_id
234: AND pts.contact_point_id = p_contact_point_id;
235: