[Home] [Help]
682: l_type VARCHAR2(10);
683: l_msg_data VARCHAR2(2000); -- debug
684: l_task_id jtf_tasks_b.task_id%TYPE;
685: l_notes_id NUMBER;
686: l_dependency_id jtf_task_depends.dependency_id%TYPE;
687: l_recurrence_rule_id jtf_task_recur_rules.recurrence_rule_id%TYPE;
688: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
689: l_task_rec jtf_task_recurrences_pub.task_details_rec;
690: l_reccurence_generated NUMBER;
6311: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TASK';
6312: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6313: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6314: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6315: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6316: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6317: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
6318: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
6319: l_task_date_id jtf_task_dates.task_date_id%TYPE;
6418: , template_flag
6419: , adjustment_time
6420: , adjustment_time_uom
6421: , validated_flag
6422: FROM jtf_task_depends
6423: WHERE task_id = l_source_task_id;
6424:
6425: CURSOR c_references IS
6426: SELECT object_type_code
7941: ) IS
7942: CURSOR c_task_info(i_task_id jtf_tasks_b.task_id%TYPE) IS
7943: SELECT a.task_id
7944: , b.object_version_number
7945: FROM jtf_task_depends a, jtf_tasks_b b
7946: WHERE a.task_id = i_task_id AND a.task_id = b.task_id
7947: AND b.task_split_flag = p_task_split_flag;
7948:
7949: -- Cursor for finding all the tasks depend on the master task
7949: -- Cursor for finding all the tasks depend on the master task
7950: CURSOR c_mass_tasks_info IS
7951: SELECT task_id
7952: , dependent_on_task_id
7953: FROM jtf_task_depends
7954: START WITH dependent_on_task_id = p_task_id
7955: CONNECT BY PRIOR task_id = dependent_on_task_id;
7956:
7957: -- changed the parameter name by SBARAT on 19/01/2006 for bug# 4888496