APPS.JTF_TASK_RECURRENCES_PVT dependencies on JTF_TASK_RECUR_RULES

Line 1650: UPDATE jtf_task_recur_rules

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:
1650: UPDATE jtf_task_recur_rules
1651: SET last_update_date = l_date
1652: , creation_date = l_date
1653: WHERE recurrence_rule_id = p_recurrence_rule_id;
1654: END;

Line 2242: l_recur_id jtf_task_recur_rules.recurrence_rule_id%TYPE;

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);
2246: l_planned_start_date date ;

Line 2266: FROM jtf_task_recur_rules

2262: l_rowid IN ROWID
2263: )
2264: IS
2265: SELECT 1
2266: FROM jtf_task_recur_rules
2267: WHERE ROWID = l_rowid;
2268:
2269: i NUMBER;
2270:

Line 2439: SELECT jtf_task_recur_rules_s.nextval

2435: EXCEPTION WHEN OTHERS THEN
2436: l_date_selected := null;
2437: END;
2438:
2439: SELECT jtf_task_recur_rules_s.nextval
2440: INTO l_recur_id
2441: FROM dual;
2442:
2443: jtf_task_recur_rules_pkg.insert_row (

Line 2443: jtf_task_recur_rules_pkg.insert_row (

2439: SELECT jtf_task_recur_rules_s.nextval
2440: INTO l_recur_id
2441: FROM dual;
2442:
2443: jtf_task_recur_rules_pkg.insert_row (
2444: x_rowid => l_rowid,
2445: x_recurrence_rule_id => l_recur_id,
2446: x_occurs_which => p_occurs_which,
2447: x_day_of_week => p_day_of_week,

Line 3139: UPDATE jtf_task_recur_rules

3135: p_recurrence_rule_id => l_recur_id
3136: ,x_repeat_start_date => l_repeat_start_date
3137: );
3138:
3139: UPDATE jtf_task_recur_rules
3140: SET start_date_active = TRUNC(NVL(l_repeat_start_date, l_output_dates_tbl(1))) -- Fix bug 2376554, bug 2385202
3141: WHERE recurrence_rule_id = l_recur_id;
3142: END IF;
3143:

Line 3156: UPDATE jtf_task_recur_rules

3152: ,x_repeat_end_date => l_repeat_end_date
3153: );*/
3154:
3155: -- Modified by SBARAT on 28/07/2005 for bug# 4365923
3156: UPDATE jtf_task_recur_rules
3157: SET end_date_active = trunc(l_output_dates_tbl(l_last)) --trunc(NVL(l_repeat_end_date,l_output_dates_tbl(l_last))) -- Fix bug 2376554, bug 2385202
3158: WHERE recurrence_rule_id = l_recur_id;
3159: END IF;
3160:

Line 3192: FROM jtf_task_recur_rules

3188: RETURN BOOLEAN
3189: IS
3190: CURSOR c_recur IS
3191: SELECT 1
3192: FROM jtf_task_recur_rules
3193: WHERE recurrence_rule_id = p_recurrence_rule_id
3194: AND TRUNC(start_date_active) = TRUNC(p_target_repeat_start_date);
3195:
3196: l_dummy NUMBER;

Line 3413: UPDATE jtf_task_recur_rules

3409: RAISE fnd_api.g_exc_unexpected_error;
3410: END IF;
3411: CLOSE c_task;
3412:
3413: UPDATE jtf_task_recur_rules
3414: SET end_date_active = TRUNC(rec_task.calendar_start_date)
3415: , occurs_number = rec_task.occurs_number
3416: WHERE recurrence_rule_id = p_recurrence_rule_id;
3417: END IF;