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_DO_UPDATE dependencies on FND_DATE

Line 721: IF fnd_date.canonical_to_date(rg_rec.pei_information1) >

717: hr_utility.set_location('702 RG Processing '||l_proc,10);
718: FOR rg_rec in c_702_rec LOOP
719: hr_utility.set_location('Effective Date '||p_pa_request_rec.effective_date,1);
720: hr_utility.set_location('702 RG Processing '||rg_rec.rei_information3,11);
721: IF fnd_date.canonical_to_date(rg_rec.pei_information1) >
722: (p_pa_request_rec.effective_date - 1) THEN
723: hr_utility.set_message(8301,'GHR_38692_RG_TO_DATE_LESSER');
724: hr_utility.raise_error;
725: END IF;

Line 731: ,p_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)

727: (p_pa_request_rec => P_PA_REQUEST_REC
728: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'
729: ,p_extra_info_id => rg_rec.rei_information3
730: ,p_l_object_version_number => rg_rec.ovn
731: ,p_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
732: );
733: END LOOP;
734: ELSIF p_pa_request_rec.first_noa_code = '740' THEN
735: --740 Processing

Line 740: IF fnd_date.canonical_to_date(rg_rec.pei_information1) >

736: hr_utility.set_location('740 RG Processing '||l_proc,15);
737: FOR rg_rec in c_740_rec LOOP
738: hr_utility.set_location('Effective Date '||p_pa_request_rec.effective_date,1);
739: hr_utility.set_location('740 RG Processing '||rg_rec.rei_information3,12);
740: IF fnd_date.canonical_to_date(rg_rec.pei_information1) >
741: (p_pa_request_rec.effective_date - 1) THEN
742: hr_utility.set_message(8301,'GHR_38692_RG_TO_DATE_LESSER');
743: hr_utility.raise_error;
744: END IF;

Line 750: ,p_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)

746: (p_pa_request_rec => P_PA_REQUEST_REC
747: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'
748: ,p_extra_info_id => rg_rec.rei_information3
749: ,p_l_object_version_number => rg_rec.ovn
750: ,p_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
751: );
752: END LOOP;
753: -------Bug 5913362 -- Adding 890
754: ELSIF p_pa_request_rec.first_noa_code IN ('866', '890') THEN

Line 770: ,p_information2 => fnd_date.date_to_canonical(l_effective_date)

766: (p_pa_request_rec => P_PA_REQUEST_REC
767: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'
768: ,p_extra_info_id => p_per_retained_grade.person_extra_info_id
769: ,p_l_object_version_number => p_per_retained_grade.object_version_number
770: ,p_information2 => fnd_date.date_to_canonical(l_effective_date)
771: );
772: FOR cur_temp_step_rec IN cur_temp_step LOOP
773: l_new_temp_step := cur_temp_step_rec.temp_step;
774: END LOOP;

Line 802: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date )

798: -- End date the existing RG record
799: hr_person_extra_info_api.update_person_extra_info
800: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
801: p_object_version_number => l_ret_object_version_number,
802: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date )
803: );
804: hr_utility.set_location('Inside 866 processing ',3);
805: -- Create the new RG Record with Temporary Promotion Step Value
806: hr_person_extra_info_api.create_person_extra_info

Line 813: fnd_date.date_to_canonical(p_pa_request_rec.effective_date + 1),

809: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
810: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
811: p_object_version_number => l_ret_object_version_number,
812: p_pei_information1 =>
813: fnd_date.date_to_canonical(p_pa_request_rec.effective_date + 1),
814: p_pei_information2 => l_new_date_to,
815: p_pei_information3 => l_new_grade_or_level,
816: p_pei_information4 => l_new_step_or_rate,
817: p_pei_information5 => l_new_pay_plan,

Line 950: IF TRUNC(fnd_date.canonical_to_date(l_cur_date_from)) = TRUNC(p_pa_request_rec.effective_date) THEN

