APPS.CS_SERVICEREQUEST_PVT dependencies on CS_HZ_SR_CONTACT_POINTS

Line 2809: after we insert record in cs_hz_sr_contact_points, so that

2805:
2806: -- This record creation should not take place if caller_type is CALLER_EMP
2807: -- For Caller type Employee, should not create any contacts
2808: /* updating value of the primary_contact_id in the cs_incidents_all_b table
2809: after we insert record in cs_hz_sr_contact_points, so that
2810: sr_contact_point_id can be inserted as primary_contact_id by shijain
2811: for enh. 2690787
2812:
2813: l_primary_contact:= get_primary_contact(l_request_id);

Line 4062: l_primary_contact_party_id cs_hz_sr_contact_points.party_id % TYPE;

4058:
4059: l_start_eres_flag VARCHAR2(1);
4060: l_approval_status VARCHAR2(80);
4061: l_sr_related_data RELATED_DATA_TYPE;
4062: l_primary_contact_party_id cs_hz_sr_contact_points.party_id % TYPE;
4063: l_last_updated_by_temp NUMBER;
4064:
4065: --siahmed added for update onetime address
4066: l_incident_location_id NUMBER;

Line 6853: -- Create entries in CS_HZ_SR_CONTACT_POINTS from p_contacts

6849: , x_audit_id => l_audit_id
6850: );
6851: END IF; -- end of addition by siahmed for invocation_mode high avaialibility project
6852: --
6853: -- Create entries in CS_HZ_SR_CONTACT_POINTS from p_contacts
6854: CS_SRCONTACT_PKG.create_update
6855: ( p_incident_id => p_request_id
6856: , p_invocation_mode => p_invocation_mode
6857: , p_sr_update_date => l_service_request_rec.last_update_date

Line 13035: -- inserting records into CS_HZ_SR_CONTACT_POINTS

13031: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #3');
13032:
13033: --
13034: -- The request_id needs to be generated here because it is needed when
13035: -- inserting records into CS_HZ_SR_CONTACT_POINTS
13036: -- This generation is done here because the earlier check to see if
13037: -- request id is unique is done only if validation level is set.
13038: --Commenting this because , selecting from dual is not supported anymore
13039: --because of performance reasons.

Line 20863: primary flag from the cs_hz_sr_contact_points table by shijain

20859:
20860:
20861: /* Added for enh.2690787, procedure to get the value of primary_contact_id for
20862: inserting into cs_incidents_all_b table based on the incident_id and the
20863: primary flag from the cs_hz_sr_contact_points table by shijain
20864:
20865: FUNCTION GET_PRIMARY_CONTACT( p_incident_id IN NUMBER)
20866: RETURN NUMBER IS
20867:

Line 20870: FROM cs_hz_sr_contact_points

20866: RETURN NUMBER IS
20867:
20868: CURSOR get_primary_contact IS
20869: SELECT sr_contact_point_id
20870: FROM cs_hz_sr_contact_points
20871: WHERE incident_id = p_incident_id
20872: AND primary_flag = 'Y';
20873:
20874: l_primary_contact NUMBER;