APPS.JTF_TASK_SYNC_UPGRADE_PKG dependencies on JTF_TASK_RECURRENCES_PVT

Line 126: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;

122: AND (jtb.object_changed_date = to_date('01/02/1970','MM/DD/YYYY') OR
123: jtb.object_changed_date IS NULL)
124: );
125:
126: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;
127: l_output_dates_counter INTEGER;
128: l_invalid BOOLEAN := TRUE;
129: l_all_changed BOOLEAN := FALSE;
130: l_task_exclusion_id NUMBER;

Line 168: jtf_task_recurrences_pvt.generate_dates (

164: -- Invalid and Extra Dates:
165: -- Nullify recurrence_rule_id
166: -- Insert into exclusion table
167: -----------------------------------------------------------
168: jtf_task_recurrences_pvt.generate_dates (
169: p_occurs_which => rec_recur.occurs_which,
170: p_day_of_week => rec_recur.day_of_week,
171: p_date_of_month => rec_recur.date_of_month,
172: p_occurs_month => rec_recur.occurs_month,

Line 389: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;

385:
386: notfound_recur_rule EXCEPTION;
387: l_recurrence_rule_id NUMBER;
388:
389: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;
390: l_output_dates_counter INTEGER;
391:
392: l_updated BOOLEAN;
393: l_duplicate_found BOOLEAN;

Line 450: jtf_task_recurrences_pvt.generate_dates (

446:
447: -------------------------------------------------------------
448: -- Generate repeating dates
449: -------------------------------------------------------------
450: jtf_task_recurrences_pvt.generate_dates (
451: p_occurs_which => rec_recur.occurs_which,
452: p_day_of_week => rec_recur.day_of_week,
453: p_date_of_month => rec_recur.date_of_month,
454: p_occurs_month => rec_recur.occurs_month,

Line 561: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;

557: FROM jtf_tasks_b t
558: WHERE t.source_object_type_code = 'APPOINTMENT'
559: AND t.recurrence_rule_id = r.recurrence_rule_id);
560:
561: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;
562: l_output_dates_counter INTEGER;
563: l_max_date DATE;
564: l_occurs_number NUMBER;
565:

Line 576: -- which is generated by jtf_task_recurrences_pvt.generate_dates().

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
580: jtf_task_recurrences_pvt.generate_dates (

Line 580: jtf_task_recurrences_pvt.generate_dates (

576: -- which is generated by jtf_task_recurrences_pvt.generate_dates().
577: ----------------------------------------------------------------------------
578: FOR rec_recur IN c_recur
579: LOOP
580: jtf_task_recurrences_pvt.generate_dates (
581: p_occurs_which => rec_recur.occurs_which,
582: p_day_of_week => rec_recur.day_of_week,
583: p_date_of_month => rec_recur.date_of_month,
584: p_occurs_month => rec_recur.occurs_month,

Line 737: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;

733: ORDER BY a.resource_id, a.resource_type_code;
734:
735: rec_assignees c_assignees%ROWTYPE;
736:
737: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;
738: l_output_dates_counter INTEGER;
739: l_max_date DATE;
740:
741: l_num NUMBER := 0;

Line 754: jtf_task_recurrences_pvt.generate_dates (

750: -- Find all appts having accept, reject and invitee together
751: ----------------------------------------------------------------------------
752: FOR rec_recur IN c_recur
753: LOOP
754: jtf_task_recurrences_pvt.generate_dates (
755: p_occurs_which => rec_recur.occurs_which,
756: p_day_of_week => rec_recur.day_of_week,
757: p_date_of_month => rec_recur.date_of_month,
758: p_occurs_month => rec_recur.occurs_month,