39: )
40: IS
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_DEPENDENCY';
43: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
44: l_task_number jtf_tasks_b.task_id%TYPE := p_task_number;
45: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
46: l_dependent_on_task_number jtf_tasks_b.task_id%TYPE := p_dependent_on_task_number;
47: l_template_flag jtf_task_depends.template_flag%TYPE := p_template_flag;
40: IS
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_DEPENDENCY';
43: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
44: l_task_number jtf_tasks_b.task_id%TYPE := p_task_number;
45: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
46: l_dependent_on_task_number jtf_tasks_b.task_id%TYPE := p_dependent_on_task_number;
47: l_template_flag jtf_task_depends.template_flag%TYPE := p_template_flag;
48: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
41: l_api_version CONSTANT NUMBER := 1.0;
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_DEPENDENCY';
43: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
44: l_task_number jtf_tasks_b.task_id%TYPE := p_task_number;
45: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
46: l_dependent_on_task_number jtf_tasks_b.task_id%TYPE := p_dependent_on_task_number;
47: l_template_flag jtf_task_depends.template_flag%TYPE := p_template_flag;
48: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
49: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
42: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TASK_DEPENDENCY';
43: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
44: l_task_number jtf_tasks_b.task_id%TYPE := p_task_number;
45: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
46: l_dependent_on_task_number jtf_tasks_b.task_id%TYPE := p_dependent_on_task_number;
47: l_template_flag jtf_task_depends.template_flag%TYPE := p_template_flag;
48: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
49: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
50: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
358: IS
359: l_api_version CONSTANT NUMBER := 1.0;
360: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DEPENDENCY';
361: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
362: l_task_id jtf_tasks_b.task_id%TYPE;
363: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
364: l_dependent_on_task_number jtf_tasks_b.task_number%TYPE := p_dependent_on_task_number;
365: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
366: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
359: l_api_version CONSTANT NUMBER := 1.0;
360: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DEPENDENCY';
361: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
362: l_task_id jtf_tasks_b.task_id%TYPE;
363: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
364: l_dependent_on_task_number jtf_tasks_b.task_number%TYPE := p_dependent_on_task_number;
365: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
366: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
367: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
360: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_DEPENDENCY';
361: l_dependency_id jtf_task_depends.dependency_id%TYPE := p_dependency_id;
362: l_task_id jtf_tasks_b.task_id%TYPE;
363: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;
364: l_dependent_on_task_number jtf_tasks_b.task_number%TYPE := p_dependent_on_task_number;
365: l_dependency_type_code jtf_task_depends.dependency_type_code%TYPE := p_dependency_type_code;
366: l_adjustment_time jtf_task_depends.adjustment_time%TYPE := p_adjustment_time;
367: l_adjustment_time_uom jtf_task_depends.adjustment_time_uom%TYPE := p_adjustment_time_uom;
368: l_template_flag jtf_task_depends.template_flag%TYPE;