[Home] [Help]
PACKAGE BODY: APPS.CSF_MAP_ACC_HRS_PKG
Source
1 PACKAGE BODY CSF_MAP_ACC_HRS_PKG as
2 /* $Header: csfmaccb.pls 120.3 2011/05/25 12:44:12 shadas ship $ */
3
4
5 PROCEDURE Query_Row(
6 p_customer_id in number,
7 p_customer_site_id in number,
8 p_customer_location_id in number,
9 x_access_hours out nocopy access_hours_rec) is
10 cursor c_access_hours(c_customer_id number,
11 c_customer_site_id number,
12 c_customer_location_id number) is
13 select ACCESS_HOUR_MAP_ID,
14 CUSTOMER_ID,
15 CUSTOMER_SITE_ID,
16 CUSTOMER_LOCATION_ID,
17 ACCESSHOUR_REQUIRED,
18 AFTER_HOURS_FLAG,
19 MONDAY_FIRST_START,
20 MONDAY_FIRST_END,
21 MONDAY_SECOND_START,
22 MONDAY_SECOND_END,
23 TUESDAY_FIRST_START,
24 TUESDAY_FIRST_END,
25 TUESDAY_SECOND_START,
26 TUESDAY_SECOND_END,
27 WEDNESDAY_FIRST_START,
28 WEDNESDAY_FIRST_END,
29 WEDNESDAY_SECOND_START,
30 WEDNESDAY_SECOND_END,
31 THURSDAY_FIRST_START,
32 THURSDAY_FIRST_END,
33 THURSDAY_SECOND_START,
34 THURSDAY_SECOND_END,
35 FRIDAY_FIRST_START,
36 FRIDAY_FIRST_END,
37 FRIDAY_SECOND_START,
38 FRIDAY_SECOND_END,
39 SATURDAY_FIRST_START,
40 SATURDAY_FIRST_END,
41 SATURDAY_SECOND_START,
42 SATURDAY_SECOND_END,
43 SUNDAY_FIRST_START,
44 SUNDAY_FIRST_END,
45 SUNDAY_SECOND_START,
46 SUNDAY_SECOND_END,
47 DESCRIPTION,
48 OBJECT_VERSION_NUMBER,
49 CREATED_BY,
50 CREATION_DATE,
51 LAST_UPDATED_BY,
52 LAST_UPDATE_DATE,
53 LAST_UPDATE_LOGIN,
54 security_group_id
55 from csf_map_access_hours_vl
56 where (c_customer_location_id is not null
57 and customer_location_id = customer_location_id)
58 or (c_customer_site_id is not null
59 and c_customer_id is not null
60 and customer_id = c_customer_id
61 and customer_site_id = c_customer_site_id)
62 or (c_customer_id is not null
63 and c_customer_site_id is null
64 and customer_id = c_customer_id
65 and customer_site_id is null);
66 begin
67 if p_customer_location_id is not null then
68 open c_access_hours(c_customer_id => null,
69 c_customer_site_id => null,
70 c_customer_location_id => p_customer_location_id);
71 fetch c_access_hours into x_access_hours;
72 close c_access_hours;
73 end if;
74 if p_customer_site_id is not null
75 and p_customer_id is not null
76 and x_access_hours.access_hour_map_id is null then
77 open c_access_hours(c_customer_id => p_customer_id,
78 c_customer_site_id => p_customer_site_id,
79 c_customer_location_id => null);
80 fetch c_access_hours into x_access_hours;
81 close c_access_hours;
82 end if;
83 if p_customer_id is not null
84 and x_access_hours.access_hour_map_id is null then
85 open c_access_hours(c_customer_id => p_customer_id,
86 c_customer_site_id => null,
87 c_customer_location_id => null);
88 fetch c_access_hours into x_access_hours;
89 close c_access_hours;
90 end if;
91 end;
92
93 PROCEDURE Insert_Row(
94 px_ACCESS_HOUR_MAP_ID IN OUT NOCOPY NUMBER,
95 p_CUSTOMER_ID IN NUMBER,
99 p_AFTER_HOURS_FLAG IN VARCHAR2,
96 p_CUSTOMER_SITE_ID IN NUMBER,
97 p_CUSTOMER_LOCATION_ID IN NUMBER,
98 p_ACCESSHOUR_REQUIRED IN VARCHAR2,
100 p_MONDAY_FIRST_START IN DATE,
101 p_MONDAY_FIRST_END IN DATE,
102 p_MONDAY_SECOND_START IN DATE,
103 p_MONDAY_SECOND_END IN DATE,
104 p_TUESDAY_FIRST_START IN DATE,
105 p_TUESDAY_FIRST_END IN DATE,
106 p_TUESDAY_SECOND_START IN DATE,
107 p_TUESDAY_SECOND_END IN DATE,
108 p_WEDNESDAY_FIRST_START IN DATE,
109 p_WEDNESDAY_FIRST_END IN DATE,
110 p_WEDNESDAY_SECOND_START IN DATE,
111 p_WEDNESDAY_SECOND_END IN DATE,
112 p_THURSDAY_FIRST_START IN DATE,
113 p_THURSDAY_FIRST_END IN DATE,
114 p_THURSDAY_SECOND_START IN DATE,
115 p_THURSDAY_SECOND_END IN DATE,
116 p_FRIDAY_FIRST_START IN DATE,
117 p_FRIDAY_FIRST_END IN DATE,
118 p_FRIDAY_SECOND_START IN DATE,
119 p_FRIDAY_SECOND_END IN DATE,
120 p_SATURDAY_FIRST_START IN DATE,
121 p_SATURDAY_FIRST_END IN DATE,
122 p_SATURDAY_SECOND_START IN DATE,
123 p_SATURDAY_SECOND_END IN DATE,
124 p_SUNDAY_FIRST_START IN DATE,
125 p_SUNDAY_FIRST_END IN DATE,
126 p_SUNDAY_SECOND_START IN DATE,
127 p_SUNDAY_SECOND_END IN DATE,
128 p_DESCRIPTION IN VARCHAR2,
129 X_OBJECT_VERSION_NUMBER Out NOCOPY NUMBER,
130 p_CREATED_BY IN NUMBER,
131 p_CREATION_DATE IN DATE,
132 p_LAST_UPDATED_BY IN NUMBER,
133 p_LAST_UPDATE_DATE IN DATE,
134 p_LAST_UPDATE_LOGIN IN NUMBER,
135 p_security_group_id IN NUMBER) is
136
137 l_object_version_number NUMBER := 1;
138
139 begin
140
141 insert into CSF_MAP_ACCESS_HOURS_B (
142 ACCESS_HOUR_MAP_ID,
143 CUSTOMER_ID,
144 CUSTOMER_SITE_ID,
145 CUSTOMER_LOCATION_ID,
146 ACCESSHOUR_REQUIRED,
147 AFTER_HOURS_FLAG,
148 MONDAY_FIRST_START,
149 MONDAY_FIRST_END,
150 MONDAY_SECOND_START,
151 MONDAY_SECOND_END,
152 TUESDAY_FIRST_START,
153 TUESDAY_FIRST_END,
154 TUESDAY_SECOND_START,
155 TUESDAY_SECOND_END,
156 WEDNESDAY_FIRST_START,
157 WEDNESDAY_FIRST_END,
158 WEDNESDAY_SECOND_START,
159 WEDNESDAY_SECOND_END,
160 THURSDAY_FIRST_START,
161 THURSDAY_FIRST_END,
162 THURSDAY_SECOND_START,
163 THURSDAY_SECOND_END,
164 FRIDAY_FIRST_START,
165 FRIDAY_FIRST_END,
166 FRIDAY_SECOND_START,
167 FRIDAY_SECOND_END,
168 SATURDAY_FIRST_START,
169 SATURDAY_FIRST_END,
170 SATURDAY_SECOND_START,
171 SATURDAY_SECOND_END,
172 SUNDAY_FIRST_START,
173 SUNDAY_FIRST_END,
174 SUNDAY_SECOND_START,
175 SUNDAY_SECOND_END,
176 OBJECT_VERSION_NUMBER,
177 CREATION_DATE,
178 CREATED_BY,
179 LAST_UPDATE_DATE,
180 LAST_UPDATED_BY,
181 LAST_UPDATE_LOGIN,
182 security_group_id
183 ) values (
184 px_ACCESS_HOUR_MAP_ID,
185 p_CUSTOMER_ID,
186 p_CUSTOMER_SITE_ID,
187 p_CUSTOMER_LOCATION_ID,
188 p_ACCESSHOUR_REQUIRED,
189 p_AFTER_HOURS_FLAG,
190 p_MONDAY_FIRST_START,
191 p_MONDAY_FIRST_END,
192 p_MONDAY_SECOND_START,
193 p_MONDAY_SECOND_END,
194 p_TUESDAY_FIRST_START,
195 p_TUESDAY_FIRST_END,
196 p_TUESDAY_SECOND_START,
197 p_TUESDAY_SECOND_END,
198 p_WEDNESDAY_FIRST_START,
199 p_WEDNESDAY_FIRST_END,
200 p_WEDNESDAY_SECOND_START,
201 p_WEDNESDAY_SECOND_END,
202 p_THURSDAY_FIRST_START,
203 p_THURSDAY_FIRST_END,
204 p_THURSDAY_SECOND_START,
205 p_THURSDAY_SECOND_END,
206 p_FRIDAY_FIRST_START,
207 p_FRIDAY_FIRST_END,
208 p_FRIDAY_SECOND_START,
209 p_FRIDAY_SECOND_END,
210 p_SATURDAY_FIRST_START,
211 p_SATURDAY_FIRST_END,
212 p_SATURDAY_SECOND_START,
213 p_SATURDAY_SECOND_END,
214 p_SUNDAY_FIRST_START,
215 p_SUNDAY_FIRST_END,
216 p_SUNDAY_SECOND_START,
217 p_SUNDAY_SECOND_END,
218 l_OBJECT_VERSION_NUMBER,
219 decode(P_CREATION_DATE,NULL,SYSDATE,P_CREATION_DATE),
220 P_CREATED_BY,
221 decode(P_LAST_UPDATE_DATE,NULL,SYSDATE,P_LAST_UPDATE_DATE),
222 P_LAST_UPDATED_BY,
223 P_LAST_UPDATE_LOGIN,
224 p_security_group_id
225 ) ;
226
227 insert into CSF_MAP_ACCESS_HOURS_TL (
228 ACCESS_HOUR_MAP_ID,
229 DESCRIPTION,
230 CREATED_BY,
231 CREATION_DATE,
232 LAST_UPDATED_BY,
233 LAST_UPDATE_DATE,
234 LAST_UPDATE_LOGIN,
235 security_group_id,
236 LANGUAGE,
237 SOURCE_LANG
238 ) select
239 PX_ACCESS_HOUR_MAP_ID,
240 P_DESCRIPTION,
241 P_CREATED_BY,
242 P_CREATION_DATE,
243 P_LAST_UPDATED_BY,
244 P_LAST_UPDATE_DATE,
245 P_LAST_UPDATE_LOGIN,
246 p_security_group_id,
247 L.LANGUAGE_CODE,
248 userenv('LANG')
249 from FND_LANGUAGES L
250 where L.INSTALLED_FLAG in ('I', 'B')
251 and not exists
255 and T.LANGUAGE = L.LANGUAGE_CODE);
252 (select NULL
253 from CSF_MAP_ACCESS_HOURS_TL T
254 where T.ACCESS_HOUR_MAP_ID = PX_ACCESS_HOUR_MAP_ID
256
257 X_OBJECT_VERSION_NUMBER := l_object_Version_number;
258 end INSERT_ROW;
259
260
261
262 PROCEDURE Update_Row(
263 p_ACCESS_HOUR_MAP_ID IN NUMBER,
264 p_CUSTOMER_ID IN NUMBER,
265 p_CUSTOMER_SITE_ID IN NUMBER,
266 p_CUSTOMER_LOCATION_ID IN NUMBER,
267 p_ACCESSHOUR_REQUIRED IN VARCHAR2,
268 p_AFTER_HOURS_FLAG IN VARCHAR2,
269 p_MONDAY_FIRST_START IN DATE,
270 p_MONDAY_FIRST_END IN DATE,
271 p_MONDAY_SECOND_START IN DATE,
272 p_MONDAY_SECOND_END IN DATE,
273 p_TUESDAY_FIRST_START IN DATE,
274 p_TUESDAY_FIRST_END IN DATE,
275 p_TUESDAY_SECOND_START IN DATE,
276 p_TUESDAY_SECOND_END IN DATE,
277 p_WEDNESDAY_FIRST_START IN DATE,
278 p_WEDNESDAY_FIRST_END IN DATE,
279 p_WEDNESDAY_SECOND_START IN DATE,
280 p_WEDNESDAY_SECOND_END IN DATE,
281 p_THURSDAY_FIRST_START IN DATE,
282 p_THURSDAY_FIRST_END IN DATE,
283 p_THURSDAY_SECOND_START IN DATE,
284 p_THURSDAY_SECOND_END IN DATE,
285 p_FRIDAY_FIRST_START IN DATE,
286 p_FRIDAY_FIRST_END IN DATE,
287 p_FRIDAY_SECOND_START IN DATE,
288 p_FRIDAY_SECOND_END IN DATE,
289 p_SATURDAY_FIRST_START IN DATE,
290 p_SATURDAY_FIRST_END IN DATE,
291 p_SATURDAY_SECOND_START IN DATE,
292 p_SATURDAY_SECOND_END IN DATE,
293 p_SUNDAY_FIRST_START IN DATE,
294 p_SUNDAY_FIRST_END IN DATE,
295 p_SUNDAY_SECOND_START IN DATE,
296 p_SUNDAY_SECOND_END IN DATE,
297 p_DESCRIPTION IN VARCHAR2,
298 X_OBJECT_VERSION_NUMBER Out NOCOPY NUMBER,
299 p_LAST_UPDATED_BY IN NUMBER,
300 p_LAST_UPDATE_DATE IN DATE,
301 p_LAST_UPDATE_LOGIN IN NUMBER,
302 p_security_group_id IN NUMBER) is
303
304 l_object_Version_number number;
305
306 begin
307 update CSF_MAP_ACCESS_HOURS_B set
308 CUSTOMER_ID = p_CUSTOMER_ID,
309 CUSTOMER_SITE_ID = p_CUSTOMER_SITE_ID,
310 CUSTOMER_LOCATION_ID = p_CUSTOMER_LOCATION_ID,
311 ACCESSHOUR_REQUIRED = p_ACCESSHOUR_REQUIRED,
312 AFTER_HOURS_FLAG = p_AFTER_HOURS_FLAG,
313 MONDAY_FIRST_START = p_MONDAY_FIRST_START,
314 MONDAY_FIRST_END = p_MONDAY_FIRST_END,
315 MONDAY_SECOND_START = p_MONDAY_SECOND_START,
316 MONDAY_SECOND_END = p_MONDAY_SECOND_END,
317 TUESDAY_FIRST_START = p_TUESDAY_FIRST_START,
318 TUESDAY_FIRST_END = p_TUESDAY_FIRST_END,
319 TUESDAY_SECOND_START = p_TUESDAY_SECOND_START,
320 TUESDAY_SECOND_END = p_TUESDAY_SECOND_END,
321 WEDNESDAY_FIRST_START = p_WEDNESDAY_FIRST_START,
322 WEDNESDAY_FIRST_END = p_WEDNESDAY_FIRST_END,
323 WEDNESDAY_SECOND_START = p_WEDNESDAY_SECOND_START,
324 WEDNESDAY_SECOND_END = p_WEDNESDAY_SECOND_END,
325 THURSDAY_FIRST_START = p_THURSDAY_FIRST_START,
326 THURSDAY_FIRST_END= p_THURSDAY_FIRST_END,
327 THURSDAY_SECOND_START = p_THURSDAY_SECOND_START,
328 THURSDAY_SECOND_END = p_THURSDAY_SECOND_END,
329 FRIDAY_FIRST_START = p_FRIDAY_FIRST_START,
330 FRIDAY_FIRST_END = p_FRIDAY_FIRST_END,
331 FRIDAY_SECOND_START = p_FRIDAY_SECOND_START,
332 FRIDAY_SECOND_END = p_FRIDAY_SECOND_END,
333 SATURDAY_FIRST_START = p_SATURDAY_FIRST_START,
334 SATURDAY_FIRST_END = p_SATURDAY_FIRST_END,
335 SATURDAY_SECOND_START = p_SATURDAY_SECOND_START,
336 SATURDAY_SECOND_END = p_SATURDAY_SECOND_END,
337 SUNDAY_FIRST_START = p_SUNDAY_FIRST_START,
338 SUNDAY_FIRST_END = p_SUNDAY_FIRST_END,
339 SUNDAY_SECOND_START = p_SUNDAY_SECOND_START,
340 SUNDAY_SECOND_END = p_SUNDAY_SECOND_END,
341 OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
342 LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
343 LAST_UPDATED_BY = P_LAST_UPDATED_BY,
344 LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
345 security_group_id = p_security_group_id
346 where ACCESS_HOUR_MAP_ID = p_ACCESS_HOUR_MAP_ID
347 RETURNING OBJECT_VERSION_NUMBER INTO L_OBJECT_VERSION_NUMBER;
348
349 X_OBJECT_VERSION_NUMBER := l_object_version_number;
350
351 if (sql%notfound) then
352 raise no_data_found;
353 end if;
354
355 update CSF_MAP_ACCESS_HOURS_TL set
356 DESCRIPTION = P_DESCRIPTION,
357 LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
358 LAST_UPDATED_BY = P_LAST_UPDATED_BY,
359 LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
360 SOURCE_LANG = userenv('LANG')
361 where ACCESS_HOUR_MAP_ID = p_ACCESS_HOUR_MAP_ID
362 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
363
364 if (sql%notfound) then
365 raise no_data_found;
366 end if;
367 end UPDATE_ROW;
368
369
370
371
372
373 PROCEDURE Lock_Row(
374 p_ACCESS_HOUR_MAP_ID IN NUMBER,
375 P_OBJECT_VERSION_NUMBER in NUMBER) is
376
377 cursor c is select
378 OBJECT_VERSION_NUMBER
379 from CSF_MAP_ACCESS_HOURS_VL
380 where ACCESS_HOUR_MAP_ID = p_ACCESS_HOUR_MAP_ID
381 for update of ACCESS_HOUR_MAP_ID nowait;
382
383 l_object_Version_number number := 0;
384
385 begin
386 open c;
387 fetch c into l_object_Version_number;
388 if (c%notfound) then
389 close c;
390 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
391 app_exception.raise_exception;
392 end if;
396 null;
393 close c;
394
395 if (l_object_version_number = P_OBJECT_VERSION_NUMBER) then
397 else
398 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
399 app_exception.raise_exception;
400 end if;
401
402 return;
403 end LOCK_ROW;
404
405
406
407 PROCEDURE Delete_Row(
408 p_ACCESS_HOUR_MAP_ID IN NUMBER) is
409 begin
410 delete from CSF_MAP_ACCESS_HOURS_TL
411 where ACCESS_HOUR_MAP_ID = p_ACCESS_HOUR_MAP_ID;
412
413 if (sql%notfound) then
414 raise no_data_found;
415 end if;
416
417 delete from CSF_MAP_ACCESS_HOURS_B
418 where ACCESS_HOUR_MAP_ID = p_ACCESS_HOUR_MAP_ID;
419
420 if (sql%notfound) then
421 raise no_data_found;
422 end if;
423 end DELETE_ROW;
424
425
426
427 PROCEDURE ADD_LANGUAGE is
428 begin
429 delete from CSF_MAP_ACCESS_HOURS_TL T
430 where not exists
431 (select NULL
432 from CSF_MAP_ACCESS_HOURS_B B
433 where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID
434 );
435
436 update CSF_MAP_ACCESS_HOURS_TL T set (
437 DESCRIPTION
438 ) = (select
439 B.DESCRIPTION
440 from CSF_MAP_ACCESS_HOURS_TL B
441 where B.ACCESS_HOUR_MAP_ID = T.ACCESS_HOUR_MAP_ID
442 and B.LANGUAGE = T.SOURCE_LANG)
443 where (
444 T.ACCESS_HOUR_MAP_ID,
445 T.LANGUAGE
446 ) in (select
447 SUBT.ACCESS_HOUR_MAP_ID,
448 SUBT.LANGUAGE
449 from CSF_MAP_ACCESS_HOURS_TL SUBB, CSF_MAP_ACCESS_HOURS_TL SUBT
450 where SUBB.ACCESS_HOUR_MAP_ID = SUBT.ACCESS_HOUR_MAP_ID
451 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
452 and (
453 SUBB.DESCRIPTION <> SUBT.DESCRIPTION
454 or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
455 or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
456 ));
457
458 insert into CSF_MAP_ACCESS_HOURS_TL (
459 DESCRIPTION,
460 CREATION_DATE,
461 CREATED_BY,
462 LAST_UPDATE_DATE,
463 LAST_UPDATED_BY,
464 LAST_UPDATE_LOGIN,
465 ACCESS_HOUR_MAP_ID,
466 security_group_id,
467 LANGUAGE,
468 SOURCE_LANG
469 ) select
470 B.DESCRIPTION,
471 B.CREATION_DATE,
472 B.CREATED_BY,
473 B.LAST_UPDATE_DATE,
474 B.LAST_UPDATED_BY,
475 B.LAST_UPDATE_LOGIN,
476 B.ACCESS_HOUR_MAP_ID,
477 B.security_group_id,
478 L.LANGUAGE_CODE,
479 B.SOURCE_LANG
480 from CSF_MAP_ACCESS_HOURS_TL B, FND_LANGUAGES L
481 where L.INSTALLED_FLAG in ('I', 'B')
482 and B.LANGUAGE = userenv('LANG')
483 and not exists
484 (select NULL
485 from CSF_MAP_ACCESS_HOURS_TL T
486 where T.ACCESS_HOUR_MAP_ID = B.ACCESS_HOUR_MAP_ID
487 and T.LANGUAGE = L.LANGUAGE_CODE);
488 end ADD_LANGUAGE;
489
490
491
492 PROCEDURE Load_Row(
493 p_ACCESS_HOUR_MAP_ID IN NUMBER,
494 p_CUSTOMER_ID IN NUMBER,
495 p_CUSTOMER_SITE_ID IN NUMBER,
496 p_CUSTOMER_LOCATION_ID IN NUMBER,
497 p_ACCESSHOUR_REQUIRED IN VARCHAR2,
498 p_AFTER_HOURS_FLAG IN VARCHAR2,
499 p_MONDAY_FIRST_START IN DATE,
500 p_MONDAY_FIRST_END IN DATE,
501 p_MONDAY_SECOND_START IN DATE,
502 p_MONDAY_SECOND_END IN DATE,
503 p_TUESDAY_FIRST_START IN DATE,
504 p_TUESDAY_FIRST_END IN DATE,
505 p_TUESDAY_SECOND_START IN DATE,
506 p_TUESDAY_SECOND_END IN DATE,
507 p_WEDNESDAY_FIRST_START IN DATE,
508 p_WEDNESDAY_FIRST_END IN DATE,
509 p_WEDNESDAY_SECOND_START IN DATE,
510 p_WEDNESDAY_SECOND_END IN DATE,
511 p_THURSDAY_FIRST_START IN DATE,
512 p_THURSDAY_FIRST_END IN DATE,
513 p_THURSDAY_SECOND_START IN DATE,
514 p_THURSDAY_SECOND_END IN DATE,
515 p_FRIDAY_FIRST_START IN DATE,
516 p_FRIDAY_FIRST_END IN DATE,
517 p_FRIDAY_SECOND_START IN DATE,
518 p_FRIDAY_SECOND_END IN DATE,
519 p_SATURDAY_FIRST_START IN DATE,
520 p_SATURDAY_FIRST_END IN DATE,
521 p_SATURDAY_SECOND_START IN DATE,
522 p_SATURDAY_SECOND_END IN DATE,
523 p_SUNDAY_FIRST_START IN DATE,
524 p_SUNDAY_FIRST_END IN DATE,
525 p_SUNDAY_SECOND_START IN DATE,
526 p_SUNDAY_SECOND_END IN DATE,
527 p_DESCRIPTION IN VARCHAR2,
528 P_OBJECT_VERSION_NUMBER IN NUMBER,
529 P_OWNER IN VARCHAR2,
530 p_CREATED_BY IN NUMBER,
531 p_CREATION_DATE IN DATE,
532 p_LAST_UPDATED_BY IN NUMBER,
533 p_LAST_UPDATE_DATE IN DATE,
534 p_LAST_UPDATE_LOGIN IN NUMBER,
535 p_security_group_id IN NUMBER)
536 IS
537
538 -- Out local variables for the update / insert row procedures.
539 lx_object_version_number NUMBER := 0;
540 l_user_id NUMBER := 0;
541
542 -- needed to be passed as the parameter value for the insert's in/out
543 -- parameter.
544 l_action_code VARCHAR2(30);
545
546 BEGIN
547
548 if ( p_owner = 'SEED' ) then
549 l_user_id := 1;
550 end if;
551
552 end Load_Row;
553
554
555
556 PROCEDURE Translate_Row( X_ACCESS_HOUR_MAP_ID in NUMBER,
557 X_DESCRIPTION in varchar2,
558 X_LAST_UPDATE_DATE in date,
559 X_LAST_UPDATE_LOGIN in number,
560 X_OWNER in varchar2)
561 is
562
563 l_user_id number;
564
565 begin
566
567 if X_OWNER = 'SEED' then
568 l_user_id := 1;
569 else
570 l_user_id := 0;
571 end if;
572
573 update CSF_MAP_ACCESS_HOURS_TL set
574 description = nvl(x_description,'none'),
575 last_update_date = nvl(x_last_update_date,sysdate),
576 last_updated_by = l_user_id,
577 last_update_login = 0,
578 source_lang = userenv('LANG')
579 where ACCESS_HOUR_MAP_ID = X_ACCESS_HOUR_MAP_ID
580 and userenv('LANG') in (LANGUAGE,SOURCE_LANG);
581
582 end TRANSLATE_ROW;
583
584
585 END CSF_MAP_ACC_HRS_PKG;
586