DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CSF_TASKS_PUB

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

147: AND tb.source_object_type_code = 'SR'
148: AND tb.source_object_id = ib.incident_id
149: AND tb.source_object_id = it.incident_id
150: AND it.LANGUAGE = USERENV('lang')
151: AND lo.location_id = csf_tasks_pub.get_task_location_id(tb.task_id, tb.address_id, tb.location_id)
152: AND ib.customer_id = pa.party_id(+);
153:
154: -- Phone Area Code
155: CURSOR c_contact_point(b_party_id NUMBER) IS

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

751: CURSOR c_task_geometry IS
752: SELECT l.geometry
753: FROM jtf_tasks_b t, hz_locations l
754: WHERE t.task_id = p_task_id
755: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id);
756:
757: CURSOR c_sorted_resources IS
758: SELECT resource_index
759: , distance

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

1855: WHERE resource_id = p_resource_id
1856: AND p_resource_type NOT IN('RS_GROUP', 'RS_TEAM');
1857: BEGIN
1858: -- Standard call to check for call compatibility
1859: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, 'CSF_TASKS_PUB') THEN
1860: RAISE fnd_api.g_exc_unexpected_error;
1861: END IF;
1862:
1863: -- Initialize message list if p_init_msg_list is set to TRUE