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 107: FUNCTION is_cancel_status (p_status_id jtf_task_statuses_b.task_status_id%TYPE)

103: l_phone := null;
104: return l_phone;
105: end return_primary_phone;
106:
107: FUNCTION is_cancel_status (p_status_id jtf_task_statuses_b.task_status_id%TYPE)
108: RETURN BOOLEAN IS
109: CURSOR c_cancelled_flag IS
110: SELECT task_status_id
111: FROM jtf_task_statuses_b

Line 111: FROM jtf_task_statuses_b

107: FUNCTION is_cancel_status (p_status_id jtf_task_statuses_b.task_status_id%TYPE)
108: RETURN BOOLEAN IS
109: CURSOR c_cancelled_flag IS
110: SELECT task_status_id
111: FROM jtf_task_statuses_b
112: WHERE task_status_id = p_status_id
113: AND NVL (cancelled_flag, 'N') = 'Y';
114: BEGIN
115: FOR v_cancelled_flag IN c_cancelled_flag LOOP

Line 140: FROM jtf_task_statuses_b

136: FUNCTION has_schedulable_status (p_task_status_id NUMBER)
137: RETURN BOOLEAN IS
138: CURSOR c_task_status IS
139: SELECT task_status_id
140: FROM jtf_task_statuses_b
141: WHERE NVL (schedulable_flag, 'N') = 'Y'
142: AND task_status_id = p_task_status_id;
143: BEGIN
144: FOR v_task_status IN c_task_status LOOP

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 635: l_status_id jtf_task_statuses_b.task_status_id%TYPE;

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
638: x_return_status := fnd_api.g_ret_sts_success;
639:

Line 688: , jtf_task_statuses_b s

684:
685: CURSOR c_esc(b_task_id NUMBER) IS
686: SELECT 1
687: FROM jtf_tasks_b t
688: , jtf_task_statuses_b s
689: WHERE t.task_id = b_task_id
690: AND t.task_type_id = g_esc_task_type_id
691: AND s.task_status_id = t.task_status_id
692: AND NVL(s.closed_flag, 'N') <> 'Y'

Line 1275: , jtf_task_statuses_b ts

1271: CURSOR c_cancel_task_assignments IS
1272: SELECT ta.task_assignment_id
1273: , ta.object_version_number
1274: FROM csf_ct_task_assignments ta
1275: , jtf_task_statuses_b ts
1276: WHERE ta.task_id = p_task_id
1277: AND ts.task_status_id = ta.assignment_status_id
1278: AND ( NVL (ts.working_flag, 'N') = 'Y'
1279: OR NVL (ts.accepted_flag, 'N') = 'Y'

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 1422: , jtf_task_statuses_b ts

1418: , t.scheduled_end_date
1419: , t.object_version_number
1420: , t.source_object_type_code
1421: FROM jtf_tasks_b t
1422: , jtf_task_statuses_b ts
1423: WHERE task_id = p_task_id
1424: AND ts.task_status_id = t.task_status_id;
1425:
1426: -- Fetch the Flags corresponding to the new Task Status.

Line 1430: FROM jtf_task_statuses_b ts

1426: -- Fetch the Flags corresponding to the new Task Status.
1427: CURSOR c_task_status_info IS
1428: SELECT NVL (ts.closed_flag, 'N') closed_flag
1429: , NVL (ts.cancelled_flag, 'N') cancelled_flag
1430: FROM jtf_task_statuses_b ts
1431: WHERE ts.task_status_id = p_task_status_id;
1432:
1433:
1434: l_task_info c_task_info%ROWTYPE;

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 1766: FROM jtf_task_statuses_b ts

1762: -- Fetch the Flags corresponding to the new Task Status.
1763: CURSOR c_task_status_info IS
1764: SELECT NVL (ts.closed_flag, 'N') closed_flag
1765: , NVL (ts.cancelled_flag, 'N') cancelled_flag
1766: FROM jtf_task_statuses_b ts
1767: WHERE ts.task_status_id = p_task_status_id;
1768:
1769: --The below cursor +variables are added for access hours 8869998
1770:

Line 2351: , jtf_task_statuses_b ts

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
2355: AND ts.task_status_id = ta.assignment_status_id

Line 2382: , jtf_task_statuses_b ts

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
2386: AND ts.task_status_id = ta.assignment_status_id

Line 2630: , jtf_task_statuses_b ts

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
2634: AND ts.task_status_id = ta.assignment_status_id

Line 2647: , jtf_task_statuses_b b

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';
2651: l_cnt NUMBER :=1;

Line 2745: , jtf_task_statuses_b ts

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
2749: )

