APPS.JTF_TASK_REPEAT_APPT_PVT dependencies on JTF_TASKS_B

Line 30: | in jtf_tasks_b |

26: | update_repeat_appointment |
27: | 03-Apr-2002 cjang Fixed so as to update last_update_date |
28: | 08-Apr-2002 cjang Added update_assignment_status |
29: | 09-Apr-2002 cjang Update object_changed_date with SYSDATE |
30: | in jtf_tasks_b |
31: | 24-Apr-2002 cjang Modified c_future and c_all |
32: | in update_repeat_appointment |
33: | to check deleted_flag |
34: | If chnage mode = ALL, do not check if it's|

Line 137: FROM jtf_tasks_b

133: rec_recur c_recur%ROWTYPE;
134:
135: CURSOR c_future (b_start_date DATE, b_recurrence_rule_id NUMBER) IS
136: SELECT task_id, calendar_start_date, calendar_end_date
137: FROM jtf_tasks_b
138: WHERE NVL(deleted_flag,'N') = 'N'
139: AND calendar_start_date >= b_start_date
140: AND recurrence_rule_id = b_recurrence_rule_id;
141:

Line 144: FROM jtf_tasks_b

140: AND recurrence_rule_id = b_recurrence_rule_id;
141:
142: CURSOR c_all (b_recurrence_rule_id NUMBER) IS
143: SELECT task_id, calendar_start_date, calendar_end_date
144: FROM jtf_tasks_b
145: WHERE NVL(deleted_flag,'N') = 'N'
146: AND recurrence_rule_id = b_recurrence_rule_id;
147:
148: l_new_minimum_task_id NUMBER;

Line 389: UPDATE jtf_tasks_b

385:
386: --------------------------------------------------------
387: -- Nullify recurrence_rule_id for this appointment
388: --------------------------------------------------------
389: UPDATE jtf_tasks_b
390: SET recurrence_rule_id = NULL
391: , object_changed_date = SYSDATE
392: WHERE task_id = p_updated_field_rec.task_id;
393:

Line 396: UPDATE jtf_tasks_b

392: WHERE task_id = p_updated_field_rec.task_id;
393:
394: IF l_first
395: THEN
396: UPDATE jtf_tasks_b
397: SET object_changed_date = SYSDATE
398: WHERE task_id = l_new_minimum_task_id;
399: END IF;
400:

Line 626: UPDATE jtf_tasks_b

622: x_return_status := fnd_api.g_ret_sts_unexp_error;
623: RAISE fnd_api.g_exc_unexpected_error;
624: END IF;
625:
626: UPDATE jtf_tasks_b
627: SET recurrence_rule_id = l_new_recurrence_rule_id
628: , object_changed_date = SYSDATE
629: WHERE task_id = rec_future.task_id;
630:

Line 631: UPDATE jtf_tasks_b

627: SET recurrence_rule_id = l_new_recurrence_rule_id
628: , object_changed_date = SYSDATE
629: WHERE task_id = rec_future.task_id;
630:
631: UPDATE jtf_tasks_b
632: SET object_changed_date = SYSDATE
633: WHERE task_id = p_updated_field_rec.task_id;
634:
635: IF rec_future.task_id = p_updated_field_rec.task_id