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 255: SELECT jtf_task_recur_rules_s.NEXTVAL

251: RAISE fnd_api.g_exc_unexpected_error;
252: END IF;
253: CLOSE c_recur;
254:
255: SELECT jtf_task_recur_rules_s.NEXTVAL
256: INTO l_new_recurrence_rule_id
257: FROM dual;
258:
259: jtf_task_recur_rules_pkg.insert_row (

Line 259: jtf_task_recur_rules_pkg.insert_row (

255: SELECT jtf_task_recur_rules_s.NEXTVAL
256: INTO l_new_recurrence_rule_id
257: FROM dual;
258:
259: jtf_task_recur_rules_pkg.insert_row (
260: x_rowid => l_rowid,
261: x_recurrence_rule_id => l_new_recurrence_rule_id,
262: x_occurs_which => rec_recur.occurs_which,
263: x_day_of_week => rec_recur.day_of_week,

Line 437: FROM jtf_task_recur_rules

433: l_task_exclusion_id NUMBER;
434:
435: CURSOR c_recur (b_recurrence_rule_id NUMBER) IS
436: SELECT *
437: FROM jtf_task_recur_rules
438: WHERE recurrence_rule_id = b_recurrence_rule_id;
439:
440: rec_recur c_recur%ROWTYPE;
441:

Line 512: SELECT jtf_task_recur_rules_s.NEXTVAL

508: RAISE fnd_api.g_exc_unexpected_error;
509: END IF;
510: CLOSE c_recur;
511:
512: SELECT jtf_task_recur_rules_s.NEXTVAL
513: INTO l_new_recurrence_rule_id
514: FROM dual;
515:
516: jtf_task_recur_rules_pkg.insert_row (

Line 516: jtf_task_recur_rules_pkg.insert_row (

512: SELECT jtf_task_recur_rules_s.NEXTVAL
513: INTO l_new_recurrence_rule_id
514: FROM dual;
515:
516: jtf_task_recur_rules_pkg.insert_row (
517: x_rowid => l_rowid,
518: x_recurrence_rule_id => l_new_recurrence_rule_id,
519: x_occurs_which => rec_recur.occurs_which,
520: x_day_of_week => rec_recur.day_of_week,