APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_PAR_SHD

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

258: -- Delete the RPA EI if there is a change in Effective Date or
259: -- Person
260: IF p_refresh_flag = 'N' THEN
261: IF (nvl(p_effective_date,hr_api.g_date)
262: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
263: (nvl(p_person_id,hr_api.g_number)
264: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
265: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
266: -- Delete from ghr_pa_request_extra_info

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

260: IF p_refresh_flag = 'N' THEN
261: IF (nvl(p_effective_date,hr_api.g_date)
262: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
263: (nvl(p_person_id,hr_api.g_number)
264: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number)) then
265: hr_utility.set_location('Inside the Delete IF '||l_noa_code, 2);
266: -- Delete from ghr_pa_request_extra_info
267: DELETE ghr_pa_request_extra_info
268: WHERE INFORMATION_TYPE in ( 'GHR_US_PAR_TERM_RET_GRADE',

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

964: hr_utility.set_location('Person inside appt_info is ' || to_char(l_person_id),1);
965: If l_person_id is not null then
966: hr_utility.set_location('Person inside appt_info is ' || to_char(l_person_id),1);
967: -- if the person_id is not the same as the old person_id then do the foll.
968: -- If l_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
969: -- a) Get PER_GROUP1 Information
970: l_refresh_flag := l_per_refresh_flag;
971: ghr_history_fetch.fetch_peopleei
972: (p_person_id => l_person_id,

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

3526: Procedure set_refresh_flags is
3527: Begin
3528:
3529: If p_person_id is not null then
3530: if (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3531: (l_rei_rec_exists = 'N' or
3532: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3533: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3534: -- correction of another action of the same effective date has been processed consecutively

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

3528:
3529: If p_person_id is not null then
3530: if (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3531: (l_rei_rec_exists = 'N' or
3532: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3533: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3534: -- correction of another action of the same effective date has been processed consecutively
3535: (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3536: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and

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

3531: (l_rei_rec_exists = 'N' or
3532: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3533: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3534: -- correction of another action of the same effective date has been processed consecutively
3535: (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3536: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3537: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3538: then
3539: hr_utility.set_location('change in eff. date only',2);

Line 3536: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and

3532: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3533: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3534: -- correction of another action of the same effective date has been processed consecutively
3535: (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3536: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3537: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3538: then
3539: hr_utility.set_location('change in eff. date only',2);
3540: l_person_id := p_person_id;

Line 3537: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))

3533: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3534: -- correction of another action of the same effective date has been processed consecutively
3535: (p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
3536: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3537: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3538: then
3539: hr_utility.set_location('change in eff. date only',2);
3540: l_person_id := p_person_id;
3541: l_per_refresh_flag := 'Y';

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

3538: then
3539: hr_utility.set_location('change in eff. date only',2);
3540: l_person_id := p_person_id;
3541: l_per_refresh_flag := 'Y';
3542: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
3543: hr_utility.set_location('person id has changed',3);
3544: l_person_id := p_person_id;
3545: l_per_refresh_flag := 'N';
3546: Else

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

3548: End if;
3549: hr_utility.set_location('person id in the condition - refresh flag N ' || to_char(l_person_id),1);
3550: End if;
3551: If p_assignment_id is not null then
3552: if (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3553: (l_rei_rec_exists = 'N' or
3554: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3555: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3556: -- correction of another action of the same effective date has been processed consecutively

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

3550: End if;
3551: If p_assignment_id is not null then
3552: if (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3553: (l_rei_rec_exists = 'N' or
3554: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3555: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3556: -- correction of another action of the same effective date has been processed consecutively
3557: (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3558: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and

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

3553: (l_rei_rec_exists = 'N' or
3554: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3555: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3556: -- correction of another action of the same effective date has been processed consecutively
3557: (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3558: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3559: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3560: then
3561: l_assignment_id := p_assignment_id;

Line 3558: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and

3554: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3555: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3556: -- correction of another action of the same effective date has been processed consecutively
3557: (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3558: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3559: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3560: then
3561: l_assignment_id := p_assignment_id;
3562: l_asg_refresh_flag := 'Y';

Line 3559: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))

3555: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3556: -- correction of another action of the same effective date has been processed consecutively
3557: (p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
3558: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3559: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3560: then
3561: l_assignment_id := p_assignment_id;
3562: l_asg_refresh_flag := 'Y';
3563: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then

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

3559: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3560: then
3561: l_assignment_id := p_assignment_id;
3562: l_asg_refresh_flag := 'Y';
3563: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then
3564: l_assignment_id := p_assignment_id;
3565: l_asg_refresh_flag := 'N';
3566: Else
3567: l_assignment_id := null;

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

3567: l_assignment_id := null;
3568: End if;
3569: End if;
3570: If p_position_id is not null then
3571: if (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
3572: (l_rei_rec_exists = 'N' or
3573: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3574: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3575: -- correction of another action of the same effective date has been processed consecutively

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

3569: End if;
3570: If p_position_id is not null then
3571: if (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
3572: (l_rei_rec_exists = 'N' or
3573: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3574: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3575: -- correction of another action of the same effective date has been processed consecutively
3576: (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
3577: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and

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

3572: (l_rei_rec_exists = 'N' or
3573: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3574: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3575: -- correction of another action of the same effective date has been processed consecutively
3576: (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
3577: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3578: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3579: then
3580: l_position_id := p_position_id;

Line 3577: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and

3573: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))) or
3574: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3575: -- correction of another action of the same effective date has been processed consecutively
3576: (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
3577: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3578: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3579: then
3580: l_position_id := p_position_id;
3581: l_pos_refresh_flag := 'Y';

Line 3578: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))

3574: --Bug # 9006561 Added this condition to consider if the cancellation of one action and
3575: -- correction of another action of the same effective date has been processed consecutively
3576: (p_position_id = nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) and
3577: p_pa_request_id <> nvl(ghr_par_shd.g_old_rec.pa_request_id ,hr_api.g_number) and
3578: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3579: then
3580: l_position_id := p_position_id;
3581: l_pos_refresh_flag := 'Y';
3582: Elsif p_position_id <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) then

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

3578: trunc(nvl(p_effective_date,sysdate)) = trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate)))
3579: then
3580: l_position_id := p_position_id;
3581: l_pos_refresh_flag := 'Y';
3582: Elsif p_position_id <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api.g_number) then
3583: l_position_id := p_position_id;
3584: l_pos_refresh_flag := 'Y';
3585: Else
3586: l_position_id := null;

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

4403: l_org_rec := Null;
4404: End if;
4405:
4406: If p_person_id is not null then
4407: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
4408: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4409: then
4410: l_person_id := p_person_id;
4411: l_per_refresh_flag := 'Y';

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

4404: End if;
4405:
4406: If p_person_id is not null then
4407: if p_person_id = nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) and
4408: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4409: then
4410: l_person_id := p_person_id;
4411: l_per_refresh_flag := 'Y';
4412: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then

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

4408: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4409: then
4410: l_person_id := p_person_id;
4411: l_per_refresh_flag := 'Y';
4412: Elsif p_person_id <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number) then
4413: l_person_id := p_person_id;
4414: l_per_refresh_flag := 'N';
4415: Else
4416: l_person_id := null;

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

4418: End if;
4419:
4420:
4421: If p_assignment_id is not null and l_flag = 'N' then
4422: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
4423: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4424: then
4425: l_assignment_id := p_assignment_id;
4426: l_asg_refresh_flag := 'Y';

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

4419:
4420:
4421: If p_assignment_id is not null and l_flag = 'N' then
4422: if p_assignment_id = nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) and
4423: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4424: then
4425: l_assignment_id := p_assignment_id;
4426: l_asg_refresh_flag := 'Y';
4427: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then

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

4423: trunc(nvl(p_effective_date,sysdate)) <> trunc(nvl(ghr_par_shd.g_old_rec.effective_date,sysdate))
4424: then
4425: l_assignment_id := p_assignment_id;
4426: l_asg_refresh_flag := 'Y';
4427: Elsif p_assignment_id <> nvl(ghr_par_shd.g_old_rec.employee_assignment_id,hr_api.g_number) then
4428: --and l_noa_family_code <> 'APP'
4429: l_assignment_id := p_assignment_id;
4430: l_asg_refresh_flag := 'N';
4431: Else