946: -- update the same record. Otherwise, end date current record and create new record.
947: -- Bug#4719037 RG record created unnecessarily where g_pay_table_upd_flag is FALSE.
948: -- So, added the per_retained_grade_flag condition to avoid it.
949: IF p_per_retained_grade.per_retained_grade_flag = 'Y' THEN
950: IF TRUNC(fnd_date.canonical_to_date(l_cur_date_from)) = TRUNC(p_pa_request_rec.effective_date) THEN
951: hr_utility.set_location('RG Start date Equal to RPA Effective Date ',22);
952: Generic_Update_Extra_Info
953: (p_pa_request_rec => P_PA_REQUEST_REC
954: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'

Line 974: ,p_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)

970: (p_pa_request_rec => P_PA_REQUEST_REC
971: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'
972: ,p_extra_info_id => l_retained_grade_rec.person_extra_info_id
973: ,p_l_object_version_number => l_ret_object_version_number
974: ,p_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
975: );
976:
977: -- Create the new RG Record with Temporary Promotion Step Value
978: hr_person_extra_info_api.create_person_extra_info

Line 985: fnd_date.date_to_canonical(p_pa_request_rec.effective_date),

981: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
982: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
983: p_object_version_number => l_ovn,
984: p_pei_information1 =>
985: fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
986: p_pei_information2 => l_new_date_to,
987: p_pei_information3 => l_new_grade_or_level,
988: p_pei_information4 => l_new_step_or_rate,
989: p_pei_information5 => l_new_pay_plan,

Line 3797: ||to_char(fnd_date.canonical_to_date(l_mddds_special_pay_nte_date),'DD-MON-RRRR');

3793: p_remark_desc => l_remark_description
3794: );
3795:
3796: l_remark_description := replace(l_remark_description,'_')
3797: ||to_char(fnd_date.canonical_to_date(l_mddds_special_pay_nte_date),'DD-MON-RRRR');
3798:
3799: --while terminating the MDDDS_SPECIAL_PAY element it should delete the remarks also.
3800: IF ( l_mddds_total_special_pay <> 0 )
3801: and ( l_mddds_total_special_pay IS NOT NULL ) THEN

Line 6106: ,p_value3 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_retention_allow_review.review_date))

6102: --3306515 added l_retention_allow_percentage
6103: ,p_value2 => to_char(nvl(p_pa_request_rec.to_retention_allow_percentage,l_retention_allow_percentage))
6104:
6105: ,p_input_value_name3 => 'Date'
6106: ,p_value3 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_retention_allow_review.review_date))
6107: ,p_effective_date => l_effective_date
6108: ,p_process_warning => l_adj_basic_pay_warn
6109: );
6110: Else --if p_pa_request_rec.ret. allowance is null

Line 6147: ,p_value3 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_retention_allow_review.review_date))

6143: ,p_value1 => to_char(p_pa_request_rec.to_retention_allowance)
6144: ,p_input_value_name2 => 'Percentage'
6145: ,p_value2 => to_char(p_pa_request_rec.to_retention_allow_percentage)
6146: ,p_input_value_name3 => 'Date'
6147: ,p_value3 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_retention_allow_review.review_date))
6148: ,p_effective_date => l_effective_date
6149: ,p_process_warning => l_adj_basic_pay_warn
6150: );
6151: End if;

Line 6167: l_wgi_due_date := fnd_date.canonical_to_date(ctr_wgi_due.wgi_due);

6163: ---- Bug 3263140
6164: -- No need for this cursor as the values are properly passed.
6165: -- Instead of the cursor the below written statement is enough
6166: /*FOR ctr_wgi_due IN cur_wgi_due LOOP
6167: l_wgi_due_date := fnd_date.canonical_to_date(ctr_wgi_due.wgi_due);
6168: END LOOP; */
6169:
6170: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
6171:

Line 6170: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);

6166: /*FOR ctr_wgi_due IN cur_wgi_due LOOP
6167: l_wgi_due_date := fnd_date.canonical_to_date(ctr_wgi_due.wgi_due);
6168: END LOOP; */
6169:
6170: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
6171:
6172: hr_utility.set_location('WGI Due date ' || l_wgi_due_date,150);
6173: hr_utility.set_location('p_pa_request_rec.noa_family_code ' || p_pa_request_rec.noa_family_code,150);
6174: -- GPPA 46 Update. l_to_pay_plan is not getting initialized. So, added the

