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 18: ( p_role_id IN pa_project_role_types.project_role_id%TYPE

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

Line 19: ,p_role_name IN pa_project_role_types.meaning%TYPE

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

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

17: procedure Check_Role_Name_Or_Id
18: ( p_role_id IN pa_project_role_types.project_role_id%TYPE
19: ,p_role_name IN pa_project_role_types.meaning%TYPE
20: ,p_check_id_flag IN VARCHAR2 := 'A'
21: ,x_role_id OUT NOCOPY pa_project_role_types.project_role_id%TYPE --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
24:
25: CURSOR c_ids IS

Line 27: FROM pa_project_role_types_vl

23: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
24:
25: CURSOR c_ids IS
26: SELECT project_role_id
27: FROM pa_project_role_types_vl
28: WHERE meaning = p_role_name;
29: l_current_id NUMBER := NULL;
30: l_num_ids NUMBER:= 0;
31: l_id_found_flag VARCHAR(1) := 'N';

Line 39: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to

35: IF p_role_id IS NOT NULL AND p_role_id <> FND_API.G_MISS_NUM THEN
36: IF p_check_id_flag = 'Y' THEN
37: SELECT project_role_id
38: INTO x_role_id
39: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
40: pa_project_role_types_b */
41: WHERE project_role_id = p_role_id
42: AND TRUNC(SYSDATE) BETWEEN
43: start_date_active AND

Line 40: pa_project_role_types_b */

36: IF p_check_id_flag = 'Y' THEN
37: SELECT project_role_id
38: INTO x_role_id
39: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
40: pa_project_role_types_b */
41: WHERE project_role_id = p_role_id
42: AND TRUNC(SYSDATE) BETWEEN
43: start_date_active AND
44: NVL(end_date_active,TRUNC(SYSDATE));

Line 81: FROM pa_project_role_types_vl

77: ELSE
78: IF (p_role_name IS NOT NULL) then
79: SELECT project_role_id
80: INTO x_role_id
81: FROM pa_project_role_types_vl
82: WHERE meaning = p_role_name
83: AND TRUNC(SYSDATE) BETWEEN
84: start_date_active AND
85: NVL(end_date_active,TRUNC(SYSDATE));

Line 114: ( p_role_id IN pa_project_role_types.project_role_id%TYPE

110: RAISE;
111: END Check_Role_Name_Or_Id;
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

Line 115: ,p_role_name IN pa_project_role_types.meaning%TYPE

111: END Check_Role_Name_Or_Id;
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

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

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
122: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
123:

Line 136: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to

132: IF p_role_id IS NOT NULL AND p_role_id <> FND_API.G_MISS_NUM THEN
133: IF p_check_id_flag = 'Y' THEN
134: SELECT project_role_id
135: INTO x_role_id
136: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
137: pa_project_role_types_b */
138: WHERE project_role_id = p_role_id
139: AND TRUNC(SYSDATE) BETWEEN
140: start_date_active AND

Line 137: pa_project_role_types_b */

133: IF p_check_id_flag = 'Y' THEN
134: SELECT project_role_id
135: INTO x_role_id
136: FROM pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
137: pa_project_role_types_b */
138: WHERE project_role_id = p_role_id
139: AND TRUNC(SYSDATE) BETWEEN
140: start_date_active AND
141: NVL(end_date_active,TRUNC(SYSDATE));

Line 148: FROM pa_project_role_types_vl

144: END IF;
145: ELSE
146: SELECT project_role_id
147: INTO x_role_id
148: FROM pa_project_role_types_vl
149: WHERE meaning = p_role_name
150: AND TRUNC(SYSDATE) BETWEEN
151: start_date_active AND
152: NVL(end_date_active,TRUNC(SYSDATE));

Line 267: (p_role_id IN pa_project_role_types.project_role_id%TYPE

263: -- This procedure returns the defaults for a role
264: --
265: -- HISTORY
266: PROCEDURE Get_Role_Defaults
267: (p_role_id IN pa_project_role_types.project_role_id%TYPE
268: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
269: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
270: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
271: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895

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

264: --
265: -- HISTORY
266: PROCEDURE Get_Role_Defaults
267: (p_role_id IN pa_project_role_types.project_role_id%TYPE
268: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
269: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
270: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
271: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
272: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

265: -- HISTORY
266: PROCEDURE Get_Role_Defaults
267: (p_role_id IN pa_project_role_types.project_role_id%TYPE
268: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
269: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
270: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
271: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
272: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
273: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895

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

266: PROCEDURE Get_Role_Defaults
267: (p_role_id IN pa_project_role_types.project_role_id%TYPE
268: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
269: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
270: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
271: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
272: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
273: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895
274: ,x_def_competencies OUT NOCOPY pa_hr_competence_utils.competency_tbl_typ --File.Sql.39 bug 4440895

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

267: (p_role_id IN pa_project_role_types.project_role_id%TYPE
268: ,x_meaning OUT NOCOPY pa_project_role_types.meaning%TYPE --File.Sql.39 bug 4440895
269: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
270: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
271: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
272: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
273: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895
274: ,x_def_competencies OUT NOCOPY pa_hr_competence_utils.competency_tbl_typ --File.Sql.39 bug 4440895
275: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

269: ,x_default_min_job_level OUT NOCOPY pa_project_role_types.default_min_job_level%TYPE --File.Sql.39 bug 4440895
270: ,x_default_max_job_level OUT NOCOPY pa_project_role_types.default_max_job_level%TYPE --File.Sql.39 bug 4440895
271: ,x_menu_id OUT NOCOPY pa_project_role_types.menu_id%TYPE --File.Sql.39 bug 4440895
272: ,x_schedulable_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
273: ,x_default_job_id OUT NOCOPY pa_project_role_types.default_job_id%TYPE --File.Sql.39 bug 4440895
274: ,x_def_competencies OUT NOCOPY pa_hr_competence_utils.competency_tbl_typ --File.Sql.39 bug 4440895
275: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
276: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
277:

Line 288: FROM pa_project_role_types_vl

284: default_min_job_level,
285: default_max_job_level,
286: menu_id,
287: default_job_id
288: FROM pa_project_role_types_vl
289: WHERE project_role_id = p_role_id ;
290: BEGIN
291: pa_debug.init_err_stack ('pa_role_utils.get_role_defaults');
292: OPEN l_role_csr;

Line 478: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to

474: --select '1'
475: --from dual
476: --where exists
477: select 'Y'
478: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
479: pa_project_role_types_b */
480: where project_role_id in (1,2,3,4)
481: and project_role_id=p_role_id
482: AND ROWNUM =1;

Line 479: pa_project_role_types_b */

475: --from dual
476: --where exists
477: select 'Y'
478: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types_vl to
479: pa_project_role_types_b */
480: where project_role_id in (1,2,3,4)
481: and project_role_id=p_role_id
482: AND ROWNUM =1;
483:

Line 538: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types to

534: --select '1'
535: --from dual
536: --where exists
537: select 'Y'
538: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types to
539: pa_project_role_types_b */
540: where project_role_id in (1,2,3,4)
541: and project_role_id=p_role_id
542: AND ROWNUM =1;

Line 539: pa_project_role_types_b */

535: --from dual
536: --where exists
537: select 'Y'
538: from pa_project_role_types_b /* Bug#2788815-Changed pa_project_role_types to
539: pa_project_role_types_b */
540: where project_role_id in (1,2,3,4)
541: and project_role_id=p_role_id
542: AND ROWNUM =1;
543: v_dummy varchar2(1);

Line 657: from pa_project_role_types

653: v_menu_id number;
654: begin
655: select menu_id
656: into v_menu_id
657: from pa_project_role_types
658: where project_role_id=p_role_id;
659:
660: if v_menu_id is not null then
661: if is_role_in_use(p_role_id)='N' then

Line 881: from pa_project_role_types_vl

877: ,x_return_status out NOCOPY varchar2 --File.Sql.39 bug 4440895
878: ,x_error_message_code out NOCOPY varchar2) IS --File.Sql.39 bug 4440895
879: cursor c_exist is
880: select 'y'
881: from pa_project_role_types_vl
882: where meaning =p_meaning;
883:
884: v_dummy varchar2(1) ;
885: begin