APPS.JTF_TASKS_PVT dependencies on JTF_TASK_RECUR_RULES

Line 4412: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;

4408: , p_enable_workflow IN VARCHAR2
4409: , p_abort_workflow IN VARCHAR2
4410: ) IS
4411: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4412: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;
4413: l_date_selected jtf_task_recur_rules.date_selected%TYPE;
4414: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4415: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4416: l_actual_date jtf_tasks_b.actual_start_date%TYPE;

Line 4413: l_date_selected jtf_task_recur_rules.date_selected%TYPE;

4409: , p_abort_workflow IN VARCHAR2
4410: ) IS
4411: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4412: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;
4413: l_date_selected jtf_task_recur_rules.date_selected%TYPE;
4414: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4415: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4416: l_actual_date jtf_tasks_b.actual_start_date%TYPE;
4417: l_obj_version jtf_tasks_b.object_version_number%TYPE;

Line 4441: FROM jtf_task_recur_rules

4437: -- Retrieve date used in recurrence rule
4438: -- ------------------------------------------------------------------------
4439: CURSOR c_recur_date(b_rule_id jtf_tasks_b.recurrence_rule_id%TYPE) IS
4440: SELECT date_selected
4441: FROM jtf_task_recur_rules
4442: WHERE recurrence_rule_id = b_rule_id;
4443:
4444: -- ------------------------------------------------------------------------
4445: -- Capture all future recurrences if p_delete_future_recurrences is TRUE,

Line 4448: CURSOR c_delete_task(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS

4444: -- ------------------------------------------------------------------------
4445: -- Capture all future recurrences if p_delete_future_recurrences is TRUE,
4446: -- or all past and future recurrences if p_delete_future_recurrences is 'A'
4447: -- ------------------------------------------------------------------------
4448: CURSOR c_delete_task(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS
4449: SELECT task_id
4450: , object_version_number
4451: , source_object_type_code
4452: , -- Added for XP Sync Story #58

Line 4549: CURSOR c_parent_child(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS

4545: , entity
4546: FROM jtf_tasks_b
4547: WHERE task_id = b_task_id;
4548:
4549: CURSOR c_parent_child(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS
4550: SELECT count(*) FROM
4551: (SELECT task_number
4552: from jtf_tasks_b
4553: where parent_task_id = p_task_id