APPS.PA_ROLE_UTILS dependencies on PA_ROLE_LISTS

Line 116: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := NULL

112:
113: procedure Check_Role_RoleList
114: ( p_role_id IN pa_project_role_types.project_role_id%TYPE
115: ,p_role_name IN pa_project_role_types.meaning%TYPE
116: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := NULL
117: ,p_role_list_name IN pa_role_lists.name%TYPE := null
118: ,p_check_id_flag IN VARCHAR2
119: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
120: ,x_role_list_id OUT NOCOPY pa_role_lists.role_list_id%TYPE --File.Sql.39 bug 4440895

Line 117: ,p_role_list_name IN pa_role_lists.name%TYPE := null

113: procedure Check_Role_RoleList
114: ( p_role_id IN pa_project_role_types.project_role_id%TYPE
115: ,p_role_name IN pa_project_role_types.meaning%TYPE
116: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := NULL
117: ,p_role_list_name IN pa_role_lists.name%TYPE := null
118: ,p_check_id_flag IN VARCHAR2
119: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
120: ,x_role_list_id OUT NOCOPY pa_role_lists.role_list_id%TYPE --File.Sql.39 bug 4440895
121: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 120: ,x_role_list_id OUT NOCOPY pa_role_lists.role_list_id%TYPE --File.Sql.39 bug 4440895

116: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := NULL
117: ,p_role_list_name IN pa_role_lists.name%TYPE := null
118: ,p_check_id_flag IN VARCHAR2
119: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
120: ,x_role_list_id OUT NOCOPY pa_role_lists.role_list_id%TYPE --File.Sql.39 bug 4440895
121: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
122: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
123:
124: l_status VARCHAR2(10) ;

Line 191: FROM pa_role_lists

187: IF p_role_list_id IS NOT NULL AND p_role_list_id <> FND_API.G_MISS_NUM THEN
188: IF p_check_id_flag <> 'N' THEN
189: SELECT role_list_id
190: INTO x_role_list_id
191: FROM pa_role_lists
192: WHERE role_list_id = p_role_list_id
193: AND TRUNC(start_date_active) <= l_sysdate
194: AND (end_date_active IS NULL OR l_sysdate <= TRUNC(end_date_active));
195: ELSE

Line 201: FROM pa_role_lists

197: END IF;
198: ELSE
199: SELECT role_list_id
200: INTO x_role_list_id
201: FROM pa_role_lists
202: WHERE name = p_role_list_name
203: AND TRUNC(start_date_active) <= l_sysdate
204: AND (end_date_active IS NULL OR l_sysdate <= TRUNC(end_date_active));
205: END IF;

Line 911: from pa_role_lists

907: ,x_return_status out NOCOPY varchar2 --File.Sql.39 bug 4440895
908: ,x_error_message_code out NOCOPY varchar2) IS --File.Sql.39 bug 4440895
909: cursor c_exist is
910: select 'y'
911: from pa_role_lists
912: where name =p_name;
913:
914: v_dummy varchar2(1) ;
915: begin