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_TASKS_B

Line 104: FROM jtf_tasks_b

100: FUNCTION task_number (p_task_id IN NUMBER)
101: RETURN VARCHAR2 IS
102: CURSOR c_number IS
103: SELECT task_number
104: FROM jtf_tasks_b
105: WHERE task_id = p_task_id;
106: l_task_number jtf_tasks_b.task_number%TYPE;
107: BEGIN
108: OPEN c_number;

Line 106: l_task_number jtf_tasks_b.task_number%TYPE;

102: CURSOR c_number IS
103: SELECT task_number
104: FROM jtf_tasks_b
105: WHERE task_id = p_task_id;
106: l_task_number jtf_tasks_b.task_number%TYPE;
107: BEGIN
108: OPEN c_number;
109: FETCH c_number INTO l_task_number;
110: CLOSE c_number;

Line 342: FROM jtf_tasks_b

338: l_api_name CONSTANT VARCHAR2 (30) := 'IS_TASK_CLOSABLE';
339:
340: CURSOR c_task_details IS
341: SELECT task_status_id
342: FROM jtf_tasks_b
343: WHERE task_id = p_task_id;
344:
345: -- Cursor to get all the Task Assignments for the Task to be closed.
346: CURSOR c_task_assignments IS

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 476: FROM jtf_tasks_b

472: , planned_end_date
473: , planned_effort
474: , address_id
475: , deleted_flag
476: FROM jtf_tasks_b
477: WHERE task_id = p_task_id;
478:
479: l_task_details c_task_details%ROWTYPE;
480: l_schedulable BOOLEAN;

Line 545: FROM jtf_tasks_b t, jtf_task_assignments ta

541: , t.scheduled_end_date
542: , t.task_split_flag
543: , t.task_status_id
544: , ta.resource_id
545: FROM jtf_tasks_b t, jtf_task_assignments ta
546: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
547:
548: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;
549: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;

Line 548: l_sched_start jtf_tasks_b.scheduled_start_date%TYPE;

544: , ta.resource_id
545: FROM jtf_tasks_b t, jtf_task_assignments ta
546: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
547:
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;

Line 549: l_sched_end jtf_tasks_b.scheduled_end_date%TYPE;

545: FROM jtf_tasks_b t, jtf_task_assignments ta
546: WHERE ta.task_id = t.task_id AND t.task_id = p_task_id;
547:
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

Line 551: l_split_flag jtf_tasks_b.task_split_flag%TYPE;

547:
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;

Line 604: FROM jtf_tasks_b t

600: AND r.object_id = p_task_id;
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

Line 739: FROM jtf_tasks_b t

735: , ts.schedulable_flag ts_schedulable_flag
736: , ts.assigned_flag
737: , tt.schedule_flag tt_schedule_flag
738: , ta.resource_name
739: FROM jtf_tasks_b t
740: , csf_ct_task_assignments ta
741: , jtf_task_statuses_vl ts
742: , jtf_task_types_b tt
743: WHERE t.ROWID = CHARTOROWID (p_row_id)

Line 1306: FROM jtf_tasks_b t

1302: , t.scheduled_start_date
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:

Line 1560: FROM jtf_tasks_b t,

