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

Line 404: FROM jtf_task_assignments ta, jtf_tasks_b t, jtf_task_statuses_b ts

400: , NVL (ts.closed_flag, 'N') closed_flag
401: , NVL (ts.cancelled_flag, 'N') cancelled_flag
402: , NVL (ts.completed_flag, 'N') completed_flag
403: , NVL (ts.rejected_flag, 'N') rejected_flag
404: FROM jtf_task_assignments ta, jtf_tasks_b t, jtf_task_statuses_b ts
405: WHERE ta.task_id = t.task_id
406: AND t.task_id = p_task_id
407: AND assignment_status_id = ts.task_status_id;
408:

Line 628: FROM jtf_tasks_b t, jtf_task_assignments ta

624: , t.scheduled_end_date
625: , t.task_split_flag
626: , t.task_status_id
627: , ta.resource_id
628: FROM jtf_tasks_b t, jtf_task_assignments ta
629: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
630:
631: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
632: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;

Line 633: l_resource_id jtf_task_assignments.resource_id%TYPE;

629: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
630:
631: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
632: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;
633: l_resource_id jtf_task_assignments.resource_id%TYPE;
634: l_split_flag jtf_tasks_b.task_split_flag%TYPE;
635: l_status_id jtf_task_statuses_b.task_status_id%TYPE;
636: BEGIN
637: -- Initialize API return status to success

Line 1297: FROM jtf_task_assignments ta, jtf_task_statuses_b ts

1293: , NVL (ts.closed_flag, 'N') closed_flag
1294: , NVL (ts.cancelled_flag, 'N') cancelled_flag
1295: , NVL (ts.completed_flag, 'N') completed_flag
1296: , NVL (ts.rejected_flag, 'N') rejected_flag
1297: FROM jtf_task_assignments ta, jtf_task_statuses_b ts
1298: WHERE ta.task_id = p_task_id
1299: AND ts.task_status_id = ta.assignment_status_id;
1300:
1301: l_task_status_id NUMBER;

