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.

[Home] [Help]

APPS.GHR_SF52_API dependencies on GHR_PAR_SHD

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

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

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

1085: hr_utility.set_location('passed action taken ' ||p_1_action_taken,1);
1086: l_action_taken := p_1_action_taken;
1087: if l_action_taken is null then
1088: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1089: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1090: l_action_taken := 'AUTHORIZED';
1091: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1092: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1093: l_action_taken := 'REQUESTED';

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

1088: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
1089: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
1090: l_action_taken := 'AUTHORIZED';
1091: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
1092: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
1093: l_action_taken := 'REQUESTED';
1094: else
1095: hr_utility.set_location('Bef c_history_exists ' ||l_pa_request_id,2);
1096: for history_exists in C_history_exists loop

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

2188: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
2189: l_old_action_taken ghr_pa_routing_history.action_taken%TYPE;
2190: l_forward_to_name ghr_pa_routing_history.user_name%type;
2191: l_rec ghr_pa_requests%rowtype;
2192: -- l_rec ghr_par_shd.g_old_rec%type;
2193: l_rei_rec ghr_pa_request_extra_info%rowtype;
2194: l_part_time_hours ghr_pa_requests.part_time_hours%type;
2195: l_requesting_office_remarks_fl ghr_pa_requests.requesting_office_remarks_flag%type;
2196: l_proposed_effective_asap_flag ghr_pa_requests.proposed_effective_asap_flag%type;

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

2983: -- b) first nature_of_action has changed (delete and then insert new records)
2984: --
2985:
2986: if nvl(p_first_noa_id,hr_api.g_number)
2987: <> nvl(ghr_par_shd.g_old_rec.first_noa_id,hr_api.g_number) then
2988: hr_utility.set_location(l_proc, 9);
2989:
2990: -- delete the existing remarks
2991: delete from ghr_pa_remarks pre

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

2992: where pre.pa_request_id = p_pa_request_id
2993: and pre.remark_id in
2994: (select remark_id
2995: from ghr_noac_remarks
2996: where nature_of_action_id = ghr_par_shd.g_old_rec.first_noa_id);
2997: if p_first_noa_id is not null then
2998: hr_utility.set_location(l_proc, 10);
2999:
3000: insert into ghr_pa_remarks

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

3024: end if;
3025: end if;
3026:
3027: if nvl(p_second_noa_id,hr_api.g_number)
3028: <> nvl(ghr_par_shd.g_old_rec.second_noa_id,hr_api.g_number) then
3029:
3030: -- delete the existing remarks
3031: delete from ghr_pa_remarks pre
3032: where pre.pa_request_id = p_pa_request_id

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

