[Home] [Help]
134: nvl(p_to_job_id_old,FND_API.G_MISS_NUM) = nvl(p_to_job_id_new,FND_API.G_MISS_NUM) ) THEN
135: return;
136:
137: -- When the trigger on PER_JOB_EXTRA_INFO is fired, we won't launch the WF in following cases
138: -- because we don't need to update pa_resources_denorm.
139: -- If 'Include in Utilization' Falg=N, we don't need to pull thos corresponding resources. So
140: -- there won't be any resources to update..
141: ELSIF p_table_name= 'PER_JOB_EXTRA_INFO' THEN
142: IF ( p_calling_mode='INSERT' AND (p_jei_information3_new='N' OR p_jei_information3_new IS NULL)) THEN
2535: if (l_primary_flag_new = 'Y' and l_primary_flag_old = 'N'
2536: and pa_hr_update_api.belongs_ExpOrg(l_org_id_new) = 'N') then
2537:
2538: /*If the assignments organization does not belong to expenditure hierarchy
2539: then the corresponding assignment in pa_resources_denorm must be
2540: end dated
2541: */
2542: pa_hr_update_api.Update_EndDate(
2543: p_person_id => l_person_id,
2579:
2580: --dbms_output.put_line('Primary flags are same');
2581:
2582: -- The code below checks if record exists for update in
2583: -- pa_resources_denorm. This check is required because a new
2584: -- assignment creation in HR only updates the default HR
2585: -- assignment. So the new assignment will not exist in PRM
2586:
2587: -- Bug 4352255 - performance improvement - change to where exists
2594: SELECT 'Y'
2595: INTO l_res_asgn_exists
2596: FROM dual
2597: WHERE EXISTS (SELECT 'Y'
2598: FROM pa_resources_denorm
2599: WHERE person_id = l_person_id
2600: AND resource_effective_start_date =
2601: l_start_date_new);
2602: EXCEPTION WHEN NO_DATA_FOUND THEN
3191:
3192: IF l_return_status = 'S' THEN
3193: SELECT max(resource_effective_end_date)
3194: INTO l_resource_effective_end_date
3195: FROM pa_resources_denorm
3196: WHERE person_id = l_person_id;
3197:
3198: log_message('before calling PA_HR_UPDATE_API.withdraw_cand_nominations, l_resource_effective_end_date: '||l_resource_effective_end_date);
3199: PA_HR_UPDATE_API.withdraw_cand_nominations