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 706: IF fnd_date.canonical_to_date(rg_rec.pei_information1) >

702: hr_utility.set_location('702 RG Processing '||l_proc,10);
703: FOR rg_rec in c_702_rec LOOP
704: hr_utility.set_location('Effective Date '||p_pa_request_rec.effective_date,1);
705: hr_utility.set_location('702 RG Processing '||rg_rec.rei_information3,11);
706: IF fnd_date.canonical_to_date(rg_rec.pei_information1) >
707: (p_pa_request_rec.effective_date - 1) THEN
708: hr_utility.set_message(8301,'GHR_38692_RG_TO_DATE_LESSER');
709: hr_utility.raise_error;
710: END IF;

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

712: (p_pa_request_rec => P_PA_REQUEST_REC
713: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'
714: ,p_extra_info_id => rg_rec.rei_information3
715: ,p_l_object_version_number => rg_rec.ovn
716: ,p_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
717: );
718: END LOOP;
719: ELSIF p_pa_request_rec.first_noa_code = '740' THEN
720: --740 Processing

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

721: hr_utility.set_location('740 RG Processing '||l_proc,15);
722: FOR rg_rec in c_740_rec LOOP
723: hr_utility.set_location('Effective Date '||p_pa_request_rec.effective_date,1);
724: hr_utility.set_location('740 RG Processing '||rg_rec.rei_information3,12);
725: IF fnd_date.canonical_to_date(rg_rec.pei_information1) >
726: (p_pa_request_rec.effective_date - 1) THEN
727: hr_utility.set_message(8301,'GHR_38692_RG_TO_DATE_LESSER');
728: hr_utility.raise_error;
729: END IF;

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

731: (p_pa_request_rec => P_PA_REQUEST_REC
732: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'
733: ,p_extra_info_id => rg_rec.rei_information3
734: ,p_l_object_version_number => rg_rec.ovn
735: ,p_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
736: );
737: END LOOP;
738: -------Bug 5913362 -- Adding 890
739: ELSIF p_pa_request_rec.first_noa_code IN ('866', '890') THEN

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

751: (p_pa_request_rec => P_PA_REQUEST_REC
752: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'
753: ,p_extra_info_id => p_per_retained_grade.person_extra_info_id
754: ,p_l_object_version_number => p_per_retained_grade.object_version_number
755: ,p_information2 => fnd_date.date_to_canonical(l_effective_date)
756: );
757: FOR cur_temp_step_rec IN cur_temp_step LOOP
758: l_new_temp_step := cur_temp_step_rec.temp_step;
759: END LOOP;

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

783: -- End date the existing RG record
784: hr_person_extra_info_api.update_person_extra_info
785: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
786: p_object_version_number => l_ret_object_version_number,
787: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date )
788: );
789: hr_utility.set_location('Inside 866 processing ',3);
790: -- Create the new RG Record with Temporary Promotion Step Value
791: hr_person_extra_info_api.create_person_extra_info

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

794: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
795: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
796: p_object_version_number => l_ret_object_version_number,
797: p_pei_information1 =>
798: fnd_date.date_to_canonical(p_pa_request_rec.effective_date + 1),
799: p_pei_information2 => l_new_date_to,
800: p_pei_information3 => l_new_grade_or_level,
801: p_pei_information4 => l_new_step_or_rate,
802: p_pei_information5 => l_new_pay_plan,

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

