DBA Data[Home] [Help]

APPS.GHR_SF52_VALIDN_PKG dependencies on PER_POSITIONS

Line 226: (p_to_position_id in per_positions.position_id%type

222: -- ---------------------------------------------------------------------------
223: --
224:
225: procedure chk_position_title_seq_desc
226: (p_to_position_id in per_positions.position_id%type
227: ,p_to_position_title in ghr_pa_requests.to_position_title%type
228: ,p_to_position_number in ghr_pa_requests.to_position_number%type
229: ,p_to_position_seq_no in ghr_pa_requests.to_position_seq_no%type
230: ,p_effective_date in date default sysdate

Line 233: l_bgp_id per_positions.business_group_id%type;

229: ,p_to_position_seq_no in ghr_pa_requests.to_position_seq_no%type
230: ,p_effective_date in date default sysdate
231: )
232: is
233: l_bgp_id per_positions.business_group_id%type;
234: l_title ghr_pa_requests.to_position_title%type;
235: l_desc_no varchar2(150);
236: l_seq_no number;
237: l_proc varchar2(72) := g_package ||'chk_position_title_seq_desc' ;