1 PACKAGE PER_TIME_PERIODS_PKG AUTHID CURRENT_USER as
2 /* $Header: pytpe01t.pkh 120.1 2005/10/04 23:06:28 pgongada noship $ */
3 --
4 /*===========================================================================+
5 | Copyright (c) 1993 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +============================================================================+
9 Name
10 per_time_periods_pkg
11 Purpose
12 Supports the TPE block in the form PAYWSDPG (Define Payroll).
13 Notes
14
15 History
16 11-Mar-94 J.S.Hobbs 40.0 Date created.
17 24-Jun-94 J.S.Hobbs 40.1 Added chk_unique_name procedure.
18 31-Jan-95 J.S.Hobbs 40.5 Removed aol WHO columns.
19 09-Jun-99 A.Mills 115.1 Added new Developer Descriptive Flexfield
20 Columns to procedures.
21 30-Apr-05 Rajeesha 115.2 Added new column Payslip_view_date
22 03-Oct-05 pgongada 120.1 Cleared GSCC errors for R12.
23 ============================================================================*/
24 --
25 -----------------------------------------------------------------------------
26 -- Name --
27 -- chk_unique_name --
28 -- Purpose --
29 -- Makes sure the time period name is unique for the calendar. --
30 -- Arguments --
31 -- See below. --
32 -- Notes --
33 -- This is used by PAYWSDCL (Define Budgetary Calendar). --
34 -----------------------------------------------------------------------------
35 --
36 procedure chk_unique_name
37 (
38 p_period_set_name varchar2,
39 p_time_period_id number,
40 p_period_name varchar2
41 );
42 --
43 -----------------------------------------------------------------------------
44 -- Name --
45 -- Insert_Row --
46 -- Purpose --
47 -- Table handler procedure that supports the insert of a time period via --
48 -- the Define Payroll form. --
49 -- Arguments --
50 -- See below. --
51 -- Notes --
52 -- --
53 -- Additions --
54 -- Added new column X_Payslip_view_Date by rajeesha bug 4246280 --
55 -----------------------------------------------------------------------------
56 --
57 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
58 X_Time_Period_Id IN OUT NOCOPY NUMBER,
59 X_Payroll_Id NUMBER,
60 X_End_Date DATE,
61 X_Period_Name VARCHAR2,
62 X_Period_Num NUMBER,
63 X_Period_Type VARCHAR2,
64 X_Start_Date DATE,
65 X_Cut_Off_Date DATE,
66 X_Default_Dd_Date DATE,
67 X_Description VARCHAR2,
68 X_Pay_Advice_Date DATE,
69 X_Period_Set_Name VARCHAR2,
70 X_Period_Year NUMBER,
71 X_Proc_Period_Type VARCHAR2,
72 X_Quarter_Num NUMBER,
73 X_Quickpay_Display_Number NUMBER,
74 X_Regular_Payment_Date DATE,
75 X_Run_Display_Number NUMBER,
76 X_Status VARCHAR2,
77 X_Year_Number NUMBER,
78 X_Attribute_Category VARCHAR2,
79 X_Attribute1 VARCHAR2,
80 X_Attribute2 VARCHAR2,
81 X_Attribute3 VARCHAR2,
82 X_Attribute4 VARCHAR2,
83 X_Attribute5 VARCHAR2,
84 X_Attribute6 VARCHAR2,
85 X_Attribute7 VARCHAR2,
86 X_Attribute8 VARCHAR2,
87 X_Attribute9 VARCHAR2,
88 X_Attribute10 VARCHAR2,
89 X_Attribute11 VARCHAR2,
90 X_Attribute12 VARCHAR2,
91 X_Attribute13 VARCHAR2,
92 X_Attribute14 VARCHAR2,
93 X_Attribute15 VARCHAR2,
94 X_Attribute16 VARCHAR2,
95 X_Attribute17 VARCHAR2,
96 X_Attribute18 VARCHAR2,
97 X_Attribute19 VARCHAR2,
98 X_Attribute20 VARCHAR2,
99 X_Prd_Information_Category VARCHAR2,
100 X_Prd_Information1 VARCHAR2,
101 X_Prd_Information2 VARCHAR2,
102 X_Prd_Information3 VARCHAR2,
103 X_Prd_Information4 VARCHAR2,
104 X_Prd_Information5 VARCHAR2,
105 X_Prd_Information6 VARCHAR2,
106 X_Prd_Information7 VARCHAR2,
107 X_Prd_Information8 VARCHAR2,
108 X_Prd_Information9 VARCHAR2,
109 X_Prd_Information10 VARCHAR2,
110 X_Prd_Information11 VARCHAR2,
111 X_Prd_Information12 VARCHAR2,
112 X_Prd_Information13 VARCHAR2,
113 X_Prd_Information14 VARCHAR2,
114 X_Prd_Information15 VARCHAR2,
115 X_Prd_Information16 VARCHAR2,
116 X_Prd_Information17 VARCHAR2,
117 X_Prd_Information18 VARCHAR2,
118 X_Prd_Information19 VARCHAR2,
119 X_Prd_Information20 VARCHAR2,
120 X_Prd_Information21 VARCHAR2,
121 X_Prd_Information22 VARCHAR2,
122 X_Prd_Information23 VARCHAR2,
123 X_Prd_Information24 VARCHAR2,
124 X_Prd_Information25 VARCHAR2,
125 X_Prd_Information26 VARCHAR2,
126 X_Prd_Information27 VARCHAR2,
127 X_Prd_Information28 VARCHAR2,
128 X_Prd_Information29 VARCHAR2,
129 X_Prd_Information30 VARCHAR2,
130 X_Payslip_view_date DATE DEFAULT NULL
131 );
132 --
133 -----------------------------------------------------------------------------
134 -- Name --
135 -- Lock_Row --
136 -- Purpose --
137 -- Table handler procedure that supports the insert , update and delete --
138 -- of a time period by applying a lock on a time period in the Define --
139 -- Payroll form. --
140 -- Arguments --
141 -- See below. --
142 -- Notes --
143 -- None. --
144 -- Additions --
145 -- Added new column X_Payslip_view_date by rajeesha bug 4246280 --
146 -----------------------------------------------------------------------------
147 --
148 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
149 X_Time_Period_Id NUMBER,
150 X_Payroll_Id NUMBER,
151 X_End_Date DATE,
152 X_Period_Name VARCHAR2,
153 X_Period_Num NUMBER,
154 X_Period_Type VARCHAR2,
155 X_Start_Date DATE,
156 X_Cut_Off_Date DATE,
157 X_Default_Dd_Date DATE,
158 X_Description VARCHAR2,
159 X_Pay_Advice_Date DATE,
160 X_Period_Set_Name VARCHAR2,
161 X_Period_Year NUMBER,
162 X_Proc_Period_Type VARCHAR2,
163 X_Quarter_Num NUMBER,
164 X_Quickpay_Display_Number NUMBER,
165 X_Regular_Payment_Date DATE,
166 X_Run_Display_Number NUMBER,
167 X_Status VARCHAR2,
168 X_Year_Number NUMBER,
169 X_Attribute_Category VARCHAR2,
170 X_Attribute1 VARCHAR2,
171 X_Attribute2 VARCHAR2,
172 X_Attribute3 VARCHAR2,
173 X_Attribute4 VARCHAR2,
174 X_Attribute5 VARCHAR2,
175 X_Attribute6 VARCHAR2,
176 X_Attribute7 VARCHAR2,
177 X_Attribute8 VARCHAR2,
178 X_Attribute9 VARCHAR2,
179 X_Attribute10 VARCHAR2,
180 X_Attribute11 VARCHAR2,
181 X_Attribute12 VARCHAR2,
182 X_Attribute13 VARCHAR2,
183 X_Attribute14 VARCHAR2,
184 X_Attribute15 VARCHAR2,
185 X_Attribute16 VARCHAR2,
186 X_Attribute17 VARCHAR2,
187 X_Attribute18 VARCHAR2,
188 X_Attribute19 VARCHAR2,
189 X_Attribute20 VARCHAR2,
190 X_Prd_Information_Category VARCHAR2,
191 X_Prd_Information1 VARCHAR2,
192 X_Prd_Information2 VARCHAR2,
193 X_Prd_Information3 VARCHAR2,
194 X_Prd_Information4 VARCHAR2,
195 X_Prd_Information5 VARCHAR2,
196 X_Prd_Information6 VARCHAR2,
197 X_Prd_Information7 VARCHAR2,
198 X_Prd_Information8 VARCHAR2,
199 X_Prd_Information9 VARCHAR2,
200 X_Prd_Information10 VARCHAR2,
201 X_Prd_Information11 VARCHAR2,
202 X_Prd_Information12 VARCHAR2,
203 X_Prd_Information13 VARCHAR2,
204 X_Prd_Information14 VARCHAR2,
205 X_Prd_Information15 VARCHAR2,
206 X_Prd_Information16 VARCHAR2,
207 X_Prd_Information17 VARCHAR2,
208 X_Prd_Information18 VARCHAR2,
209 X_Prd_Information19 VARCHAR2,
210 X_Prd_Information20 VARCHAR2,
211 X_Prd_Information21 VARCHAR2,
212 X_Prd_Information22 VARCHAR2,
213 X_Prd_Information23 VARCHAR2,
214 X_Prd_Information24 VARCHAR2,
215 X_Prd_Information25 VARCHAR2,
216 X_Prd_Information26 VARCHAR2,
217 X_Prd_Information27 VARCHAR2,
218 X_Prd_Information28 VARCHAR2,
219 X_Prd_Information29 VARCHAR2,
220 X_Prd_Information30 VARCHAR2,
221 X_payslip_view_date DATE DEFAULT NULL
222 );
223 --
224 -----------------------------------------------------------------------------
225 -- Name --
226 -- Update_Row --
227 -- Purpose --
228 -- Table handler procedure that supports the update of a time period via --
229 -- the Define Payroll form. --
230 -- Arguments --
231 -- See below. --
232 -- Notes --
233 -- None. --
234 -- Additions --
235 -- Added new column X_Payslip_view_date By rajeesha bug 4246280 --
236 -----------------------------------------------------------------------------
237 --
238 PROCEDURE Update_Row(X_Rowid VARCHAR2,
239 X_Time_Period_Id NUMBER,
240 X_Payroll_Id NUMBER,
241 X_End_Date DATE,
242 X_Period_Name VARCHAR2,
243 X_Period_Num NUMBER,
244 X_Period_Type VARCHAR2,
245 X_Start_Date DATE,
246 X_Cut_Off_Date DATE,
247 X_Default_Dd_Date DATE,
248 X_Description VARCHAR2,
249 X_Pay_Advice_Date DATE,
250 X_Period_Set_Name VARCHAR2,
251 X_Period_Year NUMBER,
252 X_Proc_Period_Type VARCHAR2,
253 X_Quarter_Num NUMBER,
254 X_Quickpay_Display_Number NUMBER,
255 X_Regular_Payment_Date DATE,
256 X_Run_Display_Number NUMBER,
257 X_Status VARCHAR2,
258 X_Year_Number NUMBER,
259 X_Attribute_Category VARCHAR2,
260 X_Attribute1 VARCHAR2,
261 X_Attribute2 VARCHAR2,
262 X_Attribute3 VARCHAR2,
263 X_Attribute4 VARCHAR2,
264 X_Attribute5 VARCHAR2,
265 X_Attribute6 VARCHAR2,
266 X_Attribute7 VARCHAR2,
267 X_Attribute8 VARCHAR2,
268 X_Attribute9 VARCHAR2,
269 X_Attribute10 VARCHAR2,
270 X_Attribute11 VARCHAR2,
271 X_Attribute12 VARCHAR2,
272 X_Attribute13 VARCHAR2,
273 X_Attribute14 VARCHAR2,
274 X_Attribute15 VARCHAR2,
275 X_Attribute16 VARCHAR2,
276 X_Attribute17 VARCHAR2,
277 X_Attribute18 VARCHAR2,
278 X_Attribute19 VARCHAR2,
279 X_Attribute20 VARCHAR2,
280 X_Prd_Information_Category VARCHAR2,
281 X_Prd_Information1 VARCHAR2,
282 X_Prd_Information2 VARCHAR2,
283 X_Prd_Information3 VARCHAR2,
284 X_Prd_Information4 VARCHAR2,
285 X_Prd_Information5 VARCHAR2,
286 X_Prd_Information6 VARCHAR2,
287 X_Prd_Information7 VARCHAR2,
288 X_Prd_Information8 VARCHAR2,
289 X_Prd_Information9 VARCHAR2,
290 X_Prd_Information10 VARCHAR2,
291 X_Prd_Information11 VARCHAR2,
292 X_Prd_Information12 VARCHAR2,
293 X_Prd_Information13 VARCHAR2,
294 X_Prd_Information14 VARCHAR2,
295 X_Prd_Information15 VARCHAR2,
296 X_Prd_Information16 VARCHAR2,
297 X_Prd_Information17 VARCHAR2,
298 X_Prd_Information18 VARCHAR2,
299 X_Prd_Information19 VARCHAR2,
300 X_Prd_Information20 VARCHAR2,
301 X_Prd_Information21 VARCHAR2,
302 X_Prd_Information22 VARCHAR2,
303 X_Prd_Information23 VARCHAR2,
304 X_Prd_Information24 VARCHAR2,
305 X_Prd_Information25 VARCHAR2,
306 X_Prd_Information26 VARCHAR2,
307 X_Prd_Information27 VARCHAR2,
308 X_Prd_Information28 VARCHAR2,
309 X_Prd_Information29 VARCHAR2,
310 X_Prd_Information30 VARCHAR2,
311 X_payslip_view_date DATE DEFAULT NULL
312 );
313 --
314 -----------------------------------------------------------------------------
315 -- Name --
316 -- Delete_Row --
317 -- Purpose --
318 -- Table handler procedure that supports the delete of a time period via --
319 -- the Define Payroll form. --
320 -- Arguments --
321 -- See below. --
322 -- Notes --
323 -- --
324 -----------------------------------------------------------------------------
325 --
326 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
327 --
328 ------------------------------------------------------------------------------
329 -- Name --
330 -- Update_Payslip_View_Date --
331 -- Purpose --
332 -- To Update Payslip_view_Date on the basis of Payslip_view_date_offset --
333 -- Arguments --
334 -- see below --
335 -- Notes --
336 -- --
337 ------------------------------------------------------------------------------
338 --
339 PROCEDURE Update_Payslip_View_Date ( P_Payroll_id Number,
340 P_offset Number
341 );
342 --
343 -------------------------------------------------------------------------------
344 END PER_TIME_PERIODS_PKG;
|
|
|