DBA Data[Home] [Help]

APPS.JTF_TASK_REPEAT_ASSIGNMENT_PVT dependencies on DUAL

Line 257: FROM dual;

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

Line 335: FROM DUAL;

331: -- Insert this appt into exclusion table
332: --------------------------------------------
333: SELECT jta_task_exclusions_s.NEXTVAL
334: INTO l_task_exclusion_id
335: FROM DUAL;
336:
337: jta_task_exclusions_pkg.insert_row (
338: p_task_exclusion_id => l_task_exclusion_id,
339: p_task_id => rec_tasks.task_id,

Line 514: FROM dual;

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

Line 593: FROM DUAL;

589: -- Insert this appt into exclusion table
590: --------------------------------------------
591: SELECT jta_task_exclusions_s.NEXTVAL
592: INTO l_task_exclusion_id
593: FROM DUAL;
594:
595: jta_task_exclusions_pkg.insert_row (
596: p_task_exclusion_id => l_task_exclusion_id,
597: p_task_id => rec_assignments.task_id,