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_SF52_API dependencies on GHR_PAR_SHD

Line 270: --l_rec ghr_par_shd.g_old_rec%type;

266: l_2_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
267: l_2_user_name ghr_pa_routing_history.user_name%TYPE;
268: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
269: l_temp number(15);
270: --l_rec ghr_par_shd.g_old_rec%type;
271: l_rec ghr_pa_requests%rowtype;
272: l_rei_rec ghr_pa_request_extra_info%rowtype; -- Temporarily added till wrapper is available
273: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
274: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;

Line 1149: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then

1145: hr_utility.set_location('passed action taken ' ||p_1_action_taken,1);
1146: l_action_taken := p_1_action_taken;
1147: if l_action_taken is null then
1148: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1149: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1150: l_action_taken := 'AUTHORIZED';
1151: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1152: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1153: l_action_taken := 'REQUESTED';

Line 1152: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then

1148: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1149: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1150: l_action_taken := 'AUTHORIZED';
1151: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1152: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1153: l_action_taken := 'REQUESTED';
1154: else
1155: hr_utility.set_location('Bef c_history_exists ' ||l_pa_request_id,2);
1156: for history_exists in C_history_exists loop

Line 2266: -- l_rec ghr_par_shd.g_old_rec%type;

2262: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2263: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2264: l_forward_to_name ghr_pa_routing_history.user_name%type;
2265: l_rec ghr_pa_requests%rowtype;
2266: -- l_rec ghr_par_shd.g_old_rec%type;
2267: l_rei_rec ghr_pa_request_extra_info%rowtype;
2268: l_part_time_hours ghr_pa_requests.part_time_hours%type;
2269: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2270: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;

Line 3131: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then

3127: -- b) first nature_of_action has changed (delete and then insert new records)
3128: --
3129:
3130: if nvl(p_first_noa_id,hr_api.g_number)
3131: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
3132: hr_utility.set_location(l_proc, 9);
3133:
3134: -- delete the existing remarks
3135: delete from ghr_pa_remarks pre

Line 3140: where nature_of_action_id = ghr_par_shd.g_old_rec.first_noa_id);

3136: where pre.pa_request_id = p_pa_request_id
3137: and pre.remark_id in
3138: (select remark_id
3139: from ghr_noac_remarks
3140: where nature_of_action_id = ghr_par_shd.g_old_rec.first_noa_id);
3141: if p_first_noa_id is not null then
3142: hr_utility.set_location(l_proc, 10);
3143:
3144: insert into ghr_pa_remarks

Line 3172: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then

3168: end if;
3169: end if;
3170:
3171: if nvl(p_second_noa_id,hr_api.g_number)
3172: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then
3173:
3174: -- delete the existing remarks
3175: delete from ghr_pa_remarks pre
3176: where pre.pa_request_id = p_pa_request_id

Line 3180: where nature_of_action_id = ghr_par_shd.g_old_rec.second_noa_id);

3176: where pre.pa_request_id = p_pa_request_id
3177: and pre.remark_id in
3178: (select remark_id
3179: from ghr_noac_remarks
3180: where nature_of_action_id = ghr_par_shd.g_old_rec.second_noa_id);
3181: --Begin Bug# 7174094
3182: l_separation_flag := FALSE;
3183: IF p_first_noa_code in ('002') THEN
3184: For l_sec_noa_fmly in c_sec_noa_fmly loop

Line 3234: l_rec.first_noa_id := ghr_par_shd.g_old_rec.first_noa_id;

3230: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
3231: then
3232:
3233: If p_first_noa_id = hr_api.g_number then
3234: l_rec.first_noa_id := ghr_par_shd.g_old_rec.first_noa_id;
3235: Else
3236: l_rec.first_noa_id := p_first_noa_id;
3237: End if;
3238:

Line 3240: l_rec.second_noa_id := ghr_par_shd.g_old_rec.second_noa_id;

3236: l_rec.first_noa_id := p_first_noa_id;
3237: End if;
3238:
3239: If p_second_noa_id = hr_api.g_number then
3240: l_rec.second_noa_id := ghr_par_shd.g_old_rec.second_noa_id;
3241: Else
3242: l_rec.second_noa_id := p_second_noa_id;
3243: End if;
3244:

Line 3246: l_rec.effective_date := ghr_par_shd.g_old_rec.effective_date;