1556: , t.planned_end_date
1557: , ta.assignment_status_id
1558: , t.task_split_flag
1559: , t.task_number
1560: FROM jtf_tasks_b t,
1561: (SELECT tas.actual_start_date
1562: , tas.actual_end_date
1563: , tas.resource_id
1564: , tas.resource_type_code

Line 1918: FROM jtf_tasks_b t

1914: , ta.object_version_number ta_object_version_number
1915: , ta.object_capacity_id
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

Line 1947: FROM jtf_tasks_b t

1943: , ta.object_version_number ta_object_version_number
1944: , ta.object_capacity_id
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

Line 2116: TYPE task_split_tbl_type IS TABLE OF jtf_tasks_b.task_split_flag%TYPE;

2112: l_api_version CONSTANT NUMBER := 1.0;
2113:
2114:
2115: TYPE ref_cursor_type IS REF CURSOR;
2116: TYPE task_split_tbl_type IS TABLE OF jtf_tasks_b.task_split_flag%TYPE;
2117:
2118: -- REF Cursor to form different query based on different conditions.
2119: c_task_list ref_cursor_type;
2120:

Line 2132: FROM jtf_tasks_b t

2128: -- and only those assigned to Resources belonging to the Dispatcher's Territory.
2129: CURSOR c_child_tasks (p_parent_task_id NUMBER) IS
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

Line 2201: -- TASK_SPLIT_FLAG is queried from JTF_TASKS_B again since the Query might

2197: CLOSE c_query_where_clause;
2198:
2199: -- Frame the Task List Query
2200:
2201: -- TASK_SPLIT_FLAG is queried from JTF_TASKS_B again since the Query might
2202: -- return PARENT_TASK and CHILD_TASK also and because of that DISTINCT might
2203: -- return two rows one beloning to PARENT_TASK and another for CHILD_TASK bcos
2204: -- of TASK_SPLIT_FLAG.
2205:

Line 2208: FROM jtf_tasks_b t1

2204: -- of TASK_SPLIT_FLAG.
2205:
2206: l_query := ' SELECT DISTINCT NVL(csf_ct_tasks.parent_task_id, csf_ct_tasks.task_id) task_id
2207: , (SELECT t1.task_split_flag
2208: FROM jtf_tasks_b t1
2209: WHERE t1.task_id = NVL(csf_ct_tasks.parent_task_id, csf_ct_tasks.task_id)) task_split_flag
2210: FROM csf_ct_tasks
2211: WHERE ' || l_where_clause || ' ORDER BY 1 DESC';
2212:

Line 2226: FROM jtf_tasks_b t

2222: -- sufficient for us to have Child's Task Split Flag alone
2223:
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

Line 2252: FROM jtf_tasks_b t

2248: -- There is just one task and its sufficient for us to get the TASK_SPLIT_FLAG
2249: -- of that task.
2250: l_query := 'SELECT NVL(t.parent_task_id, t.task_id) task_id
2251: , task_split_flag
2252: FROM jtf_tasks_b t
2253: WHERE t.task_id = :1';
2254:
2255: OPEN c_task_list FOR l_query USING p_task_id;
2256: ELSIF p_trip_id IS NOT NULL THEN

Line 2261: , jtf_tasks_b t

2257: l_query := 'SELECT NVL(t.parent_task_id, t.task_id) task_id
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

Line 2512: FROM jtf_tasks_b t

2508: , t.scheduled_end_date
2509: , t.planned_start_date
2510: , t.planned_end_date
2511: , csf_util_pvt.convert_to_minutes(t.actual_effort, t.actual_effort_uom) actual_effort
2512: FROM jtf_tasks_b t
2513: WHERE t.task_id = p_parent_task_id
2514: AND NVL(t.deleted_flag, 'N') <> 'Y';
2515:
2516: CURSOR c_new_parent_info IS

Line 2523: FROM jtf_tasks_b t

2519: , MAX(t.scheduled_end_date) scheduled_end_date
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

Line 2544: FROM jtf_tasks_b t

2540: , NVL(ts.cancelled_flag, 'N') cancelled_flag
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'

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 2797: l_child_position jtf_tasks_b.child_position%TYPE;

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';
2796:
2797: l_child_position jtf_tasks_b.child_position%TYPE;
2798: BEGIN
2799: SAVEPOINT csf_sync_child_from_parent;
2800:
2801: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 2913: FROM jtf_tasks_b t

2909: AND NVL(ats.cancelled_flag, 'N') <> 'Y'
2910: AND ROWNUM = 1
2911: ), 'N'
2912: ) is_scheduled
2913: FROM jtf_tasks_b t
2914: WHERE t.task_id = p_task_id;
2915:
2916: CURSOR c_task_assignment_info IS
2917: SELECT ta.resource_id

Line 2947: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);

2943: FETCH c_task_info INTO l_task_info;
2944: CLOSE c_task_info;
2945:
2946: IF l_task_info.task_id IS NULL THEN
2947: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
2948: RAISE fnd_api.g_exc_unexpected_error;
2949: END IF;
2950:
2951: -- If the Task is already Scheduled, then the Task Should be treated to be

Line 3119: FROM jtf_tasks_b t , jtf_task_assignments ta

3115: , scheduled_start_date
3116: , scheduled_end_date
3117: , ta.assignment_status_id
3118: , ta.object_capacity_id
3119: FROM jtf_tasks_b t , jtf_task_assignments ta
3120: WHERE t.task_id = p_task_id
3121: AND ta.task_id = t.task_id
3122: AND ta.task_assignment_id = p_task_assignment_id;
3123:

Line 3389: FROM jtf_tasks_b t

3385: , t.scheduled_end_date
3386: , t.planned_effort
3387: , t.planned_effort_uom
3388: , t.task_split_flag
3389: FROM jtf_tasks_b t
3390: WHERE t.task_id = p_task_id;
3391:
3392: CURSOR c_child_tasks IS
3393: SELECT t.task_id

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'

Line 3430: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);

3426: FETCH c_parent_task_info INTO l_parent_task_info;
3427: CLOSE c_parent_task_info;
3428:
3429: IF l_parent_task_info.task_id IS NULL THEN
3430: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
3431: RAISE fnd_api.g_exc_unexpected_error;
3432: END IF;
3433:
3434: -- Find out whether the new Task Status is valid.

Line 3614: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_parent_task_id);

3610: OPEN c_parent_task_info;
3611: FETCH c_parent_task_info INTO l_parent_task_info;
3612: IF c_parent_task_info%NOTFOUND THEN
3613: CLOSE c_parent_task_info;
3614: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_parent_task_id);
3615: RAISE fnd_api.g_exc_unexpected_error;
3616: END IF;
3617: CLOSE c_parent_task_info;
3618:

