[Home] [Help]
PACKAGE: APPS.HR_DIRBAL
Source
1 PACKAGE hr_dirbal AS
2 /* $Header: pydirbal.pkh 120.0.12000000.1 2007/01/17 18:21:39 appldev noship $ */
3 -------------------------------------------------------------------------------
4 -- Date Mode
5 FUNCTION get_balance (p_assignment_id IN NUMBER,
6 p_defined_balance_id IN NUMBER,
7 p_effective_date IN DATE)
8 RETURN NUMBER;
9 -------------------------------------------------------------------------------
10 -- Assignment Action Mode
11 FUNCTION get_balance (p_assignment_action_id IN NUMBER,
12 p_defined_balance_id IN NUMBER)
13 RETURN NUMBER;
14 -------------------------------------------------------------------------------
15 -- This overload function can be used only in PAYGBTPL report in Q_SCON
16 FUNCTION get_balance (p_assignment_action_id IN NUMBER,
17 p_defined_balance_id IN NUMBER,
18 p_dimension_id IN NUMBER,
19 p_period_id IN NUMBER,
20 p_ptd_bal_dim_id IN NUMBER)
21 RETURN NUMBER;
22 -------------------------------------------------------------------------------
23 FUNCTION balance_expired (p_assignment_action_id IN NUMBER,
24 p_owning_action_id IN NUMBER DEFAULT NULL,
25 p_defined_balance_id IN NUMBER,
26 p_database_item_suffix IN VARCHAR2 DEFAULT NULL,
27 p_effective_date IN DATE,
28 p_action_effective_date IN DATE DEFAULT NULL)
29 --
30 RETURN BOOLEAN;
31 PRAGMA RESTRICT_REFERENCES (balance_expired, WNDS);
32 -------------------------------------------------------------------------------
33 FUNCTION start_year_date(p_assignment_action_id IN NUMBER,
34 p_database_item_suffix IN VARCHAR2)
35 --
36 RETURN DATE;
37 PRAGMA RESTRICT_REFERENCES (start_year_date, WNDS);
38 -------------------------------------------------------------------------------
39 FUNCTION expired_year_date(p_action_effective_date IN DATE)
40 --
41 RETURN DATE;
42 PRAGMA RESTRICT_REFERENCES (expired_year_date, WNDS);
43 -------------------------------------------------------------------------------
44 FUNCTION expired_period_date(p_assignment_action_id IN NUMBER)
45 --
46 RETURN DATE;
47 PRAGMA RESTRICT_REFERENCES (expired_period_date, WNDS);
48 -------------------------------------------------------------------------------
49 FUNCTION expired_quarter_date(p_action_effective_date IN DATE)
50 --
51 RETURN DATE;
52 PRAGMA RESTRICT_REFERENCES (expired_quarter_date, WNDS);
53 -------------------------------------------------------------------------------
54 FUNCTION get_action_date(p_assignment_action_id IN NUMBER)
55 RETURN DATE;
56 PRAGMA RESTRICT_REFERENCES (get_action_date, WNDS);
57 -------------------------------------------------------------------------------
58 --
59 END hr_dirbal;