eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_REPEAT_ASSIGNMENT_PVT dependencies on JTF_TASK_REPEAT_APPT_PVT

Line 175: AND ((b_add_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL) OR

171: SELECT task_id
172: , calendar_start_date, calendar_end_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));
178:
179: l_task_exclusion_id NUMBER;

Line 176: (b_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE AND calendar_start_date >= b_calendar_start_date) OR

172: , calendar_start_date, calendar_end_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));
178:
179: l_task_exclusion_id NUMBER;
180:

Line 177: (b_add_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND calendar_start_date = b_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));
178:
179: l_task_exclusion_id NUMBER;
180:
181: CURSOR c_recur (b_recurrence_rule_id NUMBER) IS

Line 233: (l_first AND l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE)

229: -----------------------------------
230: -- Check if this is the last one
231: -----------------------------------
232: IF (l_first AND NOT l_exist_new_first_task) OR
233: (l_first AND l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE)
234: THEN
235: -- This repeating rule has only one appointment currently OR
236: -- A user selected the first task one and
237: -- chose the option "Add this new invitee into all the future appointments"

Line 238: l_add_option := JTF_TASK_REPEAT_APPT_PVT.G_ALL;

234: THEN
235: -- This repeating rule has only one appointment currently OR
236: -- A user selected the first task one and
237: -- chose the option "Add this new invitee into all the future appointments"
238: l_add_option := JTF_TASK_REPEAT_APPT_PVT.G_ALL;
239: END IF;
240:
241: IF l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
242: THEN

Line 241: IF l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE

237: -- chose the option "Add this new invitee into all the future appointments"
238: l_add_option := JTF_TASK_REPEAT_APPT_PVT.G_ALL;
239: END IF;
240:
241: IF l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
242: THEN
243: -----------------------------------------------------------------
244: -- Create a new repeating rule (use recurrence table handler)
245: -----------------------------------------------------------------

Line 313: IF l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND

309: ,b_calendar_start_date=> p_add_assignee_rec.calendar_start_date
310: ,b_add_option => l_add_option)
311: LOOP
312:
313: IF l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND
314: l_first AND
315: l_exist_new_first_task
316: THEN
317: ---------------------------------------------------

Line 333: IF l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE OR

329: );
330: END IF;
331: END IF;
332:
333: IF l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE OR
334: l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
335: THEN
336: --------------------------------------------
337: -- Insert this appt into exclusion table

Line 334: l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE

330: END IF;
331: END IF;
332:
333: IF l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE OR
334: l_add_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
335: THEN
336: --------------------------------------------
337: -- Insert this appt into exclusion table
338: --------------------------------------------

Line 352: -- 1) NULL if option = JTF_TASK_REPEAT_APPT_PVT.G_ONE

348: );
349:
350: --------------------------------------------------------
351: -- l_new_recurrence_rule_id has the following value
352: -- 1) NULL if option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
353: -- 2) new recurrence rule id if option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
354: --------------------------------------------------------
355: UPDATE jtf_tasks_b
356: SET recurrence_rule_id = l_new_recurrence_rule_id

Line 353: -- 2) new recurrence rule id if option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE

349:
350: --------------------------------------------------------
351: -- l_new_recurrence_rule_id has the following value
352: -- 1) NULL if option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
353: -- 2) new recurrence rule id if option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
354: --------------------------------------------------------
355: UPDATE jtf_tasks_b
356: SET recurrence_rule_id = l_new_recurrence_rule_id
357: , object_changed_date = SYSDATE

Line 482: AND ((b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL) OR

478: , jtb.calendar_start_date
479: FROM jtf_task_all_assignments jtaa
480: , jtf_tasks_b jtb
481: WHERE jtb.recurrence_rule_id = b_recurrence_rule_id
482: AND ((b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL) OR
483: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND jtb.calendar_start_date = b_calendar_start_date) OR
484: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE AND jtb.calendar_start_date >= b_calendar_start_date))
485: AND jtaa.task_id = jtb.task_id
486: AND jtaa.resource_id = b_resource_id;

Line 483: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND jtb.calendar_start_date = b_calendar_start_date) OR

479: FROM jtf_task_all_assignments jtaa
480: , jtf_tasks_b jtb
481: WHERE jtb.recurrence_rule_id = b_recurrence_rule_id
482: AND ((b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL) OR
483: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND jtb.calendar_start_date = b_calendar_start_date) OR
484: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE AND jtb.calendar_start_date >= b_calendar_start_date))
485: AND jtaa.task_id = jtb.task_id
486: AND jtaa.resource_id = b_resource_id;
487:

Line 484: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE AND jtb.calendar_start_date >= b_calendar_start_date))

480: , jtf_tasks_b jtb
481: WHERE jtb.recurrence_rule_id = b_recurrence_rule_id
482: AND ((b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL) OR
483: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND jtb.calendar_start_date = b_calendar_start_date) OR
484: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE AND jtb.calendar_start_date >= b_calendar_start_date))
485: AND jtaa.task_id = jtb.task_id
486: AND jtaa.resource_id = b_resource_id;
487:
488: l_task_exclusion_id NUMBER;

Line 540: (l_first AND l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE)

536: -----------------------------------
537: -- Check if this is the last one
538: -----------------------------------
539: IF (l_first AND NOT l_exist_new_first_task) OR
540: (l_first AND l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE)
541: THEN
542: -- This repeating rule has only one appointment currently OR
543: -- A user selected the first task one and
544: -- chose the option "Delete this invitee from all the future appointments"

Line 545: l_delete_option := JTF_TASK_REPEAT_APPT_PVT.G_ALL;

541: THEN
542: -- This repeating rule has only one appointment currently OR
543: -- A user selected the first task one and
544: -- chose the option "Delete this invitee from all the future appointments"
545: l_delete_option := JTF_TASK_REPEAT_APPT_PVT.G_ALL;
546: END IF;
547:
548: IF l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
549: THEN

Line 548: IF l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE

544: -- chose the option "Delete this invitee from all the future appointments"
545: l_delete_option := JTF_TASK_REPEAT_APPT_PVT.G_ALL;
546: END IF;
547:
548: IF l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
549: THEN
550: -----------------------------------------------------------------
551: -- Create a new repeating rule (use recurrence table handler)
552: -----------------------------------------------------------------

Line 620: IF l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND

616: ,b_calendar_start_date => p_delete_assignee_rec.calendar_start_date
617: ,b_resource_id => p_delete_assignee_rec.resource_id
618: ,b_delete_option => l_delete_option)
619: LOOP
620: IF l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND
621: l_first AND
622: l_exist_new_first_task
623: THEN
624: ---------------------------------------------------

Line 640: IF l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE OR

636: );
637: END IF;
638: END IF;
639:
640: IF l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE OR
641: l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
642: THEN
643: --------------------------------------------
644: -- Insert this appt into exclusion table

Line 641: l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE

637: END IF;
638: END IF;
639:
640: IF l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE OR
641: l_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
642: THEN
643: --------------------------------------------
644: -- Insert this appt into exclusion table
645: --------------------------------------------

Line 659: -- 1) NULL if option = JTF_TASK_REPEAT_APPT_PVT.G_ONE

655: );
656:
657: --------------------------------------------------------
658: -- l_new_recurrence_rule_id has the following value
659: -- 1) NULL if option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
660: -- 2) new recurrence rule id if option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
661: --------------------------------------------------------
662: UPDATE jtf_tasks_b
663: SET recurrence_rule_id = l_new_recurrence_rule_id

Line 660: -- 2) new recurrence rule id if option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE

656:
657: --------------------------------------------------------
658: -- l_new_recurrence_rule_id has the following value
659: -- 1) NULL if option = JTF_TASK_REPEAT_APPT_PVT.G_ONE
660: -- 2) new recurrence rule id if option = JTF_TASK_REPEAT_APPT_PVT.G_FUTURE
661: --------------------------------------------------------
662: UPDATE jtf_tasks_b
663: SET recurrence_rule_id = l_new_recurrence_rule_id
664: , object_changed_date = SYSDATE