DBA Data[Home] [Help]

PACKAGE: APPS.PQP_CLM_BAL

Source


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;