Line 6292: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);

6288: END IF;
6289: END IF; -- IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) = 'CONV_APP'
6290:
6291: -- proceed only if date_wgi_due is not null
6292: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
6293: IF l_wgi_due_date IS NOT NULL AND l_wgi_cleared = FALSE THEN
6294: ghr_sf52_do_update.get_wgi_dates
6295: (p_pa_request_rec => p_pa_request_rec,
6296: p_wgi_due_date => l_wgi_due_date,

Line 6318: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR

6314: ghr_element_api.process_sf52_element
6315: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6316: ,p_element_name => 'Within Grade Increase'
6317: ,p_input_value_name2 => 'Date Due'
6318: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6319: ,p_input_value_name3 => 'Pay Date'
6320: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6321: ,p_input_value_name4 => 'Last Equivalent Increase'
6322: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))

Line 6320: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR

6316: ,p_element_name => 'Within Grade Increase'
6317: ,p_input_value_name2 => 'Date Due'
6318: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6319: ,p_input_value_name3 => 'Pay Date'
6320: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6321: ,p_input_value_name4 => 'Last Equivalent Increase'
6322: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6323: ,p_input_value_name5 => 'Postponmt Effective'
6324: ,p_value5 =>

Line 6322: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))

6318: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6319: ,p_input_value_name3 => 'Pay Date'
6320: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6321: ,p_input_value_name4 => 'Last Equivalent Increase'
6322: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6323: ,p_input_value_name5 => 'Postponmt Effective'
6324: ,p_value5 =>
6325: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6326: ,p_effective_date => l_effective_date

Line 6325: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR

6321: ,p_input_value_name4 => 'Last Equivalent Increase'
6322: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6323: ,p_input_value_name5 => 'Postponmt Effective'
6324: ,p_value5 =>
6325: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6326: ,p_effective_date => l_effective_date
6327: ,p_process_warning => l_within_grade_increase_warn
6328: );
6329: -- If WGI Due date is not entered for Appointment and Conversion to Appointment, atleast create

Line 6344: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))

6340: ,p_value2 => NULL -- Bug 3998686
6341: ,p_input_value_name3 => 'Pay Date'
6342: ,p_value3 => NULL -- Bug 3998686
6343: ,p_input_value_name4 => 'Last Equivalent Increase'
6344: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6345: ,p_input_value_name5 => 'Postponmt Effective'
6346: ,p_value5 =>
6347: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6348: ,p_effective_date => l_effective_date

Line 6347: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR

6343: ,p_input_value_name4 => 'Last Equivalent Increase'
6344: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6345: ,p_input_value_name5 => 'Postponmt Effective'
6346: ,p_value5 =>
6347: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6348: ,p_effective_date => l_effective_date
6349: ,p_process_warning => l_within_grade_increase_warn
6350: );
6351: END IF; -- IF l_wgi_due_date IS NOT NULL THEN

Line 6387: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);

6383: l_call_wgi_dates = TRUE
6384: THEN
6385:
6386: IF p_pa_request_rec.first_noa_code in ( '702','703','713') THEN
6387: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
6388: hr_utility.set_location('702 -- l_wgi_due_date is ' || l_wgi_due_date,1);
6389: END IF;
6390:
6391: IF not (p_pa_request_rec.first_noa_code = '702' AND

Line 6401: p_dlei => fnd_date.canonical_to_date(p_wgi.p_last_equi_incr)

6397: (p_pa_request_rec => p_pa_request_rec,
6398: p_wgi_due_date => l_wgi_due_date,
6399: p_wgi_pay_date => l_wgi_pay_date,
6400: p_retained_grade_rec => l_retained_grade_rec,
6401: p_dlei => fnd_date.canonical_to_date(p_wgi.p_last_equi_incr)
6402: );
6403: -- Start of 3111719
6404: -- For QSI action get the current LEI date.
6405: -- Bug 3993664 - Included NOA 867...

Line 6436: p_wgi.p_last_equi_incr := fnd_date.date_to_canonical(p_pa_request_rec.effective_date); -- Bug 3991240

6432: END IF;
6433:
6434: -- Bug 3617295 DLEI should be updated with RPA effective date
6435: IF p_pa_request_rec.first_noa_code = '855' OR p_pa_request_rec.second_noa_code = '855' THEN
6436: p_wgi.p_last_equi_incr := fnd_date.date_to_canonical(p_pa_request_rec.effective_date); -- Bug 3991240
6437: END IF;
6438: -- End Bug 3617295
6439:
6440: hr_utility.set_location('l_wgi_due_date calculated is ' || l_wgi_due_date,1);

Line 6448: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR

6444: ghr_element_api.process_sf52_element
6445: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6446: ,p_element_name => 'Within Grade Increase'
6447: ,p_input_value_name2 => 'Date Due'
6448: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6449: ,p_input_value_name3 => 'Pay Date'
6450: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6451: ,p_input_value_name4 => 'Last Equivalent Increase'
6452: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))