931: -- update the same record. Otherwise, end date current record and create new record.
932: -- Bug#4719037 RG record created unnecessarily where g_pay_table_upd_flag is FALSE.
933: -- So, added the per_retained_grade_flag condition to avoid it.
934: IF p_per_retained_grade.per_retained_grade_flag = 'Y' THEN
935: IF TRUNC(fnd_date.canonical_to_date(l_cur_date_from)) = TRUNC(p_pa_request_rec.effective_date) THEN
936: hr_utility.set_location('RG Start date Equal to RPA Effective Date ',22);
937: Generic_Update_Extra_Info
938: (p_pa_request_rec => P_PA_REQUEST_REC
939: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'

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

955: (p_pa_request_rec => P_PA_REQUEST_REC
956: ,p_l_information_type => 'GHR_US_RETAINED_GRADE'
957: ,p_extra_info_id => l_retained_grade_rec.person_extra_info_id
958: ,p_l_object_version_number => l_ret_object_version_number
959: ,p_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
960: );
961:
962: -- Create the new RG Record with Temporary Promotion Step Value
963: hr_person_extra_info_api.create_person_extra_info

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

966: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
967: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
968: p_object_version_number => l_ovn,
969: p_pei_information1 =>
970: fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
971: p_pei_information2 => l_new_date_to,
972: p_pei_information3 => l_new_grade_or_level,
973: p_pei_information4 => l_new_step_or_rate,
974: p_pei_information5 => l_new_pay_plan,

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

3573: p_remark_desc => l_remark_description
3574: );
3575:
3576: l_remark_description := replace(l_remark_description,'_')
3577: ||to_char(fnd_date.canonical_to_date(l_mddds_special_pay_nte_date),'DD-MON-RRRR');
3578:
3579: --while terminating the MDDDS_SPECIAL_PAY element it should delete the remarks also.
3580: IF ( l_mddds_total_special_pay <> 0 )
3581: and ( l_mddds_total_special_pay IS NOT NULL ) THEN

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

5843: --3306515 added l_retention_allow_percentage
5844: ,p_value2 => to_char(nvl(p_pa_request_rec.to_retention_allow_percentage,l_retention_allow_percentage))
5845:
5846: ,p_input_value_name3 => 'Date'
5847: ,p_value3 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_retention_allow_review.review_date))
5848: ,p_effective_date => l_effective_date
5849: ,p_process_warning => l_adj_basic_pay_warn
5850: );
5851: Else --if p_pa_request_rec.ret. allowance is null

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

5884: ,p_value1 => to_char(p_pa_request_rec.to_retention_allowance)
5885: ,p_input_value_name2 => 'Percentage'
5886: ,p_value2 => to_char(p_pa_request_rec.to_retention_allow_percentage)
5887: ,p_input_value_name3 => 'Date'
5888: ,p_value3 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_retention_allow_review.review_date))
5889: ,p_effective_date => l_effective_date
5890: ,p_process_warning => l_adj_basic_pay_warn
5891: );
5892: End if;

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

5904: ---- Bug 3263140
5905: -- No need for this cursor as the values are properly passed.
5906: -- Instead of the cursor the below written statement is enough
5907: /*FOR ctr_wgi_due IN cur_wgi_due LOOP
5908: l_wgi_due_date := fnd_date.canonical_to_date(ctr_wgi_due.wgi_due);
5909: END LOOP; */
5910:
5911: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
5912:

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

5907: /*FOR ctr_wgi_due IN cur_wgi_due LOOP
5908: l_wgi_due_date := fnd_date.canonical_to_date(ctr_wgi_due.wgi_due);
5909: END LOOP; */
5910:
5911: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
5912:
5913: hr_utility.set_location('WGI Due date ' || l_wgi_due_date,150);
5914: hr_utility.set_location('p_pa_request_rec.noa_family_code ' || p_pa_request_rec.noa_family_code,150);
5915: -- GPPA 46 Update. l_to_pay_plan is not getting initialized. So, added the

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

6029: END IF;
6030: END IF; -- IF nvl(p_pa_request_rec.noa_family_code,hr_api.g_varchar2) = 'CONV_APP'
6031:
6032: -- proceed only if date_wgi_due is not null
6033: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
6034: IF l_wgi_due_date IS NOT NULL AND l_wgi_cleared = FALSE THEN
6035: ghr_sf52_do_update.get_wgi_dates
6036: (p_pa_request_rec => p_pa_request_rec,
6037: p_wgi_due_date => l_wgi_due_date,

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

6043: ghr_element_api.process_sf52_element
6044: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6045: ,p_element_name => 'Within Grade Increase'
6046: ,p_input_value_name2 => 'Date Due'
6047: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6048: ,p_input_value_name3 => 'Pay Date'
6049: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6050: ,p_input_value_name4 => 'Last Equivalent Increase'
6051: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))

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

6045: ,p_element_name => 'Within Grade Increase'
6046: ,p_input_value_name2 => 'Date Due'
6047: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6048: ,p_input_value_name3 => 'Pay Date'
6049: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6050: ,p_input_value_name4 => 'Last Equivalent Increase'
6051: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6052: ,p_input_value_name5 => 'Postponmt Effective'
6053: ,p_value5 =>

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