3032: where pre.pa_request_id = p_pa_request_id
3033: and pre.remark_id in
3034: (select remark_id
3035: from ghr_noac_remarks
3036: where nature_of_action_id = ghr_par_shd.g_old_rec.second_noa_id);
3037: if p_second_noa_id is not null then
3038: insert into ghr_pa_remarks
3039: (pa_remark_id
3040: ,pa_request_id

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

3066: If nvl(p_first_noa_code,hr_api.g_varchar2) <> '001'
3067: then
3068:
3069: If p_first_noa_id = hr_api.g_number then
3070: l_rec.first_noa_id := ghr_par_shd.g_old_rec.first_noa_id;
3071: Else
3072: l_rec.first_noa_id := p_first_noa_id;
3073: End if;
3074:

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

3072: l_rec.first_noa_id := p_first_noa_id;
3073: End if;
3074:
3075: If p_second_noa_id = hr_api.g_number then
3076: l_rec.second_noa_id := ghr_par_shd.g_old_rec.second_noa_id;
3077: Else
3078: l_rec.second_noa_id := p_second_noa_id;
3079: End if;
3080:

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

3078: l_rec.second_noa_id := p_second_noa_id;
3079: End if;
3080:
3081: If p_effective_date = hr_api.g_date then
3082: l_rec.effective_date := ghr_par_shd.g_old_rec.effective_date;
3083: Else
3084: l_rec.effective_date := p_effective_date;
3085: End if;
3086:

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

3084: l_rec.effective_date := p_effective_date;
3085: End if;
3086:
3087: If p_person_id = hr_api.g_number then
3088: l_rec.person_id := ghr_par_shd.g_old_rec.person_id;
3089: Else
3090: l_rec.person_id := p_person_id;
3091: End if;
3092:

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

3090: l_rec.person_id := p_person_id;
3091: End if;
3092:
3093: If p_employee_assignment_id = hr_api.g_number then
3094: l_rec.employee_assignment_id := ghr_par_shd.g_old_rec.employee_assignment_id;
3095: Else
3096: l_rec.employee_assignment_id := p_employee_assignment_id;
3097: End if;
3098:

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

3096: l_rec.employee_assignment_id := p_employee_assignment_id;
3097: End if;
3098:
3099: If p_to_position_id = hr_api.g_number then
3100: l_rec.to_position_id := ghr_par_shd.g_old_rec.to_position_id;
3101: Else
3102: l_rec.to_position_id := p_to_position_id;
3103: End if;
3104:

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

3105: if p_u_action_taken = 'NOT_ROUTED' then
3106: l_rpa_type := p_rpa_type;
3107: l_mass_action_id := p_mass_action_id;
3108: If nvl(l_rpa_type,'##') = hr_api.g_varchar2 then
3109: l_rpa_type := ghr_par_shd.g_old_rec.rpa_type;
3110: End if;
3111: If nvl(l_mass_action_id,-9999) = hr_api.g_number then
3112: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;
3113: End if;

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

3108: If nvl(l_rpa_type,'##') = hr_api.g_varchar2 then
3109: l_rpa_type := ghr_par_shd.g_old_rec.rpa_type;
3110: End if;
3111: If nvl(l_mass_action_id,-9999) = hr_api.g_number then
3112: l_mass_action_id := ghr_par_shd.g_old_rec.mass_action_id;
3113: End if;
3114: End if;
3115:
3116: If (nvl(p_effective_date,hr_api.g_date)

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

3113: End if;
3114: End if;
3115:
3116: If (nvl(p_effective_date,hr_api.g_date)
3117: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3118: (nvl(p_person_id,hr_api.g_number)
3119: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3120: or (p_noa_family_code = 'APP') or
3121: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then

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

3115:
3116: If (nvl(p_effective_date,hr_api.g_date)
3117: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3118: (nvl(p_person_id,hr_api.g_number)
3119: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api.g_number))
3120: or (p_noa_family_code = 'APP') or
3121: (l_action_taken = 'NOT_ROUTED' and l_mass_action_id is null and nvl(l_rpa_type,hr_api.g_varchar2) <> 'TA' ) then
3122:
3123: GHR_NON_SF52_EXTRA_INFO.fetch_generic_extra_info

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

3130: End if;
3131:
3132:
3133: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3134: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or

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

3132:
3133: if (nvl(p_first_noa_code,hr_api.g_varchar2)
3134: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or

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

3134: <> nvl(ghr_par_shd.g_old_rec.first_noa_code,hr_api.g_varchar2)) or
3135: (nvl(p_second_noa_code,hr_api.g_varchar2)
3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)
3142: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))

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

3136: <> nvl(ghr_par_shd.g_old_rec.second_noa_code,hr_api.g_varchar2)) or
3137: (nvl(p_effective_date,hr_api.g_date)
3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)
3142: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3143: then
3144: hr_utility.set_location('update/ delete extra info',1);

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

3138: <> nvl(ghr_par_shd.g_old_rec.effective_date,hr_api.g_date)) or
3139: (nvl(p_person_id,hr_api.g_number)
3140: <> nvl(ghr_par_shd.g_old_rec.person_id,hr_api .g_number)) or
3141: (nvl(p_to_position_id,hr_api.g_number)
3142: <> nvl(ghr_par_shd.g_old_rec.to_position_id,hr_api .g_number))
3143: then
3144: hr_utility.set_location('update/ delete extra info',1);
3145:
3146:

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

3167: l_action_taken := p_u_action_taken;
3168: hr_utility.set_location(l_proc, 11);
3169: if l_action_taken is null then
3170: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3171: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3172: l_action_taken := 'AUTHORIZED';
3173: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3174: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3175: l_action_taken := 'REQUESTED';

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

