APPS.JTF_TASKS_PVT dependencies on JTF_TASK_RECUR_RULES

Line 4331: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;

4327: , p_enable_workflow IN VARCHAR2
4328: , p_abort_workflow IN VARCHAR2
4329: ) IS
4330: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4331: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;
4332: l_date_selected jtf_task_recur_rules.date_selected%TYPE;
4333: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4335: l_actual_date jtf_tasks_b.actual_start_date%TYPE;

Line 4332: l_date_selected jtf_task_recur_rules.date_selected%TYPE;

4328: , p_abort_workflow IN VARCHAR2
4329: ) IS
4330: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
4331: l_recur_rule jtf_task_recur_rules.recurrence_rule_id%TYPE;
4332: l_date_selected jtf_task_recur_rules.date_selected%TYPE;
4333: l_planned_date jtf_tasks_b.planned_start_date%TYPE;
4334: l_scheduled_date jtf_tasks_b.scheduled_start_date%TYPE;
4335: l_actual_date jtf_tasks_b.actual_start_date%TYPE;
4336: l_obj_version jtf_tasks_b.object_version_number%TYPE;

Line 4360: FROM jtf_task_recur_rules

4356: -- Retrieve date used in recurrence rule
4357: -- ------------------------------------------------------------------------
4358: CURSOR c_recur_date(b_rule_id jtf_tasks_b.recurrence_rule_id%TYPE) IS
4359: SELECT date_selected
4360: FROM jtf_task_recur_rules
4361: WHERE recurrence_rule_id = b_rule_id;
4362:
4363: -- ------------------------------------------------------------------------
4364: -- Capture all future recurrences if p_delete_future_recurrences is TRUE,

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

4363: -- ------------------------------------------------------------------------
4364: -- Capture all future recurrences if p_delete_future_recurrences is TRUE,
4365: -- or all past and future recurrences if p_delete_future_recurrences is 'A'
4366: -- ------------------------------------------------------------------------
4367: CURSOR c_delete_task(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS
4368: SELECT task_id
4369: , object_version_number
4370: , source_object_type_code
4371: , -- Added for XP Sync Story #58

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

4464: , entity
4465: FROM jtf_tasks_b
4466: WHERE task_id = b_task_id;
4467:
4468: CURSOR c_parent_child(b_date_selected jtf_task_recur_rules.date_selected%TYPE) IS
4469: SELECT count(*) FROM
4470: (SELECT task_number
4471: from jtf_tasks_b
4472: where parent_task_id = p_task_id