eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_TASK_ASSIGNMENTS_PUB dependencies on JTF_TASK_ASSIGNMENTS

Line 84: , jtf_task_assignments ta

80: , csf_util_pvt.convert_to_minutes(ta.actual_travel_duration, ta.actual_travel_duration_uom) actual_travel_duration
81: , cac.object_capacity_id old_trip_id
82: , cac.object_version_number old_trip_ovn
83: FROM jtf_tasks_b t
84: , jtf_task_assignments ta
85: , jtf_task_statuses_b ts
86: , cac_sr_object_capacity cac
87: WHERE t.task_id = p_task_id
88: AND ta.task_id (+) = t.task_id

Line 332: FROM jtf_task_assignments ta2, jtf_task_statuses_b ts2

328: , cac.object_capacity_id trip_id
329: , cac.object_version_number trip_ovn
330: , NVL(
331: ( SELECT 'Y'
332: FROM jtf_task_assignments ta2, jtf_task_statuses_b ts2
333: WHERE ta2.task_id = t.task_id
334: AND ta2.task_assignment_id <> ta.task_assignment_id
335: AND ts2.task_status_id = ta2.assignment_status_id
336: AND NVL(ts2.cancelled_flag, 'N') <> 'Y'

Line 345: , jtf_task_assignments ta

341: )
342: , 'N'
343: ) other_ta_exists
344: FROM jtf_tasks_b t
345: , jtf_task_assignments ta
346: , cac_sr_object_capacity cac
347: WHERE ta.task_assignment_id = p_task_assignment_id
348: AND t.task_id = ta.task_id
349: AND cac.object_capacity_id (+) = ta.object_capacity_id;

Line 353: from jtf_Task_assignments jta , jtf_task_statuses_b jtb

349: AND cac.object_capacity_id (+) = ta.object_capacity_id;
350:
351: cursor c_tasks is
352: select jta.assignment_status_id,jtb.validation_start_date,jtb.validation_end_date,jta.task_id,JTA.OBJECT_CAPACITY_ID
353: from jtf_Task_assignments jta , jtf_task_statuses_b jtb
354: where jta.assignment_status_id= jtb.task_status_id
355: and jta.task_assignment_id=p_task_assignment_id
356: and jtb.enforce_validation_flag = 'Y'
357: and nvl(jtb.validation_start_date,sysdate) <= sysdate

Line 565: FROM jtf_task_assignments ta, jtf_task_statuses_b ts

561:
562: CURSOR c_cancelled_assignments IS
563: SELECT ta.task_assignment_id
564: , ta.object_version_number
565: FROM jtf_task_assignments ta, jtf_task_statuses_b ts
566: WHERE ta.task_id = p_task_id
567: AND ta.resource_id = p_resource_id
568: AND ta.resource_type_code = p_resource_type_code
569: AND ta.assignment_status_id = ts.task_status_id

Line 576: FROM jtf_task_assignments

572: AND ts.cancelled_flag = 'Y';
573:
574: CURSOR c_assignment_info IS
575: SELECT object_version_number
576: FROM jtf_task_assignments
577: WHERE task_assignment_id = x_task_assignment_id;
578:
579: l_cancelled_assignments c_cancelled_assignments%ROWTYPE;
580: l_trans_valid VARCHAR2(1);