Line 6450: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR

6446: ,p_element_name => 'Within Grade Increase'
6447: ,p_input_value_name2 => 'Date Due'
6448: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6449: ,p_input_value_name3 => 'Pay Date'
6450: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6451: ,p_input_value_name4 => 'Last Equivalent Increase'
6452: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6453: ,p_input_value_name5 => 'Postponmt Effective'
6454: ,p_value5 =>

Line 6452: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))

6448: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6449: ,p_input_value_name3 => 'Pay Date'
6450: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6451: ,p_input_value_name4 => 'Last Equivalent Increase'
6452: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6453: ,p_input_value_name5 => 'Postponmt Effective'
6454: ,p_value5 =>
6455: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6456: ,p_effective_date => l_effective_date

Line 6455: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR

6451: ,p_input_value_name4 => 'Last Equivalent Increase'
6452: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6453: ,p_input_value_name5 => 'Postponmt Effective'
6454: ,p_value5 =>
6455: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6456: ,p_effective_date => l_effective_date
6457: ,p_process_warning => l_within_grade_increase_warn
6458: );
6459: END IF; -- IF not (p_pa_request_rec.first_noa_code = '702'

Line 6475: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_due)) --AVR

6471: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6472: ,p_element_name => 'Within Grade Increase'
6473: ,p_input_value_name2 => 'Date Due'
6474: ,p_value2 =>
6475: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_due)) --AVR
6476: ,p_input_value_name3 => 'Pay Date'
6477: ,p_value3 =>
6478: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_wgi_pay_date)) --AVR
6479: ,p_input_value_name4 => 'Last Equivalent Increase'

Line 6478: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_wgi_pay_date)) --AVR

6474: ,p_value2 =>
6475: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_due)) --AVR
6476: ,p_input_value_name3 => 'Pay Date'
6477: ,p_value3 =>
6478: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_wgi_pay_date)) --AVR
6479: ,p_input_value_name4 => 'Last Equivalent Increase'
6480: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6481: ,p_input_value_name5 => 'Postponmt Effective'
6482: ,p_value5 =>

Line 6480: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))

6476: ,p_input_value_name3 => 'Pay Date'
6477: ,p_value3 =>
6478: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_wgi_pay_date)) --AVR
6479: ,p_input_value_name4 => 'Last Equivalent Increase'
6480: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6481: ,p_input_value_name5 => 'Postponmt Effective'
6482: ,p_value5 =>
6483: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) ---AVR
6484: ,p_effective_date => l_effective_date

Line 6483: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) ---AVR

6479: ,p_input_value_name4 => 'Last Equivalent Increase'
6480: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6481: ,p_input_value_name5 => 'Postponmt Effective'
6482: ,p_value5 =>
6483: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) ---AVR
6484: ,p_effective_date => l_effective_date
6485: ,p_process_warning => l_within_grade_increase_warn
6486: );
6487: end if;

Line 6542: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)

6538: AND ghr_process_sf52.g_prd IS NOT NULL then
6539: hr_person_extra_info_api.update_person_extra_info
6540: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6541: p_object_version_number => l_ret_object_version_number,
6542: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
6543: );
6544: end if;
6545: If p_pa_request_rec.first_noa_code in ('867','892','893') then
6546: --- Bug 6193571 end

