DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on HR_PERSON_EXTRA_INFO_API

Line 452: hr_person_extra_info_api.create_person_extra_info

448: END IF;
449: -- Bug#5045806
450: If l_extra_info_id is null then
451: hr_utility.set_location(l_proc,30);
452: hr_person_extra_info_api.create_person_extra_info
453: (p_Person_id => P_Pa_request_rec.Person_id
454: ,p_Information_type => p_l_information_type
455: ,p_pei_information_category => p_l_information_type
456: ,p_pei_information1 => l_information1

Line 491: hr_person_extra_info_api.update_person_extra_info

487: ,p_object_version_number => l_per_cre_ovn );
488: Else
489: --
490: hr_utility.set_location(l_proc,35);
491: hr_person_extra_info_api.update_person_extra_info
492: ( p_person_extra_info_id => l_Extra_Info_Id
493: , p_object_version_number => l_ovn
494: , p_pei_information1 => p_information1
495: , p_pei_information2 => p_information2

Line 799: hr_person_extra_info_api.update_person_extra_info

795: ghr_history_api.get_g_session_var(l_session);
796: hr_utility.set_location('Inside 866 processing ',2);
797: IF l_session.noa_id_correct is null then
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: );

Line 806: hr_person_extra_info_api.create_person_extra_info

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
807: (p_person_id => p_pa_request_rec.person_id,
808: p_information_type => 'GHR_US_RETAINED_GRADE',
809: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
810: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,

Line 826: hr_person_extra_info_api.update_person_extra_info

822: );
823: hr_utility.set_location('Inside 866 processing ',3);
824: ELSE
825: -- Update the TPS in Retain Grade record
826: hr_person_extra_info_api.update_person_extra_info
827: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
828: p_object_version_number => l_ret_object_version_number,
829: p_pei_information9 => l_new_temp_step
830: );

Line 854: hr_person_extra_info_api.update_person_extra_info

850: END LOOP;
851: hr_utility.set_location('P_Per_retained_grade.step_or_rate '||P_Per_retained_grade.retain_step_or_rate,1);
852: hr_utility.set_location('l_retained_grade_rec.step_or_rate '||l_retained_grade_rec.step_or_rate,1);
853: IF (NVL(P_Per_retained_grade.retain_step_or_rate,-1) <> NVL(l_retained_grade_rec.step_or_rate,-1)) THEN
854: hr_person_extra_info_api.update_person_extra_info
855: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
856: p_object_version_number => l_ret_object_version_number,
857: p_pei_information4 => P_Per_retained_grade.retain_step_or_rate
858: );

Line 863: hr_person_extra_info_api.update_person_extra_info

859: END IF;
860: hr_utility.set_location('P_Per_retained_grade.temp_step '||P_Per_retained_grade.temp_step,1);
861: hr_utility.set_location('l_retained_grade_rec.temp_step '||l_retained_grade_rec.temp_step,1);
862: IF (NVL(P_Per_retained_grade.temp_step,-1) <> NVL(l_retained_grade_rec.temp_step,-1)) THEN
863: hr_person_extra_info_api.update_person_extra_info
864: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
865: p_object_version_number => l_ret_object_version_number,
866: p_pei_information9 => P_Per_retained_grade.temp_step
867: );

Line 978: hr_person_extra_info_api.create_person_extra_info

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
979: (p_person_id => p_pa_request_rec.person_id,
980: p_information_type => 'GHR_US_RETAINED_GRADE',
981: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
982: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,

Line 6539: hr_person_extra_info_api.update_person_extra_info

6535: ----Bug 6193571 start
6536: if p_pa_request_rec.first_noa_code = '894'
6537: AND l_new_step_or_rate is not null
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: );

Line 6547: hr_person_extra_info_api.update_person_extra_info

6543: );
6544: end if;
6545: If p_pa_request_rec.first_noa_code in ('867','892','893') then
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: );

Line 6561: hr_person_extra_info_api.create_person_extra_info

6557: END IF;
6558: hr_utility.set_location('TPS 1a '||l_new_temp_step,1);
6559: IF l_new_temp_step is NOT NULL THEN
6560: hr_utility.set_location('TPS 1b '||l_new_temp_step,1);
6561: hr_person_extra_info_api.create_person_extra_info
6562: (p_person_id => p_pa_request_rec.person_id,
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,

Line 6585: hr_person_extra_info_api.create_person_extra_info

6581: --- Bug 6193571 start
6582: if p_pa_request_rec.first_noa_code = '894'
6583: AND l_new_step_or_rate is not null
6584: AND ghr_process_sf52.g_prd IS NOT NULL then
6585: hr_person_extra_info_api.create_person_extra_info
6586: (p_person_id => p_pa_request_rec.person_id,
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,

Line 6603: hr_person_extra_info_api.create_person_extra_info

6599: );
6600: end if;
6601: IF p_pa_request_rec.first_noa_code in ('867','892','893') THEN
6602: ----Bug 6193571 end
6603: hr_person_extra_info_api.create_person_extra_info
6604: (p_person_id => p_pa_request_rec.person_id,
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,

Line 6623: hr_person_extra_info_api.update_person_extra_info

6619: END IF;
6620: End if;
6621: Else
6622: hr_utility.set_location('TPS 3 '||l_new_step_or_rate,3);
6623: hr_person_extra_info_api.update_person_extra_info
6624: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6625: p_object_version_number => l_ret_object_version_number,
6626: p_pei_information4 => l_retained_grade_rec.step_or_rate
6627: );

Line 6666: hr_person_extra_info_api.update_person_extra_info

6662: ghr_history_api.get_g_session_var(l_session);
6663: hr_utility.set_location('Inside 703 processing ',2);
6664: IF l_session.noa_id_correct is null then
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: );

Line 6673: hr_person_extra_info_api.create_person_extra_info

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
6674: (p_person_id => p_pa_request_rec.person_id,
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,

Line 6693: hr_person_extra_info_api.update_person_extra_info

6689: hr_utility.set_location('Inside 703 processing ',3);
6690: ELSE
6691: -- Update the current RG
6692: hr_utility.set_location('Inside 703 correction processing '||l_new_temp_step,4);
6693: hr_person_extra_info_api.update_person_extra_info
6694: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6695: p_object_version_number => l_ret_object_version_number,
6696: p_pei_information9 => l_new_temp_step
6697: );

Line 6737: hr_person_extra_info_api.update_person_extra_info

6733: hr_utility.set_location('Inside 740 processing ',2);
6734: ghr_history_api.get_g_session_var(l_session);
6735: IF l_new_temp_step IS NOT NULL and l_session.noa_id_correct IS NULL THEN
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: );

Line 6744: hr_person_extra_info_api.create_person_extra_info

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
6745: (p_person_id => p_pa_request_rec.person_id,
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,