6047: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6048: ,p_input_value_name3 => 'Pay Date'
6049: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6050: ,p_input_value_name4 => 'Last Equivalent Increase'
6051: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6052: ,p_input_value_name5 => 'Postponmt Effective'
6053: ,p_value5 =>
6054: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6055: ,p_effective_date => l_effective_date

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

6050: ,p_input_value_name4 => 'Last Equivalent Increase'
6051: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6052: ,p_input_value_name5 => 'Postponmt Effective'
6053: ,p_value5 =>
6054: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6055: ,p_effective_date => l_effective_date
6056: ,p_process_warning => l_within_grade_increase_warn
6057: );
6058: -- If WGI Due date is not entered for Appointment and Conversion to Appointment, atleast create

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

6069: ,p_value2 => NULL -- Bug 3998686
6070: ,p_input_value_name3 => 'Pay Date'
6071: ,p_value3 => NULL -- Bug 3998686
6072: ,p_input_value_name4 => 'Last Equivalent Increase'
6073: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6074: ,p_input_value_name5 => 'Postponmt Effective'
6075: ,p_value5 =>
6076: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6077: ,p_effective_date => l_effective_date

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

6072: ,p_input_value_name4 => 'Last Equivalent Increase'
6073: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6074: ,p_input_value_name5 => 'Postponmt Effective'
6075: ,p_value5 =>
6076: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6077: ,p_effective_date => l_effective_date
6078: ,p_process_warning => l_within_grade_increase_warn
6079: );
6080: END IF; -- IF l_wgi_due_date IS NOT NULL THEN

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

6112: l_call_wgi_dates = TRUE
6113: THEN
6114:
6115: IF p_pa_request_rec.first_noa_code in ( '702','703','713') THEN
6116: l_wgi_due_date := fnd_date.canonical_to_date(p_wgi.p_date_wgi_due);
6117: hr_utility.set_location('702 -- l_wgi_due_date is ' || l_wgi_due_date,1);
6118: END IF;
6119:
6120: IF not (p_pa_request_rec.first_noa_code = '702' AND

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

6126: (p_pa_request_rec => p_pa_request_rec,
6127: p_wgi_due_date => l_wgi_due_date,
6128: p_wgi_pay_date => l_wgi_pay_date,
6129: p_retained_grade_rec => l_retained_grade_rec,
6130: p_dlei => fnd_date.canonical_to_date(p_wgi.p_last_equi_incr)
6131: );
6132: -- Start of 3111719
6133: -- For QSI action get the current LEI date.
6134: -- Bug 3993664 - Included NOA 867...

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

6161: END IF;
6162:
6163: -- Bug 3617295 DLEI should be updated with RPA effective date
6164: IF p_pa_request_rec.first_noa_code = '855' OR p_pa_request_rec.second_noa_code = '855' THEN
6165: p_wgi.p_last_equi_incr := fnd_date.date_to_canonical(p_pa_request_rec.effective_date); -- Bug 3991240
6166: END IF;
6167: -- End Bug 3617295
6168:
6169: hr_utility.set_location('l_wgi_due_date calculated is ' || l_wgi_due_date,1);

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

6173: ghr_element_api.process_sf52_element
6174: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6175: ,p_element_name => 'Within Grade Increase'
6176: ,p_input_value_name2 => 'Date Due'
6177: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6178: ,p_input_value_name3 => 'Pay Date'
6179: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6180: ,p_input_value_name4 => 'Last Equivalent Increase'
6181: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))

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

6175: ,p_element_name => 'Within Grade Increase'
6176: ,p_input_value_name2 => 'Date Due'
6177: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6178: ,p_input_value_name3 => 'Pay Date'
6179: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6180: ,p_input_value_name4 => 'Last Equivalent Increase'
6181: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6182: ,p_input_value_name5 => 'Postponmt Effective'
6183: ,p_value5 =>

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

6177: ,p_value2 => fnd_date.date_to_displaydate(l_wgi_due_date) --AVR
6178: ,p_input_value_name3 => 'Pay Date'
6179: ,p_value3 => fnd_date.date_to_displaydate(l_wgi_pay_date) --AVR
6180: ,p_input_value_name4 => 'Last Equivalent Increase'
6181: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6182: ,p_input_value_name5 => 'Postponmt Effective'
6183: ,p_value5 =>
6184: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6185: ,p_effective_date => l_effective_date

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

