[Home] [Help]
251: l_dependency_id jtf_task_depends.dependency_id%TYPE;
252: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
253: l_task_rec jtf_task_recurrences_pub.task_details_rec;
254: l_task_group_id jtf_task_templates_b.task_group_id%TYPE;
255: l_description jtf_task_templates_tl.description%TYPE := p_description;
256: l_reccurence_generated NUMBER;
257: l_type VARCHAR2(10);
258: current_record INTEGER;
259: x CHAR;
820: l_api_version CONSTANT NUMBER := 1.0;
821: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_TEMPLATE';
822: l_task_id jtf_task_templates_b.task_template_id%TYPE := p_task_id;
823: l_task_number jtf_task_templates_b.task_number%TYPE := p_task_number;
824: l_task_name jtf_task_templates_tl.task_name%TYPE := p_task_name;
825: l_task_type_name jtf_task_types_tl.name%TYPE := p_task_type_name;
826: l_task_type_id jtf_task_types_b.task_type_id%TYPE := p_task_type_id;
827: l_task_status_name jtf_task_statuses_tl.name%TYPE := p_task_status_name;
828: l_task_status_id jtf_task_statuses_b.task_status_id%TYPE := p_task_status_id;
833: l_private_flag jtf_task_templates_b.private_flag%TYPE;
834: l_publish_flag jtf_task_templates_b.publish_flag%TYPE;
835: l_restrict_closure_flag jtf_task_templates_b.restrict_closure_flag%TYPE;
836: l_multi_booked_flag jtf_task_templates_b.multi_booked_flag%TYPE;
837: l_description jtf_task_templates_tl.description%TYPE;
838: l_planned_effort jtf_task_templates_b.planned_effort%TYPE;
839: l_planned_effort_uom jtf_task_templates_b.planned_effort_uom%TYPE;
840: l_milestone_flag jtf_task_templates_b.milestone_flag%TYPE;
841: l_holiday_flag jtf_task_templates_b.holiday_flag%TYPE;