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_TRIPS_PUB dependencies on JTF_TASK_ASSIGNMENTS

Line 362: FROM jtf_task_assignments ta

358: SELECT 1
359: FROM cac_sr_object_capacity oc
360: WHERE object_capacity_id = p_trip_id
361: AND EXISTS (SELECT 1
362: FROM jtf_task_assignments ta
363: , jtf_task_statuses_b ts
364: , jtf_tasks_b t
365: WHERE ta.object_capacity_id = oc.object_capacity_id
366: AND ts.task_status_id = ta.assignment_status_id

Line 713: FROM jtf_task_assignments ta

709: , csf_util_pvt.convert_to_minutes(
710: ta.sched_travel_duration
711: , ta.sched_travel_duration_uom
712: ) travel_time
713: FROM jtf_task_assignments ta
714: , jtf_task_statuses_b ts
715: , jtf_tasks_b t
716: WHERE ta.resource_id = p_resource_id
717: AND ta.resource_type_code = p_resource_type

Line 952: , jtf_task_assignments ta

948: , t.task_number
949: , t.object_version_number task_ovn
950: , t.task_status_id
951: FROM cac_sr_object_capacity cac
952: , jtf_task_assignments ta
953: , jtf_tasks_b t
954: , jtf_task_statuses_b ts
955: WHERE cac.object_capacity_id = p_trip.trip_id
956: AND ta.resource_id = cac.object_id

Line 1154: FROM jtf_task_assignments ta

1150: SELECT t.task_id
1151: , t.object_version_number
1152: , t.task_name
1153: , t.task_number
1154: FROM jtf_task_assignments ta
1155: , jtf_tasks_vl t
1156: WHERE ta.object_capacity_id = p_trip.trip_id
1157: AND t.task_id = ta.task_id
1158: AND NVL(t.deleted_flag, 'N') = 'N'

Line 1304: , jtf_task_assignments ta

1300: , ta.object_version_number
1301: , ta.object_capacity_id wrong_trip_id
1302: , oc.object_capacity_id correct_trip_id
1303: FROM cac_sr_object_capacity oc
1304: , jtf_task_assignments ta
1305: , jtf_tasks_b t
1306: , jtf_task_statuses_b ts
1307: WHERE oc.object_capacity_id = p_trip.trip_id
1308: AND ta.resource_id = oc.object_id

Line 1328: , jtf_task_assignments ta

1324: , ta.object_version_number
1325: , p_trip.trip_id wrong_trip_id
1326: , oc.object_capacity_id correct_trip_id
1327: FROM cac_sr_object_capacity oc
1328: , jtf_task_assignments ta
1329: , jtf_tasks_b t
1330: , jtf_task_statuses_b ts
1331: WHERE ta.object_capacity_id = p_trip.trip_id
1332: AND oc.object_id = ta.resource_id

Line 1350: FROM jtf_task_assignments ta

1346: , ta.task_assignment_id
1347: , ta.object_version_number
1348: , to_number(NULL) wrong_trip_id
1349: , p_trip.trip_id correct_trip_id
1350: FROM jtf_task_assignments ta
1351: , jtf_tasks_b t
1352: WHERE ta.task_id IN (l_dep_task_id, l_arr_task_id)
1353: AND t.task_id = ta.task_id;
1354:

Line 1361: FROM jtf_task_assignments ta

1357: , SUM (NVL(csf_util_pvt.convert_to_minutes(
1358: ta.sched_travel_duration
1359: , ta.sched_travel_duration_uom
1360: ), 0)) travel_time
1361: FROM jtf_task_assignments ta
1362: , jtf_task_statuses_b ts
1363: WHERE ta.object_capacity_id = p_trip.trip_id
1364: AND ts.task_status_id = ta.assignment_status_id
1365: AND NVL(ts.closed_flag, 'N') = 'N'

Line 1377: FROM jtf_task_assignments ta

1373: , t.task_name
1374: , t.task_number
1375: , LAG(t.task_id) OVER (PARTITION BY t.task_type_id
1376: ORDER BY t.scheduled_start_date) duplicate
1377: FROM jtf_task_assignments ta
1378: , jtf_tasks_vl t
1379: WHERE ta.object_capacity_id = p_trip.trip_id
1380: AND t.task_id = ta.task_id
1381: AND NVL(t.deleted_flag, 'N') = 'N'

Line 1468: jtf_task_assignments_pub.update_task_assignment(

1464: IF l_debug THEN
1465: debug(' TaskID#' || v_task.task_id || ' is part of Trip#' || v_task.wrong_trip_id || '. But should be in Trip#' || v_task.correct_trip_id || '. Fixing the Task', l_api_name, fnd_log.level_statement);
1466: END IF;
1467:
1468: jtf_task_assignments_pub.update_task_assignment(
1469: p_api_version => 1.0
1470: , x_return_status => x_return_status
1471: , x_msg_data => x_msg_data
1472: , x_msg_count => x_msg_count

Line 1724: , jtf_task_assignments ta

1720: -- Query to check for the existence of Stray Shift Tasks
1721: CURSOR c_shift_tasks_exist (p_res_id NUMBER, p_res_type VARCHAR2, p_start DATE, p_end DATE) IS
1722: SELECT 'Y'
1723: FROM jtf_tasks_b t
1724: , jtf_task_assignments ta
1725: WHERE t.owner_id = p_res_id
1726: AND t.owner_type_code = p_res_type
1727: AND t.planned_start_date BETWEEN p_start AND p_end
1728: AND t.task_type_id IN (20, 21)

Line 1749: , jtf_task_assignments ta

1745: ta.sched_travel_duration
1746: , ta.sched_travel_duration_uom
1747: ) travel_time
1748: FROM TABLE ( CAST(l_del_trip_tbl AS jtf_number_table) ) oc
1749: , jtf_task_assignments ta
1750: , jtf_task_statuses_b ts
1751: , jtf_tasks_b t
1752: WHERE ta.object_capacity_id = oc.COLUMN_VALUE
1753: AND ts.task_status_id = ta.assignment_status_id

Line 1766: FROM jtf_task_assignments jta,

1762:
1763:
1764: CURSOR c_linkable_tasks(l_trip number) IS
1765: SELECT tb.task_id
1766: FROM jtf_task_assignments jta,
1767: jtf_tasks_b tb,
1768: jtf_task_statuses_b jts
1769: WHERE jta.object_capacity_id=l_trip
1770: AND jta.task_id=tb.task_id

Line 2146: jtf_task_assignments_pub.update_task_assignment(

2142: l_trip_length := l_trip_length
2143: + v_task.booking_end_date - v_task.booking_start_date
2144: + NVL(v_task.travel_time, 0) / g_mins_in_day;
2145:
2146: jtf_task_assignments_pub.update_task_assignment(
2147: p_api_version => 1.0
2148: , x_return_status => x_return_status
2149: , x_msg_data => x_msg_data
2150: , x_msg_count => x_msg_count

Line 2406: , jtf_task_assignments dta

2402: , a.task_id arr_task_id
2403: , d.planned_start_date start_time
2404: , a.planned_end_date end_time
2405: FROM jtf_tasks_b d
2406: , jtf_task_assignments dta
2407: , jtf_tasks_b a
2408: , jtf_task_assignments ata
2409: WHERE d.owner_id = p_resource_tbl(1).resource_id
2410: AND d.owner_type_code = p_resource_tbl(1).resource_type

Line 2408: , jtf_task_assignments ata

2404: , a.planned_end_date end_time
2405: FROM jtf_tasks_b d
2406: , jtf_task_assignments dta
2407: , jtf_tasks_b a
2408: , jtf_task_assignments ata
2409: WHERE d.owner_id = p_resource_tbl(1).resource_id
2410: AND d.owner_type_code = p_resource_tbl(1).resource_type
2411: AND d.planned_start_date BETWEEN p_start_date AND p_end_date
2412: AND d.task_type_id = 20

Line 4086: FROM jtf_task_assignments ta

4082: , csf_util_pvt.convert_to_minutes(
4083: ta.sched_travel_duration
4084: , ta.sched_travel_duration_uom
4085: ) travel_time
4086: FROM jtf_task_assignments ta
4087: , jtf_task_statuses_b ts
4088: , jtf_tasks_b t
4089: WHERE ta.resource_id = p_resource_id
4090: AND ta.resource_type_code = p_resource_type

Line 4104: FROM jtf_task_assignments ta

4100: AND (t.task_type_id NOT IN (20, 21) OR t.task_id IN (l_dep_task_id, l_arr_task_id));
4101:
4102: CURSOR c_shift_tasks_info IS
4103: SELECT ta.task_assignment_id, ta.object_version_number, ta.task_id
4104: FROM jtf_task_assignments ta
4105: WHERE ta.task_id IN (l_dep_task_id, l_arr_task_id);
4106:
4107: BEGIN
4108: SAVEPOINT csf_new_trip;

Line 4971: , jtf_task_assignments ta

4967: CURSOR c_dangling_tasks(p_res_id number,p_res_type varchar2)
4968: IS
4969: SELECT t.task_id,t.object_version_number,scheduled_start_date,scheduled_end_date
4970: FROM jtf_tasks_b t
4971: , jtf_task_assignments ta
4972: WHERE t.owner_id = p_res_id
4973: AND t.owner_type_code = p_res_type
4974: AND t.planned_start_date BETWEEN p_start AND p_end
4975: AND t.task_type_id IN (20, 21)

Line 4988: AND TASK_ID NOT IN (SELECT ta.TASK_ID FROM JTF_TASK_ASSIGNMENTS ta WHERE ta.task_id=t.task_id and RESOURCE_ID = p_res_id

4984: AND t.owner_type_code = p_res_type
4985: AND t.task_type_id IN (20, 21)
4986: AND NVL(t.deleted_flag, 'N') <> 'Y'
4987: AND( t.planned_start_date BETWEEN p_start AND p_end )
4988: AND TASK_ID NOT IN (SELECT ta.TASK_ID FROM JTF_TASK_ASSIGNMENTS ta WHERE ta.task_id=t.task_id and RESOURCE_ID = p_res_id
4989: AND RESOURCE_TYPE_CODE = p_res_type);
4990:
4991: CURSOR c_alone_trip_tasks(p_res_id number,p_res_type varchar2)
4992: IS

Line 5001: FROM JTF_TASK_ASSIGNMENTS

4997: owner_type_code
4998: FROM JTF_TASKS_B
4999: WHERE TASK_ID IN
5000: (SELECT TASK_ID
5001: FROM JTF_TASK_ASSIGNMENTS
5002: WHERE OBJECT_CAPACITY_ID IN
5003: (SELECT co.object_capacity_id
5004: FROM cac_sr_object_capacity co,
5005: jtf_tasks_b jtb,

Line 5006: jtf_task_assignments jta,

5002: WHERE OBJECT_CAPACITY_ID IN
5003: (SELECT co.object_capacity_id
5004: FROM cac_sr_object_capacity co,
5005: jtf_tasks_b jtb,
5006: jtf_task_assignments jta,
5007: jtf_task_statuses_b jts,
5008: jtf_Task_statuses_b jtsa
5009: WHERE jtb.task_id =jta.task_id
5010: AND jta.assignment_status_id =jts.task_status_id

Line 5111: FROM jtf_task_assignments ta

5107: , t.task_name
5108: , t.task_number
5109: , LAG(t.task_id) OVER (PARTITION BY t.task_type_id,resource_id,resource_type_code,scheduled_start_date
5110: ORDER BY t.scheduled_start_date) duplicate
5111: FROM jtf_task_assignments ta
5112: , jtf_tasks_vl t
5113: WHERE t.task_id = ta.task_id
5114: AND NVL(t.deleted_flag, 'N') = 'N'
5115: AND t.task_type_id IN (20, 21)

Line 5191: FROM jtf_task_assignments ta

5187: , csf_util_pvt.convert_to_minutes(
5188: ta.sched_travel_duration
5189: , ta.sched_travel_duration_uom
5190: ) travel_time
5191: FROM jtf_task_assignments ta
5192: , jtf_task_statuses_b ts
5193: , jtf_tasks_b t
5194: WHERE ta.resource_id = p_resource_id
5195: AND ta.resource_type_code = p_resource_type

Line 5257: JTF_TASK_ASSIGNMENTS_PUB.UPDATE_TASK_ASSIGNMENT(

5253: OPEN c_trip_info(l_tasks.object_capacity_id);
5254: FETCH c_trip_info INTO l_trip_info;
5255: CLOSE c_trip_info;
5256:
5257: JTF_TASK_ASSIGNMENTS_PUB.UPDATE_TASK_ASSIGNMENT(
5258: p_api_version => 1.0,
5259: p_commit => fnd_api.G_FALSE,
5260: p_object_version_number => l_tasks.OBJECT_VERSION_NUMBER,
5261: p_task_assignment_id => l_tasks.TASK_ASSIGNMENT_ID,