2152: AND res_temp.person_id IS NOT NULL;
2153:
2154: UPDATE pa_res_members_temp res_temp
2155: SET job_id = (SELECT default_job_id
2156: FROM pa_project_role_types_vl role
2157: WHERE role.project_role_id = res_temp.project_role_id
2158: AND ROWNUM = 1)
2159: WHERE res_temp.job_id IS NULL
2160: AND res_temp.project_role_id IS NOT NULL;
3010: Cursor c_PrjRoles (P_Prj_Role_Id IN Number) Is
3011: Select
3012: Meaning
3013: From
3014: Pa_Project_Role_Types_vl
3015: Where
3016: Project_Role_Id = P_Prj_Role_Id;
3017:
3018: Cursor c_Res_Attributes Is
4075: Cursor c_PrjRoles (P_Prj_Role_Id IN Number) Is
4076: Select
4077: Meaning
4078: From
4079: Pa_Project_Role_Types_vl
4080: Where
4081: Project_Role_Id = P_Prj_Role_Id;
4082:
4083: Begin
4083: Begin
4084:
4085: If P_Role_Id is Not Null Then
4086:
4087: -- Get role from pa_project_role_types_vl
4088: Open c_PrjRoles(P_Prj_Role_Id => P_Role_Id);
4089: Fetch c_PrjRoles Into l_Role_Displayed;
4090:
4091: If c_PrjRoles%NOTFOUND Then
4263: Cursor c_PrjRoles (P_Prj_Role_Id IN Number) Is
4264: Select
4265: Meaning
4266: From
4267: Pa_Project_Role_Types_vl
4268: Where
4269: Project_Role_Id = P_Prj_Role_Id;
4270:
4271: Cursor c_Res_Attributes