APPS.GHR_HISTORY_FETCH dependencies on PER_PEOPLE_EXTRA_INFO

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

1463: when OTHERS then
1464: raise;
1465: End fetch_element_entries;
1466: --
1467: -- Procedure fetch_peopleei fetches the last record from per_people_extra_info or
1468: -- ghr_people_extra_info_h_v
1469: --
1470: Procedure fetch_peopleei (
1471: p_person_extra_info_id in number default null,

Line 1478: p_peopleei_data in out nocopy per_people_extra_info%rowtype,

1474: p_noa_id_corrected in number default null,
1475: p_rowid in rowid default null,
1476: p_pa_history_id in number default null,
1477: p_get_ovn_flag in varchar2 default 'N',
1478: p_peopleei_data in out nocopy per_people_extra_info%rowtype,
1479: p_result_code out nocopy varchar2 ) is
1480: l_result_code varchar2(100);
1481: l_hist_data ghr_pa_history%rowtype;
1482: l_proc varchar2(30) := 'fetch_peopleei';

Line 1483: l_peopleei_data per_people_extra_info%rowtype;

1479: p_result_code out nocopy varchar2 ) is
1480: l_result_code varchar2(100);
1481: l_hist_data ghr_pa_history%rowtype;
1482: l_proc varchar2(30) := 'fetch_peopleei';
1483: l_peopleei_data per_people_extra_info%rowtype;
1484: cursor per_peopleei_rowid_cursor is
1485: select *
1486: from per_people_extra_info
1487: where rowid = p_rowid;

Line 1486: from per_people_extra_info

1482: l_proc varchar2(30) := 'fetch_peopleei';
1483: l_peopleei_data per_people_extra_info%rowtype;
1484: cursor per_peopleei_rowid_cursor is
1485: select *
1486: from per_people_extra_info
1487: where rowid = p_rowid;
1488: cursor c_get_ovn is
1489: select object_version_number
1490: from per_people_extra_info

Line 1490: from per_people_extra_info

1486: from per_people_extra_info
1487: where rowid = p_rowid;
1488: cursor c_get_ovn is
1489: select object_version_number
1490: from per_people_extra_info
1491: where person_extra_info_id = p_person_extra_info_id;
1492: Begin
1493: hr_utility.set_location('Entering:'|| l_proc, 5);
1494: hr_utility.set_location('extra info id:'|| to_char(p_person_extra_info_id) || l_proc, 6);

Line 1596: p_per_ei_data in out nocopy per_people_extra_info%rowtype

1592:
1593: Procedure fetch_peopleei(p_person_id in number,
1594: p_information_type in varchar2,
1595: p_date_effective in date,
1596: p_per_ei_data in out nocopy per_people_extra_info%rowtype
1597: )
1598: is
1599: l_proc varchar2(72) := 'Fetch_peoplei (2)';
1600: l_per_ei_data ghr_people_extra_info_h_v%rowtype;

Line 1604: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

1600: l_per_ei_data ghr_people_extra_info_h_v%rowtype;
1601: l_pa_history_id ghr_pa_history.pa_history_id%type;
1602: l_max_effective_date date;
1603: l_session ghr_history_api.g_session_var_type;
1604: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1605: l_result varchar2(20);
1606: cursor c_extra_info_id is
1607: select pei.person_extra_info_id
1608: from per_people_extra_info pei

Line 1608: from per_people_extra_info pei

1604: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
1605: l_result varchar2(20);
1606: cursor c_extra_info_id is
1607: select pei.person_extra_info_id
1608: from per_people_extra_info pei
1609: where pei.person_id = p_person_id
1610: and pei.information_type = p_information_type;
1611: Begin
1612: hr_utility.set_location('Entering ' || l_proc,5);

Line 2667: r_pei per_people_extra_info%rowtype;

2663: ,p_creation_date out nocopy date
2664: ,p_result_code out nocopy varchar2
2665: )
2666: Is
2667: r_pei per_people_extra_info%rowtype;
2668: l_proc varchar2(30):='fetch_peopleei (1)';
2669: l_result_code varchar2(30);
2670: Begin
2671: hr_utility.set_location(' Entering : ' || l_proc, 10);