[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy hr_ctx_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: hr_ctx_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
120: hr_ctx_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: hr_ctx_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: --
129: Raise;
161: --
162: -- {End Of Comments}
163: -- ----------------------------------------------------------------------------
164: Procedure pre_update
165: (p_rec in hr_ctx_shd.g_rec_type
166: ) is
167: --
168: l_proc varchar2(72) := g_package||'pre_update';
169: --
205: --
206: -- {End Of Comments}
207: -- ----------------------------------------------------------------------------
208: Procedure post_update
209: (p_rec in hr_ctx_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72) := g_package||'post_update';
213: --
282: => p_rec.param_30
283: ,p_object_version_number
284: => p_rec.object_version_number
285: ,p_view_name_o
286: => hr_ctx_shd.g_old_rec.view_name
287: ,p_param_1_o
288: => hr_ctx_shd.g_old_rec.param_1
289: ,p_param_2_o
290: => hr_ctx_shd.g_old_rec.param_2
284: => p_rec.object_version_number
285: ,p_view_name_o
286: => hr_ctx_shd.g_old_rec.view_name
287: ,p_param_1_o
288: => hr_ctx_shd.g_old_rec.param_1
289: ,p_param_2_o
290: => hr_ctx_shd.g_old_rec.param_2
291: ,p_param_3_o
292: => hr_ctx_shd.g_old_rec.param_3
286: => hr_ctx_shd.g_old_rec.view_name
287: ,p_param_1_o
288: => hr_ctx_shd.g_old_rec.param_1
289: ,p_param_2_o
290: => hr_ctx_shd.g_old_rec.param_2
291: ,p_param_3_o
292: => hr_ctx_shd.g_old_rec.param_3
293: ,p_param_4_o
294: => hr_ctx_shd.g_old_rec.param_4
288: => hr_ctx_shd.g_old_rec.param_1
289: ,p_param_2_o
290: => hr_ctx_shd.g_old_rec.param_2
291: ,p_param_3_o
292: => hr_ctx_shd.g_old_rec.param_3
293: ,p_param_4_o
294: => hr_ctx_shd.g_old_rec.param_4
295: ,p_param_5_o
296: => hr_ctx_shd.g_old_rec.param_5
290: => hr_ctx_shd.g_old_rec.param_2
291: ,p_param_3_o
292: => hr_ctx_shd.g_old_rec.param_3
293: ,p_param_4_o
294: => hr_ctx_shd.g_old_rec.param_4
295: ,p_param_5_o
296: => hr_ctx_shd.g_old_rec.param_5
297: ,p_param_6_o
298: => hr_ctx_shd.g_old_rec.param_6
292: => hr_ctx_shd.g_old_rec.param_3
293: ,p_param_4_o
294: => hr_ctx_shd.g_old_rec.param_4
295: ,p_param_5_o
296: => hr_ctx_shd.g_old_rec.param_5
297: ,p_param_6_o
298: => hr_ctx_shd.g_old_rec.param_6
299: ,p_param_7_o
300: => hr_ctx_shd.g_old_rec.param_7
294: => hr_ctx_shd.g_old_rec.param_4
295: ,p_param_5_o
296: => hr_ctx_shd.g_old_rec.param_5
297: ,p_param_6_o
298: => hr_ctx_shd.g_old_rec.param_6
299: ,p_param_7_o
300: => hr_ctx_shd.g_old_rec.param_7
301: ,p_param_8_o
302: => hr_ctx_shd.g_old_rec.param_8
296: => hr_ctx_shd.g_old_rec.param_5
297: ,p_param_6_o
298: => hr_ctx_shd.g_old_rec.param_6
299: ,p_param_7_o
300: => hr_ctx_shd.g_old_rec.param_7
301: ,p_param_8_o
302: => hr_ctx_shd.g_old_rec.param_8
303: ,p_param_9_o
304: => hr_ctx_shd.g_old_rec.param_9
298: => hr_ctx_shd.g_old_rec.param_6
299: ,p_param_7_o
300: => hr_ctx_shd.g_old_rec.param_7
301: ,p_param_8_o
302: => hr_ctx_shd.g_old_rec.param_8
303: ,p_param_9_o
304: => hr_ctx_shd.g_old_rec.param_9
305: ,p_param_10_o
306: => hr_ctx_shd.g_old_rec.param_10
300: => hr_ctx_shd.g_old_rec.param_7
301: ,p_param_8_o
302: => hr_ctx_shd.g_old_rec.param_8
303: ,p_param_9_o
304: => hr_ctx_shd.g_old_rec.param_9
305: ,p_param_10_o
306: => hr_ctx_shd.g_old_rec.param_10
307: ,p_param_11_o
308: => hr_ctx_shd.g_old_rec.param_11
302: => hr_ctx_shd.g_old_rec.param_8
303: ,p_param_9_o
304: => hr_ctx_shd.g_old_rec.param_9
305: ,p_param_10_o
306: => hr_ctx_shd.g_old_rec.param_10
307: ,p_param_11_o
308: => hr_ctx_shd.g_old_rec.param_11
309: ,p_param_12_o
310: => hr_ctx_shd.g_old_rec.param_12
304: => hr_ctx_shd.g_old_rec.param_9
305: ,p_param_10_o
306: => hr_ctx_shd.g_old_rec.param_10
307: ,p_param_11_o
308: => hr_ctx_shd.g_old_rec.param_11
309: ,p_param_12_o
310: => hr_ctx_shd.g_old_rec.param_12
311: ,p_param_13_o
312: => hr_ctx_shd.g_old_rec.param_13
306: => hr_ctx_shd.g_old_rec.param_10
307: ,p_param_11_o
308: => hr_ctx_shd.g_old_rec.param_11
309: ,p_param_12_o
310: => hr_ctx_shd.g_old_rec.param_12
311: ,p_param_13_o
312: => hr_ctx_shd.g_old_rec.param_13
313: ,p_param_14_o
314: => hr_ctx_shd.g_old_rec.param_14
308: => hr_ctx_shd.g_old_rec.param_11
309: ,p_param_12_o
310: => hr_ctx_shd.g_old_rec.param_12
311: ,p_param_13_o
312: => hr_ctx_shd.g_old_rec.param_13
313: ,p_param_14_o
314: => hr_ctx_shd.g_old_rec.param_14
315: ,p_param_15_o
316: => hr_ctx_shd.g_old_rec.param_15
310: => hr_ctx_shd.g_old_rec.param_12
311: ,p_param_13_o
312: => hr_ctx_shd.g_old_rec.param_13
313: ,p_param_14_o
314: => hr_ctx_shd.g_old_rec.param_14
315: ,p_param_15_o
316: => hr_ctx_shd.g_old_rec.param_15
317: ,p_param_16_o
318: => hr_ctx_shd.g_old_rec.param_16
312: => hr_ctx_shd.g_old_rec.param_13
313: ,p_param_14_o
314: => hr_ctx_shd.g_old_rec.param_14
315: ,p_param_15_o
316: => hr_ctx_shd.g_old_rec.param_15
317: ,p_param_16_o
318: => hr_ctx_shd.g_old_rec.param_16
319: ,p_param_17_o
320: => hr_ctx_shd.g_old_rec.param_17
314: => hr_ctx_shd.g_old_rec.param_14
315: ,p_param_15_o
316: => hr_ctx_shd.g_old_rec.param_15
317: ,p_param_16_o
318: => hr_ctx_shd.g_old_rec.param_16
319: ,p_param_17_o
320: => hr_ctx_shd.g_old_rec.param_17
321: ,p_param_18_o
322: => hr_ctx_shd.g_old_rec.param_18
316: => hr_ctx_shd.g_old_rec.param_15
317: ,p_param_16_o
318: => hr_ctx_shd.g_old_rec.param_16
319: ,p_param_17_o
320: => hr_ctx_shd.g_old_rec.param_17
321: ,p_param_18_o
322: => hr_ctx_shd.g_old_rec.param_18
323: ,p_param_19_o
324: => hr_ctx_shd.g_old_rec.param_19
318: => hr_ctx_shd.g_old_rec.param_16
319: ,p_param_17_o
320: => hr_ctx_shd.g_old_rec.param_17
321: ,p_param_18_o
322: => hr_ctx_shd.g_old_rec.param_18
323: ,p_param_19_o
324: => hr_ctx_shd.g_old_rec.param_19
325: ,p_param_20_o
326: => hr_ctx_shd.g_old_rec.param_20
320: => hr_ctx_shd.g_old_rec.param_17
321: ,p_param_18_o
322: => hr_ctx_shd.g_old_rec.param_18
323: ,p_param_19_o
324: => hr_ctx_shd.g_old_rec.param_19
325: ,p_param_20_o
326: => hr_ctx_shd.g_old_rec.param_20
327: ,p_param_21_o
328: => hr_ctx_shd.g_old_rec.param_21
322: => hr_ctx_shd.g_old_rec.param_18
323: ,p_param_19_o
324: => hr_ctx_shd.g_old_rec.param_19
325: ,p_param_20_o
326: => hr_ctx_shd.g_old_rec.param_20
327: ,p_param_21_o
328: => hr_ctx_shd.g_old_rec.param_21
329: ,p_param_22_o
330: => hr_ctx_shd.g_old_rec.param_22
324: => hr_ctx_shd.g_old_rec.param_19
325: ,p_param_20_o
326: => hr_ctx_shd.g_old_rec.param_20
327: ,p_param_21_o
328: => hr_ctx_shd.g_old_rec.param_21
329: ,p_param_22_o
330: => hr_ctx_shd.g_old_rec.param_22
331: ,p_param_23_o
332: => hr_ctx_shd.g_old_rec.param_23
326: => hr_ctx_shd.g_old_rec.param_20
327: ,p_param_21_o
328: => hr_ctx_shd.g_old_rec.param_21
329: ,p_param_22_o
330: => hr_ctx_shd.g_old_rec.param_22
331: ,p_param_23_o
332: => hr_ctx_shd.g_old_rec.param_23
333: ,p_param_24_o
334: => hr_ctx_shd.g_old_rec.param_24
328: => hr_ctx_shd.g_old_rec.param_21
329: ,p_param_22_o
330: => hr_ctx_shd.g_old_rec.param_22
331: ,p_param_23_o
332: => hr_ctx_shd.g_old_rec.param_23
333: ,p_param_24_o
334: => hr_ctx_shd.g_old_rec.param_24
335: ,p_param_25_o
336: => hr_ctx_shd.g_old_rec.param_25
330: => hr_ctx_shd.g_old_rec.param_22
331: ,p_param_23_o
332: => hr_ctx_shd.g_old_rec.param_23
333: ,p_param_24_o
334: => hr_ctx_shd.g_old_rec.param_24
335: ,p_param_25_o
336: => hr_ctx_shd.g_old_rec.param_25
337: ,p_param_26_o
338: => hr_ctx_shd.g_old_rec.param_26
332: => hr_ctx_shd.g_old_rec.param_23
333: ,p_param_24_o
334: => hr_ctx_shd.g_old_rec.param_24
335: ,p_param_25_o
336: => hr_ctx_shd.g_old_rec.param_25
337: ,p_param_26_o
338: => hr_ctx_shd.g_old_rec.param_26
339: ,p_param_27_o
340: => hr_ctx_shd.g_old_rec.param_27
334: => hr_ctx_shd.g_old_rec.param_24
335: ,p_param_25_o
336: => hr_ctx_shd.g_old_rec.param_25
337: ,p_param_26_o
338: => hr_ctx_shd.g_old_rec.param_26
339: ,p_param_27_o
340: => hr_ctx_shd.g_old_rec.param_27
341: ,p_param_28_o
342: => hr_ctx_shd.g_old_rec.param_28
336: => hr_ctx_shd.g_old_rec.param_25
337: ,p_param_26_o
338: => hr_ctx_shd.g_old_rec.param_26
339: ,p_param_27_o
340: => hr_ctx_shd.g_old_rec.param_27
341: ,p_param_28_o
342: => hr_ctx_shd.g_old_rec.param_28
343: ,p_param_29_o
344: => hr_ctx_shd.g_old_rec.param_29
338: => hr_ctx_shd.g_old_rec.param_26
339: ,p_param_27_o
340: => hr_ctx_shd.g_old_rec.param_27
341: ,p_param_28_o
342: => hr_ctx_shd.g_old_rec.param_28
343: ,p_param_29_o
344: => hr_ctx_shd.g_old_rec.param_29
345: ,p_param_30_o
346: => hr_ctx_shd.g_old_rec.param_30
340: => hr_ctx_shd.g_old_rec.param_27
341: ,p_param_28_o
342: => hr_ctx_shd.g_old_rec.param_28
343: ,p_param_29_o
344: => hr_ctx_shd.g_old_rec.param_29
345: ,p_param_30_o
346: => hr_ctx_shd.g_old_rec.param_30
347: ,p_object_version_number_o
348: => hr_ctx_shd.g_old_rec.object_version_number
342: => hr_ctx_shd.g_old_rec.param_28
343: ,p_param_29_o
344: => hr_ctx_shd.g_old_rec.param_29
345: ,p_param_30_o
346: => hr_ctx_shd.g_old_rec.param_30
347: ,p_object_version_number_o
348: => hr_ctx_shd.g_old_rec.object_version_number
349: );
350: --
344: => hr_ctx_shd.g_old_rec.param_29
345: ,p_param_30_o
346: => hr_ctx_shd.g_old_rec.param_30
347: ,p_object_version_number_o
348: => hr_ctx_shd.g_old_rec.object_version_number
349: );
350: --
351: exception
352: --
404: --
405: -- {End Of Comments}
406: -- ----------------------------------------------------------------------------
407: Procedure convert_defs
408: (p_rec in out nocopy hr_ctx_shd.g_rec_type
409: ) is
410: --
411: Begin
412: --
416: -- is being used then we must set to the 'current' argument value.
417: --
418: If (p_rec.view_name = hr_api.g_varchar2) then
419: p_rec.view_name :=
420: hr_ctx_shd.g_old_rec.view_name;
421: End If;
422: If (p_rec.param_1 = hr_api.g_varchar2) then
423: p_rec.param_1 :=
424: hr_ctx_shd.g_old_rec.param_1;
420: hr_ctx_shd.g_old_rec.view_name;
421: End If;
422: If (p_rec.param_1 = hr_api.g_varchar2) then
423: p_rec.param_1 :=
424: hr_ctx_shd.g_old_rec.param_1;
425: End If;
426: If (p_rec.param_2 = hr_api.g_varchar2) then
427: p_rec.param_2 :=
428: hr_ctx_shd.g_old_rec.param_2;
424: hr_ctx_shd.g_old_rec.param_1;
425: End If;
426: If (p_rec.param_2 = hr_api.g_varchar2) then
427: p_rec.param_2 :=
428: hr_ctx_shd.g_old_rec.param_2;
429: End If;
430: If (p_rec.param_3 = hr_api.g_varchar2) then
431: p_rec.param_3 :=
432: hr_ctx_shd.g_old_rec.param_3;
428: hr_ctx_shd.g_old_rec.param_2;
429: End If;
430: If (p_rec.param_3 = hr_api.g_varchar2) then
431: p_rec.param_3 :=
432: hr_ctx_shd.g_old_rec.param_3;
433: End If;
434: If (p_rec.param_4 = hr_api.g_varchar2) then
435: p_rec.param_4 :=
436: hr_ctx_shd.g_old_rec.param_4;
432: hr_ctx_shd.g_old_rec.param_3;
433: End If;
434: If (p_rec.param_4 = hr_api.g_varchar2) then
435: p_rec.param_4 :=
436: hr_ctx_shd.g_old_rec.param_4;
437: End If;
438: If (p_rec.param_5 = hr_api.g_varchar2) then
439: p_rec.param_5 :=
440: hr_ctx_shd.g_old_rec.param_5;
436: hr_ctx_shd.g_old_rec.param_4;
437: End If;
438: If (p_rec.param_5 = hr_api.g_varchar2) then
439: p_rec.param_5 :=
440: hr_ctx_shd.g_old_rec.param_5;
441: End If;
442: If (p_rec.param_6 = hr_api.g_varchar2) then
443: p_rec.param_6 :=
444: hr_ctx_shd.g_old_rec.param_6;
440: hr_ctx_shd.g_old_rec.param_5;
441: End If;
442: If (p_rec.param_6 = hr_api.g_varchar2) then
443: p_rec.param_6 :=
444: hr_ctx_shd.g_old_rec.param_6;
445: End If;
446: If (p_rec.param_7 = hr_api.g_varchar2) then
447: p_rec.param_7 :=
448: hr_ctx_shd.g_old_rec.param_7;
444: hr_ctx_shd.g_old_rec.param_6;
445: End If;
446: If (p_rec.param_7 = hr_api.g_varchar2) then
447: p_rec.param_7 :=
448: hr_ctx_shd.g_old_rec.param_7;
449: End If;
450: If (p_rec.param_8 = hr_api.g_varchar2) then
451: p_rec.param_8 :=
452: hr_ctx_shd.g_old_rec.param_8;
448: hr_ctx_shd.g_old_rec.param_7;
449: End If;
450: If (p_rec.param_8 = hr_api.g_varchar2) then
451: p_rec.param_8 :=
452: hr_ctx_shd.g_old_rec.param_8;
453: End If;
454: If (p_rec.param_9 = hr_api.g_varchar2) then
455: p_rec.param_9 :=
456: hr_ctx_shd.g_old_rec.param_9;
452: hr_ctx_shd.g_old_rec.param_8;
453: End If;
454: If (p_rec.param_9 = hr_api.g_varchar2) then
455: p_rec.param_9 :=
456: hr_ctx_shd.g_old_rec.param_9;
457: End If;
458: If (p_rec.param_10 = hr_api.g_varchar2) then
459: p_rec.param_10 :=
460: hr_ctx_shd.g_old_rec.param_10;
456: hr_ctx_shd.g_old_rec.param_9;
457: End If;
458: If (p_rec.param_10 = hr_api.g_varchar2) then
459: p_rec.param_10 :=
460: hr_ctx_shd.g_old_rec.param_10;
461: End If;
462: If (p_rec.param_11 = hr_api.g_varchar2) then
463: p_rec.param_11 :=
464: hr_ctx_shd.g_old_rec.param_11;
460: hr_ctx_shd.g_old_rec.param_10;
461: End If;
462: If (p_rec.param_11 = hr_api.g_varchar2) then
463: p_rec.param_11 :=
464: hr_ctx_shd.g_old_rec.param_11;
465: End If;
466: If (p_rec.param_12 = hr_api.g_varchar2) then
467: p_rec.param_12 :=
468: hr_ctx_shd.g_old_rec.param_12;
464: hr_ctx_shd.g_old_rec.param_11;
465: End If;
466: If (p_rec.param_12 = hr_api.g_varchar2) then
467: p_rec.param_12 :=
468: hr_ctx_shd.g_old_rec.param_12;
469: End If;
470: If (p_rec.param_13 = hr_api.g_varchar2) then
471: p_rec.param_13 :=
472: hr_ctx_shd.g_old_rec.param_13;
468: hr_ctx_shd.g_old_rec.param_12;
469: End If;
470: If (p_rec.param_13 = hr_api.g_varchar2) then
471: p_rec.param_13 :=
472: hr_ctx_shd.g_old_rec.param_13;
473: End If;
474: If (p_rec.param_14 = hr_api.g_varchar2) then
475: p_rec.param_14 :=
476: hr_ctx_shd.g_old_rec.param_14;
472: hr_ctx_shd.g_old_rec.param_13;
473: End If;
474: If (p_rec.param_14 = hr_api.g_varchar2) then
475: p_rec.param_14 :=
476: hr_ctx_shd.g_old_rec.param_14;
477: End If;
478: If (p_rec.param_15 = hr_api.g_varchar2) then
479: p_rec.param_15 :=
480: hr_ctx_shd.g_old_rec.param_15;
476: hr_ctx_shd.g_old_rec.param_14;
477: End If;
478: If (p_rec.param_15 = hr_api.g_varchar2) then
479: p_rec.param_15 :=
480: hr_ctx_shd.g_old_rec.param_15;
481: End If;
482: If (p_rec.param_16 = hr_api.g_varchar2) then
483: p_rec.param_16 :=
484: hr_ctx_shd.g_old_rec.param_16;
480: hr_ctx_shd.g_old_rec.param_15;
481: End If;
482: If (p_rec.param_16 = hr_api.g_varchar2) then
483: p_rec.param_16 :=
484: hr_ctx_shd.g_old_rec.param_16;
485: End If;
486: If (p_rec.param_17 = hr_api.g_varchar2) then
487: p_rec.param_17 :=
488: hr_ctx_shd.g_old_rec.param_17;
484: hr_ctx_shd.g_old_rec.param_16;
485: End If;
486: If (p_rec.param_17 = hr_api.g_varchar2) then
487: p_rec.param_17 :=
488: hr_ctx_shd.g_old_rec.param_17;
489: End If;
490: If (p_rec.param_18 = hr_api.g_varchar2) then
491: p_rec.param_18 :=
492: hr_ctx_shd.g_old_rec.param_18;
488: hr_ctx_shd.g_old_rec.param_17;
489: End If;
490: If (p_rec.param_18 = hr_api.g_varchar2) then
491: p_rec.param_18 :=
492: hr_ctx_shd.g_old_rec.param_18;
493: End If;
494: If (p_rec.param_19 = hr_api.g_varchar2) then
495: p_rec.param_19 :=
496: hr_ctx_shd.g_old_rec.param_19;
492: hr_ctx_shd.g_old_rec.param_18;
493: End If;
494: If (p_rec.param_19 = hr_api.g_varchar2) then
495: p_rec.param_19 :=
496: hr_ctx_shd.g_old_rec.param_19;
497: End If;
498: If (p_rec.param_20 = hr_api.g_varchar2) then
499: p_rec.param_20 :=
500: hr_ctx_shd.g_old_rec.param_20;
496: hr_ctx_shd.g_old_rec.param_19;
497: End If;
498: If (p_rec.param_20 = hr_api.g_varchar2) then
499: p_rec.param_20 :=
500: hr_ctx_shd.g_old_rec.param_20;
501: End If;
502: If (p_rec.param_21 = hr_api.g_varchar2) then
503: p_rec.param_21 :=
504: hr_ctx_shd.g_old_rec.param_21;
500: hr_ctx_shd.g_old_rec.param_20;
501: End If;
502: If (p_rec.param_21 = hr_api.g_varchar2) then
503: p_rec.param_21 :=
504: hr_ctx_shd.g_old_rec.param_21;
505: End If;
506: If (p_rec.param_22 = hr_api.g_varchar2) then
507: p_rec.param_22 :=
508: hr_ctx_shd.g_old_rec.param_22;
504: hr_ctx_shd.g_old_rec.param_21;
505: End If;
506: If (p_rec.param_22 = hr_api.g_varchar2) then
507: p_rec.param_22 :=
508: hr_ctx_shd.g_old_rec.param_22;
509: End If;
510: If (p_rec.param_23 = hr_api.g_varchar2) then
511: p_rec.param_23 :=
512: hr_ctx_shd.g_old_rec.param_23;
508: hr_ctx_shd.g_old_rec.param_22;
509: End If;
510: If (p_rec.param_23 = hr_api.g_varchar2) then
511: p_rec.param_23 :=
512: hr_ctx_shd.g_old_rec.param_23;
513: End If;
514: If (p_rec.param_24 = hr_api.g_varchar2) then
515: p_rec.param_24 :=
516: hr_ctx_shd.g_old_rec.param_24;
512: hr_ctx_shd.g_old_rec.param_23;
513: End If;
514: If (p_rec.param_24 = hr_api.g_varchar2) then
515: p_rec.param_24 :=
516: hr_ctx_shd.g_old_rec.param_24;
517: End If;
518: If (p_rec.param_25 = hr_api.g_varchar2) then
519: p_rec.param_25 :=
520: hr_ctx_shd.g_old_rec.param_25;
516: hr_ctx_shd.g_old_rec.param_24;
517: End If;
518: If (p_rec.param_25 = hr_api.g_varchar2) then
519: p_rec.param_25 :=
520: hr_ctx_shd.g_old_rec.param_25;
521: End If;
522: If (p_rec.param_26 = hr_api.g_varchar2) then
523: p_rec.param_26 :=
524: hr_ctx_shd.g_old_rec.param_26;
520: hr_ctx_shd.g_old_rec.param_25;
521: End If;
522: If (p_rec.param_26 = hr_api.g_varchar2) then
523: p_rec.param_26 :=
524: hr_ctx_shd.g_old_rec.param_26;
525: End If;
526: If (p_rec.param_27 = hr_api.g_varchar2) then
527: p_rec.param_27 :=
528: hr_ctx_shd.g_old_rec.param_27;
524: hr_ctx_shd.g_old_rec.param_26;
525: End If;
526: If (p_rec.param_27 = hr_api.g_varchar2) then
527: p_rec.param_27 :=
528: hr_ctx_shd.g_old_rec.param_27;
529: End If;
530: If (p_rec.param_28 = hr_api.g_varchar2) then
531: p_rec.param_28 :=
532: hr_ctx_shd.g_old_rec.param_28;
528: hr_ctx_shd.g_old_rec.param_27;
529: End If;
530: If (p_rec.param_28 = hr_api.g_varchar2) then
531: p_rec.param_28 :=
532: hr_ctx_shd.g_old_rec.param_28;
533: End If;
534: If (p_rec.param_29 = hr_api.g_varchar2) then
535: p_rec.param_29 :=
536: hr_ctx_shd.g_old_rec.param_29;
532: hr_ctx_shd.g_old_rec.param_28;
533: End If;
534: If (p_rec.param_29 = hr_api.g_varchar2) then
535: p_rec.param_29 :=
536: hr_ctx_shd.g_old_rec.param_29;
537: End If;
538: If (p_rec.param_30 = hr_api.g_varchar2) then
539: p_rec.param_30 :=
540: hr_ctx_shd.g_old_rec.param_30;
536: hr_ctx_shd.g_old_rec.param_29;
537: End If;
538: If (p_rec.param_30 = hr_api.g_varchar2) then
539: p_rec.param_30 :=
540: hr_ctx_shd.g_old_rec.param_30;
541: End If;
542: --
543: End convert_defs;
544: --
545: -- ----------------------------------------------------------------------------
546: -- |---------------------------------< upd >----------------------------------|
547: -- ----------------------------------------------------------------------------
548: Procedure upd
549: (p_rec in out nocopy hr_ctx_shd.g_rec_type
550: ) is
551: --
552: l_proc varchar2(72) := g_package||'upd';
553: --
555: hr_utility.set_location('Entering:'||l_proc, 5);
556: --
557: -- We must lock the row which we need to update.
558: --
559: hr_ctx_shd.lck
560: (p_rec.context_id
561: ,p_rec.object_version_number
562: );
563: --
631: ,p_param_29 in varchar2 default hr_api.g_varchar2
632: ,p_param_30 in varchar2 default hr_api.g_varchar2
633: ) is
634: --
635: l_rec hr_ctx_shd.g_rec_type;
636: l_proc varchar2(72) := g_package||'upd';
637: --
638: Begin
639: hr_utility.set_location('Entering:'||l_proc, 5);
641: -- Call conversion function to turn arguments into the
642: -- l_rec structure.
643: --
644: l_rec :=
645: hr_ctx_shd.convert_args
646: (p_context_id
647: ,p_view_name
648: ,p_param_1
649: ,p_param_2