13: -- 21-Sep-2000 nchouhan Created
14: -- ----------------------------------------------------------------------------
15:
16: procedure Check_Work_Type_Name_or_ID
17: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE
18: ,p_name IN pa_work_types_v.name%TYPE
19: ,p_check_id_flag IN VARCHAR2
20: ,x_work_type_id OUT NOCOPY pa_work_types_v.work_type_id%TYPE
21: ,x_return_status OUT NOCOPY VARCHAR2
14: -- ----------------------------------------------------------------------------
15:
16: procedure Check_Work_Type_Name_or_ID
17: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE
18: ,p_name IN pa_work_types_v.name%TYPE
19: ,p_check_id_flag IN VARCHAR2
20: ,x_work_type_id OUT NOCOPY pa_work_types_v.work_type_id%TYPE
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_error_message_code OUT NOCOPY VARCHAR2);
16: procedure Check_Work_Type_Name_or_ID
17: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE
18: ,p_name IN pa_work_types_v.name%TYPE
19: ,p_check_id_flag IN VARCHAR2
20: ,x_work_type_id OUT NOCOPY pa_work_types_v.work_type_id%TYPE
21: ,x_return_status OUT NOCOPY VARCHAR2
22: ,x_error_message_code OUT NOCOPY VARCHAR2);
23:
24: -- ----------------------------------------------------------------------------
37: --
38: -- ----------------------------------------------------------------------------
39:
40: procedure Check_Work_Type
41: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE
42: ,p_project_id IN pa_projects.project_id%TYPE
43: ,p_task_id IN pa_tasks.task_id%TYPE
44: ,x_return_status OUT NOCOPY VARCHAR2
45: ,x_error_message_code OUT NOCOPY VARCHAR2);