[Home] [Help]
25: FUNCTION is_repeating_appt RETURN BOOLEAN
26: IS
27: cursor c_appt is
28: select 'x'
29: from jtf_tasks_b
30: where source_object_type_code = 'APPOINTMENT'
31: and rownum = 1;
32: l_is_appt CHAR(1);
33:
57: -----------------------------------------------------------
58: CURSOR c_duplicates (b_recurrence_rule_id NUMBER
59: ,b_recur_creation_date DATE) IS
60: SELECT t.task_id
61: FROM jtf_tasks_b t
62: , (SELECT recurrence_rule_id
63: , calendar_start_date
64: , count(task_id) cnt
65: , min(task_id) min_task_id
62: , (SELECT recurrence_rule_id
63: , calendar_start_date
64: , count(task_id) cnt
65: , min(task_id) min_task_id
66: FROM jtf_tasks_b
67: WHERE recurrence_rule_id = b_recurrence_rule_id
68: AND (last_update_date <= b_recur_creation_date OR
69: last_update_date = creation_date)
70: AND source_object_type_code = 'APPOINTMENT'
83: ,b_recur_creation_date DATE) IS
84: SELECT task_id
85: , calendar_start_date
86: , created_by
87: FROM jtf_tasks_b
88: WHERE recurrence_rule_id = b_recurrence_rule_id
89: AND (last_update_date <= b_recur_creation_date OR
90: last_update_date = creation_date)
91: AND source_object_type_code = 'APPOINTMENT'
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'
122: AND (jtb.object_changed_date = to_date('01/02/1970','MM/DD/YYYY') OR
123: jtb.object_changed_date IS NULL)
150: LOOP
151: l_num := l_num + 1;
152:
153: -- Nullify recurrence_rule_id
154: UPDATE jtf_tasks_b
155: SET recurrence_rule_id = NULL
156: , last_updated_by = fnd_global.user_id
157: WHERE task_id = rec_duplicates.task_id;
158:
215: -----------------------------------------------
216: IF l_invalid
217: THEN
218: -- Nullify recurrence_rule_id
219: UPDATE jtf_tasks_b
220: SET recurrence_rule_id = NULL
221: , last_updated_by = fnd_global.user_id
222: WHERE task_id = rec_repeat_appt.task_id;
223:
287: IS
288: -- Added hint by SBARAT on 14/02/2006 for perf bug# 4965969
289: CURSOR c_tasks IS
290: SELECT /*+ parallel(b) */ b.rowid row_id
291: FROM jtf_tasks_b b
292: WHERE b.object_changed_date IS NULL;
293:
294: l_num NUMBER := 0;
295: l_commit_records NUMBER := 0;
303: -- Update object_changed_date with 02-Jan-1970
304: ----------------------------------------------------------------------------
305: FOR rec_tasks IN c_tasks
306: LOOP
307: UPDATE jtf_tasks_b
308: SET object_changed_date = TO_DATE('01/02/1970', 'MM/DD/YYYY')
309: , last_updated_by = fnd_global.user_id
310: WHERE rowid = rec_tasks.row_id;
311:
335: , t.calendar_start_date
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
352: --,b_recur_creation_date DATE
353: ,b_calendar_start_date DATE
354: ,b_task_id NUMBER) IS
355: SELECT task_id
356: FROM jtf_tasks_b
357: WHERE recurrence_rule_id = b_recurrence_rule_id
358: AND calendar_start_date = b_calendar_start_date
359: AND task_id <> b_task_id;
360:
513:
514: -- If this has not been deleted, nullify recurrence rule
515: IF NVL(rec_updated_appts.deleted_flag,'N') = 'N'
516: THEN
517: UPDATE jtf_tasks_b
518: SET recurrence_rule_id = NULL
519: , last_updated_by = fnd_global.user_id
520: WHERE task_id = rec_updated_appts.task_id;
521:
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'
559: AND t.recurrence_rule_id = r.recurrence_rule_id);
560:
561: l_output_dates_tbl jtf_task_recurrences_pvt.output_dates_rec;
644: SELECT DISTINCT
645: t.task_id
646: , a.task_assignment_id
647: FROM jtf_task_all_assignments a
648: , jtf_tasks_b t
649: , (SELECT /*+ parallel(jtb) */ jtb.recurrence_rule_id
650: , jtaa.resource_id
651: , SUM(decode(jtaa.assignment_status_id, 3, 1, 0)) num_of_accept
652: , SUM(decode(jtaa.assignment_status_id, 4, 1, 0)) num_of_reject
651: , SUM(decode(jtaa.assignment_status_id, 3, 1, 0)) num_of_accept
652: , SUM(decode(jtaa.assignment_status_id, 4, 1, 0)) num_of_reject
653: , SUM(decode(jtaa.assignment_status_id, 18, 1, 0)) num_of_invitee
654: FROM jtf_task_all_assignments jtaa
655: , jtf_tasks_b jtb
656: WHERE jtb.recurrence_rule_id IS NOT NULL
657: AND jtb.source_object_type_code = 'APPOINTMENT'
658: AND jtaa.task_id = jtb.task_id
659: AND jtaa.assignee_role = 'ASSIGNEE'
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);
717:
718: CURSOR c_assignees (b_recurrence_rule_id NUMBER
720: SELECT a.resource_id
721: , a.resource_type_code
722: , count(a.task_assignment_id)
723: FROM jtf_task_all_assignments a
724: , jtf_tasks_b t
725: WHERE t.recurrence_rule_id = b_recurrence_rule_id
726: AND t.source_object_type_code = 'APPOINTMENT'
727: AND (t.object_changed_date = to_date('01/02/1970','MM/DD/YYYY') OR
728: t.object_changed_date IS NULL)
778: IF c_assignees%FOUND
779: THEN
780: l_num := l_num + 1;
781:
782: UPDATE jtf_tasks_b
783: SET recurrence_rule_id = NULL
784: , last_updated_by = fnd_global.user_id
785: WHERE recurrence_rule_id = rec_recur.recurrence_rule_id
786: AND NVL(deleted_flag,'N') <> 'Y';