6180: ,p_input_value_name4 => 'Last Equivalent Increase'
6181: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6182: ,p_input_value_name5 => 'Postponmt Effective'
6183: ,p_value5 =>
6184: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) --AVR
6185: ,p_effective_date => l_effective_date
6186: ,p_process_warning => l_within_grade_increase_warn
6187: );
6188: END IF; -- IF not (p_pa_request_rec.first_noa_code = '702'

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

6200: (p_assignment_id => p_pa_request_rec.employee_assignment_id
6201: ,p_element_name => 'Within Grade Increase'
6202: ,p_input_value_name2 => 'Date Due'
6203: ,p_value2 =>
6204: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_due)) --AVR
6205: ,p_input_value_name3 => 'Pay Date'
6206: ,p_value3 =>
6207: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_wgi_pay_date)) --AVR
6208: ,p_input_value_name4 => 'Last Equivalent Increase'

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

6203: ,p_value2 =>
6204: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_due)) --AVR
6205: ,p_input_value_name3 => 'Pay Date'
6206: ,p_value3 =>
6207: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_wgi_pay_date)) --AVR
6208: ,p_input_value_name4 => 'Last Equivalent Increase'
6209: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6210: ,p_input_value_name5 => 'Postponmt Effective'
6211: ,p_value5 =>

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

6205: ,p_input_value_name3 => 'Pay Date'
6206: ,p_value3 =>
6207: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_wgi_pay_date)) --AVR
6208: ,p_input_value_name4 => 'Last Equivalent Increase'
6209: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6210: ,p_input_value_name5 => 'Postponmt Effective'
6211: ,p_value5 =>
6212: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) ---AVR
6213: ,p_effective_date => l_effective_date

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

6208: ,p_input_value_name4 => 'Last Equivalent Increase'
6209: ,p_value4 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_last_equi_incr))
6210: ,p_input_value_name5 => 'Postponmt Effective'
6211: ,p_value5 =>
6212: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_wgi.p_date_wgi_postpone_effective)) ---AVR
6213: ,p_effective_date => l_effective_date
6214: ,p_process_warning => l_within_grade_increase_warn
6215: );
6216: end if;

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

6267: AND ghr_process_sf52.g_prd IS NOT NULL then
6268: hr_person_extra_info_api.update_person_extra_info
6269: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6270: p_object_version_number => l_ret_object_version_number,
6271: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
6272: );
6273: end if;
6274: If p_pa_request_rec.first_noa_code in ('867','892','893') then
6275: --- Bug 6193571 end

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

6275: --- Bug 6193571 end
6276: hr_person_extra_info_api.update_person_extra_info
6277: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6278: p_object_version_number => l_ret_object_version_number,
6279: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
6280: );
6281: end if;
6282: IF p_pa_request_rec.first_noa_code in ('867','892','893') THEN
6283: l_new_step_or_rate := l_retained_grade_rec.step_or_rate;

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

6292: p_information_type => 'GHR_US_RETAINED_GRADE',
6293: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6294: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6295: p_object_version_number => l_ret_object_version_number,
6296: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6297: p_pei_information2 => l_new_date_to,
6298: p_pei_information3 => l_new_grade_or_level,
6299: p_pei_information4 => l_cur_step_or_rate,
6300: p_pei_information5 => l_new_pay_plan,

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

6316: p_information_type => 'GHR_US_RETAINED_GRADE',
6317: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6318: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6319: p_object_version_number => l_ret_object_version_number,
6320: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6321: p_pei_information2 => l_new_date_to,
6322: p_pei_information3 => l_new_grade_or_level,
6323: p_pei_information4 => nvl(l_new_step_or_rate,l_cur_step_or_rate),
6324: p_pei_information5 => l_new_pay_plan,

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

6334: p_information_type => 'GHR_US_RETAINED_GRADE',
6335: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6336: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6337: p_object_version_number => l_ret_object_version_number,
6338: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6339: p_pei_information2 => l_new_date_to,
6340: p_pei_information3 => l_new_grade_or_level,
6341: p_pei_information4 => nvl(l_new_step_or_rate,l_cur_step_or_rate),
6342: p_pei_information5 => l_new_pay_plan,

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

