APPS.GHR_HISTORY_FETCH dependencies on PER_POSITION_EXTRA_INFO

Line 6: --g_info_type per_position_extra_info.information_type%type;

2: /* $Header: ghhisfet.pkb 120.16.12020000.4 2012/12/27 10:27:40 vmididho ship $ */
3: -- Global Constant
4: c_not_found varchar2(30):='not_found';
5: --made the declaration in header
6: --g_info_type per_position_extra_info.information_type%type;
7:
8: Procedure Traverse(
9: p_pa_history_id in number,
10: p_root_pa_request_id in number,

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

1281: end if;
1282: end if;
1283: End;
1284: --
1285: -- Procedure fetches the last record from per_position_extra_info or
1286: -- ghr_position_extra_info_h_v
1287: --
1288: Procedure fetch_positionei (
1289: p_position_extra_info_id in number default null,

Line 1296: p_posei_data out nocopy per_position_extra_info%rowtype,

1292: p_noa_id_corrected in number default null,
1293: p_rowid in rowid default null,
1294: p_pa_history_id in number default null,
1295: p_get_ovn_flag in varchar2 default 'N',
1296: p_posei_data out nocopy per_position_extra_info%rowtype,
1297: p_result_code out nocopy varchar2 ) is
1298:
1299: cursor per_posei_rowid_cursor is
1300: select *

Line 1301: from per_position_extra_info

1297: p_result_code out nocopy varchar2 ) is
1298:
1299: cursor per_posei_rowid_cursor is
1300: select *
1301: from per_position_extra_info
1302: where rowid = p_rowid;
1303:
1304: cursor c_get_ovn is
1305: select object_version_number

Line 1306: from per_position_extra_info

1302: where rowid = p_rowid;
1303:
1304: cursor c_get_ovn is
1305: select object_version_number
1306: from per_position_extra_info
1307: where position_extra_info_id = p_position_extra_info_id;
1308:
1309: l_result_code varchar2(30);
1310: l_posei_data per_position_extra_info%rowtype;

Line 1310: l_posei_data per_position_extra_info%rowtype;

1306: from per_position_extra_info
1307: where position_extra_info_id = p_position_extra_info_id;
1308:
1309: l_result_code varchar2(30);
1310: l_posei_data per_position_extra_info%rowtype;
1311: l_hist_data ghr_pa_history%rowtype;
1312: l_proc varchar2(30):='fetch_positionei';
1313:
1314: Begin

Line 1730: p_pos_ei_data out nocopy per_position_extra_info%rowtype

1726:
1727: Procedure fetch_positionei(p_position_id in number,
1728: p_information_type in varchar2,
1729: p_date_effective in date,
1730: p_pos_ei_data out nocopy per_position_extra_info%rowtype
1731: )
1732: is
1733: l_proc varchar2(72) := 'Fetch_positionei (2)';
1734: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;

Line 1738: l_extra_info_id per_position_extra_info.position_extra_info_id%type;

1734: l_pos_ei_data ghr_position_extra_info_h_v%rowtype;
1735: l_pa_history_id ghr_pa_history.pa_history_id%type;
1736: l_max_effective_date date;
1737: l_session ghr_history_api.g_session_var_type;
1738: l_extra_info_id per_position_extra_info.position_extra_info_id%type;
1739: l_result varchar2(20);
1740:
1741:
1742: cursor c_extra_info_id is

Line 1744: from per_position_extra_info ghr_pos

1740:
1741:
1742: cursor c_extra_info_id is
1743: select ghr_pos.position_extra_info_id
1744: from per_position_extra_info ghr_pos
1745: where ghr_pos.position_id = p_position_id
1746: and ghr_pos.information_type = p_information_type;
1747:
1748: Begin

Line 2523: r_poi per_position_extra_info%rowtype;

2519: ,p_creation_date out nocopy date
2520: ,p_result_code out nocopy varchar2
2521: )
2522: Is
2523: r_poi per_position_extra_info%rowtype;
2524: l_proc varchar2(30):='fetch_positionei (1)';
2525: l_result_code varchar2(30);
2526: Begin
2527: hr_utility.set_location('Entering :' || l_proc, 10);