26: ,p_error_message_code OUT NOCOPY VARCHAR2) IS
27:
28: cursor c_exists is
29: select 'Y'
30: from pa_role_job_bgs
31: where project_role_id = p_project_role_id
32: and nvl(business_group_id, -99) = nvl(p_business_group_id, -99)
33: and role_job_bg_id <> nvl(p_role_job_bg_id, -99);
34:
80: BEGIN
81:
82: SELECT job_id
83: into l_job_id
84: FROM pa_role_job_bgs
85: WHERE project_role_id = p_project_role_id
86: AND nvl(business_group_id, -1) = l_bg_id;
87:
88: EXCEPTION
114: BEGIN
115:
116: SELECT min_job_level
117: into l_min_job_level
118: FROM pa_role_job_bgs
119: WHERE project_role_id = p_project_role_id
120: AND nvl(business_group_id, -1) = l_bg_id;
121:
122: EXCEPTION
148: BEGIN
149:
150: SELECT max_job_level
151: into l_max_job_level
152: FROM pa_role_job_bgs
153: WHERE project_role_id = p_project_role_id
154: AND nvl(business_group_id, -1) = l_bg_id;
155:
156: EXCEPTION