1 PACKAGE hr_jprts AS
2 /* $Header: pyjprts.pkh 120.1 2005/09/26 19:27:33 ttagawa noship $ */
3 /* ------------------------------------------------------------------------------------ */
4 /* ------------------------------------------------------------------------------------
5 -- Define Global Value, which are parameter values in HR_JP_PARAMETERS.
6 -- HR_JPBAL, HR_JPDRB call them.
7 -- ------------------------------------------------------------------------------------ */
8 g_asg_run PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RUN';
9 g_asg_proc_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_PTD';
10 g_asg_mtd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_MTD EFFECTIVE_DATE 01-01 RESET 12';
11 g_ast_ytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_YTD EFFECTIVE_DATE 01-01 RESET 01';
12 g_asg_fytd_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_FYTD DATE_EARNED RESET 01';
13 g_asg_aug2jul_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_AUGTD EFFECTIVE_DATE 01-08 RESET 01';
14 g_asg_jul2jun_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_JULTD EFFECTIVE_DATE 01-07 RESET 01';
15 g_retro PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_RETRO_RUN';
16 g_asg_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_LTD';
17 g_element_itd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_LTD';
18 g_element_ptd PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ELM_PTD';
19 g_payment PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_PAYMENTS';
20 g_asg_fytd2_jp PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE := '_ASG_BYTD';
21 /* ------------------------------------------------------------------------------------ */
22 FUNCTION span_start(
23 p_input_date IN DATE,
24 p_frequency IN NUMBER,
25 p_start_dd_mm IN VARCHAR2)
26 RETURN date ;
27 -- PRAGMA RESTRICT_REFERENCES (span_start, WNDS, WNPS);
28 /* ------------------------------------------------------------------------------------ */
29 FUNCTION span_end(
30 p_input_date IN DATE,
31 p_frequency IN NUMBER,
32 p_end_dd_mm IN VARCHAR2)
33 RETURN date ;
34 -- PRAGMA RESTRICT_REFERENCES (span_end, WNDS, WNPS);
35 /* ------------------------------------------------------------------------------------ */
36 FUNCTION span_start_fisical_year(
37 p_input_date IN DATE,
38 p_business_group_id NUMBER
39 )
40 RETURN date;
41 -- PRAGMA RESTRICT_REFERENCES (span_start_fisical_year, WNDS, WNPS);
42 /* ------------------------------------------------------------------------------------ */
43 FUNCTION span_end_fisical_year(
44 p_input_date IN DATE,
45 p_business_group_id NUMBER
46 )
47 RETURN date;
48 -- PRAGMA RESTRICT_REFERENCES (span_end_fisical_year, WNDS, WNPS);
49 /* ------------------------------------------------------------------------------------ */
50 -- what is the latest reset date for a particular dimension
51 FUNCTION dimension_reset_date(
52 p_dimension_name IN VARCHAR2,
53 p_user_date IN DATE)
54 RETURN date;
55 -- PRAGMA RESTRICT_REFERENCES (dimension_reset_date, WNDS, WNPS);
56 /* ------------------------------------------------------------------------------------ */
57 -- what is the latest reset last date for a particular dimension
58 FUNCTION dimension_reset_last_date(
59 p_dimension_name IN VARCHAR2,
60 p_user_date IN DATE)
61 RETURN date;
62 -- PRAGMA RESTRICT_REFERENCES (dimension_reset_last_date, WNDS, WNPS);
63 /* ------------------------------------------------------------------------------------ */
64 FUNCTION dimension_reset_date_userdef(
65 p_dimension_name IN VARCHAR2,
66 p_user_date IN DATE,
67 p_storage_type IN VARCHAR2, -- ('FLEX' for Org.Developer,
68 -- 'GLOBAL' for Global Value)
69 p_storage_name IN VARCHAR2,
70 p_business_group_id NUMBER
71 )
72 RETURN date;
73 -- PRAGMA RESTRICT_REFERENCES (dimension_reset_date_userdef, WNDS, WNPS);
74 /* ------------------------------------------------------------------------------------ */
75 FUNCTION dim_reset_last_date_userdef(
76 p_dimension_name IN VARCHAR2,
77 p_user_date IN DATE,
78 p_storage_type IN VARCHAR2, -- ('FLEX' for Org.Developer,
79 -- 'GLOBAL' for Global Value)
80 p_storage_name IN VARCHAR2,
81 p_business_group_id NUMBER
82 )
83 RETURN date;
84 -- PRAGMA RESTRICT_REFERENCES (dim_reset_last_date_userdef, WNDS, WNPS);
85 /* ------------------------------------------------------------------------------------ */
86 FUNCTION calc_bal_date_earned(
87 p_assignment_id IN NUMBER,
88 p_balance_type_id IN NUMBER, -- balance
89 p_from_date IN DATE, -- since effective date of
90 p_to_date IN DATE, -- sum up to this date
91 p_action_sequence IN NUMBER) -- sum up to this sequence
92 RETURN NUMBER;
93 -- PRAGMA RESTRICT_REFERENCES (calc_bal_date_earned, WNDS, WNPS);
94 --
95 -- This procedure is no more used since pay_balance_pkg.get_value work this logic instead.
96 -- Blank out by keyazawa for bug.
97 --/* ------------------------------------------------------------------------------------ */
98 -- FUNCTION calc_bal_bue(
99 -- p_assignment_id IN NUMBER,
100 -- p_balance_type_id IN NUMBER, -- balance
101 -- p_from_date IN DATE, -- since effective date of
102 -- p_to_date IN DATE) -- sum up to this date
103 -- RETURN NUMBER;
104 -- PRAGMA RESTRICT_REFERENCES (calc_bal_bue, WNDS, WNPS);
105 /* ------------------------------------------------------------------------------------ */
106 FUNCTION calc_bal_eff_date(
107 p_assignment_id IN NUMBER,
108 p_balance_type_id IN NUMBER, -- balance
109 p_from_date IN DATE, -- since effective date of
110 p_to_date IN DATE, -- sum up to this date
111 p_action_sequence IN NUMBER) -- sum up to this sequence
112 RETURN NUMBER;
113 -- PRAGMA RESTRICT_REFERENCES (calc_bal_eff_date, WNDS, WNPS);
114 --
115 -- This procedure is no more used since pay_balance_pkg.get_value work this logic instead.
116 -- Blank out by keyazawa for bug.
117 --/* ------------------------------------------------------------------------------------ */
118 -- FUNCTION asg_mtd_jp(
119 -- p_assignment_action_id IN NUMBER,
120 -- p_balance_type_id IN NUMBER) -- balance
121 ---- p_dimension_name IN VARCHAR2)
122 -- RETURN NUMBER;
123 -- PRAGMA RESTRICT_REFERENCES (asg_mtd_jp, WNDS, WNPS);
124 --
125 --
126 -- This procedure is no more used since pay_balance_pkg.get_value work this logic instead.
127 -- Blank out by keyazawa for bug.
128 --/* ------------------------------------------------------------------------------------ */
129 -- FUNCTION asg_ytd_jp(
130 -- p_assignment_action_id IN NUMBER,
131 -- p_balance_type_id IN NUMBER) -- balance
132 ---- p_dimension_name IN VARCHAR2)
133 -- RETURN NUMBER;
134 -- PRAGMA RESTRICT_REFERENCES (asg_ytd_jp, WNDS, WNPS);
135 /* ------------------------------------------------------------------------------------ */
136 FUNCTION asg_fytd_jp(
137 p_assignment_action_id IN NUMBER,
138 p_balance_type_id IN NUMBER) -- balance
139 -- p_dimension_name IN VARCHAR2)
140 RETURN NUMBER;
141 -- PRAGMA RESTRICT_REFERENCES (asg_fytd_jp, WNDS, WNPS);
142 --
143 --
144 -- This procedure is no more used since pay_balance_pkg.get_value work this logic instead.
145 -- Blank out by keyazawa for bug.
146 --/* ------------------------------------------------------------------------------------ */
147 -- FUNCTION asg_aug2jul_jp(
148 -- p_assignment_action_id IN NUMBER,
149 -- p_balance_type_id IN NUMBER) -- balance
150 ---- p_dimension_name IN VARCHAR2)
151 -- RETURN NUMBER;
152 -- PRAGMA RESTRICT_REFERENCES (asg_aug2jul_jp, WNDS, WNPS);
153 /* ------------------------------------------------------------------------------------ */
154 FUNCTION retro_jp(
155 p_assignment_action_id IN NUMBER,
156 p_balance_type_id IN NUMBER) -- balance
157 RETURN NUMBER;
158 -- PRAGMA RESTRICT_REFERENCES (retro_jp, WNDS, WNPS);
159 /* ------------------------------------------------------------------------------------ */
160 --
161 END hr_jprts;