Line 2779: , jtf_task_statuses_b ts

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
2783: )

Line 2822: , jtf_task_statuses_b ts

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
2826: AND NVL(ts.closed_flag, ''N'') = ''N''

Line 2856: , jtf_task_statuses_b ts

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
2859: AND ta.resource_type_code = cac.object_type
2860: AND ta.booking_start_date <= (cac.end_date_time + ' || g_overtime || ')

Line 3119: , jtf_task_statuses_b ts

3115: , MIN(t.actual_start_date) actual_start_date
3116: , MAX(t.actual_end_date) actual_end_date
3117: , SUM(csf_util_pvt.convert_to_minutes(t.actual_effort, t.actual_effort_uom)) actual_effort
3118: FROM jtf_tasks_b t
3119: , jtf_task_statuses_b ts
3120: WHERE t.parent_task_id = p_parent_task_id
3121: AND NVL(t.deleted_flag, 'N') <> 'Y'
3122: AND ts.task_status_id = t.task_status_id
3123: AND NVL(ts.cancelled_flag, 'N') <> 'Y';

Line 3140: , jtf_task_statuses_b ts

3136: , NVL(ts.accepted_flag, 'N') accepted_flag
3137: , NVL(ts.assignment_status_flag, 'N') assignment_status_flag
3138: , 0 status_bitcode
3139: FROM jtf_tasks_b t
3140: , jtf_task_statuses_b ts
3141: WHERE t.parent_task_id = p_parent_task_id
3142: AND ts.task_status_id = t.task_status_id
3143: AND NVL(t.deleted_flag, 'N') <> 'Y'
3144: ORDER BY t.task_id;

Line 3386: FROM jtf_tasks_b t ,jtf_task_statuses_b ts

3382: , NVL(t.child_position, '@@') child_position
3383: , NVL(t.child_sequence_num, -1) child_sequence_num
3384: , RANK() OVER (ORDER BY t.scheduled_start_date, t.scheduled_end_date,nvl(t.child_sequence_num,-1)) correct_seq_num
3385: , LEAD (t.task_id) OVER (ORDER BY t.scheduled_start_date, t.scheduled_end_date,nvl(t.child_sequence_num,-1)) next_task_id
3386: FROM jtf_tasks_b t ,jtf_task_statuses_b ts
3387: WHERE t.parent_task_id = p_parent_task_id
3388: AND NVL(t.deleted_flag, 'N') <> 'Y'
3389: AND ts.task_status_id = t.task_status_id
3390: AND NVL(ts.cancelled_flag, 'N') <> 'Y';

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 3744: FROM jtf_task_statuses_b ts

3740: -- Fetch the Flags corresponding to the new Task Status.
3741: CURSOR c_task_status_info IS
3742: SELECT NVL (ts.closed_flag, 'N') closed_flag
3743: , NVL (ts.cancelled_flag, 'N') cancelled_flag
3744: FROM jtf_task_statuses_b ts
3745: WHERE ts.task_status_id = p_task_status_id;
3746:
3747: l_task_info c_task_info%ROWTYPE;
3748: l_task_status_info c_task_status_info%ROWTYPE;

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'