DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UTILS dependencies on PA_WORK_TYPES_V

Line 17: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE

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

Line 18: ,p_name IN pa_work_types_v.name%TYPE

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);

Line 20: ,x_work_type_id OUT NOCOPY pa_work_types_v.work_type_id%TYPE

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: -- ----------------------------------------------------------------------------

Line 41: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE

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);