6394: -- End date the existing RG record
6395: hr_person_extra_info_api.update_person_extra_info
6396: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6397: p_object_version_number => l_ret_object_version_number,
6398: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
6399: );
6400: hr_utility.set_location('Inside 703 processing ',3);
6401: -- Create the new RG Record with Temporary Promotion Step Value
6402: hr_person_extra_info_api.create_person_extra_info

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

6404: p_information_type => 'GHR_US_RETAINED_GRADE',
6405: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6406: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6407: p_object_version_number => l_ret_object_version_number,
6408: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6409: p_pei_information2 => l_new_date_to,
6410: p_pei_information3 => l_new_grade_or_level,
6411: p_pei_information4 => l_new_step_or_rate,
6412: p_pei_information5 => l_new_pay_plan,

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

6465: -- End date the existing RG record
6466: hr_person_extra_info_api.update_person_extra_info
6467: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6468: p_object_version_number => l_ret_object_version_number,
6469: p_pei_information2 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date - 1)
6470: );
6471: hr_utility.set_location('Inside 740 processing ',3);
6472: -- Create the new RG Record with null Temporary Promotion Step Value
6473: hr_person_extra_info_api.create_person_extra_info

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

6475: p_information_type => 'GHR_US_RETAINED_GRADE',
6476: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
6477: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,
6478: p_object_version_number => l_ret_object_version_number,
6479: p_pei_information1 => fnd_date.date_to_canonical(p_pa_request_rec.effective_date),
6480: p_pei_information2 => l_new_date_to,
6481: p_pei_information3 => l_new_grade_or_level,
6482: p_pei_information4 => l_new_step_or_rate,
6483: p_pei_information5 => l_new_pay_plan,

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

6612:
6613: -- Bug#5039100
6614: IF p_percent = 0 THEN
6615: -- Change the remark from 'As on' to 'As of' : Bug:5170178
6616: l_remark_information1 := 'Retention Incentive Biweekly is terminated as of '||fnd_date.date_to_displaydate(p_payment_date);
6617: ELSE
6618: -- Added this IF condition to remove the end date if end date is '4712/12/31' : Bug#5170178
6619: IF l_end_date IS NULL THEN
6620: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '

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

6617: ELSE
6618: -- Added this IF condition to remove the end date if end date is '4712/12/31' : Bug#5170178
6619: IF l_end_date IS NULL THEN
6620: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6621: ||fnd_date.date_to_displaydate(p_payment_date);
6622: ELSE
6623: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6624: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6625: ||fnd_date.date_to_displaydate(l_end_date);

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

6620: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6621: ||fnd_date.date_to_displaydate(p_payment_date);
6622: ELSE
6623: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6624: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6625: ||fnd_date.date_to_displaydate(l_end_date);
6626: END IF;
6627: END IF;
6628: ELSE

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

6621: ||fnd_date.date_to_displaydate(p_payment_date);
6622: ELSE
6623: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid from '
6624: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6625: ||fnd_date.date_to_displaydate(l_end_date);
6626: END IF;
6627: END IF;
6628: ELSE
6629: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid '

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

6626: END IF;
6627: END IF;
6628: ELSE
6629: l_remark_information1 := p_category||' is '||p_percent||'% of Earned Basic Pay to be paid '
6630: ||fnd_date.date_to_displaydate(p_payment_date);
6631: END IF;
6632: ELSE
6633: IF p_category = 'Biweekly' THEN
6634: -- Added this IF condition to remove the end date if end date is '4712/12/31' : Bug#5170178

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

6633: IF p_category = 'Biweekly' THEN
6634: -- Added this IF condition to remove the end date if end date is '4712/12/31' : Bug#5170178
6635: IF l_end_date IS NULL THEN
6636: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6637: ||fnd_date.date_to_displaydate(p_payment_date);
6638: ELSE
6639: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6640: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6641: ||fnd_date.date_to_displaydate(l_end_date);

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

6636: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6637: ||fnd_date.date_to_displaydate(p_payment_date);
6638: ELSE
6639: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6640: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6641: ||fnd_date.date_to_displaydate(l_end_date);
6642:
6643: END IF;
6644: ELSE

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

6637: ||fnd_date.date_to_displaydate(p_payment_date);
6638: ELSE
6639: l_remark_information1 := p_category||' of $'||p_amount||' to be paid from '
6640: ||fnd_date.date_to_displaydate(p_payment_date) ||' to '
6641: ||fnd_date.date_to_displaydate(l_end_date);
6642:
6643: END IF;
6644: ELSE
6645: l_remark_information1 := p_category||' of $'||p_amount||' to be paid '

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

