1 Package PER_POSITION_MAPPING AUTHID CURRENT_USER as
2 -- $Header: perpomap.pkh 115.3 99/10/18 20:41:07 porting shi $
3 function get_position_id
4 ( p_name IN varchar2,
5 p_effective_date IN date )
6 return number;
7
8 function get_position_definition_id
9 ( p_name IN varchar2,
10 p_effective_date IN date )
11 return number;
12
13 function get_prior_position_id
14 ( p_prior_position_name IN varchar2,
15 p_effective_date IN date )
16 return number;
17
18 function get_supervisor_position_id
19 ( p_supervisor_position_name IN varchar2,
20 p_effective_date IN date )
21 return number;
22
23 function get_successor_position_id
24 ( p_successor_position_name IN varchar2,
25 p_effective_date IN date )
26 return number;
27
28 function get_relief_position_id
29 ( p_relief_position_name IN varchar2,
30 p_effective_date IN date )
31 return number;
32
33 function get_AVAILABILITY_STATUS_id (
34 p_shared_type_name varchar2
35 ,p_system_type_cd varchar2
36 ,p_business_group_id number )
37 return number ;
38
39 function get_entry_step_id (
40 p_spinal_point varchar2
41 , p_effective_date date
42 ,p_business_group_id number )
43 return number ;
44
45 function get_pay_freq_payroll_id (
46 p_pay_freq_payroll_name varchar2
47 ,p_business_group_id number )
48 return number ;
49
50 function get_position_ovn
51 ( p_name IN varchar2,
52 p_effective_date IN date )
53 return number ;
54 END;