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.JTF_TASK_RECURRENCES_PVT dependencies on JTF_TASKS_B

Line 715: Select calendar_start_date, timezone_id From jtf_tasks_b Where task_id=p_task_id;

711: l_server_tz_id NUMBER := to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID'));
712: l_client_tz_id NUMBER := to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
713:
714: Cursor c_task IS
715: Select calendar_start_date, timezone_id From jtf_tasks_b Where task_id=p_task_id;
716:
717: l_cal_start_date DATE;
718: l_conv_cal_start_date DATE;
719: l_tz_id NUMBER;

Line 1569: FROM jtf_tasks_b

1565: IS
1566: CURSOR c_tasks_ovn (b_task_id NUMBER)
1567: IS
1568: SELECT object_version_number
1569: FROM jtf_tasks_b
1570: WHERE task_id = b_task_id;
1571:
1572: l_object_version_number NUMBER;
1573: BEGIN

Line 1630: -- from jtf_tasks_b t

1626: IS
1627: -- Fix bug 2376554
1628: --CURSOR c_last_update_date IS
1629: --select max(last_update_date)
1630: -- from jtf_tasks_b t
1631: --where t.recurrence_rule_id = p_recurrence_rule_id
1632: -- and deleted_flag <> 'Y';
1633: l_date DATE := SYSDATE;
1634: BEGIN

Line 1645: -- UPDATE jtf_tasks_b

1641: -- fnd_msg_pub.add;
1642: -- RAISE fnd_api.g_exc_unexpected_error;
1643: --ELSE
1644: -- CLOSE c_last_update_date;
1645: -- UPDATE jtf_tasks_b
1646: -- SET last_update_date = NVL(l_date, SYSDATE) -- Fix bug 2376554
1647: -- WHERE recurrence_rule_id = p_recurrence_rule_id;
1648: --END IF;
1649:

Line 1661: from jtf_tasks_b t

1657: x_repeat_start_date OUT NOCOPY DATE)
1658: IS
1659: CURSOR c_start_date IS
1660: select min(planned_start_date)
1661: from jtf_tasks_b t
1662: where t.recurrence_rule_id = p_recurrence_rule_id
1663: and deleted_flag <> 'Y';
1664:
1665: l_start_date DATE;

Line 1685: from jtf_tasks_b t

1681: x_repeat_end_date OUT NOCOPY DATE)
1682: IS
1683: CURSOR c_end_date IS
1684: select max(planned_end_date)
1685: from jtf_tasks_b t
1686: where t.recurrence_rule_id = p_recurrence_rule_id
1687: and deleted_flag <> 'Y';
1688:
1689: l_end_date DATE;

Line 2241: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;

2237: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;
2238: l_recur_task_id NUMBER;
2239: l_api_version CONSTANT NUMBER := 1.0;
2240: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_RECURRENCE';
2241: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
2242: l_recur_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
2243: l_rowid ROWID;
2244: x CHAR;
2245: l_date_selected VARCHAR(1);

Line 2282: FROM jtf_tasks_b

2278: , actual_end_date
2279: , task_status_id
2280: , creation_date
2281: ,source_object_type_code
2282: FROM jtf_tasks_b
2283: WHERE task_id = p_task_id;
2284:
2285: /* Start of addition by lokumar for bug#6067036 */
2286: cursor c_task_planned_effort (p_task_id number)

Line 2290: from jtf_tasks_b

2286: cursor c_task_planned_effort (p_task_id number)
2287: is
2288: select planned_effort,
2289: planned_effort_uom
2290: from jtf_tasks_b
2291: where task_id=p_task_id;
2292:
2293: v_task_planned_effort c_task_planned_effort%rowtype;
2294:

Line 2363: FROM jtf_tasks_b

2359: END IF;
2360: ELSE
2361: SELECT recurrence_rule_id
2362: INTO l_recur_id
2363: FROM jtf_tasks_b
2364: WHERE task_id = l_task_id;
2365: IF l_recur_id IS NOT NULL
2366: THEN
2367: x_return_status := fnd_api.g_ret_sts_error;

Line 2439: FROM jtf_tasks_b

2435: --- To fix bug#2170817
2436: BEGIN
2437: SELECT date_selected
2438: INTO l_date_selected
2439: FROM jtf_tasks_b
2440: WHERE task_id = p_task_id;
2441: EXCEPTION WHEN OTHERS THEN
2442: l_date_selected := null;
2443: END;

Line 2510: UPDATE jtf_tasks_b

2506: UPDATE jtf_task_templates_b
2507: SET recurrence_rule_id = l_recur_id
2508: WHERE task_template_id = l_task_id;
2509: ELSE
2510: UPDATE jtf_tasks_b
2511: SET recurrence_rule_id = l_recur_id
2512: WHERE task_id = l_task_id;
2513:
2514: END IF;

Line 3050: UPDATE jtf_tasks_b

3046: x_msg_data => x_msg_data,
3047: x_task_id => l_recur_task_id
3048: );
3049:
3050: UPDATE jtf_tasks_b
3051: SET recurrence_rule_id = l_recur_id,
3052: planned_start_date = l_planned_start_date ,
3053: planned_end_date = l_planned_end_date,
3054: scheduled_start_date = l_scheduled_start_date ,

Line 3065: UPDATE jtf_tasks_b

3061: last_update_date = l_current,
3062: date_selected = l_date_selected -- Added by lokumar for bug#6067036
3063: WHERE task_id = l_recur_task_id ;
3064: ELSE
3065: UPDATE jtf_tasks_b
3066: SET recurrence_rule_id = l_recur_id,
3067: planned_start_date = l_planned_start_date ,
3068: planned_end_date = l_planned_end_date,
3069: scheduled_start_date = l_scheduled_start_date ,

Line 3312: FROM jtf_tasks_b t

3308: IS
3309: CURSOR c_task (b_task_id NUMBER) IS
3310: SELECT MAX(t.calendar_start_date) calendar_start_date
3311: , COUNT(t.task_id) occurs_number
3312: FROM jtf_tasks_b t
3313: , jtf_tasks_b curr_task
3314: WHERE curr_task.task_id = b_task_id
3315: AND t.recurrence_rule_id = curr_task.recurrence_rule_id
3316: AND t.calendar_start_date < curr_task.calendar_start_date;

Line 3313: , jtf_tasks_b curr_task

3309: CURSOR c_task (b_task_id NUMBER) IS
3310: SELECT MAX(t.calendar_start_date) calendar_start_date
3311: , COUNT(t.task_id) occurs_number
3312: FROM jtf_tasks_b t
3313: , jtf_tasks_b curr_task
3314: WHERE curr_task.task_id = b_task_id
3315: AND t.recurrence_rule_id = curr_task.recurrence_rule_id
3316: AND t.calendar_start_date < curr_task.calendar_start_date;
3317:

Line 3322: FROM jtf_tasks_b

3318: rec_task c_task%ROWTYPE;
3319:
3320: CURSOR c_new_start_date (b_task_id NUMBER) IS
3321: SELECT TRUNC(calendar_start_date) calendar_start_date
3322: FROM jtf_tasks_b
3323: WHERE task_id = b_task_id;
3324:
3325: rec_new_start_date c_new_start_date%ROWTYPE;
3326: