APPS.GHR_HISTORY_FETCH dependencies on PER_PEOPLE_EXTRA_INFO

Line 1537: -- Procedure fetch_peopleei fetches the last record from per_people_extra_info or

1533: when OTHERS then
1534: raise;
1535: End fetch_element_entries;
1536: --
1537: -- Procedure fetch_peopleei fetches the last record from per_people_extra_info or
1538: -- ghr_people_extra_info_h_v
1539: --
1540: Procedure fetch_peopleei (
1541: p_person_extra_info_id in number default null,

Line 1548: p_peopleei_data in out nocopy per_people_extra_info%rowtype,

1544: p_noa_id_corrected in number default null,
1545: p_rowid in rowid default null,
1546: p_pa_history_id in number default null,
1547: p_get_ovn_flag in varchar2 default 'N',
1548: p_peopleei_data in out nocopy per_people_extra_info%rowtype,
1549: p_result_code out nocopy varchar2 ) is
1550: l_result_code varchar2(100);
1551: l_hist_data ghr_pa_history%rowtype;
1552: l_proc varchar2(30) := 'fetch_peopleei';

Line 1553: l_peopleei_data per_people_extra_info%rowtype;

1549: p_result_code out nocopy varchar2 ) is
1550: l_result_code varchar2(100);
1551: l_hist_data ghr_pa_history%rowtype;
1552: l_proc varchar2(30) := 'fetch_peopleei';
1553: l_peopleei_data per_people_extra_info%rowtype;
1554: cursor per_peopleei_rowid_cursor is
1555: select *
1556: from per_people_extra_info
1557: where rowid = p_rowid;

Line 1556: from per_people_extra_info

1552: l_proc varchar2(30) := 'fetch_peopleei';
1553: l_peopleei_data per_people_extra_info%rowtype;
1554: cursor per_peopleei_rowid_cursor is
1555: select *
1556: from per_people_extra_info
1557: where rowid = p_rowid;
1558: cursor c_get_ovn is
1559: select object_version_number
1560: from per_people_extra_info

Line 1560: from per_people_extra_info

1556: from per_people_extra_info
1557: where rowid = p_rowid;
1558: cursor c_get_ovn is
1559: select object_version_number
1560: from per_people_extra_info
1561: where person_extra_info_id = p_person_extra_info_id;
1562: Begin
1563: hr_utility.set_location('Entering:'|| l_proc, 5);
1564: hr_utility.set_location('extra info id:'|| to_char(p_person_extra_info_id) || l_proc, 6);

Line 1691: p_per_ei_data in out nocopy per_people_extra_info%rowtype

1687:
1688: Procedure fetch_peopleei(p_person_id in number,
1689: p_information_type in varchar2,
1690: p_date_effective in date,
1691: p_per_ei_data in out nocopy per_people_extra_info%rowtype
1692: )
1693: is
1694: l_proc varchar2(72) := 'Fetch_peoplei (2)';
1695: l_per_ei_data ghr_people_extra_info_h_v%rowtype;

Line 1699: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

1695: l_per_ei_data ghr_people_extra_info_h_v%rowtype;
1696: l_pa_history_id ghr_pa_history.pa_history_id%type;
1697: l_max_effective_date date;
1698: l_session ghr_history_api.g_session_var_type;
1699: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1700: l_result varchar2(20);
1701: cursor c_extra_info_id is
1702: select pei.person_extra_info_id
1703: from per_people_extra_info pei

Line 1703: from per_people_extra_info pei

1699: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1700: l_result varchar2(20);
1701: cursor c_extra_info_id is
1702: select pei.person_extra_info_id
1703: from per_people_extra_info pei
1704: where pei.person_id = p_person_id
1705: and pei.information_type = p_information_type;
1706: Begin
1707: hr_utility.set_location('Entering ' || l_proc,5);

Line 2767: r_pei per_people_extra_info%rowtype;

2763: ,p_creation_date out nocopy date
2764: ,p_result_code out nocopy varchar2
2765: )
2766: Is
2767: r_pei per_people_extra_info%rowtype;
2768: l_proc varchar2(30):='fetch_peopleei (1)';
2769: l_result_code varchar2(30);
2770: Begin
2771: hr_utility.set_location(' Entering : ' || l_proc, 10);