1 Package pqh_reallocation_pkg AUTHID CURRENT_USER as
2 /* $Header: pqrealoc.pkh 115.6 2004/04/20 09:53:13 hsajja noship $ */
3 --
4 --
5 --
6 function get_reallocation(p_position_id in number default null
7 ,p_job_id in number default null
8 ,p_grade_id in number default null
9 ,p_organization_id in number default null
10 ,p_budget_entity in varchar2 default 'POSITION'
11 ,p_start_date in date default sysdate
12 ,p_end_date in date default sysdate
13 ,p_effective_date in date default sysdate
14 ,p_system_budget_unit in varchar2
15 ,p_business_group_id in number
16 ) return number;
17 function get_reallocated_money(p_position_id in number
18 ,p_business_group_id in number
19 ,p_type in varchar2 default 'DNTD'
20 ,p_start_date in date default sysdate
21 ,p_end_date in date default sysdate
22 ,p_effective_date in date default sysdate) return number ;
23 end;