Line 6550: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)

6546: --- Bug 6193571 end
6547: hr_person_extra_info_api.update_person_extra_info
6548: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6549: p_object_version_number => l_ret_object_version_number,
6550: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
6551: );
6552: end if;
6553: IF p_pa_request_rec.first_noa_code in ('867','892','893') THEN
6554: l_new_step_or_rate := l_retained_grade_rec.step_or_rate;

Line 6567: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),

6563: p_information_type => 'GHR_US_RETAINED_GRADE',
6564: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6565: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6566: p_object_version_number => l_ret_object_version_number,
6567: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6568: p_pei_information2 => l_new_date_to,
6569: p_pei_information3 => l_new_grade_or_level,
6570: p_pei_information4 => l_cur_step_or_rate,
6571: p_pei_information5 => l_new_pay_plan,

Line 6591: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),

6587: p_information_type => 'GHR_US_RETAINED_GRADE',
6588: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6589: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6590: p_object_version_number => l_ret_object_version_number,
6591: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6592: p_pei_information2 => l_new_date_to,
6593: p_pei_information3 => l_new_grade_or_level,
6594: p_pei_information4 => nvl(l_new_step_or_rate,l_cur_step_or_rate),
6595: p_pei_information5 => l_new_pay_plan,

Line 6609: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),

6605: p_information_type => 'GHR_US_RETAINED_GRADE',
6606: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6607: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6608: p_object_version_number => l_ret_object_version_number,
6609: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6610: p_pei_information2 => l_new_date_to,
6611: p_pei_information3 => l_new_grade_or_level,
6612: p_pei_information4 => nvl(l_new_step_or_rate,l_cur_step_or_rate),
6613: p_pei_information5 => l_new_pay_plan,

Line 6669: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)

6665: -- End date the existing RG record
6666: hr_person_extra_info_api.update_person_extra_info
6667: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6668: p_object_version_number => l_ret_object_version_number,
6669: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
6670: );
6671: hr_utility.set_location('Inside 703 processing ',3);
6672: -- Create the new RG Record with Temporary Promotion Step Value
6673: hr_person_extra_info_api.create_person_extra_info

Line 6679: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),

6675: p_information_type => 'GHR_US_RETAINED_GRADE',
6676: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6677: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6678: p_object_version_number => l_ret_object_version_number,
6679: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6680: p_pei_information2 => l_new_date_to,
6681: p_pei_information3 => l_new_grade_or_level,
6682: p_pei_information4 => l_new_step_or_rate,
6683: p_pei_information5 => l_new_pay_plan,

Line 6740: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)

6736: -- End date the existing RG record
6737: hr_person_extra_info_api.update_person_extra_info
6738: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6739: p_object_version_number => l_ret_object_version_number,
6740: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
6741: );
6742: hr_utility.set_location('Inside 740 processing ',3);
6743: -- Create the new RG Record with null Temporary Promotion Step Value
6744: hr_person_extra_info_api.create_person_extra_info

Line 6750: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),

6746: p_information_type => 'GHR_US_RETAINED_GRADE',
6747: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6748: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6749: p_object_version_number => l_ret_object_version_number,
6750: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6751: p_pei_information2 => l_new_date_to,
6752: p_pei_information3 => l_new_grade_or_level,
6753: p_pei_information4 => l_new_step_or_rate,
6754: p_pei_information5 => l_new_pay_plan,

Line 6892: l_remark_information1 := 'Retention Incentive Biweekly is terminated as of '||fnd_date.date_to_displaydate(p_payment_date);

6888:
6889: -- Bug#5039100
6890: IF p_percent = 0 THEN
6891: -- Change the remark from 'As on' to 'As of' : Bug:5170178
6892: l_remark_information1 := 'Retention Incentive Biweekly is terminated as of '||fnd_date.date_to_displaydate(p_payment_date);
6893: ELSE
6894: -- Added this IF condition to remove the end date if end date is '4712/12/31' : Bug#5170178
6895: IF l_end_date IS NULL THEN
6896: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '

Line 6897: ||fnd_date.date_to_displaydate(p_payment_date);

6893: ELSE
6894: -- Added this IF condition to remove the end date if end date is '4712/12/31' : Bug#5170178
6895: IF l_end_date IS NULL THEN
6896: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6897: ||fnd_date.date_to_displaydate(p_payment_date);
6898: ELSE
6899: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6900: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6901: ||fnd_date.date_to_displaydate(l_end_date);

Line 6900: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '

6896: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6897: ||fnd_date.date_to_displaydate(p_payment_date);
6898: ELSE
6899: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6900: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6901: ||fnd_date.date_to_displaydate(l_end_date);
6902: END IF;
6903: END IF;
6904: ELSE

Line 6901: ||fnd_date.date_to_displaydate(l_end_date);

6897: ||fnd_date.date_to_displaydate(p_payment_date);
6898: ELSE
6899: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6900: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6901: ||fnd_date.date_to_displaydate(l_end_date);
6902: END IF;
6903: END IF;
6904: ELSE
6905: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid '

Line 6906: ||fnd_date.date_to_displaydate(p_payment_date);

6902: END IF;
6903: END IF;
6904: ELSE
6905: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid '
6906: ||fnd_date.date_to_displaydate(p_payment_date);
6907: END IF;
6908: ELSE
6909: IF p_category = 'Biweekly' THEN
6910: -- Added this IF condition to remove the end date if end date is '4712/12/31' : Bug#5170178

Line 6913: ||fnd_date.date_to_displaydate(p_payment_date);

6909: IF p_category = 'Biweekly' THEN
6910: -- Added this IF condition to remove the end date if end date is '4712/12/31' : Bug#5170178
6911: IF l_end_date IS NULL THEN
6912: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6913: ||fnd_date.date_to_displaydate(p_payment_date);
6914: ELSE
6915: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6916: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6917: ||fnd_date.date_to_displaydate(l_end_date);

Line 6916: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '

6912: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6913: ||fnd_date.date_to_displaydate(p_payment_date);
6914: ELSE
6915: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6916: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6917: ||fnd_date.date_to_displaydate(l_end_date);
6918:
6919: END IF;
6920: ELSE

Line 6917: ||fnd_date.date_to_displaydate(l_end_date);

6913: ||fnd_date.date_to_displaydate(p_payment_date);
6914: ELSE
6915: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6916: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6917: ||fnd_date.date_to_displaydate(l_end_date);
6918:
6919: END IF;
6920: ELSE
6921: l_remark_information1 := p_category||' of $'||p_amount||' to be paid '

Line 6922: ||fnd_date.date_to_displaydate(p_payment_date);

6918:
6919: END IF;
6920: ELSE
6921: l_remark_information1 := p_category||' of $'||p_amount||' to be paid '
6922: ||fnd_date.date_to_displaydate(p_payment_date);
6923: END IF;
6924: END IF;
6925:
6926:

Line 7039: l_date1 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);

7035: LOOP
7036: l_ctr := l_ctr + 1;
7037: IF l_ctr = 1 THEN
7038: l_amount1 := c_incdet_rec.amount;
7039: l_date1 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);
7040: ELSE -- ie. l_ctr =2
7041: l_amount2 := c_incdet_rec.amount;
7042: l_date2 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);
7043: END IF;

Line 7042: l_date2 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);

7038: l_amount1 := c_incdet_rec.amount;
7039: l_date1 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);
7040: ELSE -- ie. l_ctr =2
7041: l_amount2 := c_incdet_rec.amount;
7042: l_date2 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);
7043: END IF;
7044: END LOOP;
7045:
7046: l_ctr := 0;

Line 7430: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_fegli.eligibility_expiration))

7426: ,p_input_value_name1 => 'FEGLI'
7427: -- Bug#2759379 Added Input Value2 here.
7428: ,p_input_value_name2 => 'Eligibility Expiration'
7429: ,p_value2 =>
7430: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_fegli.eligibility_expiration))
7431: ,p_value1 => p_pa_request_rec.fegli
7432: ,p_effective_date => l_effective_date
7433: ,p_process_warning => l_warning
7434: );