3170: if nvl(p_authorized_by_person_id,hr_api.g_number) <>
3171: nvl(ghr_par_shd.g_old_rec.authorized_by_person_id,hr_api.g_number) then
3172: l_action_taken := 'AUTHORIZED';
3173: elsif nvl(p_requested_by_person_id,hr_api.g_number) <>
3174: nvl(ghr_par_shd.g_old_rec.requested_by_person_id,hr_api.g_number) then
3175: l_action_taken := 'REQUESTED';
3176: else
3177: for history_exists in C_history_exists loop
3178: l_exists := true;

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

3422: l_rec.pa_request_id := p_pa_request_id;
3423: l_rec.noa_family_code := p_noa_family_code;
3424: l_rec.routing_group_id := p_routing_group_id;
3425: If p_proposed_effective_asap_flag = hr_api.g_varchar2 then
3426: l_rec.proposed_effective_asap_flag := ghr_par_shd.g_old_rec.proposed_effective_asap_flag;
3427: Else
3428: l_rec.proposed_effective_asap_flag := p_proposed_effective_asap_flag;
3429: End if;
3430: l_rec.academic_discipline := p_academic_discipline;

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

3445: l_rec.bargaining_unit_status := p_bargaining_unit_status;
3446: l_rec.citizenship := p_citizenship;
3447: l_rec.concurrence_date := p_concurrence_date;
3448: If p_custom_pay_calc_flag = hr_api.g_varchar2 then
3449: l_rec.custom_pay_calc_flag := ghr_par_shd.g_old_rec.custom_pay_calc_flag;
3450: Else
3451: l_rec.custom_pay_calc_flag := p_custom_pay_calc_flag;
3452: End if;
3453: l_rec.duty_station_code := p_duty_station_code;

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

3471: l_rec.first_action_la_desc1 := p_first_action_la_desc1;
3472: l_rec.first_action_la_desc2 := p_first_action_la_desc2;
3473: l_rec.first_noa_cancel_or_correct := p_first_noa_cancel_or_correct;
3474: If p_first_noa_code = hr_api.g_varchar2 then
3475: l_rec.first_noa_code := ghr_par_shd.g_old_rec.first_noa_code;
3476: Else
3477: l_rec.first_noa_code := p_first_noa_code;
3478: End if;
3479: l_rec.first_noa_desc := p_first_noa_desc;

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

3496: l_rec.from_other_pay_amount := p_from_other_pay_amount;
3497: l_rec.from_pay_basis := p_from_pay_basis;
3498:
3499: If p_from_pay_plan = hr_api.g_varchar2 then
3500: l_rec.from_pay_plan := ghr_par_shd.g_old_rec.from_pay_plan;
3501: Else
3502: l_rec.from_pay_plan := p_from_pay_plan;
3503: End if;
3504: -- FWFA Changes Bug#4444609

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

3519: l_rec.from_total_salary := p_from_total_salary;
3520: l_rec.functional_class := p_functional_class;
3521: l_rec.notepad := p_notepad;
3522: If p_part_time_hours = hr_api.g_number then
3523: l_rec.part_time_hours := ghr_par_shd.g_old_rec.part_time_hours;
3524: Else
3525: l_rec.part_time_hours := p_part_time_hours;
3526: End if;
3527: l_rec.pay_rate_determinant := p_pay_rate_determinant;

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

3532: l_rec.requested_by_title := p_requested_by_title;
3533: l_rec.requested_date := p_requested_date;
3534: l_rec.requesting_office_remarks_desc := p_requesting_office_remarks_de;
3535: If p_requesting_office_remarks_fl = hr_api.g_varchar2 then
3536: l_rec.requesting_office_remarks_flag := ghr_par_shd.g_old_rec.requesting_office_remarks_flag;
3537: Else
3538: l_rec.requesting_office_remarks_flag := p_requesting_office_remarks_fl;
3539: End if;
3540:

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