Line 684: jtf_task_assignments_pub.create_task_assignment(

680: , x_task_object_version_number => x_task_object_version_number
681: , x_task_status_id => x_task_status_id
682: );
683: ELSE
684: jtf_task_assignments_pub.create_task_assignment(
685: p_api_version => 1.0
686: , x_return_status => x_return_status
687: , x_msg_count => x_msg_count
688: , x_msg_data => x_msg_data

Line 877: FROM jtf_task_assignments ta

873:
874: -- cursor to fetch Information about the Task Assignment.
875: CURSOR c_task_assignment_info IS
876: SELECT ta.assignment_status_id, ta.task_id
877: FROM jtf_task_assignments ta
878: WHERE task_assignment_id = p_task_assignment_id;
879:
880: cursor c_tasks is
881: select jta.assignment_status_id,jta.task_id,JTA.OBJECT_CAPACITY_ID,object_version_number

Line 882: from jtf_Task_assignments jta

878: WHERE task_assignment_id = p_task_assignment_id;
879:
880: cursor c_tasks is
881: select jta.assignment_status_id,jta.task_id,JTA.OBJECT_CAPACITY_ID,object_version_number
882: from jtf_Task_assignments jta
883: where jta.task_assignment_id=p_task_assignment_id;
884:
885: CURSOR c_cross_task(p_sched_start_date date, p_sched_end_date date)
886: IS

Line 959: -- lets retrieve it from JTF_TASK_ASSIGNMENTS. If the caller has indeeed

955: FETCH c_task_assignment_info INTO l_old_assignment_status_id, l_task_id;
956: CLOSE c_task_assignment_info;
957:
958: -- We require Task Id for computations. If the caller doesnt pass Task Id
959: -- lets retrieve it from JTF_TASK_ASSIGNMENTS. If the caller has indeeed
960: -- passed it, then use that value.
961: IF p_task_id <> fnd_api.g_miss_num AND p_task_id IS NOT NULL THEN
962: l_task_id := p_task_id;
963: END IF;

Line 1073: jtf_task_assignments_pub.update_task_assignment(

1069: IF l_modified_ver_no IS NULL
1070: THEN
1071: l_modified_ver_no :=p_object_version_number;
1072: END IF;
1073: jtf_task_assignments_pub.update_task_assignment(
1074: p_api_version => 1.0
1075: , x_return_status => x_return_status
1076: , x_msg_count => x_msg_count
1077: , x_msg_data => x_msg_data

Line 1257: FROM jtf_task_assignments ta

1253:
1254: -- cursor to fetch Information about the Task Assignment.
1255: CURSOR c_task_assignment_info IS
1256: SELECT ta.assignment_status_id,ta.task_id
1257: FROM jtf_task_assignments ta
1258: WHERE task_assignment_id = p_task_assignment_id;
1259:
1260: -- Fetch the Cancelled Flag corresponding to the new Task Status.
1261: CURSOR c_task_status_info IS

Line 1268: from jtf_Task_assignments jta

1264: WHERE ts.task_status_id = p_assignment_status_id;
1265:
1266: cursor c_tasks is
1267: select jta.assignment_status_id,jta.task_id,JTA.OBJECT_CAPACITY_ID
1268: from jtf_Task_assignments jta
1269: where jta.task_assignment_id=p_task_assignment_id;
1270:
1271: CURSOR c_cross_task(p_sched_start_date date, p_sched_end_date date)
1272: IS

Line 1417: jtf_task_assignments_pub.update_task_assignment(

1413: -- Update the Task Assignment.
1414:
1415:
1416: -- Update the Task Assignment.
1417: jtf_task_assignments_pub.update_task_assignment(
1418: p_api_version => 1.0
1419: , x_return_status => x_return_status
1420: , x_msg_count => x_msg_count
1421: , x_msg_data => x_msg_data

Line 1497: jtf_task_assignments jta,

1493: cac.object_capacity_id,
1494: cac.start_date_time ,
1495: cac.end_date_time
1496: FROM jtf_tasks_b jtb ,
1497: jtf_task_assignments jta,
1498: cac_sr_object_capacity cac
1499: WHERE jta.task_assignment_id = p_task_assignment_id
1500: AND jta.task_id = jtb.task_id
1501: AND cac.object_capacity_id (+) = jta.object_capacity_id;

Line 1508: FROM jtf_task_assignments a ,

1504: IS
1505: SELECT b.task_id ,
1506: a.task_assignment_id,
1507: a.assignment_status_id
1508: FROM jtf_task_assignments a ,
1509: jtf_tasks_b b
1510: WHERE object_capacity_id = p_trip
1511: AND a.task_id =b.task_id
1512: AND b.task_id NOT IN (p_task)

Line 1844: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;

1840: scheduled_dates c_scheduled_dates%rowtype;
1841:
1842: BEGIN
1843:
1844: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
1845: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
1846: l_assignment_status := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;
1847:
1848: open c_scheduled_dates(l_task_id);

Line 1845: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

1841:
1842: BEGIN
1843:
1844: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
1845: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
1846: l_assignment_status := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;
1847:
1848: open c_scheduled_dates(l_task_id);
1849: fetch c_scheduled_dates into scheduled_dates;

Line 1846: l_assignment_status := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;

1842: BEGIN
1843:
1844: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
1845: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
1846: l_assignment_status := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;
1847:
1848: open c_scheduled_dates(l_task_id);
1849: fetch c_scheduled_dates into scheduled_dates;
1850: IF c_scheduled_dates%FOUND then