DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CSF_TASKS_PUB

Line 170: AND lo.location_id = csf_tasks_pub.get_task_location_id(tb.task_id, tb.address_id, tb.location_id)

166: AND tb.source_object_type_code = 'SR'
167: AND tb.source_object_id = ib.incident_id
168: AND tb.source_object_id = it.incident_id
169: AND it.LANGUAGE = USERENV('lang')
170: AND lo.location_id = csf_tasks_pub.get_task_location_id(tb.task_id, tb.address_id, tb.location_id)
171: AND ib.customer_id = pa.party_id(+);
172:
173: -- Phone Area Code
174: CURSOR c_contact_point(b_party_id NUMBER) IS

Line 919: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id);

915: CURSOR c_task_geometry IS
916: SELECT l.geometry
917: FROM jtf_tasks_b t, hz_locations l
918: WHERE t.task_id = p_task_id
919: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id);
920:
921: CURSOR c_sorted_resources IS
922: SELECT resource_index
923: , distance

Line 2403: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, 'CSF_TASKS_PUB') THEN

2399: WHERE resource_id = p_resource_id
2400: AND p_resource_type NOT IN('RS_GROUP', 'RS_TEAM');
2401: BEGIN
2402: -- Standard call to check for call compatibility
2403: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, 'CSF_TASKS_PUB') THEN
2404: RAISE fnd_api.g_exc_unexpected_error;
2405: END IF;
2406:
2407: -- Initialize message list if p_init_msg_list is set to TRUE