DBA Data[Home] [Help]

APPS.JTF_TASK_REPEAT_ASSIGNMENT_PVT dependencies on DUAL

Line 262: FROM dual;

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 (
265: x_rowid => l_rowid,
266: x_recurrence_rule_id => l_new_recurrence_rule_id,

Line 341: FROM DUAL;

337: -- Insert this appt into exclusion table
338: --------------------------------------------
339: SELECT jta_task_exclusions_s.NEXTVAL
340: INTO l_task_exclusion_id
341: FROM DUAL;
342:
343: jta_task_exclusions_pkg.insert_row (
344: p_task_exclusion_id => l_task_exclusion_id,
345: p_task_id => rec_tasks.task_id,

Line 569: FROM dual;

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 (
572: x_rowid => l_rowid,
573: x_recurrence_rule_id => l_new_recurrence_rule_id,

Line 648: FROM DUAL;

644: -- Insert this appt into exclusion table
645: --------------------------------------------
646: SELECT jta_task_exclusions_s.NEXTVAL
647: INTO l_task_exclusion_id
648: FROM DUAL;
649:
650: jta_task_exclusions_pkg.insert_row (
651: p_task_exclusion_id => l_task_exclusion_id,
652: p_task_id => rec_assignments.task_id,