APPS.GHR_HISTORY_CASCADE dependencies on PER_ALL_PEOPLE_F

Line 54: p_people_data in out nocopy per_all_people_f%rowtype);

50: Procedure Cascade_addresses (
51: p_post_record in ghr_pa_history%rowtype );
52:
53: Procedure correct_people_row (
54: p_people_data in out nocopy per_all_people_f%rowtype);
55:
56: Procedure correct_asgn_row (
57: p_asgn_data in out nocopy per_all_assignments_f%rowtype);
58:

Line 888: l_people_data per_all_people_f%rowtype;

884: p_hist_data_as_of_date in ghr_pa_history%rowtype
885: ) is
886:
887: l_true_false ghr_history_cascade.condition_rg_type;
888: l_people_data per_all_people_f%rowtype;
889: l_hist_peop_data ghr_pa_history%rowtype;
890: l_stop Boolean;
891: l_proc varchar2(30):='Cascade_People';
892:

Line 896: from per_all_people_f

892:
893: -- this cursor is meant to retrieve all following records in per_people_f table.
894: Cursor c_people( c_date_Effective in date, c_person_id in number) is
895: Select *
896: from per_all_people_f
897: where effective_start_date >= c_date_effective and
898: person_id = c_person_id;
899:
900: Begin

Line 1766: Procedure Correct_people_row (p_people_data in out nocopy per_all_people_f%rowtype) is

1762: --
1763: -- {End Of Comments}
1764: -- ---------------------------------------------------------------------------
1765: -- Procedure Correct_people_row will update the Per_People_F row in correct mode
1766: Procedure Correct_people_row (p_people_data in out nocopy per_all_people_f%rowtype) is
1767:
1768: -- this cursor gets the object_version_number from core table, so the core
1769: -- table can be updated.
1770: cursor c_people_getovn( cp_person_id number,

Line 1774: from per_all_people_f

1770: cursor c_people_getovn( cp_person_id number,
1771: cp_eff_st_dt date
1772: ,cp_eff_end_dt date) is
1773: select object_version_number,npw_number --Bug# 10195261 added npw_number
1774: from per_all_people_f
1775: where person_id = cp_person_id
1776: and effective_start_date = cp_eff_st_dt;
1777:
1778: -- and effective_end_date = cp_eff_end_dt;

Line 1784: l_people_data per_all_people_f%rowtype;

1780: l_datetrack_mode varchar2(30):=hr_api.g_correction;
1781: l_dob_null_warning boolean;
1782: l_name_combination_warning boolean;
1783: l_orig_hire_warning boolean;
1784: l_people_data per_all_people_f%rowtype;
1785: l_proc varchar2(30):='Correct_people_Row';
1786: l_date1 per_all_people_f.effective_start_date%type;
1787:
1788: Begin

Line 1786: l_date1 per_all_people_f.effective_start_date%type;

1782: l_name_combination_warning boolean;
1783: l_orig_hire_warning boolean;
1784: l_people_data per_all_people_f%rowtype;
1785: l_proc varchar2(30):='Correct_people_Row';
1786: l_date1 per_all_people_f.effective_start_date%type;
1787:
1788: Begin
1789:
1790: hr_utility.set_location( 'Entering : ' || l_proc, 10);

Line 3012: -- updated in PER_ALL_PEOPLE_F

3008: hr_utility.set_location(l_proc,20);
3009:
3010: --BUG # 14625196 Added as lastname need to be updated and last name is stored
3011: -- in information6 of GHR_PA_HISTORY. with out this last name not getting
3012: -- updated in PER_ALL_PEOPLE_F
3013:
3014: IF UPPER(p_post_record.table_name) = ghr_history_api.g_peop_table THEN
3015: cascade_field_value
3016: (p_pre_field => p_pre_record.information6,