DBA Data[Home] [Help]

APPS.CAC_VIEW_AVAIL_PVT dependencies on JTF_TASK_UTL

Line 56: l_ResourceName := jtf_task_utl.get_owner(p_object_type_code => p_ResourceType

52: AND ( p_ResourceID IS NOT NULL )
53: AND ( p_ResourceType IS NOT NULL )
54: )
55: THEN
56: l_ResourceName := jtf_task_utl.get_owner(p_object_type_code => p_ResourceType
57: ,p_object_id => p_ResourceID);
58: ELSE
59: l_ResourceName := p_ResourceName;
60: END IF;

Line 729: , jtf_task_utl.get_owner(jta.resource_type_code, jta.resource_id) resource_name

725:
726: CURSOR c_resources (b_task_id NUMBER) IS
727: SELECT jta.resource_id
728: , jta.resource_type_code
729: , jtf_task_utl.get_owner(jta.resource_type_code, jta.resource_id) resource_name
730: FROM jtf_task_all_assignments jta
731: WHERE jta.task_id = b_task_id
732: AND jta.show_on_calendar = 'Y'
733: AND jta.assignment_status_id <> 4 -- using status rejected for declined