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_STATUSES_B

Line 57: FUNCTION is_cancel_status (p_status_id jtf_task_statuses_b.task_status_id%TYPE)

53:
54: /*******************************************************************************
55: * Private Functions and Procedures *
56: ********************************************************************************/
57: FUNCTION is_cancel_status (p_status_id jtf_task_statuses_b.task_status_id%TYPE)
58: RETURN BOOLEAN IS
59: CURSOR c_cancelled_flag IS
60: SELECT task_status_id
61: FROM jtf_task_statuses_b

Line 61: FROM jtf_task_statuses_b

57: FUNCTION is_cancel_status (p_status_id jtf_task_statuses_b.task_status_id%TYPE)
58: RETURN BOOLEAN IS
59: CURSOR c_cancelled_flag IS
60: SELECT task_status_id
61: FROM jtf_task_statuses_b
62: WHERE task_status_id = p_status_id
63: AND NVL (cancelled_flag, 'N') = 'Y';
64: BEGIN
65: FOR v_cancelled_flag IN c_cancelled_flag LOOP

Line 90: FROM jtf_task_statuses_b

86: FUNCTION has_schedulable_status (p_task_status_id NUMBER)
87: RETURN BOOLEAN IS
88: CURSOR c_task_status IS
89: SELECT task_status_id
90: FROM jtf_task_statuses_b
91: WHERE NVL (schedulable_flag, 'N') = 'Y'
92: AND task_status_id = p_task_status_id;
93: BEGIN
94: FOR v_task_status IN c_task_status LOOP

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

350: , NVL (ts.closed_flag, 'N') closed_flag
351: , NVL (ts.cancelled_flag, 'N') cancelled_flag
352: , NVL (ts.completed_flag, 'N') completed_flag
353: , NVL (ts.rejected_flag, 'N') rejected_flag
354: FROM jtf_task_assignments ta, jtf_tasks_b t, jtf_task_statuses_b ts
355: WHERE ta.task_id = t.task_id
356: AND t.task_id = p_task_id
357: AND assignment_status_id = ts.task_status_id;
358:

Line 552: l_status_id jtf_task_statuses_b.task_status_id%TYPE;

548: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
549: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;
550: l_resource_id jtf_task_assignments.resource_id%TYPE;
551: l_split_flag jtf_tasks_b.task_split_flag%TYPE;
552: l_status_id jtf_task_statuses_b.task_status_id%TYPE;
553: BEGIN
554: -- Initialize API return status to success
555: x_return_status := fnd_api.g_ret_sts_success;
556:

Line 605: , jtf_task_statuses_b s

601:
602: CURSOR c_esc(b_task_id NUMBER) IS
603: SELECT 1
604: FROM jtf_tasks_b t
605: , jtf_task_statuses_b s
606: WHERE t.task_id = b_task_id
607: AND t.task_type_id = g_esc_task_type_id
608: AND s.task_status_id = t.task_status_id
609: AND NVL(s.closed_flag, 'N') <> 'Y'

Line 1169: , jtf_task_statuses_b ts

