APPS.CAC_SR_OBJECT_CAPACITY_PUB dependencies on JTF_TASK_ASSIGNMENTS

Line 129: , jtf_task_assignments jta

125: , jtb.planned_end_date
126: , jtb.address_id
127: , jtb.customer_id
128: from jtf_task_statuses_b jtsb
129: , jtf_task_assignments jta
130: , jtf_tasks_b jtb
131: where nvl(jtsb.closed_flag, 'N') = 'N'
132: and nvl(jtsb.completed_flag, 'N') = 'N'
133: and nvl(jtsb.cancelled_flag, 'N') = 'N'

Line 444: JTF_TASK_ASSIGNMENTS_PUB.UPDATE_TASK_ASSIGNMENT

440: AND p_Object_Capacity.EXISTS(p_Object_Tasks(l_idx).OBJECT_CAPACITY_TBL_IDX))
441: THEN
442: -- Call assignments api to update object capacity id
443: l_ovn := p_Object_Tasks(l_idx).TASK_ASSIGNMENT_OVN;
444: JTF_TASK_ASSIGNMENTS_PUB.UPDATE_TASK_ASSIGNMENT
445: (
446: p_api_version => 1.0,
447: p_commit => fnd_api.G_FALSE,
448: p_object_version_number => l_ovn,

Line 801: , jtf_task_assignments jta

797: is
798: select jta.task_assignment_id
799: , jta.object_version_number
800: from jtf_task_statuses_b jtsb
801: , jtf_task_assignments jta
802: , jtf_tasks_b jtb
803: where jtsb.task_status_id = jta.assignment_status_id
804: and jta.object_capacity_id = b_object_capacity_id
805: and jta.task_id = jtb.task_id

Line 859: JTF_TASK_ASSIGNMENTS_PUB.UPDATE_TASK_ASSIGNMENT

855: -- First get all the open task assignments and remove the object capacity
856: FOR ref_tasks IN c_tasks(p_object_capacity_id)
857: LOOP
858: -- Call assignments api to update object capacity id
859: JTF_TASK_ASSIGNMENTS_PUB.UPDATE_TASK_ASSIGNMENT
860: (
861: p_api_version => 1.0,
862: p_commit => fnd_api.G_FALSE,
863: p_object_version_number => ref_tasks.OBJECT_VERSION_NUMBER,