APPS.PA_WORK_TYPE_UTILS dependencies on PA_WORK_TYPES_V

Line 15: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE

11: -- HISTORY
12: -- 19-Jul-2000 nchouhan Created
13: -- ----------------------------------------------------------------------------
14: procedure Check_Work_Type_Name_or_ID
15: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE
16: ,p_name IN pa_work_types_v.name%TYPE
17: ,p_check_id_flag IN VARCHAR2
18: ,x_work_type_id OUT NOCOPY pa_work_types_v.work_type_id%TYPE
19: ,x_return_status OUT NOCOPY VARCHAR2

Line 16: ,p_name IN pa_work_types_v.name%TYPE

12: -- 19-Jul-2000 nchouhan Created
13: -- ----------------------------------------------------------------------------
14: procedure Check_Work_Type_Name_or_ID
15: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE
16: ,p_name IN pa_work_types_v.name%TYPE
17: ,p_check_id_flag IN VARCHAR2
18: ,x_work_type_id OUT NOCOPY pa_work_types_v.work_type_id%TYPE
19: ,x_return_status OUT NOCOPY VARCHAR2
20: ,x_error_message_code OUT NOCOPY VARCHAR2)

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

14: procedure Check_Work_Type_Name_or_ID
15: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE
16: ,p_name IN pa_work_types_v.name%TYPE
17: ,p_check_id_flag IN VARCHAR2
18: ,x_work_type_id OUT NOCOPY pa_work_types_v.work_type_id%TYPE
19: ,x_return_status OUT NOCOPY VARCHAR2
20: ,x_error_message_code OUT NOCOPY VARCHAR2)
21: IS
22: BEGIN

Line 31: FROM pa_work_types_b --pa_work_types_v changed pa_work_types_v to pa_work_types_b for performance issues. Refer Bug:4668829

27: -- Validate ID based on the check id flag
28: IF p_check_id_flag = 'Y' THEN
29: SELECT work_type_id
30: INTO x_work_type_id
31: FROM pa_work_types_b --pa_work_types_v changed pa_work_types_v to pa_work_types_b for performance issues. Refer Bug:4668829
32: WHERE work_type_id = p_work_type_id
33: AND TRUNC(SYSDATE) BETWEEN start_date_active
34: AND NVL(end_date_active,TRUNC(SYSDATE));
35: ELSE

Line 42: FROM pa_work_types_v

38: ELSE
39: -- Validate Name
40: SELECT work_type_id
41: INTO x_work_type_id
42: FROM pa_work_types_v
43: WHERE name = p_name
44: AND TRUNC(SYSDATE) BETWEEN start_date_active
45: AND NVL(end_date_active,TRUNC(SYSDATE));
46: END IF;

Line 89: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE

85: --
86: -- ----------------------------------------------------------------------------
87: --
88: procedure Check_Work_Type
89: ( p_work_type_id IN pa_work_types_v.work_type_id%TYPE
90: ,p_project_id IN pa_projects.project_id%TYPE
91: ,p_task_id IN pa_tasks.task_id%TYPE
92: ,x_return_status OUT NOCOPY VARCHAR2
93: ,x_error_message_code OUT NOCOPY VARCHAR2)

Line 115: FROM pa_work_types_b w -- changed pa_work_types_v to pa_work_types_b for performance issue. Refer Bug: 4668829

111: FROM pa_tasks t
112: WHERE t.task_id = p_task_id;
113: CURSOR work_type_cur IS
114: SELECT w.BILLABLE_CAPITALIZABLE_FLAG
115: FROM pa_work_types_b w -- changed pa_work_types_v to pa_work_types_b for performance issue. Refer Bug: 4668829
116: WHERE w.work_type_id = p_work_type_id;
117:
118: l_proj_type_rec Get_Project_type_class_cur%ROWTYPE;
119: l_proj_rec Get_Project_type%ROWTYPE;