DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on HR_PERSON_EXTRA_INFO_API

Line 437: hr_person_extra_info_api.create_person_extra_info

433: END IF;
434: -- Bug#5045806
435: If l_extra_info_id is null then
436: hr_utility.set_location(l_proc,30);
437: hr_person_extra_info_api.create_person_extra_info
438: (p_Person_id => P_Pa_request_rec.Person_id
439: ,p_Information_type => p_l_information_type
440: ,p_pei_information_category => p_l_information_type
441: ,p_pei_information1 => l_information1

Line 476: hr_person_extra_info_api.update_person_extra_info

472: ,p_object_version_number => l_per_cre_ovn );
473: Else
474: --
475: hr_utility.set_location(l_proc,35);
476: hr_person_extra_info_api.update_person_extra_info
477: ( p_person_extra_info_id => l_Extra_Info_Id
478: , p_object_version_number => l_ovn
479: , p_pei_information1 => p_information1
480: , p_pei_information2 => p_information2

Line 784: hr_person_extra_info_api.update_person_extra_info

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

Line 791: hr_person_extra_info_api.create_person_extra_info

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
792: (p_person_id => p_pa_request_rec.person_id,
793: p_information_type => 'GHR_US_RETAINED_GRADE',
794: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
795: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,

Line 811: hr_person_extra_info_api.update_person_extra_info

807: );
808: hr_utility.set_location('Inside 866 processing ',3);
809: ELSE
810: -- Update the TPS in Retain Grade record
811: hr_person_extra_info_api.update_person_extra_info
812: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
813: p_object_version_number => l_ret_object_version_number,
814: p_pei_information9 => l_new_temp_step
815: );

Line 839: hr_person_extra_info_api.update_person_extra_info

835: END LOOP;
836: hr_utility.set_location('P_Per_retained_grade.step_or_rate '||P_Per_retained_grade.retain_step_or_rate,1);
837: hr_utility.set_location('l_retained_grade_rec.step_or_rate '||l_retained_grade_rec.step_or_rate,1);
838: IF (NVL(P_Per_retained_grade.retain_step_or_rate,-1) <> NVL(l_retained_grade_rec.step_or_rate,-1)) THEN
839: hr_person_extra_info_api.update_person_extra_info
840: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
841: p_object_version_number => l_ret_object_version_number,
842: p_pei_information4 => P_Per_retained_grade.retain_step_or_rate
843: );

Line 848: hr_person_extra_info_api.update_person_extra_info

844: END IF;
845: hr_utility.set_location('P_Per_retained_grade.temp_step '||P_Per_retained_grade.temp_step,1);
846: hr_utility.set_location('l_retained_grade_rec.temp_step '||l_retained_grade_rec.temp_step,1);
847: IF (NVL(P_Per_retained_grade.temp_step,-1) <> NVL(l_retained_grade_rec.temp_step,-1)) THEN
848: hr_person_extra_info_api.update_person_extra_info
849: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
850: p_object_version_number => l_ret_object_version_number,
851: p_pei_information9 => P_Per_retained_grade.temp_step
852: );

Line 963: hr_person_extra_info_api.create_person_extra_info

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
964: (p_person_id => p_pa_request_rec.person_id,
965: p_information_type => 'GHR_US_RETAINED_GRADE',
966: p_pei_information_category => 'GHR_US_RETAINED_GRADE',
967: p_person_extra_info_id => l_ret_grade_rec.person_extra_info_id,

Line 6268: hr_person_extra_info_api.update_person_extra_info

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

Line 6276: hr_person_extra_info_api.update_person_extra_info

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

Line 6290: hr_person_extra_info_api.create_person_extra_info

6286: END IF;
6287: hr_utility.set_location('TPS 1a '||l_new_temp_step,1);
6288: IF l_new_temp_step is NOT NULL THEN
6289: hr_utility.set_location('TPS 1b '||l_new_temp_step,1);
6290: hr_person_extra_info_api.create_person_extra_info
6291: (p_person_id => p_pa_request_rec.person_id,
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,

Line 6314: hr_person_extra_info_api.create_person_extra_info

6310: --- Bug 6193571 start
6311: if p_pa_request_rec.first_noa_code = '894'
6312: AND l_new_step_or_rate is not null
6313: AND ghr_process_sf52.g_prd IS NOT NULL then
6314: hr_person_extra_info_api.create_person_extra_info
6315: (p_person_id => p_pa_request_rec.person_id,
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,

Line 6332: hr_person_extra_info_api.create_person_extra_info

6328: );
6329: end if;
6330: IF p_pa_request_rec.first_noa_code in ('867','892','893') THEN
6331: ----Bug 6193571 end
6332: hr_person_extra_info_api.create_person_extra_info
6333: (p_person_id => p_pa_request_rec.person_id,
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,

Line 6352: hr_person_extra_info_api.update_person_extra_info

6348: END IF;
6349: End if;
6350: Else
6351: hr_utility.set_location('TPS 3 '||l_new_step_or_rate,3);
6352: hr_person_extra_info_api.update_person_extra_info
6353: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6354: p_object_version_number => l_ret_object_version_number,
6355: p_pei_information4 => l_retained_grade_rec.step_or_rate
6356: );

Line 6395: hr_person_extra_info_api.update_person_extra_info

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

Line 6402: hr_person_extra_info_api.create_person_extra_info

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

Line 6422: hr_person_extra_info_api.update_person_extra_info

6418: hr_utility.set_location('Inside 703 processing ',3);
6419: ELSE
6420: -- Update the current RG
6421: hr_utility.set_location('Inside 703 correction processing '||l_new_temp_step,4);
6422: hr_person_extra_info_api.update_person_extra_info
6423: (p_person_extra_info_id => l_retained_grade_rec.person_extra_info_id,
6424: p_object_version_number => l_ret_object_version_number,
6425: p_pei_information9 => l_new_temp_step
6426: );

Line 6466: hr_person_extra_info_api.update_person_extra_info

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

Line 6473: hr_person_extra_info_api.create_person_extra_info

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