DBA Data[Home] [Help]

APPS.JTF_TASK_SYNC_UPGRADE_PKG dependencies on JTA_TASK_EXCLUSIONS_S

Line 249: SELECT jta_task_exclusions_s.NEXTVAL

245: FOR i IN l_output_dates_tbl.FIRST..l_output_dates_tbl.LAST
246: LOOP
247: IF l_output_dates_tbl.EXISTS(i)
248: THEN
249: SELECT jta_task_exclusions_s.NEXTVAL
250: INTO l_task_exclusion_id
251: FROM DUAL;
252:
253: IF TRUNC(l_output_dates_tbl(i)) = l_output_dates_tbl(i) AND

Line 499: SELECT jta_task_exclusions_s.NEXTVAL

495: -- The following "if" means
496: -- that the appointment start date has been changed and has not been duplicated
497: IF NOT (l_duplicate_found OR l_start_date_or_extra_modified)
498: THEN
499: SELECT jta_task_exclusions_s.NEXTVAL
500: INTO l_task_exclusion_id
501: FROM DUAL;
502:
503: jta_task_exclusions_pkg.insert_row (