DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CSZ_SERVICEREQUEST_UTIL_PVT

Line 622: , csz_servicerequest_util_pvt.get_rel_obj_details(SrLnkEO.object_type,

618: CURSOR Get_Rel_Obj IS
619: SELECT CAST(MULTISET
620: (SELECT obj.name RelatedOB_name
621: , SrLnkEO.object_number RelatedOB_Number
622: , csz_servicerequest_util_pvt.get_rel_obj_details(SrLnkEO.object_type,
623: SrLnkEO.object_id) RelatedOB_Description
624: FROM cs_incident_links SrLnkEO
625: , jtf_objects_tl obj
626: WHERE SrLnkEO.subject_id = x_incident_id

Line 1160: SELECT CSZ_SERVICEREQUEST_UTIL_PVT.get_contact_name(sr_cont.contact_type,

1156:
1157:
1158: -- :Contact_Name
1159: CURSOR Get_Contact_Name (v_incident_id NUMBER, v_customer_id NUMBER) IS
1160: SELECT CSZ_SERVICEREQUEST_UTIL_PVT.get_contact_name(sr_cont.contact_type,
1161: sr_cont.party_id,
1162: v_customer_id)
1163: FROM cs_hz_sr_contact_points sr_cont
1164: WHERE sr_cont.incident_id = v_incident_id