Line 3809: FROM jtf_tasks_b t

3805: SELECT t.task_id
3806: , t.task_split_flag
3807: , t.parent_task_id
3808: , t.task_confirmation_status
3809: FROM jtf_tasks_b t
3810: WHERE t.task_id = p_task_id;
3811:
3812: CURSOR c_parent_child_tasks (p_task_id NUMBER) IS
3813: SELECT jtb.task_id

Line 3815: FROM jtf_task_statuses_vl ts, jtf_tasks_b jtb

3811:
3812: CURSOR c_parent_child_tasks (p_task_id NUMBER) IS
3813: SELECT jtb.task_id
3814: , jtb.object_version_number
3815: FROM jtf_task_statuses_vl ts, jtf_tasks_b jtb
3816: WHERE jtb.parent_task_id = p_task_id
3817: AND ts.task_status_id = jtb.task_status_id
3818: AND jtb.task_split_flag = 'D'
3819: AND ( NVL(ts.on_hold_flag, 'N') = 'Y'

Line 3830: FROM jtf_tasks_b t

3826: AND NVL(ts.rejected_flag, 'N') <> 'Y' ))
3827: UNION
3828: SELECT t.task_id
3829: , t.object_version_number
3830: FROM jtf_tasks_b t
3831: WHERE task_id = p_task_id;
3832:
3833: l_cust_task_tbl jtf_number_table := jtf_number_table();
3834: l_cust_objver_tbl jtf_number_table := jtf_number_table();

Line 3984: FROM jtf_tasks_b t

3980: WHERE ps.party_site_id = p_party_site_id;
3981:
3982: CURSOR c_task_location IS
3983: SELECT NVL(t.location_id, ps.location_id)
3984: FROM jtf_tasks_b t
3985: , hz_party_sites ps
3986: WHERE t.task_id = p_task_id
3987: AND ps.party_site_id(+) = t.address_id;
3988:

Line 4053: FROM jtf_tasks_b t

4049: , l.city
4050: , l.state
4051: , l.province
4052: , l.country
4053: FROM jtf_tasks_b t
4054: , hz_party_sites ps
4055: , hz_locations l
4056: WHERE t.task_id = p_task_id
4057: AND ps.party_site_id(+) = t.address_id

Line 4136: * Split Flag are passed, then it helps in better performance as JTF_TASKS_B

4132: * the profile CSF: Default Effort UOM by calling
4133: * CSF_UTIL_PVT.GET_EFFORT_IN_DEFAULT_UOM function.
4134: *
4135: * All parameters are optional. If Planned Effort, Planned Effort UOM and Task
4136: * Split Flag are passed, then it helps in better performance as JTF_TASKS_B
4137: * wont be queried to get those information. In case of better flexibility,
4138: * the caller can just pass the Task ID and the API will fetch the required
4139: * information. If case none of the required parameters are passed, the API returns
4140: * NULL.

Line 4172: l_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;

4168: )
4169: RETURN VARCHAR2 IS
4170:
4171: l_effort NUMBER;
4172: l_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
4173: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;
4174:
4175: CURSOR c_task_info IS
4176: SELECT NVL(p_planned_effort, planned_effort) planned_effort

Line 4173: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;

4169: RETURN VARCHAR2 IS
4170:
4171: l_effort NUMBER;
4172: l_effort_uom jtf_tasks_b.planned_effort_uom%TYPE;
4173: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;
4174:
4175: CURSOR c_task_info IS
4176: SELECT NVL(p_planned_effort, planned_effort) planned_effort
4177: , NVL(p_planned_effort_uom, planned_effort_uom) planned_effort_uom

Line 4179: FROM jtf_tasks_b

4175: CURSOR c_task_info IS
4176: SELECT NVL(p_planned_effort, planned_effort) planned_effort
4177: , NVL(p_planned_effort_uom, planned_effort_uom) planned_effort_uom
4178: , decode(p_task_split_flag, '@', task_split_flag, p_task_split_flag) task_split_flag
4179: FROM jtf_tasks_b
4180: WHERE task_id = p_task_id;
4181: BEGIN
4182: l_effort := p_planned_effort;
4183: l_effort_uom := p_planned_effort_uom;

Line 4552: from jtf_tasks_b

4548:
4549: cursor c_obj(p_task number)
4550: is
4551: select object_version_number
4552: from jtf_tasks_b
4553: where task_id =p_task;
4554:
4555: cursor c_task_ass(p_task_id number)
4556: is

Line 4558: from jtf_task_assignments jta,jtf_tasks_b jt

4554:
4555: cursor c_task_ass(p_task_id number)
4556: is
4557: select jta.task_assignment_id
4558: from jtf_task_assignments jta,jtf_tasks_b jt
4559: where jt.task_id=p_task_id
4560: and jta.task_id=jt.task_id
4561: and jt.source_object_type_code = 'TASK'
4562: and jt.task_type_id not in (20,21);