[Home] [Help]
PACKAGE: APPS.HR_JPDRB
Source
1 PACKAGE hr_jpdrb AUTHID CURRENT_USER AS
2 /* $Header: pyjpdrb.pkh 115.4 2004/05/14 02:48:47 keyazawa ship $ */
3 /* ------------------------------------------------------------------------------------ */
4 --Cached variables
5 cached_rows NUMBER := 0;
6 cached_assignment_id NUMBER := 0;
7 --
8 TYPE CachedTable IS TABLE OF NUMBER
9 INDEX BY BINARY_INTEGER;
10 --
11 TYPE CachedDateTable IS TABLE OF DATE
12 INDEX BY BINARY_INTEGER;
13 --
14 cached_defined_balances CachedTable;
15 cached_values CachedTable;
16 cached_assignment_actions CachedTable;
17 cached_expired_actions CachedTable;
18 cached_expired_values CachedTable;
19 cached_action_sequences CachedTable;
20 cached_assignments CachedTable;
21 cached_effective_dates CachedDateTable;
22
23 --
24 -- Date Mode
25 FUNCTION get_balance (p_assignment_id IN NUMBER,
26 p_defined_balance_id IN NUMBER,
27 p_effective_date IN DATE)
28 RETURN NUMBER;
29 /* ------------------------------------------------------------------------------------ */
30 -- Assignment Action Mode
31 FUNCTION get_balance (p_assignment_action_id IN NUMBER,
32 p_defined_balance_id IN NUMBER)
33 RETURN NUMBER;
34 /* ------------------------------------------------------------------------------------ */
35 FUNCTION balance_expired (p_assignment_action_id IN NUMBER,
36 p_defined_balance_id IN NUMBER,
37 p_dimension_name IN VARCHAR2,
38 p_effective_date IN DATE,
39 p_action_effective_date IN DATE)
40 --
41 RETURN BOOLEAN;
42 /* ------------------------------------------------------------------------------------ */
43 FUNCTION expired_period_date(p_assignment_action_id IN NUMBER)
44 --
45 RETURN DATE;
46 --
47 /* ------------------------------------------------------------------------------------ */
48 FUNCTION get_action_date(p_assignment_action_id IN NUMBER)
49 RETURN DATE;
50 /* ------------------------------------------------------------------------------------ */
51 --
52 END hr_jpdrb;