APPS.CS_SERVICEREQUEST_PVT dependencies on CS_HZ_SR_CONTACT_POINTS

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

2475:
2476: -- This record creation should not take place if caller_type is CALLER_EMP
2477: -- For Caller type Employee, should not create any contacts
2478: /* updating value of the primary_contact_id in the cs_incidents_all_b table
2479: after we insert record in cs_hz_sr_contact_points, so that
2480: sr_contact_point_id can be inserted as primary_contact_id by shijain
2481: for enh. 2690787
2482:
2483: l_primary_contact:= get_primary_contact(l_request_id);

Line 3711: l_primary_contact_party_id cs_hz_sr_contact_points.party_id % TYPE;

3707:
3708: l_start_eres_flag VARCHAR2(1);
3709: l_approval_status VARCHAR2(80);
3710: l_sr_related_data RELATED_DATA_TYPE;
3711: l_primary_contact_party_id cs_hz_sr_contact_points.party_id % TYPE;
3712: l_last_updated_by_temp NUMBER;
3713: BEGIN
3714:
3715: -- Standard start of API savepoint

Line 6072: -- Create entries in CS_HZ_SR_CONTACT_POINTS from p_contacts

6068: , p_comments => p_audit_comments
6069: , x_audit_id => l_audit_id
6070: );
6071: --
6072: -- Create entries in CS_HZ_SR_CONTACT_POINTS from p_contacts
6073: CS_SRCONTACT_PKG.create_update
6074: ( p_incident_id => p_request_id
6075: , p_invocation_mode => p_invocation_mode
6076: , p_sr_update_date => l_service_request_rec.last_update_date

Line 11993: -- inserting records into CS_HZ_SR_CONTACT_POINTS

11989: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #3');
11990:
11991: --
11992: -- The request_id needs to be generated here because it is needed when
11993: -- inserting records into CS_HZ_SR_CONTACT_POINTS
11994: -- This generation is done here because the earlier check to see if
11995: -- request id is unique is done only if validation level is set.
11996: --Commenting this because , selecting from dual is not supported anymore
11997: --because of performance reasons.

Line 19347: primary flag from the cs_hz_sr_contact_points table by shijain

19343:
19344:
19345: /* Added for enh.2690787, procedure to get the value of primary_contact_id for
19346: inserting into cs_incidents_all_b table based on the incident_id and the
19347: primary flag from the cs_hz_sr_contact_points table by shijain
19348:
19349: FUNCTION GET_PRIMARY_CONTACT( p_incident_id IN NUMBER)
19350: RETURN NUMBER IS
19351:

Line 19354: FROM cs_hz_sr_contact_points

19350: RETURN NUMBER IS
19351:
19352: CURSOR get_primary_contact IS
19353: SELECT sr_contact_point_id
19354: FROM cs_hz_sr_contact_points
19355: WHERE incident_id = p_incident_id
19356: AND primary_flag = 'Y';
19357:
19358: l_primary_contact NUMBER;