3242: l_rec.second_noa_id := p_second_noa_id;
3243: End if;
3244:
3245: If p_effective_date = hr_api.g_date then
3246: l_rec.effective_date := ghr_par_shd.g_old_rec.effective_date;
3247: Else
3248: l_rec.effective_date := p_effective_date;
3249: End if;
3250:

Line 3252: l_rec.person_id := ghr_par_shd.g_old_rec.person_id;

3248: l_rec.effective_date := p_effective_date;
3249: End if;
3250:
3251: If p_person_id = hr_api.g_number then
3252: l_rec.person_id := ghr_par_shd.g_old_rec.person_id;
3253: Else
3254: l_rec.person_id := p_person_id;
3255: End if;
3256:

Line 3258: l_rec.employee_assignment_id := ghr_par_shd.g_old_rec.employee_assignment_id;

3254: l_rec.person_id := p_person_id;
3255: End if;
3256:
3257: If p_employee_assignment_id = hr_api.g_number then
3258: l_rec.employee_assignment_id := ghr_par_shd.g_old_rec.employee_assignment_id;
3259: Else
3260: l_rec.employee_assignment_id := p_employee_assignment_id;
3261: End if;
3262:

Line 3264: l_rec.to_position_id := ghr_par_shd.g_old_rec.to_position_id;

3260: l_rec.employee_assignment_id := p_employee_assignment_id;
3261: End if;
3262:
3263: If p_to_position_id = hr_api.g_number then
3264: l_rec.to_position_id := ghr_par_shd.g_old_rec.to_position_id;
3265: Else
3266: l_rec.to_position_id := p_to_position_id;
3267: End if;
3268:

Line 3273: l_rpa_type := ghr_par_shd.g_old_rec.rpa_type;

3269: if p_u_action_taken = 'NOT_ROUTED' then
3270: l_rpa_type := p_rpa_type;
3271: l_mass_action_id := p_mass_action_id;
3272: If nvl(l_rpa_type,'##') = hr_api.g_varchar2 then
3273: l_rpa_type := ghr_par_shd.g_old_rec.rpa_type;
3274: End if;
3275: If nvl(l_mass_action_id,-9999) = hr_api.g_number then
3276: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;
3277: End if;

Line 3276: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;

3272: If nvl(l_rpa_type,'##') = hr_api.g_varchar2 then
3273: l_rpa_type := ghr_par_shd.g_old_rec.rpa_type;
3274: End if;
3275: If nvl(l_mass_action_id,-9999) = hr_api.g_number then
3276: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;
3277: End if;
3278: End if;
3279:
3280: If (nvl(p_effective_date,hr_api.g_date)

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

3277: End if;
3278: End if;
3279:
3280: If (nvl(p_effective_date,hr_api.g_date)
3281: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3282: (nvl(p_person_id,hr_api.g_number)
3283: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3284: or (p_noa_family_code = 'APP') or
3285: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then

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

3279:
3280: If (nvl(p_effective_date,hr_api.g_date)
3281: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3282: (nvl(p_person_id,hr_api.g_number)
3283: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3284: or (p_noa_family_code = 'APP') or
3285: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then
3286:
3287: GHR_NON_SF52_EXTRA_INFO.fetch_generic_extra_info

Line 3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or

3294: End if;
3295:
3296:
3297: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or

Line 3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or

3296:
3297: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or

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

3298: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3299: (nvl(p_second_noa_code,hr_api.g_varchar2)
3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)
3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))

Line 3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or

3300: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3301: (nvl(p_effective_date,hr_api.g_date)
3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)
3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3307: then
3308: hr_utility.set_location('update/ delete extra info',1);

Line 3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))

3302: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3303: (nvl(p_person_id,hr_api.g_number)
3304: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3305: (nvl(p_to_position_id,hr_api.g_number)
3306: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3307: then
3308: hr_utility.set_location('update/ delete extra info',1);
3309:
3310:

Line 3348: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then

3344: l_action_taken := p_u_action_taken;
3345: hr_utility.set_location(l_proc, 11);
3346: if l_action_taken is null then
3347: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3348: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3349: l_action_taken := 'AUTHORIZED';
3350: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3351: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3352: l_action_taken := 'REQUESTED';

Line 3351: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then

3347: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3348: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3349: l_action_taken := 'AUTHORIZED';
3350: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3351: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3352: l_action_taken := 'REQUESTED';
3353: else
3354: for history_exists in C_history_exists loop
3355: l_exists := true;

Line 3605: l_rec.proposed_effective_asap_flag := ghr_par_shd.g_old_rec.proposed_effective_asap_flag;

3601: l_rec.pa_request_id := p_pa_request_id;
3602: l_rec.noa_family_code := p_noa_family_code;
3603: l_rec.routing_group_id := p_routing_group_id;
3604: If p_proposed_effective_asap_flag = hr_api.g_varchar2 then
3605: l_rec.proposed_effective_asap_flag := ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
3606: Else
3607: l_rec.proposed_effective_asap_flag := p_proposed_effective_asap_flag;
3608: End if;
3609: l_rec.academic_discipline := p_academic_discipline;

Line 3628: l_rec.custom_pay_calc_flag := ghr_par_shd.g_old_rec.custom_pay_calc_flag;

3624: l_rec.bargaining_unit_status := p_bargaining_unit_status;
3625: l_rec.citizenship := p_citizenship;
3626: l_rec.concurrence_date := p_concurrence_date;
3627: If p_custom_pay_calc_flag = hr_api.g_varchar2 then
3628: l_rec.custom_pay_calc_flag := ghr_par_shd.g_old_rec.custom_pay_calc_flag;
3629: Else
3630: l_rec.custom_pay_calc_flag := p_custom_pay_calc_flag;
3631: End if;
3632: l_rec.duty_station_code := p_duty_station_code;

Line 3654: l_rec.first_noa_code := ghr_par_shd.g_old_rec.first_noa_code;

3650: l_rec.first_action_la_desc1 := p_first_action_la_desc1;
3651: l_rec.first_action_la_desc2 := p_first_action_la_desc2;
3652: l_rec.first_noa_cancel_or_correct := p_first_noa_cancel_or_correct;
3653: If p_first_noa_code = hr_api.g_varchar2 then
3654: l_rec.first_noa_code := ghr_par_shd.g_old_rec.first_noa_code;
3655: Else
3656: l_rec.first_noa_code := p_first_noa_code;
3657: End if;
3658: l_rec.first_noa_desc := p_first_noa_desc;

Line 3679: l_rec.from_pay_plan := ghr_par_shd.g_old_rec.from_pay_plan;

3675: l_rec.from_other_pay_amount := p_from_other_pay_amount;
3676: l_rec.from_pay_basis := p_from_pay_basis;
3677:
3678: If p_from_pay_plan = hr_api.g_varchar2 then
3679: l_rec.from_pay_plan := ghr_par_shd.g_old_rec.from_pay_plan;
3680: Else
3681: l_rec.from_pay_plan := p_from_pay_plan;
3682: End if;
3683: -- FWFA Changes Bug#4444609

Line 3702: l_rec.part_time_hours := ghr_par_shd.g_old_rec.part_time_hours;

3698: l_rec.from_total_salary := p_from_total_salary;
3699: l_rec.functional_class := p_functional_class;
3700: l_rec.notepad := p_notepad;
3701: If p_part_time_hours = hr_api.g_number then
3702: l_rec.part_time_hours := ghr_par_shd.g_old_rec.part_time_hours;
3703: Else
3704: l_rec.part_time_hours := p_part_time_hours;
3705: End if;
3706: l_rec.pay_rate_determinant := p_pay_rate_determinant;

Line 3715: l_rec.requesting_office_remarks_flag := ghr_par_shd.g_old_rec.requesting_office_remarks_flag;

3711: l_rec.requested_by_title := p_requested_by_title;
3712: l_rec.requested_date := p_requested_date;
3713: l_rec.requesting_office_remarks_desc := p_requesting_office_remarks_de;
3714: If p_requesting_office_remarks_fl = hr_api.g_varchar2 then
3715: l_rec.requesting_office_remarks_flag := ghr_par_shd.g_old_rec.requesting_office_remarks_flag;
3716: Else
3717: l_rec.requesting_office_remarks_flag := p_requesting_office_remarks_fl;
3718: End if;
3719:

Line 3755: l_rec.to_pay_plan := ghr_par_shd.g_old_rec.to_pay_plan;

3751: l_rec.to_supervisory_differential := p_to_supervisory_differential;
3752: l_rec.to_staffing_differential := p_to_staffing_differential;
3753: l_rec.to_pay_basis := p_to_pay_basis;
3754: If p_to_pay_plan = hr_api.g_varchar2 then
3755: l_rec.to_pay_plan := ghr_par_shd.g_old_rec.to_pay_plan;
3756: Else
3757: l_rec.to_pay_plan := p_to_pay_plan;
3758: End if;
3759: -- FWFA Changes Bug# 4444609

Line 3780: l_rec.year_degree_attained := ghr_par_shd.g_old_rec.year_degree_attained;

3776: l_rec.veterans_status := p_veterans_status;
3777: l_rec.work_schedule := p_work_schedule;
3778: l_rec.work_schedule_desc := p_work_schedule_desc;
3779: If p_year_degree_attained = hr_api.g_number then
3780: l_rec.year_degree_attained := ghr_par_shd.g_old_rec.year_degree_attained;
3781: Else
3782: l_rec.year_degree_attained := p_year_degree_attained;
3783: End if;
3784:

Line 3838: l_rec.to_retention_allow_percentage := ghr_par_shd.g_old_rec.to_retention_allow_percentage;

3834: l_rec.attribute19 := p_attribute19;
3835: l_rec.attribute20 := p_attribute20;
3836: l_rec.object_version_number := l_par_object_version_number;
3837: If p_to_retention_allow_percentag = hr_api.g_number then
3838: l_rec.to_retention_allow_percentage := ghr_par_shd.g_old_rec.to_retention_allow_percentage;
3839: Else
3840: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
3841: End if;
3842: If p_to_supervisory_diff_percenta = hr_api.g_number then

Line 3843: l_rec.to_supervisory_diff_percentage := ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;

3839: Else
3840: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
3841: End if;
3842: If p_to_supervisory_diff_percenta = hr_api.g_number then
3843: l_rec.to_supervisory_diff_percentage := ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
3844: Else
3845: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
3846: End if;
3847: If p_to_staffing_diff_percentage = hr_api.g_number then

Line 3848: l_rec.to_staffing_diff_percentage := ghr_par_shd.g_old_rec.to_staffing_diff_percentage;

3844: Else
3845: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
3846: End if;
3847: If p_to_staffing_diff_percentage = hr_api.g_number then
3848: l_rec.to_staffing_diff_percentage := ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
3849: Else
3850: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
3851: End if;
3852: If p_award_percentage = hr_api.g_number then

Line 3853: l_rec.award_percentage := ghr_par_shd.g_old_rec.award_percentage;

3849: Else
3850: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
3851: End if;
3852: If p_award_percentage = hr_api.g_number then
3853: l_rec.award_percentage := ghr_par_shd.g_old_rec.award_percentage;
3854: Else
3855: l_rec.award_percentage := p_award_percentage;
3856: End if;
3857: l_rec.rpa_type := p_rpa_type;

Line 3861: l_rec.mass_action_eligible_flag := ghr_par_shd.g_old_rec.mass_action_eligible_flag;

3857: l_rec.rpa_type := p_rpa_type;
3858: l_rec.mass_action_id := p_mass_action_id;
3859:
3860: If p_mass_action_eligible_flag = hr_api.g_varchar2 then
3861: l_rec.mass_action_eligible_flag := ghr_par_shd.g_old_rec.mass_action_eligible_flag;
3862: Else
3863: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3864: End if;
3865: If p_mass_action_select_flag = hr_api.g_varchar2 then

Line 3866: l_rec.mass_action_select_flag := ghr_par_shd.g_old_rec.mass_action_select_flag;

3862: Else
3863: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3864: End if;
3865: If p_mass_action_select_flag = hr_api.g_varchar2 then
3866: l_rec.mass_action_select_flag := ghr_par_shd.g_old_rec.mass_action_select_flag;
3867: Else
3868: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3869: End if;
3870:

Line 4916: or (nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date

4912: p_status := 'FUTURE_ACTION';
4913: End if;
4914: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date
4915: --8279908 added comparison for pa request id
4916: or (nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date
4917: and ghr_par_shd.g_old_rec.pa_request_id = p_pa_request_id) then
4918: p_status := 'APPROVED';
4919: Elsif p_authorized_by_person_id is not null then
4920: p_status := 'AUTHORIZED';

Line 4917: and ghr_par_shd.g_old_rec.pa_request_id = p_pa_request_id) then

4913: End if;
4914: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date
4915: --8279908 added comparison for pa request id
4916: or (nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date
4917: and ghr_par_shd.g_old_rec.pa_request_id = p_pa_request_id) then
4918: p_status := 'APPROVED';
4919: Elsif p_authorized_by_person_id is not null then
4920: p_status := 'AUTHORIZED';
4921: Elsif p_requested_by_person_id is not null then