6642:
6643: END IF;
6644: ELSE
6645: l_remark_information1 := p_category||' of $'||p_amount||' to be paid '
6646: ||fnd_date.date_to_displaydate(p_payment_date);
6647: END IF;
6648: END IF;
6649:
6650:

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

6759: LOOP
6760: l_ctr := l_ctr + 1;
6761: IF l_ctr = 1 THEN
6762: l_amount1 := c_incdet_rec.amount;
6763: l_date1 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);
6764: ELSE -- ie. l_ctr =2
6765: l_amount2 := c_incdet_rec.amount;
6766: l_date2 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);
6767: END IF;

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

6762: l_amount1 := c_incdet_rec.amount;
6763: l_date1 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);
6764: ELSE -- ie. l_ctr =2
6765: l_amount2 := c_incdet_rec.amount;
6766: l_date2 := fnd_date.date_to_displaydate(c_incdet_rec.payment_date);
6767: END IF;
6768: END LOOP;
6769:
6770: l_ctr := 0;

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

7148: ,p_input_value_name1 => 'FEGLI'
7149: -- Bug#2759379 Added Input Value2 here.
7150: ,p_input_value_name2 => 'Eligibility Expiration'
7151: ,p_value2 =>
7152: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_fegli.eligibility_expiration))
7153: ,p_value1 => p_pa_request_rec.fegli
7154: ,p_effective_date => l_effective_date
7155: ,p_process_warning => l_warning
7156: );

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

7211: ,p_input_value_name1 => 'Amount'
7212: ,p_value1 => p_recruitment_bonus.p_recruitment_bonus
7213: ,p_input_value_name2 => 'Expiration Date'
7214: ,p_value2 =>
7215: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_recruitment_bonus.p_date_recruit_exp)) --AVR
7216: ,p_input_value_name3 => 'Percentage'
7217: ,p_value3 => p_recruitment_bonus.p_percentage
7218:
7219: ,p_effective_date => l_effective_date

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

7240: ,p_input_value_name1 => 'Amount'
7241: ,p_value1 => p_relocation_bonus.p_relocation_bonus
7242: ,p_input_value_name2 => 'Expiration Date'
7243: ,p_value2 =>
7244: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_relocation_bonus.p_date_reloc_exp)) --AVR
7245: ,p_input_value_name3 => 'Percentage'
7246: ,p_value3 => p_relocation_bonus.p_percentage
7247: ,p_effective_date => l_effective_date
7248: ,p_process_warning => l_warning

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

7268: ,p_input_value_name1 => 'Amount'
7269: ,p_value1 => p_student_loan_repay.p_amount
7270: ,p_input_value_name2 => 'Review Date'
7271: ,p_value2 =>
7272: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_student_loan_repay.p_review_date))
7273: ,p_effective_date => l_effective_date
7274: ,p_process_warning => l_warning
7275: );
7276: ELSIF (p_student_loan_repay.p_repay_schedule = 'R') THEN

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

7281: ,p_input_value_name1 => 'Amount'
7282: ,p_value1 => (p_student_loan_repay.p_amount)
7283: ,p_input_value_name2 => 'Review Date'
7284: ,p_value2 =>
7285: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_student_loan_repay.p_review_date))
7286: ,p_effective_date => l_effective_date
7287: ,p_process_warning => l_warning
7288: );
7289: END IF;

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

7317: ,p_input_value_name6 => 'Tangible Benefit Dollars'
7318: ,p_value6 => p_gov_award.tangible_benefit_dollars
7319: ,p_input_value_name8 => 'Date Award Earned'
7320: ,p_value8 =>
7321: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_gov_award.date_award_earned)) --AVR
7322: ,p_input_value_name9 => 'Appropriation Code'
7323: ,p_value9 => p_gov_award.award_appropriation_code
7324: ,p_input_value_name10 => 'Date Ex Emp Award Paid'
7325: ,p_value10 =>

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

7322: ,p_input_value_name9 => 'Appropriation Code'
7323: ,p_value9 => p_gov_award.award_appropriation_code
7324: ,p_input_value_name10 => 'Date Ex Emp Award Paid'
7325: ,p_value10 =>
7326: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_gov_award.date_exemp_award))
7327: ,p_effective_date => l_effective_date
7328: ,p_process_warning => l_warning
7329: );
7330: End if;

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