Line 7493: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_recruitment_bonus.p_date_recruit_exp)) --AVR

7489: ,p_input_value_name1 => 'Amount'
7490: ,p_value1 => p_recruitment_bonus.p_recruitment_bonus
7491: ,p_input_value_name2 => 'Expiration Date'
7492: ,p_value2 =>
7493: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_recruitment_bonus.p_date_recruit_exp)) --AVR
7494: ,p_input_value_name3 => 'Percentage'
7495: ,p_value3 => p_recruitment_bonus.p_percentage
7496:
7497: ,p_effective_date => l_effective_date

Line 7522: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_relocation_bonus.p_date_reloc_exp)) --AVR

7518: ,p_input_value_name1 => 'Amount'
7519: ,p_value1 => p_relocation_bonus.p_relocation_bonus
7520: ,p_input_value_name2 => 'Expiration Date'
7521: ,p_value2 =>
7522: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_relocation_bonus.p_date_reloc_exp)) --AVR
7523: ,p_input_value_name3 => 'Percentage'
7524: ,p_value3 => p_relocation_bonus.p_percentage
7525: ,p_effective_date => l_effective_date
7526: ,p_process_warning => l_warning

Line 7550: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_student_loan_repay.p_review_date))

7546: ,p_input_value_name1 => 'Amount'
7547: ,p_value1 => p_student_loan_repay.p_amount
7548: ,p_input_value_name2 => 'Review Date'
7549: ,p_value2 =>
7550: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_student_loan_repay.p_review_date))
7551: ,p_effective_date => l_effective_date
7552: ,p_process_warning => l_warning
7553: );
7554: ELSIF (p_student_loan_repay.p_repay_schedule = 'R') THEN

Line 7563: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_student_loan_repay.p_review_date))

7559: ,p_input_value_name1 => 'Amount'
7560: ,p_value1 => (p_student_loan_repay.p_amount)
7561: ,p_input_value_name2 => 'Review Date'
7562: ,p_value2 =>
7563: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_student_loan_repay.p_review_date))
7564: ,p_effective_date => l_effective_date
7565: ,p_process_warning => l_warning
7566: );
7567: END IF;

Line 7599: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_gov_award.date_award_earned)) --AVR

7595: ,p_input_value_name6 => 'Tangible Benefit Dollars'
7596: ,p_value6 => p_gov_award.tangible_benefit_dollars
7597: ,p_input_value_name8 => 'Date Award Earned'
7598: ,p_value8 =>
7599: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_gov_award.date_award_earned)) --AVR
7600: ,p_input_value_name9 => 'Appropriation Code'
7601: ,p_value9 => p_gov_award.award_appropriation_code
7602: ,p_input_value_name10 => 'Date Ex Emp Award Paid'
7603: ,p_value10 =>

Line 7604: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_gov_award.date_exemp_award))

7600: ,p_input_value_name9 => 'Appropriation Code'
7601: ,p_value9 => p_gov_award.award_appropriation_code
7602: ,p_input_value_name10 => 'Date Ex Emp Award Paid'
7603: ,p_value10 =>
7604: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_gov_award.date_exemp_award))
7605: ,p_effective_date => l_effective_date
7606: ,p_process_warning => l_warning
7607: );
7608: End if;

Line 7635: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_foreign_lang_prof_pay.certification_date)) --AVR

7631: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7632: ,p_element_name => 'Foreign Lang Proficiency Pay'
7633: ,p_input_value_name1 => 'Certification Date'
7634: ,p_value1 =>
7635: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_foreign_lang_prof_pay.certification_date)) --AVR
7636: ,p_input_value_name2 => 'Pay Level or Rate'
7637: ,p_value2 => p_foreign_lang_prof_pay.pay_level_or_rate
7638: ,p_effective_date => l_effective_date
7639: ,p_process_warning => l_warning

Line 7794: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_living_quarters_allow.purchase_date)) --AVR

