DBA Data[Home] [Help]

APPS.JTF_TASK_DEPENDENCY_PUB dependencies on JTF_TASKS_B

Line 43: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;

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;

Line 44: l_task_number jtf_tasks_b.task_id%TYPE := p_task_number;

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;

Line 45: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;

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;

Line 46: l_dependent_on_task_number jtf_tasks_b.task_id%TYPE := p_dependent_on_task_number;

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;

Line 362: l_task_id jtf_tasks_b.task_id%TYPE;

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;

Line 363: l_dependent_on_task_id jtf_tasks_b.task_id%TYPE := p_dependent_on_task_id;

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;

Line 364: l_dependent_on_task_number jtf_tasks_b.task_number%TYPE := p_dependent_on_task_number;

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;