APPS.CSM_SR_EVENT_PKG dependencies on HZ_PARTIES

Line 303: l_party_id hz_parties.party_id%TYPE;

299: l_sqlerrmsg VARCHAR2(4000);
300: l_error_msg VARCHAR2(4000);
301: l_return_status VARCHAR2(2000);
302: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
303: l_party_id hz_parties.party_id%TYPE;
304:
305: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,
306: p_sr_contact_point_id NUMBER)
307: IS

Line 316: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)

312: FROM cs_hz_sr_contact_points
313: WHERE incident_id = p_incident_id
314: AND sr_contact_point_id = NVL(p_sr_contact_point_id, sr_contact_point_id);
315:
316: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)
317: IS
318: SELECT jtrs.resource_id
319: FROM jtf_rs_resource_extns jtrs
320: WHERE jtrs.source_id = p_party_id

Line 570: l_party_id hz_parties.party_id%TYPE;

566: l_sqlerrmsg VARCHAR2(4000);
567: l_error_msg VARCHAR2(4000);
568: l_return_status VARCHAR2(2000);
569: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
570: l_party_id hz_parties.party_id%TYPE;
571:
572: CURSOR l_srcontpts_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE,
573: p_sr_contact_point_id NUMBER)
574: IS

Line 583: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)

579: FROM cs_hz_sr_contact_points
580: WHERE incident_id = p_incident_id
581: AND sr_contact_point_id = NVL(p_sr_contact_point_id, sr_contact_point_id);
582:
583: CURSOR l_emp_resource_csr (p_party_id hz_parties.party_id%TYPE)
584: IS
585: SELECT jtrs.resource_id
586: FROM jtf_rs_resource_extns jtrs
587: WHERE jtrs.source_id = p_party_id