APPS.GHR_HISTORY_API dependencies on GHR_HISTORY_FETCH

Line 633: ghr_history_fetch.fetch_people(p_person_id => p_person_id,

629: l_hist_data := p_hist_data;
630:
631: if ( lower(p_table_name) = lower(ghr_history_api.g_peop_table) ) then
632: hr_utility.set_location(l_proc, 10);
633: ghr_history_fetch.fetch_people(p_person_id => p_person_id,
634: p_date_effective => p_date_effective,
635: p_altered_pa_request_id => p_altered_pa_request_id,
636: p_noa_id_corrected => p_noa_id_corrected,
637: p_rowid => p_row_id,

Line 646: ghr_history_fetch.fetch_asgei(p_assignment_extra_info_id => p_table_pk_id,

642: ghr_history_conv_rg.conv_people_rg_to_hist_rg( p_people_data => l_people_data,
643: p_history_data => p_hist_data );
644: elsif ( lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) ) then
645: hr_utility.set_location(l_proc, 15);
646: ghr_history_fetch.fetch_asgei(p_assignment_extra_info_id => p_table_pk_id,
647: p_date_effective => p_date_effective,
648: p_altered_pa_request_id => p_altered_pa_request_id,
649: p_noa_id_corrected => p_noa_id_corrected,
650: p_rowid => p_row_id,

Line 660: ghr_history_fetch.fetch_assignment (

656: p_history_data => p_hist_data );
657:
658: elsif ( lower(p_table_name) = lower(ghr_history_api.g_asgn_table) ) then
659: hr_utility.set_location(l_proc, 25);
660: ghr_history_fetch.fetch_assignment (
661: p_assignment_id => p_table_pk_id,
662: p_date_effective => p_date_effective,
663: p_altered_pa_request_id => p_altered_pa_request_id,
664: p_noa_id_corrected => p_noa_id_corrected,

Line 676: ghr_history_fetch.fetch_peopleei(

672: p_history_data => p_hist_data );
673:
674: elsif ( lower(p_table_name) = lower(ghr_history_api.g_peopei_table) ) then
675: hr_utility.set_location(l_proc, 35);
676: ghr_history_fetch.fetch_peopleei(
677: p_person_extra_info_id => p_table_pk_id,
678: p_date_effective => p_date_effective,
679: p_altered_pa_request_id => p_altered_pa_request_id,
680: p_noa_id_corrected => p_noa_id_corrected,

Line 692: ghr_history_fetch.fetch_element_entry_value(

688: p_history_data => p_hist_data );
689:
690: elsif ( lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) ) then
691: hr_utility.set_location(l_proc, 35);
692: ghr_history_fetch.fetch_element_entry_value(
693: p_element_entry_value_id => p_table_pk_id,
694: p_date_effective => p_date_effective,
695: p_altered_pa_request_id => p_altered_pa_request_id,
696: p_noa_id_corrected => p_noa_id_corrected,

Line 708: ghr_history_fetch.fetch_element_entries(

704: p_history_data => p_hist_data );
705:
706: elsif ( lower(p_table_name) = lower(ghr_history_api.g_eleent_table) ) then
707: hr_utility.set_location(l_proc, 35);
708: ghr_history_fetch.fetch_element_entries(
709: p_element_entry_id => p_table_pk_id,
710: p_date_effective => p_date_effective,
711: p_altered_pa_request_id => p_altered_pa_request_id,
712: p_noa_id_corrected => p_noa_id_corrected,

Line 724: ghr_history_fetch.fetch_positionei(

720: p_history_data => p_hist_data );
721:
722: elsif ( lower(p_table_name) = lower(ghr_history_api.g_posnei_table) ) then
723: hr_utility.set_location(l_proc, 35);
724: ghr_history_fetch.fetch_positionei(
725: p_position_extra_info_id => p_table_pk_id,
726: p_date_effective => p_date_effective,
727: p_altered_pa_request_id => p_altered_pa_request_id,
728: p_noa_id_corrected => p_noa_id_corrected,

Line 740: ghr_history_fetch.fetch_person_analyses (

736: p_history_data => p_hist_data );
737:
738: elsif ( lower(p_table_name) = lower(ghr_history_api.g_perana_table) ) then
739: hr_utility.set_location(l_proc, 40);
740: ghr_history_fetch.fetch_person_analyses (
741: p_person_analysis_id => p_table_pk_id,
742: p_date_effective => p_date_effective,
743: p_altered_pa_request_id => p_altered_pa_request_id,
744: p_noa_id_corrected => p_noa_id_corrected,

Line 755: ghr_history_fetch.fetch_address(

751: p_peranalyses_data => l_peranalyses_data,
752: p_history_data => p_hist_data);
753: elsif ( lower(p_table_name) = lower(ghr_history_api.g_addres_table) ) then
754: hr_utility.set_location(l_proc, 40);
755: ghr_history_fetch.fetch_address(
756: p_address_id => p_table_pk_id,
757: p_date_effective => p_date_effective,
758: p_altered_pa_request_id => p_altered_pa_request_id,
759: p_noa_id_corrected => p_noa_id_corrected,

Line 770: ghr_history_fetch.fetch_position(

766: p_addresses_data => l_address_data,
767: p_history_data => p_hist_data);
768: elsif ( lower(p_table_name) = lower(ghr_history_api.g_posn_table) ) then
769: hr_utility.set_location(l_proc, 40);
770: ghr_history_fetch.fetch_position(
771: p_position_id => p_table_pk_id,
772: p_date_effective => p_date_effective,
773: p_altered_pa_request_id => p_altered_pa_request_id,
774: p_noa_id_corrected => p_noa_id_corrected,

Line 1362: ghr_history_fetch.get_date_eff_eleevl(

1358: -- core table if necessary.
1359:
1360: -- get the row from ghr_pa_history for this element_entry_value given the effective date
1361: -- of this action.
1362: ghr_history_fetch.get_date_eff_eleevl(
1363: p_element_entry_value_id => to_number(l_post_data.information1) ,
1364: p_date_effective => l_post_data.effective_date ,
1365: p_element_entry_data => l_eleevl_data ,
1366: p_result_code => l_return_status ,