1165: CURSOR c_cancel_task_assignments IS
1166: SELECT ta.task_assignment_id
1167: , ta.object_version_number
1168: FROM csf_ct_task_assignments ta
1169: , jtf_task_statuses_b ts
1170: WHERE ta.task_id = p_task_id
1171: AND ts.task_status_id = ta.assignment_status_id
1172: AND ( NVL (ts.working_flag, 'N') = 'Y'
1173: OR NVL (ts.accepted_flag, 'N') = 'Y'

Line 1191: FROM jtf_task_assignments ta, jtf_task_statuses_b ts

1187: , NVL (ts.closed_flag, 'N') closed_flag
1188: , NVL (ts.cancelled_flag, 'N') cancelled_flag
1189: , NVL (ts.completed_flag, 'N') completed_flag
1190: , NVL (ts.rejected_flag, 'N') rejected_flag
1191: FROM jtf_task_assignments ta, jtf_task_statuses_b ts
1192: WHERE ta.task_id = p_task_id
1193: AND ts.task_status_id = ta.assignment_status_id;
1194:
1195: l_task_status_id NUMBER;

Line 1307: , jtf_task_statuses_b ts

1303: , t.scheduled_end_date
1304: , t.object_version_number
1305: , t.source_object_type_code
1306: FROM jtf_tasks_b t
1307: , jtf_task_statuses_b ts
1308: WHERE task_id = p_task_id
1309: AND ts.task_status_id = t.task_status_id;
1310:
1311: -- Fetch the Flags corresponding to the new Task Status.

Line 1315: FROM jtf_task_statuses_b ts

1311: -- Fetch the Flags corresponding to the new Task Status.
1312: CURSOR c_task_status_info IS
1313: SELECT NVL (ts.closed_flag, 'N') closed_flag
1314: , NVL (ts.cancelled_flag, 'N') cancelled_flag
1315: FROM jtf_task_statuses_b ts
1316: WHERE ts.task_status_id = p_task_status_id;
1317:
1318:
1319: l_task_info c_task_info%ROWTYPE;

Line 1572: FROM jtf_task_assignments tas, jtf_task_statuses_b ts

1568: , tas.assignment_status_id
1569: , tas.task_id
1570: , tas.actual_effort
1571: , tas.actual_effort_uom
1572: FROM jtf_task_assignments tas, jtf_task_statuses_b ts
1573: WHERE task_id = p_task_id
1574: AND ts.task_status_id = tas.assignment_status_id
1575: AND NVL(ts.cancelled_flag, 'N') <> 'Y'
1576: AND NVL(ts.closed_flag, 'N') <> 'Y'

Line 1588: FROM jtf_task_statuses_b ts

1584: -- Fetch the Flags corresponding to the new Task Status.
1585: CURSOR c_task_status_info IS
1586: SELECT NVL (ts.closed_flag, 'N') closed_flag
1587: , NVL (ts.cancelled_flag, 'N') cancelled_flag
1588: FROM jtf_task_statuses_b ts
1589: WHERE ts.task_status_id = p_task_status_id;
1590:
1591:
1592: l_task_info c_task_info%ROWTYPE;

Line 1920: , jtf_task_statuses_b ts

1916: , ta.assignment_status_id
1917: , cac.status trip_status
1918: FROM jtf_tasks_b t
1919: , jtf_task_assignments ta
1920: , jtf_task_statuses_b ts
1921: , cac_sr_object_capacity cac
1922: WHERE t.task_id = p_task_id
1923: AND ta.task_id = t.task_id
1924: AND ts.task_status_id = ta.assignment_status_id

Line 1949: , jtf_task_statuses_b ts

1945: , ta.assignment_status_id
1946: , cac.status trip_status
1947: FROM jtf_tasks_b t
1948: , jtf_task_assignments ta
1949: , jtf_task_statuses_b ts
1950: , cac_sr_object_capacity cac
1951: WHERE t.task_id = p_task_id
1952: AND ta.task_id = t.task_id
1953: AND ts.task_status_id = ta.assignment_status_id

Line 2134: , jtf_task_statuses_b ts

2130: SELECT t.task_id
2131: , cac.status trip_status
2132: FROM jtf_tasks_b t
2133: , jtf_task_assignments ta
2134: , jtf_task_statuses_b ts
2135: , cac_sr_object_capacity cac
2136: WHERE t.parent_task_id = p_parent_task_id
2137: AND ta.task_id = t.task_id
2138: AND ts.task_status_id = ta.assignment_status_id

Line 2151: , jtf_task_statuses_b b

2147: CURSOR check_assignments(p_task_id number)
2148: IS
2149: SELECT count(task_id)
2150: FROM jtf_task_assignments a
2151: , jtf_task_statuses_b b
2152: WHERE a.task_id = p_task_id
2153: AND a.assignment_status_id = b.task_status_id
2154: AND nvl(b.cancelled_flag ,'N') <> 'Y';
2155: l_cnt NUMBER :=1;

Line 2228: , jtf_task_statuses_b ts

2224: l_query := 'SELECT DISTINCT NVL(t.parent_task_id, t.task_id) task_id
2225: , t.task_split_flag
2226: FROM jtf_tasks_b t
2227: , jtf_task_assignments ta
2228: , jtf_task_statuses_b ts
2229: WHERE ta.resource_id = :1
2230: AND ta.resource_type_code = :2
2231: AND ts.task_status_id = ta.assignment_status_id
2232: AND NVL(ts.closed_flag, ''N'') = ''N''

Line 2262: , jtf_task_statuses_b ts

2258: , task_split_flag
2259: FROM cac_sr_object_capacity cac
2260: , jtf_task_assignments ta
2261: , jtf_tasks_b t
2262: , jtf_task_statuses_b ts
2263: WHERE cac.object_capacity_id = :1
2264: AND ta.resource_id = cac.object_id
2265: AND ta.resource_type_code = cac.object_type
2266: AND ta.booking_start_date <= (cac.end_date_time + ' || g_overtime || ')

Line 2524: , jtf_task_statuses_b ts

2520: , MIN(t.actual_start_date) actual_start_date
2521: , MAX(t.actual_end_date) actual_end_date
2522: , SUM(csf_util_pvt.convert_to_minutes(t.actual_effort, t.actual_effort_uom)) actual_effort
2523: FROM jtf_tasks_b t
2524: , jtf_task_statuses_b ts
2525: WHERE t.parent_task_id = p_parent_task_id
2526: AND NVL(t.deleted_flag, 'N') <> 'Y'
2527: AND ts.task_status_id = t.task_status_id
2528: AND NVL(ts.cancelled_flag, 'N') <> 'Y';

Line 2545: , jtf_task_statuses_b ts

2541: , NVL(ts.accepted_flag, 'N') accepted_flag
2542: , NVL(ts.assignment_status_flag, 'N') assignment_status_flag
2543: , 0 status_bitcode
2544: FROM jtf_tasks_b t
2545: , jtf_task_statuses_b ts
2546: WHERE t.parent_task_id = p_parent_task_id
2547: AND ts.task_status_id = t.task_status_id
2548: AND NVL(t.deleted_flag, 'N') <> 'Y'
2549: ORDER BY t.task_id;

Line 2791: FROM jtf_tasks_b t ,jtf_task_statuses_b ts

2787: , NVL(t.child_position, '@@') child_position
2788: , NVL(t.child_sequence_num, -1) child_sequence_num
2789: , RANK() OVER (ORDER BY t.scheduled_start_date, t.scheduled_end_date,nvl(t.child_sequence_num,-1)) correct_seq_num
2790: , LEAD (t.task_id) OVER (ORDER BY t.scheduled_start_date, t.scheduled_end_date,nvl(t.child_sequence_num,-1)) next_task_id
2791: FROM jtf_tasks_b t ,jtf_task_statuses_b ts
2792: WHERE t.parent_task_id = p_parent_task_id
2793: AND NVL(t.deleted_flag, 'N') <> 'Y'
2794: AND ts.task_status_id = t.task_status_id
2795: AND NVL(ts.cancelled_flag, 'N') <> 'Y';

Line 2906: FROM jtf_task_assignments ta, jtf_task_statuses_b ats

2902: , t.object_version_number
2903: , t.scheduled_start_date
2904: , t.scheduled_end_date
2905: , NVL( ( SELECT 'Y'
2906: FROM jtf_task_assignments ta, jtf_task_statuses_b ats
2907: WHERE ta.task_id = p_task_id
2908: AND ta.assignment_status_id = ats.task_status_id
2909: AND NVL(ats.cancelled_flag, 'N') <> 'Y'
2910: AND ROWNUM = 1

Line 3128: FROM jtf_task_statuses_b ts

3124: -- Fetch the Flags corresponding to the new Task Status.
3125: CURSOR c_task_status_info IS
3126: SELECT NVL (ts.closed_flag, 'N') closed_flag
3127: , NVL (ts.cancelled_flag, 'N') cancelled_flag
3128: FROM jtf_task_statuses_b ts
3129: WHERE ts.task_status_id = p_task_status_id;
3130:
3131: l_task_info c_task_info%ROWTYPE;
3132: l_task_status_info c_task_status_info%ROWTYPE;

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

3395: , t.task_status_id
3396: , ta.task_assignment_id
3397: , ta.object_version_number task_assignment_ovn
3398: , ta.assignment_status_id
3399: FROM jtf_tasks_b t ,jtf_task_statuses_b ts ,jtf_task_assignments ta
3400: WHERE t.parent_task_id = p_task_id
3401: AND NVL(t.deleted_flag, 'N') <> 'Y'
3402: AND ts.task_status_id = t.task_status_id
3403: AND NVL(ts.cancelled_flag, 'N') <> 'Y'