7790: ,p_input_value_name1 => 'Purchase Amount'
7791: ,p_value1 => p_living_quarters_allow.purchase_amount
7792: ,p_input_value_name2 => 'Purchase Date'
7793: ,p_value2 =>
7794: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_living_quarters_allow.purchase_date)) --AVR
7795: ,p_input_value_name3 => 'Rent Amount'
7796: ,p_value3 => p_living_quarters_allow.rent_amount
7797: ,p_input_value_name4 => 'Utility Amount'
7798: ,p_value4 => p_living_quarters_allow.utility_amount

Line 7939: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_retirement_annuity.eligibility_expires)) --AVR

7935: ,p_input_value_name1 => 'Sum'
7936: ,p_value1 => p_retirement_annuity.annuity_sum
7937: ,p_input_value_name2 => 'Eligibility Expires'
7938: ,p_value2 =>
7939: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_retirement_annuity.eligibility_expires)) --AVR
7940: ,p_effective_date => l_effective_date
7941: ,p_process_warning => l_warning
7942: );
7943: end if;

Line 7984: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_thrift_saving_plan.status_date)) --AVR

7980: ,p_input_value_name6 => 'Status'
7981: ,p_value6 => p_thrift_saving_plan.status
7982: ,p_input_value_name7 => 'Status Date'
7983: ,p_value7 =>
7984: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_thrift_saving_plan.status_date)) --AVR
7985: ,p_effective_date => l_effective_date
7986: ,p_process_warning => l_warning
7987: );
7988: END IF; -- IF ghr_utility.is_ghr_ben_tsp

Line 8048: ,p_value10 => fnd_date.date_to_displaydate(p_mddds_special_pay.mddds_special_pay_date)

8044: ,p_value8 => p_mddds_special_pay.Dentist_post_graduate_training
8045: ,p_input_value_name9 => 'Amount'
8046: ,p_value9 => p_mddds_special_pay.amount
8047: ,p_input_value_name10 => 'MDDDS Special Pay NTE Date'
8048: ,p_value10 => fnd_date.date_to_displaydate(p_mddds_special_pay.mddds_special_pay_date)
8049: ,p_effective_date => l_effective_date
8050: ,p_process_warning => l_warning
8051: );
8052: end if;

Line 8429: p_wgi_due_date := fnd_date.canonical_to_date(l_wgi_due_date);

8425: p_date_effective => p_pa_request_rec.effective_date,
8426: p_screen_entry_value => l_wgi_due_date
8427: );
8428:
8429: p_wgi_due_date := fnd_date.canonical_to_date(l_wgi_due_date);
8430: -- End of Bug 3111719.
8431: -- Bug 3709414 New Approach-- For 713 actions take from element entry
8432: -- If DLEI is entered, use that to calculate Due Date, else retain the old date
8433: ELSIF (p_pa_request_rec.first_noa_code = '713' OR p_pa_request_rec.second_noa_code = '713') AND p_dlei IS NULL THEN

Line 8441: p_wgi_due_date := fnd_date.canonical_to_date(l_lei_date);

8437: p_assignment_id => p_pa_request_rec.employee_assignment_id,
8438: p_date_effective => p_pa_request_rec.effective_date,
8439: p_screen_entry_value => l_lei_date
8440: );
8441: p_wgi_due_date := fnd_date.canonical_to_date(l_lei_date);
8442: ELSE
8443: hr_utility.set_location(l_proc,40);
8444: If l_from_Step is not null then
8445: for waiting_period in c_waiting_period loop

Line 8461: p_wgi_due_date := fnd_date.canonical_to_date(l_wgi_due_date) + 364;

8457: p_screen_entry_value => l_wgi_due_date
8458: );
8459:
8460: hr_utility.set_location(l_proc,25);
8461: p_wgi_due_date := fnd_date.canonical_to_date(l_wgi_due_date) + 364;
8462: -- If it's NOA 713 and DLEI is entered, it enters here
8463: -- Need to use DLEI to calculate WGI due date instead of effective date
8464: -- Code added as part of WGI Enhancments/Bug fixes
8465: ELSIF (p_pa_request_rec.first_noa_code = '713' or p_pa_request_rec.second_noa_code = '713') THEN