7353: (p_assignment_id => p_pa_request_rec.employee_assignment_id
7354: ,p_element_name => 'Foreign Lang Proficiency Pay'
7355: ,p_input_value_name1 => 'Certification Date'
7356: ,p_value1 =>
7357: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_foreign_lang_prof_pay.certification_date)) --AVR
7358: ,p_input_value_name2 => 'Pay Level or Rate'
7359: ,p_value2 => p_foreign_lang_prof_pay.pay_level_or_rate
7360: ,p_effective_date => l_effective_date
7361: ,p_process_warning => l_warning

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

7512: ,p_input_value_name1 => 'Purchase Amount'
7513: ,p_value1 => p_living_quarters_allow.purchase_amount
7514: ,p_input_value_name2 => 'Purchase Date'
7515: ,p_value2 =>
7516: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_living_quarters_allow.purchase_date)) --AVR
7517: ,p_input_value_name3 => 'Rent Amount'
7518: ,p_value3 => p_living_quarters_allow.rent_amount
7519: ,p_input_value_name4 => 'Utility Amount'
7520: ,p_value4 => p_living_quarters_allow.utility_amount

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

7657: ,p_input_value_name1 => 'Sum'
7658: ,p_value1 => p_retirement_annuity.annuity_sum
7659: ,p_input_value_name2 => 'Eligibility Expires'
7660: ,p_value2 =>
7661: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_retirement_annuity.eligibility_expires)) --AVR
7662: ,p_effective_date => l_effective_date
7663: ,p_process_warning => l_warning
7664: );
7665: end if;

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

7702: ,p_input_value_name6 => 'Status'
7703: ,p_value6 => p_thrift_saving_plan.status
7704: ,p_input_value_name7 => 'Status Date'
7705: ,p_value7 =>
7706: fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_thrift_saving_plan.status_date)) --AVR
7707: ,p_effective_date => l_effective_date
7708: ,p_process_warning => l_warning
7709: );
7710: END IF; -- IF ghr_utility.is_ghr_ben_tsp

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

7742: ,p_value8 => p_mddds_special_pay.Dentist_post_graduate_training
7743: ,p_input_value_name9 => 'Amount'
7744: ,p_value9 => p_mddds_special_pay.amount
7745: ,p_input_value_name10 => 'MDDDS Special Pay NTE Date'
7746: ,p_value10 => fnd_date.date_to_displaydate(p_mddds_special_pay.mddds_special_pay_date)
7747: ,p_effective_date => l_effective_date
7748: ,p_process_warning => l_warning
7749: );
7750: end if;

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

8122: p_date_effective => p_pa_request_rec.effective_date,
8123: p_screen_entry_value => l_wgi_due_date
8124: );
8125:
8126: p_wgi_due_date := fnd_date.canonical_to_date(l_wgi_due_date);
8127: -- End of Bug 3111719.
8128: -- Bug 3709414 New Approach-- For 713 actions take from element entry
8129: -- If DLEI is entered, use that to calculate Due Date, else retain the old date
8130: 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 8138: p_wgi_due_date := fnd_date.canonical_to_date(l_lei_date);

8134: p_assignment_id => p_pa_request_rec.employee_assignment_id,
8135: p_date_effective => p_pa_request_rec.effective_date,
8136: p_screen_entry_value => l_lei_date
8137: );
8138: p_wgi_due_date := fnd_date.canonical_to_date(l_lei_date);
8139: ELSE
8140: hr_utility.set_location(l_proc,40);
8141: If l_from_Step is not null then
8142: for waiting_period in c_waiting_period loop

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

8154: p_screen_entry_value => l_wgi_due_date
8155: );
8156:
8157: hr_utility.set_location(l_proc,25);
8158: p_wgi_due_date := fnd_date.canonical_to_date(l_wgi_due_date) + 364;
8159: -- If it's NOA 713 and DLEI is entered, it enters here
8160: -- Need to use DLEI to calculate WGI due date instead of effective date
8161: -- Code added as part of WGI Enhancments/Bug fixes
8162: ELSIF (p_pa_request_rec.first_noa_code = '713' or p_pa_request_rec.second_noa_code = '713') THEN