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 2445: SELECT jtf_task_recur_rules_s.nextval

2441: EXCEPTION WHEN OTHERS THEN
2442: l_date_selected := null;
2443: END;
2444:
2445: SELECT jtf_task_recur_rules_s.nextval
2446: INTO l_recur_id
2447: FROM dual;
2448:
2449: jtf_task_recur_rules_pkg.insert_row (

Line 2449: jtf_task_recur_rules_pkg.insert_row (

2445: SELECT jtf_task_recur_rules_s.nextval
2446: INTO l_recur_id
2447: FROM dual;
2448:
2449: jtf_task_recur_rules_pkg.insert_row (
2450: x_rowid => l_rowid,
2451: x_recurrence_rule_id => l_recur_id,
2452: x_occurs_which => p_occurs_which,
2453: x_day_of_week => p_day_of_week,

Line 3193: UPDATE jtf_task_recur_rules

3189: p_recurrence_rule_id => l_recur_id
3190: ,x_repeat_start_date => l_repeat_start_date
3191: );
3192:
3193: UPDATE jtf_task_recur_rules
3194: SET start_date_active = TRUNC(NVL(l_repeat_start_date, l_output_dates_tbl(1))) -- Fix bug 2376554, bug 2385202
3195: WHERE recurrence_rule_id = l_recur_id;
3196: END IF;
3197:

Line 3210: UPDATE jtf_task_recur_rules

3206: ,x_repeat_end_date => l_repeat_end_date
3207: );*/
3208:
3209: -- Modified by SBARAT on 28/07/2005 for bug# 4365923
3210: UPDATE jtf_task_recur_rules
3211: 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
3212: WHERE recurrence_rule_id = l_recur_id;
3213: END IF;
3214:

Line 3246: FROM jtf_task_recur_rules

3242: RETURN BOOLEAN
3243: IS
3244: CURSOR c_recur IS
3245: SELECT 1
3246: FROM jtf_task_recur_rules
3247: WHERE recurrence_rule_id = p_recurrence_rule_id
3248: AND TRUNC(start_date_active) = TRUNC(p_target_repeat_start_date);
3249:
3250: l_dummy NUMBER;

Line 3467: UPDATE jtf_task_recur_rules

3463: RAISE fnd_api.g_exc_unexpected_error;
3464: END IF;
3465: CLOSE c_task;
3466:
3467: UPDATE jtf_task_recur_rules
3468: SET end_date_active = TRUNC(rec_task.calendar_start_date)
3469: , occurs_number = rec_task.occurs_number
3470: WHERE recurrence_rule_id = p_recurrence_rule_id;
3471: END IF;