PACKAGE: APPS.HR_DIRBAL

Source

1 PACKAGE hr_dirbal AUTHID CURRENT_USER 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;