APPS.GHR_HISTORY_FETCH dependencies on PER_POSITION_EXTRA_INFO

Line 5: g_info_type per_position_extra_info.information_type%type;

1: Package Body GHR_HISTORY_FETCH as
2: /* $Header: ghhisfet.pkb 120.6.12010000.1 2008/07/28 10:31:27 appldev ship $ */
3: -- Global Constant
4: c_not_found varchar2(30):='not_found';
5: g_info_type per_position_extra_info.information_type%type;
6:
7: Procedure Traverse(
8: p_pa_history_id in number,
9: p_root_pa_request_id in number,

Line 1217: -- Procedure fetches the last record from per_position_extra_info or

1213: end if;
1214: end if;
1215: End;
1216: --
1217: -- Procedure fetches the last record from per_position_extra_info or
1218: -- ghr_position_extra_info_h_v
1219: --
1220: Procedure fetch_positionei (
1221: p_position_extra_info_id in number default null,

Line 1228: p_posei_data out nocopy per_position_extra_info%rowtype,

1224: p_noa_id_corrected in number default null,
1225: p_rowid in rowid default null,
1226: p_pa_history_id in number default null,
1227: p_get_ovn_flag in varchar2 default 'N',
1228: p_posei_data out nocopy per_position_extra_info%rowtype,
1229: p_result_code out nocopy varchar2 ) is
1230:
1231: cursor per_posei_rowid_cursor is
1232: select *

Line 1233: from per_position_extra_info

1229: p_result_code out nocopy varchar2 ) is
1230:
1231: cursor per_posei_rowid_cursor is
1232: select *
1233: from per_position_extra_info
1234: where rowid = p_rowid;
1235:
1236: cursor c_get_ovn is
1237: select object_version_number

Line 1238: from per_position_extra_info

1234: where rowid = p_rowid;
1235:
1236: cursor c_get_ovn is
1237: select object_version_number
1238: from per_position_extra_info
1239: where position_extra_info_id = p_position_extra_info_id;
1240:
1241: l_result_code varchar2(30);
1242: l_posei_data per_position_extra_info%rowtype;

Line 1242: l_posei_data per_position_extra_info%rowtype;

1238: from per_position_extra_info
1239: where position_extra_info_id = p_position_extra_info_id;
1240:
1241: l_result_code varchar2(30);
1242: l_posei_data per_position_extra_info%rowtype;
1243: l_hist_data ghr_pa_history%rowtype;
1244: l_proc varchar2(30):='fetch_positionei';
1245:
1246: Begin

Line 1635: p_pos_ei_data out nocopy per_position_extra_info%rowtype

1631:
1632: Procedure fetch_positionei(p_position_id in number,
1633: p_information_type in varchar2,
1634: p_date_effective in date,
1635: p_pos_ei_data out nocopy per_position_extra_info%rowtype
1636: )
1637: is
1638: l_proc varchar2(72) := 'Fetch_positionei (2)';
1639: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;

Line 1643: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

1639: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;
1640: l_pa_history_id ghr_pa_history.pa_history_id%type;
1641: l_max_effective_date date;
1642: l_session ghr_history_api.g_session_var_type;
1643: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
1644: l_result varchar2(20);
1645:
1646:
1647: cursor c_extra_info_id is

Line 1649: from per_position_extra_info ghr_pos

1645:
1646:
1647: cursor c_extra_info_id is
1648: select ghr_pos.position_extra_info_id
1649: from per_position_extra_info ghr_pos
1650: where ghr_pos.position_id = p_position_id
1651: and ghr_pos.information_type = p_information_type;
1652:
1653: Begin

Line 2423: r_poi per_position_extra_info%rowtype;

2419: ,p_creation_date out nocopy date
2420: ,p_result_code out nocopy varchar2
2421: )
2422: Is
2423: r_poi per_position_extra_info%rowtype;
2424: l_proc varchar2(30):='fetch_positionei (1)';
2425: l_result_code varchar2(30);
2426: Begin
2427: hr_utility.set_location('Entering :' || l_proc, 10);