1 Package PQP_CLM_BAL AUTHID CURRENT_USER as
2 /* $Header: pqpvmbal.pkh 115.1 2003/06/16 13:38:34 jcpereir noship $*/
3
4 FUNCTION get_vehicletype_balance
5 (p_assignment_id IN number
6 ,p_business_group_id IN number
7 ,p_vehicle_type IN varchar2
8 ,p_ownership IN varchar2
9 ,p_usage_type IN varchar2
10 ,p_balance_name IN varchar2
11 ,p_element_entry_id IN NUMBER
12 ,p_assignment_action_id IN NUMBER
13 ) RETURN NUMBER;
14
15
16 FUNCTION get_balance_value
17 (p_element_name IN VARCHAR2
18 ,p_assignment_action_id IN NUMBER
19 ,p_element_entry_id IN NUMBER
20 ,p_business_group_id IN NUMBER
21 ,p_payroll_action_id IN NUMBER
22 ,p_balance_name IN VARCHAR2
23 ) RETURN NUMBER;
24
25 TYPE r_balance_cache is Record
26 ( balance_name VARCHAR2(80)
27 ,balance_type_id NUMBER
28 );
29
30 TYPE t_balance_cache is Table of r_balance_cache
31 INDEX BY binary_integer;
32
33 g_balance_cache t_balance_cache;
34
35 end pqp_clm_bal;