APPS.JTF_TASK_REPEAT_APPT_PVT dependencies on JTF_TASK_RECUR_RULES

Line 130: FROM jtf_task_recur_rules

126: IS
127:
128: CURSOR c_recur (b_recurrence_rule_id NUMBER) IS
129: SELECT *
130: FROM jtf_task_recur_rules
131: WHERE recurrence_rule_id = b_recurrence_rule_id;
132:
133: rec_recur c_recur%ROWTYPE;
134:

Line 426: SELECT jtf_task_recur_rules_s.NEXTVAL

422: RAISE fnd_api.g_exc_unexpected_error;
423: END IF;
424: CLOSE c_recur;
425:
426: SELECT jtf_task_recur_rules_s.NEXTVAL
427: INTO l_new_recurrence_rule_id
428: FROM dual;
429:
430: jtf_task_recur_rules_pkg.insert_row (

Line 430: jtf_task_recur_rules_pkg.insert_row (

426: SELECT jtf_task_recur_rules_s.NEXTVAL
427: INTO l_new_recurrence_rule_id
428: FROM dual;
429:
430: jtf_task_recur_rules_pkg.insert_row (
431: x_rowid => l_rowid,
432: x_recurrence_rule_id => l_new_recurrence_rule_id,
433: x_occurs_which => rec_recur.occurs_which,
434: x_day_of_week => rec_recur.day_of_week,

Line 648: UPDATE jtf_task_recur_rules

644: --update_assignment_status(p_task_id => rec_future.task_id);
645: END LOOP;
646:
647: -- Added by SBARAT on 12/04/2006 for bug# 5119782
648: UPDATE jtf_task_recur_rules
649: SET occurs_number=l_occurs
650: WHERE recurrence_rule_id = l_new_recurrence_rule_id;
651:
652: ELSIF l_change_mode = G_ALL