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.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_PAR_SHD

Line 228: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or

224: -- Delete the RPA EI if there is a change in Effective Date or
225: -- Person
226: IF p_refresh_flag = 'N' THEN
227: IF (nvl(p_effective_date,hr_api.g_date)
228: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
229: (nvl(p_person_id,hr_api.g_number)
230: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
231: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
232: -- Delete from ghr_pa_request_extra_info

Line 230: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then

226: IF p_refresh_flag = 'N' THEN
227: IF (nvl(p_effective_date,hr_api.g_date)
228: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
229: (nvl(p_person_id,hr_api.g_number)
230: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
231: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
232: -- Delete from ghr_pa_request_extra_info
233: DELETE ghr_pa_request_extra_info
234: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',

Line 890: -- If l_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then

886: hr_utility.set_location('Person inside appt_info is ' || to_char(l_person_id),1);
887: If l_person_id is not null then
888: hr_utility.set_location('Person inside appt_info is ' || to_char(l_person_id),1);
889: -- if the person_id is not the same as the old person_id then do the foll.
890: -- If l_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
891: -- a) Get PER_GROUP1 Information
892: l_refresh_flag := l_per_refresh_flag;
893: ghr_history_fetch.fetch_peopleei
894: (p_person_id => l_person_id,

Line 2915: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and

2911: */ --Backout the changes done for Bug# 4588575
2912: Procedure set_refresh_flags is
2913: Begin
2914: If p_person_id is not null then
2915: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
2916: (l_rei_rec_exists = 'N' or
2917: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2918: then
2919: hr_utility.set_location('change in eff. date only',2);

Line 2917: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))

2913: Begin
2914: If p_person_id is not null then
2915: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
2916: (l_rei_rec_exists = 'N' or
2917: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2918: then
2919: hr_utility.set_location('change in eff. date only',2);
2920: l_person_id := p_person_id;
2921: l_per_refresh_flag := 'Y';

Line 2922: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then

2918: then
2919: hr_utility.set_location('change in eff. date only',2);
2920: l_person_id := p_person_id;
2921: l_per_refresh_flag := 'Y';
2922: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
2923: hr_utility.set_location('person id has changed',3);
2924: l_person_id := p_person_id;
2925: l_per_refresh_flag := 'N';
2926: Else

Line 2932: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and

2928: End if;
2929: hr_utility.set_location('person id in the condition - refresh flag N ' || to_char(l_person_id),1);
2930: End if;
2931: If p_assignment_id is not null then
2932: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
2933: (l_rei_rec_exists = 'N' or
2934: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2935: then
2936: l_assignment_id := p_assignment_id;

Line 2934: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))

2930: End if;
2931: If p_assignment_id is not null then
2932: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
2933: (l_rei_rec_exists = 'N' or
2934: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2935: then
2936: l_assignment_id := p_assignment_id;
2937: l_asg_refresh_flag := 'Y';
2938: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then

Line 2938: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then

2934: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2935: then
2936: l_assignment_id := p_assignment_id;
2937: l_asg_refresh_flag := 'Y';
2938: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then
2939: l_assignment_id := p_assignment_id;
2940: l_asg_refresh_flag := 'N';
2941: Else
2942: l_assignment_id := null;

Line 2946: if p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and

2942: l_assignment_id := null;
2943: End if;
2944: End if;
2945: If p_position_id is not null then
2946: if p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
2947: (l_rei_rec_exists = 'N' or
2948: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2949: then
2950: l_position_id := p_position_id;

Line 2948: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))

2944: End if;
2945: If p_position_id is not null then
2946: if p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
2947: (l_rei_rec_exists = 'N' or
2948: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2949: then
2950: l_position_id := p_position_id;
2951: l_pos_refresh_flag := 'Y';
2952: Elsif p_position_id <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) then

Line 2952: Elsif p_position_id <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) then

2948: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
2949: then
2950: l_position_id := p_position_id;
2951: l_pos_refresh_flag := 'Y';
2952: Elsif p_position_id <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) then
2953: l_position_id := p_position_id;
2954: l_pos_refresh_flag := 'Y';
2955: Else
2956: l_position_id := null;

Line 3650: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and

3646: l_org_rec := Null;
3647: End if;
3648:
3649: If p_person_id is not null then
3650: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3651: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3652: then
3653: l_person_id := p_person_id;
3654: l_per_refresh_flag := 'Y';

Line 3651: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))

3647: End if;
3648:
3649: If p_person_id is not null then
3650: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3651: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3652: then
3653: l_person_id := p_person_id;
3654: l_per_refresh_flag := 'Y';
3655: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then

Line 3655: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then

3651: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3652: then
3653: l_person_id := p_person_id;
3654: l_per_refresh_flag := 'Y';
3655: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
3656: l_person_id := p_person_id;
3657: l_per_refresh_flag := 'N';
3658: Else
3659: l_person_id := null;

Line 3665: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and

3661: End if;
3662:
3663:
3664: If p_assignment_id is not null and l_flag = 'N' then
3665: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3666: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3667: then
3668: l_assignment_id := p_assignment_id;
3669: l_asg_refresh_flag := 'Y';

Line 3666: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))

3662:
3663:
3664: If p_assignment_id is not null and l_flag = 'N' then
3665: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3666: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3667: then
3668: l_assignment_id := p_assignment_id;
3669: l_asg_refresh_flag := 'Y';
3670: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then

Line 3670: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then

3666: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
3667: then
3668: l_assignment_id := p_assignment_id;
3669: l_asg_refresh_flag := 'Y';
3670: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then
3671: --and l_noa_family_code <> 'APP'
3672: l_assignment_id := p_assignment_id;
3673: l_asg_refresh_flag := 'N';
3674: Else