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

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

Line 2289: from jtf_tasks_b

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

Line 2357: FROM jtf_tasks_b

2353: END IF;
2354: ELSE
2355: SELECT recurrence_rule_id
2356: INTO l_recur_id
2357: FROM jtf_tasks_b
2358: WHERE task_id = l_task_id;
2359: IF l_recur_id IS NOT NULL
2360: THEN
2361: x_return_status := fnd_api.g_ret_sts_error;

Line 2433: FROM jtf_tasks_b

2429: --- To fix bug#2170817
2430: BEGIN
2431: SELECT date_selected
2432: INTO l_date_selected
2433: FROM jtf_tasks_b
2434: WHERE task_id = p_task_id;
2435: EXCEPTION WHEN OTHERS THEN
2436: l_date_selected := null;
2437: END;

Line 2504: UPDATE jtf_tasks_b

2500: UPDATE jtf_task_templates_b
2501: SET recurrence_rule_id = l_recur_id
2502: WHERE task_template_id = l_task_id;
2503: ELSE
2504: UPDATE jtf_tasks_b
2505: SET recurrence_rule_id = l_recur_id
2506: WHERE task_id = l_task_id;
2507:
2508: END IF;

Line 3044: UPDATE jtf_tasks_b

3040: x_msg_data => x_msg_data,
3041: x_task_id => l_recur_task_id
3042: );
3043:
3044: UPDATE jtf_tasks_b
3045: SET recurrence_rule_id = l_recur_id,
3046: planned_start_date = l_planned_start_date ,
3047: planned_end_date = l_planned_end_date,
3048: scheduled_start_date = l_scheduled_start_date ,

Line 3059: UPDATE jtf_tasks_b

3055: last_update_date = l_current,
3056: date_selected = l_date_selected -- Added by lokumar for bug#6067036
3057: WHERE task_id = l_recur_task_id ;
3058: ELSE
3059: UPDATE jtf_tasks_b
3060: SET recurrence_rule_id = l_recur_id,
3061: planned_start_date = l_planned_start_date ,
3062: planned_end_date = l_planned_end_date,
3063: scheduled_start_date = l_scheduled_start_date ,

Line 3258: FROM jtf_tasks_b t

3254: IS
3255: CURSOR c_task (b_task_id NUMBER) IS
3256: SELECT MAX(t.calendar_start_date) calendar_start_date
3257: , COUNT(t.task_id) occurs_number
3258: FROM jtf_tasks_b t
3259: , jtf_tasks_b curr_task
3260: WHERE curr_task.task_id = b_task_id
3261: AND t.recurrence_rule_id = curr_task.recurrence_rule_id
3262: AND t.calendar_start_date < curr_task.calendar_start_date;

Line 3259: , jtf_tasks_b curr_task

3255: CURSOR c_task (b_task_id NUMBER) IS
3256: SELECT MAX(t.calendar_start_date) calendar_start_date
3257: , COUNT(t.task_id) occurs_number
3258: FROM jtf_tasks_b t
3259: , jtf_tasks_b curr_task
3260: WHERE curr_task.task_id = b_task_id
3261: AND t.recurrence_rule_id = curr_task.recurrence_rule_id
3262: AND t.calendar_start_date < curr_task.calendar_start_date;
3263:

Line 3268: FROM jtf_tasks_b

3264: rec_task c_task%ROWTYPE;
3265:
3266: CURSOR c_new_start_date (b_task_id NUMBER) IS
3267: SELECT TRUNC(calendar_start_date) calendar_start_date
3268: FROM jtf_tasks_b
3269: WHERE task_id = b_task_id;
3270:
3271: rec_new_start_date c_new_start_date%ROWTYPE;
3272: