[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;
6286: l_api_name CONSTANT VARCHAR2(30) := 'COPY_TASK';
6287: l_source_task_id jtf_tasks_b.task_id%TYPE := p_source_task_id;
6288: l_target_task_id jtf_tasks_b.task_id%TYPE := p_target_task_id;
6289: l_task_number jtf_tasks_b.task_id%TYPE := p_source_task_number;
6290: l_dependency_id jtf_task_depends.dependency_id%TYPE;
6291: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
6292: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
6293: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
6294: l_task_date_id jtf_task_dates.task_date_id%TYPE;
6393: , template_flag
6394: , adjustment_time
6395: , adjustment_time_uom
6396: , validated_flag
6397: FROM jtf_task_depends
6398: WHERE task_id = l_source_task_id;
6399:
6400: CURSOR c_references IS
6401: SELECT object_type_code
7916: ) IS
7917: CURSOR c_task_info(i_task_id jtf_tasks_b.task_id%TYPE) IS
7918: SELECT a.task_id
7919: , b.object_version_number
7920: FROM jtf_task_depends a, jtf_tasks_b b
7921: WHERE a.task_id = i_task_id AND a.task_id = b.task_id
7922: AND b.task_split_flag = p_task_split_flag;
7923:
7924: -- Cursor for finding all the tasks depend on the master task
7924: -- Cursor for finding all the tasks depend on the master task
7925: CURSOR c_mass_tasks_info IS
7926: SELECT task_id
7927: , dependent_on_task_id
7928: FROM jtf_task_depends
7929: START WITH dependent_on_task_id = p_task_id
7930: CONNECT BY PRIOR task_id = dependent_on_task_id;
7931:
7932: -- changed the parameter name by SBARAT on 19/01/2006 for bug# 4888496