APPS.JTF_TASK_REPEAT_APPT_PVT dependencies on JTA_TASK_EXCLUSIONS

Line 149: l_task_exclusion_id jta_task_exclusions.task_exclusion_id%TYPE;

145: WHERE NVL(deleted_flag,'N') = 'N'
146: AND recurrence_rule_id = b_recurrence_rule_id;
147:
148: l_new_minimum_task_id NUMBER;
149: l_task_exclusion_id jta_task_exclusions.task_exclusion_id%TYPE;
150: l_new_recurrence_rule_id NUMBER;
151: l_send_notification VARCHAR2(1);
152: l_rowid ROWID;
153: l_first BOOLEAN := FALSE;

Line 265: SELECT jta_task_exclusions_s.NEXTVAL

261:
262: --------------------------------------------
263: -- Insert this appt into exclusion table
264: --------------------------------------------
265: SELECT jta_task_exclusions_s.NEXTVAL
266: INTO l_task_exclusion_id
267: FROM DUAL;
268:
269: jta_task_exclusions_pkg.insert_row (

Line 269: jta_task_exclusions_pkg.insert_row (

265: SELECT jta_task_exclusions_s.NEXTVAL
266: INTO l_task_exclusion_id
267: FROM DUAL;
268:
269: jta_task_exclusions_pkg.insert_row (
270: p_task_exclusion_id => l_task_exclusion_id,
271: p_task_id => p_updated_field_rec.task_id,
272: p_recurrence_rule_id => p_updated_field_rec.recurrence_rule_id,
273: p_exclusion_date => p_updated_field_rec.old_calendar_start_date

Line 487: SELECT jta_task_exclusions_s.NEXTVAL

483:
484: --------------------------------------------
485: -- Insert this appt into exclusion table
486: --------------------------------------------
487: SELECT jta_task_exclusions_s.NEXTVAL
488: INTO l_task_exclusion_id
489: FROM DUAL;
490:
491: jta_task_exclusions_pkg.insert_row (

Line 491: jta_task_exclusions_pkg.insert_row (

487: SELECT jta_task_exclusions_s.NEXTVAL
488: INTO l_task_exclusion_id
489: FROM DUAL;
490:
491: jta_task_exclusions_pkg.insert_row (
492: p_task_exclusion_id => l_task_exclusion_id,
493: p_task_id => rec_future.task_id,
494: p_recurrence_rule_id => p_updated_field_rec.recurrence_rule_id,
495: p_exclusion_date => rec_future.calendar_start_date