DBA Data[Home] [Help]

APPS.GHR_HISTORY_FETCH dependencies on PER_POSITION_EXTRA_INFO

Line 4: g_info_type per_position_extra_info.information_type%type := NULL;

1: package GHR_HISTORY_FETCH AUTHID CURRENT_USER as
2: /* $Header: ghhisfet.pkh 120.3.12020000.1 2012/06/29 04:17:04 appldev ship $ */
3:
4: g_info_type per_position_extra_info.information_type%type := NULL;
5: g_cascad_eff_date ghr_pa_history.effective_date%type;
6:
7: Procedure fetch_people (
8: p_person_id in number default null,

Line 76: p_posei_data out nocopy per_position_extra_info%rowtype,

72: p_noa_id_corrected in number default null,
73: p_rowid in rowid default null,
74: p_pa_history_id in number default null,
75: p_get_ovn_flag in varchar2 default 'N',
76: p_posei_data out nocopy per_position_extra_info%rowtype,
77: p_result_code out nocopy varchar2 ) ;
78:
79: Procedure fetch_positionei(
80: p_position_id in number,

Line 83: p_pos_ei_data out nocopy per_position_extra_info%rowtype

79: Procedure fetch_positionei(
80: p_position_id in number,
81: p_information_type in varchar2,
82: p_date_effective in date,
83: p_pos_ei_data out nocopy per_position_extra_info%rowtype
84: ) ;
85:
86: Procedure fetch_position (
87: p_position_id in number default null,