3572: l_rec.to_supervisory_differential := p_to_supervisory_differential;
3573: l_rec.to_staffing_differential := p_to_staffing_differential;
3574: l_rec.to_pay_basis := p_to_pay_basis;
3575: If p_to_pay_plan = hr_api.g_varchar2 then
3576: l_rec.to_pay_plan := ghr_par_shd.g_old_rec.to_pay_plan;
3577: Else
3578: l_rec.to_pay_plan := p_to_pay_plan;
3579: End if;
3580: -- FWFA Changes Bug# 4444609

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

3597: l_rec.veterans_status := p_veterans_status;
3598: l_rec.work_schedule := p_work_schedule;
3599: l_rec.work_schedule_desc := p_work_schedule_desc;
3600: If p_year_degree_attained = hr_api.g_number then
3601: l_rec.year_degree_attained := ghr_par_shd.g_old_rec.year_degree_attained;
3602: Else
3603: l_rec.year_degree_attained := p_year_degree_attained;
3604: End if;
3605:

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

3655: l_rec.attribute19 := p_attribute19;
3656: l_rec.attribute20 := p_attribute20;
3657: l_rec.object_version_number := l_par_object_version_number;
3658: If p_to_retention_allow_percentag = hr_api.g_number then
3659: l_rec.to_retention_allow_percentage := ghr_par_shd.g_old_rec.to_retention_allow_percentage;
3660: Else
3661: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
3662: End if;
3663: If p_to_supervisory_diff_percenta = hr_api.g_number then

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

3660: Else
3661: l_rec.to_retention_allow_percentage := p_to_retention_allow_percentag;
3662: End if;
3663: If p_to_supervisory_diff_percenta = hr_api.g_number then
3664: l_rec.to_supervisory_diff_percentage := ghr_par_shd.g_old_rec.to_supervisory_diff_percentage;
3665: Else
3666: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
3667: End if;
3668: If p_to_staffing_diff_percentage = hr_api.g_number then

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

3665: Else
3666: l_rec.to_supervisory_diff_percentage := p_to_supervisory_diff_percenta;
3667: End if;
3668: If p_to_staffing_diff_percentage = hr_api.g_number then
3669: l_rec.to_staffing_diff_percentage := ghr_par_shd.g_old_rec.to_staffing_diff_percentage;
3670: Else
3671: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
3672: End if;
3673: If p_award_percentage = hr_api.g_number then

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

3670: Else
3671: l_rec.to_staffing_diff_percentage := p_to_staffing_diff_percentage;
3672: End if;
3673: If p_award_percentage = hr_api.g_number then
3674: l_rec.award_percentage := ghr_par_shd.g_old_rec.award_percentage;
3675: Else
3676: l_rec.award_percentage := p_award_percentage;
3677: End if;
3678: l_rec.rpa_type := p_rpa_type;

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

3678: l_rec.rpa_type := p_rpa_type;
3679: l_rec.mass_action_id := p_mass_action_id;
3680:
3681: If p_mass_action_eligible_flag = hr_api.g_varchar2 then
3682: l_rec.mass_action_eligible_flag := ghr_par_shd.g_old_rec.mass_action_eligible_flag;
3683: Else
3684: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3685: End if;
3686: If p_mass_action_select_flag = hr_api.g_varchar2 then

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

3683: Else
3684: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3685: End if;
3686: If p_mass_action_select_flag = hr_api.g_varchar2 then
3687: l_rec.mass_action_select_flag := ghr_par_shd.g_old_rec.mass_action_select_flag;
3688: Else
3689: l_rec.mass_action_eligible_flag := p_mass_action_eligible_flag;
3690: End if;
3691:

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

4666: If nvl(p_action_taken,hr_api.g_varchar2) = 'UPDATE_HR' and trunc(nvl(p_effective_date,hr_api.g_date)) > sysdate then
4667: p_status := 'FUTURE_ACTION';
4668: End if;
4669: Elsif nvl(p_approval_date,hr_api.g_date) <> hr_api.g_date
4670: or nvl(ghr_par_shd.g_old_rec.approval_date,hr_api.g_date) <> hr_api.g_date then
4671: p_status := 'APPROVED';
4672: Elsif p_authorized_by_person_id is not null then
4673: p_status := 'AUTHORIZED';
4674: Elsif p_requested_by_person_id is not null then