1 package pay_kr_dim_pkg as
2 /* $Header: pykrdim.pkh 120.0.12010000.4 2008/08/06 07:39:23 ubhat ship $ */
3
4 --------------------------------------------------------------------------------
5 procedure ptd_ec(
6 p_owner_payroll_action_id in number, -- run created balance.
7 p_user_payroll_action_id in number, -- current run.
8 p_owner_assignment_action_id in number, -- assact created balance.
9 p_user_assignment_action_id in number, -- current assact.
10 p_owner_effective_date in date, -- eff date of balance.
11 p_user_effective_date in date, -- eff date of current run.
12 p_dimension_name in varchar2, -- balance dimension name.
13 p_expiry_information out nocopy number); -- dimension expired flag.
14 --------------------------------------------------------------------------------
15 -- Overloaded procedure ptd_ec for bug 2815428
16 --
17 procedure ptd_ec(
18 p_owner_payroll_action_id in number, -- run created balance.
19 p_user_payroll_action_id in number, -- current run.
20 p_owner_assignment_action_id in number, -- assact created balance.
21 p_user_assignment_action_id in number, -- current assact.
22 p_owner_effective_date in date, -- eff date of balance.
23 p_user_effective_date in date, -- eff date of current run.
24 p_dimension_name in varchar2, -- balance dimension name.
25 p_expiry_information out nocopy date); -- dimension expired date.
26
27 --------------------------------------------------------------------------------
28 procedure mtd_ec(
29 p_owner_payroll_action_id in number, -- run created balance.
30 p_user_payroll_action_id in number, -- current run.
31 p_owner_assignment_action_id in number, -- assact created balance.
32 p_user_assignment_action_id in number, -- current assact.
33 p_owner_effective_date in date, -- eff date of balance.
34 p_user_effective_date in date, -- eff date of current run.
35 p_dimension_name in varchar2, -- balance dimension name.
36 p_expiry_information out nocopy number); -- dimension expired flag.
37 --------------------------------------------------------------------------------
38 -- Overloaded procedure mtd_ec for bug 2815428
39 --
40 procedure mtd_ec(
41 p_owner_payroll_action_id in number, -- run created balance.
42 p_user_payroll_action_id in number, -- current run.
43 p_owner_assignment_action_id in number, -- assact created balance.
44 p_user_assignment_action_id in number, -- current assact.
45 p_owner_effective_date in date, -- eff date of balance.
46 p_user_effective_date in date, -- eff date of current run.
47 p_dimension_name in varchar2, -- balance dimension name.
48 p_expiry_information out nocopy date); -- dimension expired date.
49
50 --------------------------------------------------------------------------------
51 procedure qtd_ec(
52 p_owner_payroll_action_id in number, -- run created balance.
53 p_user_payroll_action_id in number, -- current run.
54 p_owner_assignment_action_id in number, -- assact created balance.
55 p_user_assignment_action_id in number, -- current assact.
56 p_owner_effective_date in date, -- eff date of balance.
57 p_user_effective_date in date, -- eff date of current run.
58 p_dimension_name in varchar2, -- balance dimension name.
59 p_expiry_information out nocopy number); -- dimension expired flag.
60 --------------------------------------------------------------------------------
61 -- Overloaded procedure qtd_ec for bug 2815428
62 --
63 procedure qtd_ec(
64 p_owner_payroll_action_id in number, -- run created balance.
65 p_user_payroll_action_id in number, -- current run.
66 p_owner_assignment_action_id in number, -- assact created balance.
67 p_user_assignment_action_id in number, -- current assact.
68 p_owner_effective_date in date, -- eff date of balance.
69 p_user_effective_date in date, -- eff date of current run.
70 p_dimension_name in varchar2, -- balance dimension name.
71 p_expiry_information out nocopy date); -- dimension expired date.
72
73 --------------------------------------------------------------------------------
74 procedure ytd_ec(
75 p_owner_payroll_action_id in number, -- run created balance.
76 p_user_payroll_action_id in number, -- current run.
77 p_owner_assignment_action_id in number, -- assact created balance.
78 p_user_assignment_action_id in number, -- current assact.
79 p_owner_effective_date in date, -- eff date of balance.
80 p_user_effective_date in date, -- eff date of current run.
81 p_dimension_name in varchar2, -- balance dimension name.
82 p_expiry_information out nocopy number); -- dimension expired flag.
83 --------------------------------------------------------------------------------
84 -- Overloaded procedure ytd_ec for bug 2815428
85 --
86 procedure ytd_ec(
87 p_owner_payroll_action_id in number, -- run created balance.
88 p_user_payroll_action_id in number, -- current run.
89 p_owner_assignment_action_id in number, -- assact created balance.
90 p_user_assignment_action_id in number, -- current assact.
91 p_owner_effective_date in date, -- eff date of balance.
92 p_user_effective_date in date, -- eff date of current run.
93 p_dimension_name in varchar2, -- balance dimension name.
94 p_expiry_information out nocopy date); -- dimension expired date.
95
96
97 /* Bug 6263815 - Adding expiry checking code for _itd dimension */
98 --------------------------------------------------------------------------------
99 procedure itd_ec(
100 p_owner_payroll_action_id in number, -- run created balance.
101 p_user_payroll_action_id in number, -- current run.
102 p_owner_assignment_action_id in number, -- assact created balance.
103 p_user_assignment_action_id in number, -- current assact.
104 p_owner_effective_date in date, -- eff date of balance.
105 p_user_effective_date in date, -- eff date of current run.
106 p_dimension_name in varchar2, -- balance dimension name.
107 p_expiry_information out NOCOPY number); -- dimension expired flag.
108
109 --------------------------------------------------------------------------------
110 procedure itd_ec(
111 p_owner_payroll_action_id in number, -- run created balance.
112 p_user_payroll_action_id in number, -- current run.
113 p_owner_assignment_action_id in number, -- assact created balance.
114 p_user_assignment_action_id in number, -- current assact.
115 p_owner_effective_date in date, -- eff date of balance.
116 p_user_effective_date in date, -- eff date of current run.
117 p_dimension_name in varchar2, -- balance dimension name.
118 p_expiry_information out NOCOPY date); -- dimension expired date.
119
120 --------------------------------------------------------------------------------
121 procedure fqtd_ec(
122 p_owner_payroll_action_id in number, -- run created balance.
123 p_user_payroll_action_id in number, -- current run.
124 p_owner_assignment_action_id in number, -- assact created balance.
125 p_user_assignment_action_id in number, -- current assact.
126 p_owner_effective_date in date, -- eff date of balance.
127 p_user_effective_date in date, -- eff date of current run.
128 p_dimension_name in varchar2, -- balance dimension name.
129 p_expiry_information out nocopy number); -- dimension expired flag.
130 --------------------------------------------------------------------------------
131 -- Overloaded procedure fqtd_ec for bug 2815428
132 --
133 procedure fqtd_ec(
134 p_owner_payroll_action_id in number, -- run created balance.
135 p_user_payroll_action_id in number, -- current run.
136 p_owner_assignment_action_id in number, -- assact created balance.
137 p_user_assignment_action_id in number, -- current assact.
138 p_owner_effective_date in date, -- eff date of balance.
139 p_user_effective_date in date, -- eff date of current run.
140 p_dimension_name in varchar2, -- balance dimension name.
141 p_expiry_information out nocopy date); -- dimension expired date.
142 --------------------------------------------------------------------------------
143 procedure fytd_ec(
144 p_owner_payroll_action_id in number, -- run created balance.
145 p_user_payroll_action_id in number, -- current run.
146 p_owner_assignment_action_id in number, -- assact created balance.
147 p_user_assignment_action_id in number, -- current assact.
148 p_owner_effective_date in date, -- eff date of balance.
149 p_user_effective_date in date, -- eff date of current run.
150 p_dimension_name in varchar2, -- balance dimension name.
151 p_expiry_information out nocopy number); -- dimension expired flag.
152 --------------------------------------------------------------------------------
153 -- Overloaded procedure fytd_ec for bug 2815428
154 --
155 procedure fytd_ec(
156 p_owner_payroll_action_id in number, -- run created balance.
157 p_user_payroll_action_id in number, -- current run.
158 p_owner_assignment_action_id in number, -- assact created balance.
159 p_user_assignment_action_id in number, -- current assact.
160 p_owner_effective_date in date, -- eff date of balance.
161 p_user_effective_date in date, -- eff date of current run.
162 p_dimension_name in varchar2, -- balance dimension name.
163 p_expiry_information out nocopy date); -- dimension expired date.
164
165 --------------------------------------------------------------------------------
166 procedure hdtd_ec(
167 p_owner_payroll_action_id in number, -- run created balance.
168 p_user_payroll_action_id in number, -- current run.
169 p_owner_assignment_action_id in number, -- assact created balance.
170 p_user_assignment_action_id in number, -- current assact.
171 p_owner_effective_date in date, -- eff date of balance.
172 p_user_effective_date in date, -- eff date of current run.
173 p_dimension_name in varchar2, -- balance dimension name.
174 p_balance_context_values in varchar2, -- list of context value
175 p_expiry_information out nocopy number); -- dimension expired flag.
176 --------------------------------------------------------------------------------
177 -- Overloaded procedure hdtd_ec for bug 2815428
178 --
179 procedure hdtd_ec(
180 p_owner_payroll_action_id in number, -- run created balance.
181 p_user_payroll_action_id in number, -- current run.
182 p_owner_assignment_action_id in number, -- assact created balance.
183 p_user_assignment_action_id in number, -- current assact.
184 p_owner_effective_date in date, -- eff date of balance.
185 p_user_effective_date in date, -- eff date of current run.
186 p_dimension_name in varchar2, -- balance dimension name.
187 p_balance_context_values in varchar2, -- list of context value
188 p_expiry_information out nocopy date); -- dimension expired date.
189 --------------------------------------------------------------------------------
190
191 /*
192 procedure gen_fc(
193 p_payroll_action_id in number,
194 p_assignment_action_id in number,
195 p_assignment_id in number,
196 p_effective_date in date,
197 p_dimension_name in varchar2,
198 p_balance_contexts in varchar2,
199 p_feed_flag in out nocopy number);
200 */
201 --------------------------------------------------------------------------------
202 procedure bptd_fc(
203 p_payroll_action_id in number,
204 p_assignment_action_id in number,
205 p_assignment_id in number,
206 p_effective_date in date,
207 p_dimension_name in varchar2,
208 p_balance_contexts in varchar2,
209 p_feed_flag in out nocopy number);
210 --------------------------------------------------------------------------------
211 procedure mth_fc(
212 p_payroll_action_id in number,
213 p_assignment_action_id in number,
214 p_assignment_id in number,
215 p_effective_date in date,
216 p_dimension_name in varchar2,
217 p_balance_contexts in varchar2,
218 p_feed_flag in out nocopy number);
219 --------------------------------------------------------------------------------
220 procedure bon_fc(
221 p_payroll_action_id in number,
222 p_assignment_action_id in number,
223 p_assignment_id in number,
224 p_effective_date in date,
225 p_dimension_name in varchar2,
226 p_balance_contexts in varchar2,
227 p_feed_flag in out nocopy number);
228 --------------------------------------------------------------------------------
229 procedure sep_fc(
230 p_payroll_action_id in number,
231 p_assignment_action_id in number,
232 p_assignment_id in number,
233 p_effective_date in date,
234 p_dimension_name in varchar2,
235 p_balance_contexts in varchar2,
236 p_feed_flag in out nocopy number);
237 --------------------------------------------------------------------------------
238 function bonus_period_start_date(
239 p_payroll_id in number,
240 p_effective_date in date,
241 p_assignment_set_id in number,
242 p_run_type_id in number) return date;
243 --------------------------------------------------------------------------------
244 function bonus_period_start_date(
245 p_assignment_action_id in number,
246 p_payroll_action_id in number) return date;
247 --------------------------------------------------------------------------------
248
249 Function inc_or_exc_assact (
250 p_bal_asact in pay_assignment_actions.assignment_action_id%type
251 ,p_asact in pay_assignment_actions.assignment_action_id%type
252 ,p_bal_asact_rtype_name in pay_run_types_f.run_type_name%type
253 ,p_asact_rtype_name in pay_run_types_f.run_type_name%type ) return varchar2 ;
254
255 --------------------------------------------------------------------------------
256
257 PROCEDURE hdtd_start_date(
258 p_effective_date IN DATE ,
259 p_start_date OUT NOCOPY DATE,
260 p_payroll_id IN NUMBER DEFAULT NULL,
261 p_bus_grp IN NUMBER DEFAULT NULL,
262 p_asg_action IN NUMBER DEFAULT NULL);
263 --------------------------------------------------------------------------
264 end pay_kr_dim_pkg;