APPS.JTF_TASK_SYNC_UPGRADE_PKG dependencies on JTF_TASK_RECUR_RULES

Line 117: FROM jtf_task_recur_rules r

113: , friday
114: , saturday
115: , created_by
116: , creation_date
117: FROM jtf_task_recur_rules r
118: WHERE EXISTS (SELECT 1
119: FROM jtf_tasks_b jtb
120: WHERE jtb.recurrence_rule_id = r.recurrence_rule_id
121: AND jtb.source_object_type_code = 'APPOINTMENT'

Line 340: , jtf_task_recur_rules recur

336: , t.created_by
337: , t.deleted_flag
338: , recur.creation_date recur_creation_date
339: FROM jtf_tasks_b t
340: , jtf_task_recur_rules recur
341: WHERE ((t.creation_date <> t.last_update_date AND
342: t.last_update_date > recur.creation_date
343: ) OR
344: deleted_flag = 'Y')

Line 380: FROM jtf_task_recur_rules

376: , thursday
377: , friday
378: , saturday
379: , created_by
380: FROM jtf_task_recur_rules
381: WHERE recurrence_rule_id = b_recurrence_rule_id;
382:
383: rec_duplicate_dates c_duplicate_dates%ROWTYPE;
384: rec_recur c_recur%ROWTYPE;

Line 543: raise_application_error(-20001, 'Unexpected error at jtftkugb.pls (exclude_modified_repeat_appts) : recurrence_rule_id '||l_recurrence_rule_id||'is not found in the table JTF_TASK_RECUR_RULES.');

539: COMMIT WORK;
540: EXCEPTION
541: WHEN notfound_recur_rule THEN
542: ROLLBACK;
543: raise_application_error(-20001, 'Unexpected error at jtftkugb.pls (exclude_modified_repeat_appts) : recurrence_rule_id '||l_recurrence_rule_id||'is not found in the table JTF_TASK_RECUR_RULES.');
544:
545: WHEN OTHERS THEN
546: ROLLBACK;
547: raise_application_error(-20001, 'Unexpected error at jtftkugb.pls (exclude_modified_repeat_appts) : '||SQLCODE||' '||SQLERRM);

Line 554: FROM jtf_task_recur_rules r

550: PROCEDURE correct_recurrence_rule
551: IS
552: CURSOR c_recur IS
553: SELECT *
554: FROM jtf_task_recur_rules r
555: WHERE (end_date_active IS NULL OR occurs_number IS NULL)
556: AND EXISTS (SELECT 1
557: FROM jtf_tasks_b t
558: WHERE t.source_object_type_code = 'APPOINTMENT'

Line 575: -- Update end_date_active in jtf_task_recur_rules with the last one of dates

571: RETURN;
572: END IF;
573:
574: ----------------------------------------------------------------------------
575: -- Update end_date_active in jtf_task_recur_rules with the last one of dates
576: -- which is generated by jtf_task_recurrences_pvt.generate_dates().
577: ----------------------------------------------------------------------------
578: FOR rec_recur IN c_recur
579: LOOP

Line 617: UPDATE jtf_task_recur_rules

613: l_max_date := l_output_dates_tbl(i);
614: END IF;
615: END LOOP;
616:
617: UPDATE jtf_task_recur_rules
618: SET occurs_number = l_occurs_number
619: , end_date_active = l_max_date
620: , last_updated_by = fnd_global.user_id
621: WHERE recurrence_rule_id = rec_recur.recurrence_rule_id;

Line 712: FROM jtf_task_recur_rules r

708: PROCEDURE nullify_wrong_assignments
709: IS
710: CURSOR c_recur IS
711: SELECT *
712: FROM jtf_task_recur_rules r
713: WHERE EXISTS (SELECT 1
714: FROM jtf_tasks_b t
715: WHERE t.source_object_type_code = 'APPOINTMENT'
716: AND t.recurrence_rule_id = r.recurrence_rule_id);