eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ROLE_UTILS dependencies on PA_PROJECT_ROLE_TYPES

Line 15: ( p_role_id IN pa_project_role_types.project_role_id%TYPE

11: -- HISTORY
12: -- 22-JUN-2000 R. Krishnamurthy Created
13: --
14: procedure Check_Role_Name_Or_Id
15: ( p_role_id IN pa_project_role_types.project_role_id%TYPE
16: ,p_role_name IN pa_project_role_types.meaning%TYPE
17: ,p_check_id_flag IN VARCHAR2 := 'A'
18: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
19: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 16: ,p_role_name IN pa_project_role_types.meaning%TYPE

12: -- 22-JUN-2000 R. Krishnamurthy Created
13: --
14: procedure Check_Role_Name_Or_Id
15: ( p_role_id IN pa_project_role_types.project_role_id%TYPE
16: ,p_role_name IN pa_project_role_types.meaning%TYPE
17: ,p_check_id_flag IN VARCHAR2 := 'A'
18: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
19: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
20: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 18: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895

14: procedure Check_Role_Name_Or_Id
15: ( p_role_id IN pa_project_role_types.project_role_id%TYPE
16: ,p_role_name IN pa_project_role_types.meaning%TYPE
17: ,p_check_id_flag IN VARCHAR2 := 'A'
18: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
19: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
20: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
21:
22: --

Line 36: ( p_role_id IN pa_project_role_types.project_role_id%TYPE

32: -- HISTORY
33: -- 19-FEB-2001 Song Yao Created
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

Line 37: ,p_role_name IN pa_project_role_types.meaning%TYPE

33: -- 19-FEB-2001 Song Yao Created
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

Line 41: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895

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
44: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
45:

Line 55: (p_role_id IN pa_project_role_types.project_role_id%TYPE

51: --
52: -- HISTORY
53: --
54: procedure Get_Role_Defaults
55: (p_role_id IN pa_project_role_types.project_role_id%TYPE
56: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
57: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
58: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
59: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895

Line 56: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895

52: -- HISTORY
53: --
54: procedure Get_Role_Defaults
55: (p_role_id IN pa_project_role_types.project_role_id%TYPE
56: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
57: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
58: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
59: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
60: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 57: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895

53: --
54: procedure Get_Role_Defaults
55: (p_role_id IN pa_project_role_types.project_role_id%TYPE
56: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
57: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
58: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
59: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
60: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
61: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895

Line 58: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895

54: procedure Get_Role_Defaults
55: (p_role_id IN pa_project_role_types.project_role_id%TYPE
56: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
57: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
58: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
59: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
60: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
61: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895
62: ,x_def_competencies OUT NOCOPY pa_hr_competence_utils.competency_tbl_typ --File.Sql.39 bug 4440895

Line 59: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895

55: (p_role_id IN pa_project_role_types.project_role_id%TYPE
56: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
57: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
58: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
59: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
60: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
61: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895
62: ,x_def_competencies OUT NOCOPY pa_hr_competence_utils.competency_tbl_typ --File.Sql.39 bug 4440895
63: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 61: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895

57: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
58: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
59: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
60: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
61: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895
62: ,x_def_competencies OUT NOCOPY pa_hr_competence_utils.competency_tbl_typ --File.Sql.39 bug 4440895
63: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64: ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
65: