APPS.CSM_SR_CONTACT_EVENT_PKG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 5: g_srcntacts_table_name CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';

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

Line 15: l_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%type;

11: l_markdirty_failed EXCEPTION;
12:
13: PROCEDURE SR_CNTACT_MDIRTY_U_FOREACHUSER(p_sr_contact_point_id IN NUMBER)
14: IS
15: l_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%type;
16: l_access_id NUMBER;
17: l_err_msg VARCHAR2(4000);
18: l_user_id NUMBER;
19:

Line 20: CURSOR l_user_csr (p_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%type) IS

16: l_access_id NUMBER;
17: l_err_msg VARCHAR2(4000);
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:

Line 104: CURSOR l_sr_contact_usr_csr (p_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%TYPE)

100: l_sqlerrmsg VARCHAR2(4000);
101: l_error_msg VARCHAR2(4000);
102: l_return_status VARCHAR2(2000);
103:
104: CURSOR l_sr_contact_usr_csr (p_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%TYPE)
105: IS
106: SELECT acc.incident_id,
107: acc.user_id
108: FROM cs_hz_sr_contact_points srcp,

Line 108: FROM cs_hz_sr_contact_points srcp,

104: CURSOR l_sr_contact_usr_csr (p_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%TYPE)
105: IS
106: SELECT acc.incident_id,
107: acc.user_id
108: FROM cs_hz_sr_contact_points srcp,
109: csm_incidents_all_acc 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

Line 180: CURSOR l_sr_contact_usr_csr (p_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%TYPE)

176: l_sqlerrmsg VARCHAR2(4000);
177: l_error_msg VARCHAR2(4000);
178: l_return_status VARCHAR2(2000);
179:
180: CURSOR l_sr_contact_usr_csr (p_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%TYPE)
181: IS
182: SELECT acc.incident_id,
183: acc.user_id
184: FROM cs_hz_sr_contact_points srcp,

Line 184: FROM cs_hz_sr_contact_points srcp,

180: CURSOR l_sr_contact_usr_csr (p_sr_contact_point_id cs_hz_sr_contact_points.sr_contact_point_id%TYPE)
181: IS
182: SELECT acc.incident_id,
183: acc.user_id
184: FROM cs_hz_sr_contact_points srcp,
185: csm_incidents_all_acc acc
186: WHERE srcp.sr_contact_point_id = p_sr_contact_point_id
187: AND acc.incident_id = srcp.incident_id
188: AND EXISTS

Line 232: cs_hz_sr_contact_points pts

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:
236: BEGIN