DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CSZ_SERVICEREQUEST_UTIL_PVT

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

634: CURSOR Get_Rel_Obj IS
635: SELECT CAST(MULTISET
636: (SELECT obj.name RelatedOB_name
637: , SrLnkEO.object_number RelatedOB_Number
638: , csz_servicerequest_util_pvt.get_rel_obj_details(SrLnkEO.object_type,
639: SrLnkEO.object_id) RelatedOB_Description
640: FROM cs_incident_links SrLnkEO
641: , jtf_objects_tl obj
642: WHERE SrLnkEO.subject_id = x_incident_id

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

1227:
1228:
1229: -- :Contact_Name
1230: CURSOR Get_Contact_Name (v_incident_id NUMBER, v_customer_id NUMBER) IS
1231: SELECT CSZ_SERVICEREQUEST_UTIL_PVT.get_contact_name(sr_cont.contact_type,
1232: sr_cont.party_id,
1233: v_customer_id)
1234: FROM cs_hz_sr_contact_points sr_cont
1235: WHERE sr_cont.incident_id = v_incident_id