1 PACKAGE pay_ca_group_level_bal_pkg AS
2 /* $Header: pycatxbv.pkh 120.0.12000000.1 2007/01/17 17:39:05 appldev noship $ */
3 --
4 -- Functions/Procedures (see package body for detailed descriptions)
5 --
6 FUNCTION ca_group_level_balance (p_balance_name in VARCHAR2,
7 p_time_dimension in VARCHAR2,
8 p_effective_date in DATE,
9 p_start_date in DATE DEFAULT NULL,
10 p_source_id in NUMBER DEFAULT NULL,
11 p_gre_id in NUMBER DEFAULT NULL,
12 p_jurisdiction in VARCHAR2 DEFAULT NULL,
13 p_organization_id in NUMBER DEFAULT NULL,
14 p_location_id in NUMBER DEFAULT NULL,
15 p_payroll_id in NUMBER DEFAULT NULL,
16 p_pay_basis_type in VARCHAR2 DEFAULT NULL)
17
18 RETURN NUMBER;
19 --
20 --PRAGMA RESTRICT_REFERENCES(ca_group_level_balance, WNDS);
21 --
22 FUNCTION get_defined_balance (p_balance_name VARCHAR2,
23 p_dimension VARCHAR2,
24 p_business_group_id NUMBER DEFAULT NULL)
25 RETURN NUMBER;
26 --
27 PRAGMA RESTRICT_REFERENCES(get_defined_balance, WNDS);
28 --
29 FUNCTION ca_group_level_balance_rb (p_balance_name in VARCHAR2,
30 p_time_dimension in VARCHAR2,
31 p_effective_date in DATE,
32 p_start_date in DATE DEFAULT NULL,
33 p_source_id in NUMBER DEFAULT NULL,
34 p_gre_id in NUMBER DEFAULT NULL,
35 p_jurisdiction in VARCHAR2 DEFAULT NULL,
36 p_organization_id in NUMBER DEFAULT NULL,
37 p_location_id in NUMBER DEFAULT NULL,
38 p_payroll_id in NUMBER DEFAULT NULL,
39 p_pay_basis_type in VARCHAR2 DEFAULT NULL,
40 p_flag in VARCHAR2 DEFAULT 'N')
41
42 RETURN NUMBER;
43 END pay_ca_group_level_bal_pkg;
44 --