Line 1363: jtf_task_assignments_pub.update_task_assignment(

1359: RAISE fnd_api.g_exc_error;
1360: END IF;
1361:
1362: -- All validations done. Close the Task Assignment
1363: jtf_task_assignments_pub.update_task_assignment(
1364: p_api_version => 1.0
1365: , x_return_status => x_return_status
1366: , x_msg_count => x_msg_count
1367: , x_msg_data => x_msg_data

Line 1750: FROM jtf_task_assignments tas, jtf_task_statuses_b ts

1746: , tas.assignment_status_id
1747: , tas.task_id
1748: , tas.actual_effort
1749: , tas.actual_effort_uom
1750: FROM jtf_task_assignments tas, jtf_task_statuses_b ts
1751: WHERE task_id = p_task_id
1752: AND ts.task_status_id = tas.assignment_status_id
1753: AND NVL(ts.cancelled_flag, 'N') <> 'Y'
1754: AND NVL(ts.closed_flag, 'N') <> 'Y'

Line 2350: , jtf_task_assignments ta

2346: , cac.status trip_status
2347: , ta.resource_id
2348: , ta.resource_type_code
2349: FROM jtf_tasks_b t
2350: , jtf_task_assignments ta
2351: , jtf_task_statuses_b ts
2352: , cac_sr_object_capacity cac
2353: WHERE t.task_id = p_task_id
2354: AND ta.task_id = t.task_id

Line 2381: , jtf_task_assignments ta

2377: , cac.status trip_status
2378: , ta.resource_id
2379: , ta.resource_type_code
2380: FROM jtf_tasks_b t
2381: , jtf_task_assignments ta
2382: , jtf_task_statuses_b ts
2383: , cac_sr_object_capacity cac
2384: WHERE t.task_id = p_task_id
2385: AND ta.task_id = t.task_id

Line 2629: , jtf_task_assignments ta

2625: CURSOR c_child_tasks (p_parent_task_id NUMBER) IS
2626: SELECT t.task_id
2627: , cac.status trip_status
2628: FROM jtf_tasks_b t
2629: , jtf_task_assignments ta
2630: , jtf_task_statuses_b ts
2631: , cac_sr_object_capacity cac
2632: WHERE t.parent_task_id = p_parent_task_id
2633: AND ta.task_id = t.task_id

Line 2646: FROM jtf_task_assignments a

2642: --for given task
2643: CURSOR check_assignments(p_task_id number)
2644: IS
2645: SELECT count(task_id)
2646: FROM jtf_task_assignments a
2647: , jtf_task_statuses_b b
2648: WHERE a.task_id = p_task_id
2649: AND a.assignment_status_id = b.task_status_id
2650: AND nvl(b.cancelled_flag ,'N') <> 'Y';

Line 2744: , jtf_task_assignments ta

2740: THEN
2741: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
2742: , t.task_split_flag
2743: FROM jtf_tasks_b t
2744: , jtf_task_assignments ta
2745: , jtf_task_statuses_b ts
2746: , (SELECT TO_NUMBER(SUBSTR(column_value
2747: , 1
2748: , INSTR(column_value, ''-'', 1, 1) - 1

Line 2778: , jtf_task_assignments ta

2774: ELSE
2775: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
2776: , t.task_split_flag
2777: FROM jtf_tasks_b t
2778: , jtf_task_assignments ta
2779: , jtf_task_statuses_b ts
2780: , (SELECT TO_NUMBER(SUBSTR(column_value
2781: , 1
2782: , INSTR(column_value, ''-'', 1, 1) - 1

Line 2821: , jtf_task_assignments ta

2817:
2818: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
2819: , t.task_split_flag
2820: FROM jtf_tasks_b t
2821: , jtf_task_assignments ta
2822: , jtf_task_statuses_b ts
2823: WHERE ta.resource_id = :1
2824: AND ta.resource_type_code = :2
2825: AND ts.task_status_id = ta.assignment_status_id

Line 2854: , jtf_task_assignments ta

2850: ELSIF p_trip_id IS NOT NULL THEN
2851: l_query := 'SELECT NVL(t.parent_task_id, t.task_id) task_id
2852: , task_split_flag
2853: FROM cac_sr_object_capacity cac
2854: , jtf_task_assignments ta
2855: , jtf_tasks_b t
2856: , jtf_task_statuses_b ts
2857: WHERE cac.object_capacity_id = :1
2858: AND ta.resource_id = cac.object_id

Line 3501: FROM jtf_task_assignments ta, jtf_task_statuses_b ats

3497: , t.object_version_number
3498: , t.scheduled_start_date
3499: , t.scheduled_end_date
3500: , NVL( ( SELECT 'Y'
3501: FROM jtf_task_assignments ta, jtf_task_statuses_b ats
3502: WHERE ta.task_id = p_task_id
3503: AND ta.assignment_status_id = ats.task_status_id
3504: AND NVL(ats.cancelled_flag, 'N') <> 'Y'
3505: AND ROWNUM = 1

Line 3514: FROM jtf_task_assignments ta

3510:
3511: CURSOR c_task_assignment_info IS
3512: SELECT ta.resource_id
3513: , ta.resource_type_code
3514: FROM jtf_task_assignments ta
3515: WHERE ta.task_assignment_id = p_old_task_assignment_id;
3516:
3517: l_task_info c_task_info%ROWTYPE;
3518: l_task_assignment_info c_task_assignment_info%ROWTYPE;

Line 3735: FROM jtf_tasks_b t , jtf_task_assignments ta

3731: , scheduled_start_date
3732: , scheduled_end_date
3733: , ta.assignment_status_id
3734: , ta.object_capacity_id
3735: FROM jtf_tasks_b t , jtf_task_assignments ta
3736: WHERE t.task_id = p_task_id
3737: AND ta.task_id = t.task_id
3738: AND ta.task_assignment_id = p_task_assignment_id;
3739:

Line 3917: jtf_task_assignments_pub.update_task_assignment(

3913: IF p_sched_travel_distance IS NOT NULL
3914: OR p_sched_travel_duration IS NOT NULL
3915: OR p_sched_travel_duration_uom IS NOT NULL
3916: THEN
3917: jtf_task_assignments_pub.update_task_assignment(
3918: p_api_version => 1.0
3919: , x_return_status => x_return_status
3920: , x_msg_count => x_msg_count
3921: , x_msg_data => x_msg_data

Line 4015: FROM jtf_tasks_b t ,jtf_task_statuses_b ts ,jtf_task_assignments ta

4011: , t.task_status_id
4012: , ta.task_assignment_id
4013: , ta.object_version_number task_assignment_ovn
4014: , ta.assignment_status_id
4015: FROM jtf_tasks_b t ,jtf_task_statuses_b ts ,jtf_task_assignments ta
4016: WHERE t.parent_task_id = p_task_id
4017: AND NVL(t.deleted_flag, 'N') <> 'Y'
4018: AND ts.task_status_id = t.task_status_id
4019: AND NVL(ts.cancelled_flag, 'N') <> 'Y'

Line 4374: jtf_task_assignments_pub.create_task_assignment(

4370: END IF;
4371: END IF;
4372:
4373: -- Create the Task Assignment
4374: jtf_task_assignments_pub.create_task_assignment(
4375: p_api_version => 1.0
4376: , x_return_status => x_return_status
4377: , x_msg_count => x_msg_count
4378: , x_msg_data => x_msg_data

Line 5177: from jtf_task_assignments jta,jtf_tasks_b jt

5173:
5174: cursor c_task_ass(p_task_id number)
5175: is
5176: select jta.task_assignment_id
5177: from jtf_task_assignments jta,jtf_tasks_b jt
5178: where jt.task_id=p_task_id
5179: and jta.task_id=jt.task_id
5180: and jt.source_object_type_code = 'TASK'
5181: and jt.task_type_id not in (20,21);