DBA Data[Home] [Help]

APPS.PA_ROLE_UTILS dependencies on PA_ROLE_LISTS

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

34:
35: procedure Check_Role_RoleList
36: ( p_role_id IN pa_project_role_types.project_role_id%TYPE
37: ,p_role_name IN pa_project_role_types.meaning%TYPE
38: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := NULL
39: ,p_role_list_name IN pa_role_lists.name%TYPE := null
40: ,p_check_id_flag IN VARCHAR2
41: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
42: ,x_role_list_id OUT NOCOPY pa_role_lists.role_list_id%TYPE --File.Sql.39 bug 4440895

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

35: procedure Check_Role_RoleList
36: ( p_role_id IN pa_project_role_types.project_role_id%TYPE
37: ,p_role_name IN pa_project_role_types.meaning%TYPE
38: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := NULL
39: ,p_role_list_name IN pa_role_lists.name%TYPE := null
40: ,p_check_id_flag IN VARCHAR2
41: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
42: ,x_role_list_id OUT NOCOPY pa_role_lists.role_list_id%TYPE --File.Sql.39 bug 4440895
43: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

38: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := NULL
39: ,p_role_list_name IN pa_role_lists.name%TYPE := null
40: ,p_check_id_flag IN VARCHAR2
41: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
42: ,x_role_list_id OUT NOCOPY pa_role_lists.role_list_id%TYPE --File.Sql.39 bug 4440895
43: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
45:
46: --