APPS.JTF_TASK_REPEAT_ASSIGNMENT_PVT dependencies on JTF_TASKS_B

Line 49: | in jtf_tasks_b |

45: | Modified response_invitation |
46: | 02-Apr-2002 cjang Modified |
47: | 03-Apr-2002 cjang Fixed so as to update last_update_date |
48: | 09-Apr-2002 cjang Update object_changed_date with SYSDATE|
49: | in jtf_tasks_b |
50: | 10-Apr-2002 cjang A user is NOT allowed to accept one of |
51: | occurrences. |
52: | He/She can either accept all or reject all.|
53: | The "update_all" and "calendar_start_date" |

Line 81: , jtf_tasks_b jtb

77: SELECT jtb.task_id
78: , jtaa.task_assignment_id
79: , jtaa.object_version_number
80: FROM jtf_task_all_assignments jtaa
81: , jtf_tasks_b jtb
82: , jtf_task_all_assignments rs
83: WHERE jtb.recurrence_rule_id = b_recurrence_rule_id
84: AND rs.task_assignment_id = b_task_assignment_id
85: AND jtaa.task_id = jtb.task_id

Line 173: FROM jtf_tasks_b

169: ,b_add_option VARCHAR2)
170: IS
171: SELECT task_id
172: , calendar_start_date
173: FROM jtf_tasks_b
174: WHERE recurrence_rule_id = b_recurrence_rule_id
175: AND ((b_add_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL) OR
176: (b_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE AND calendar_start_date >= b_calendar_start_date) OR
177: (b_add_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND calendar_start_date = b_calendar_start_date));

Line 349: UPDATE jtf_tasks_b

345: -- l_new_recurrence_rule_id has the following value
346: -- 1) NULL if option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
347: -- 2) new recurrence rule id if option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
348: --------------------------------------------------------
349: UPDATE jtf_tasks_b
350: SET recurrence_rule_id = l_new_recurrence_rule_id
351: , object_changed_date = SYSDATE
352: WHERE task_id = rec_tasks.task_id;
353: END IF;

Line 425: , jtf_tasks_b jtb

421: , jtaa.object_version_number
422: , jtaa.task_id
423: , jtb.calendar_start_date
424: FROM jtf_task_all_assignments jtaa
425: , jtf_tasks_b jtb
426: WHERE jtb.recurrence_rule_id = b_recurrence_rule_id
427: AND ((b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL) OR
428: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND jtb.calendar_start_date = b_calendar_start_date) OR
429: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE AND jtb.calendar_start_date >= b_calendar_start_date))

Line 607: UPDATE jtf_tasks_b

603: -- l_new_recurrence_rule_id has the following value
604: -- 1) NULL if option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
605: -- 2) new recurrence rule id if option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
606: --------------------------------------------------------
607: UPDATE jtf_tasks_b
608: SET recurrence_rule_id = l_new_recurrence_rule_id
609: , object_changed_date = SYSDATE
610: WHERE task_id = rec_assignments.task_id;
611: END IF;