APPS.JTF_TASK_REPEAT_ASSIGNMENT_PVT dependencies on JTF_TASK_RECUR_RULES

Line 183: FROM jtf_task_recur_rules

179: l_task_exclusion_id NUMBER;
180:
181: CURSOR c_recur (b_recurrence_rule_id NUMBER) IS
182: SELECT *
183: FROM jtf_task_recur_rules
184: WHERE recurrence_rule_id = b_recurrence_rule_id;
185:
186: rec_recur c_recur%ROWTYPE;
187:

Line 260: SELECT jtf_task_recur_rules_s.NEXTVAL

256: RAISE fnd_api.g_exc_unexpected_error;
257: END IF;
258: CLOSE c_recur;
259:
260: SELECT jtf_task_recur_rules_s.NEXTVAL
261: INTO l_new_recurrence_rule_id
262: FROM dual;
263:
264: jtf_task_recur_rules_pkg.insert_row (

Line 264: jtf_task_recur_rules_pkg.insert_row (

260: SELECT jtf_task_recur_rules_s.NEXTVAL
261: INTO l_new_recurrence_rule_id
262: FROM dual;
263:
264: jtf_task_recur_rules_pkg.insert_row (
265: x_rowid => l_rowid,
266: x_recurrence_rule_id => l_new_recurrence_rule_id,
267: x_occurs_which => rec_recur.occurs_which,
268: x_day_of_week => rec_recur.day_of_week,

Line 492: FROM jtf_task_recur_rules

488: l_task_exclusion_id NUMBER;
489:
490: CURSOR c_recur (b_recurrence_rule_id NUMBER) IS
491: SELECT *
492: FROM jtf_task_recur_rules
493: WHERE recurrence_rule_id = b_recurrence_rule_id;
494:
495: rec_recur c_recur%ROWTYPE;
496:

Line 567: SELECT jtf_task_recur_rules_s.NEXTVAL

563: RAISE fnd_api.g_exc_unexpected_error;
564: END IF;
565: CLOSE c_recur;
566:
567: SELECT jtf_task_recur_rules_s.NEXTVAL
568: INTO l_new_recurrence_rule_id
569: FROM dual;
570:
571: jtf_task_recur_rules_pkg.insert_row (

Line 571: jtf_task_recur_rules_pkg.insert_row (

567: SELECT jtf_task_recur_rules_s.NEXTVAL
568: INTO l_new_recurrence_rule_id
569: FROM dual;
570:
571: jtf_task_recur_rules_pkg.insert_row (
572: x_rowid => l_rowid,
573: x_recurrence_rule_id => l_new_recurrence_rule_id,
574: x_occurs_which => rec_recur.occurs_which,
575: x_day_of_week => rec_recur.day_of_week,