[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy hr_wnp_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
114: Exception
115: When hr_api.check_integrity_violated Then
116: -- A check constraint has been violated
117: --
118: hr_wnp_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: --
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When hr_api.parent_integrity_violated Then
121: -- Parent integrity has been violated
122: --
123: hr_wnp_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: --
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.unique_integrity_violated Then
126: -- Unique integrity has been violated
127: --
128: hr_wnp_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: --
132: Raise;
164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure pre_update
168: (p_rec in hr_wnp_shd.g_rec_type
169: ) is
170: --
171: l_proc varchar2(72) := g_package||'pre_update';
172: --
208: --
209: -- {End Of Comments}
210: -- ----------------------------------------------------------------------------
211: Procedure post_update
212: (p_rec in hr_wnp_shd.g_rec_type
213: ) is
214: --
215: l_proc varchar2(72) := g_package||'post_update';
216: --
295: => p_rec.information29
296: ,p_information30
297: => p_rec.information30
298: ,p_form_window_id_o
299: => hr_wnp_shd.g_old_rec.form_window_id
300: ,p_template_window_id_o
301: => hr_wnp_shd.g_old_rec.template_window_id
302: ,p_height_o
303: => hr_wnp_shd.g_old_rec.height
297: => p_rec.information30
298: ,p_form_window_id_o
299: => hr_wnp_shd.g_old_rec.form_window_id
300: ,p_template_window_id_o
301: => hr_wnp_shd.g_old_rec.template_window_id
302: ,p_height_o
303: => hr_wnp_shd.g_old_rec.height
304: ,p_width_o
305: => hr_wnp_shd.g_old_rec.width
299: => hr_wnp_shd.g_old_rec.form_window_id
300: ,p_template_window_id_o
301: => hr_wnp_shd.g_old_rec.template_window_id
302: ,p_height_o
303: => hr_wnp_shd.g_old_rec.height
304: ,p_width_o
305: => hr_wnp_shd.g_old_rec.width
306: ,p_x_position_o
307: => hr_wnp_shd.g_old_rec.x_position
301: => hr_wnp_shd.g_old_rec.template_window_id
302: ,p_height_o
303: => hr_wnp_shd.g_old_rec.height
304: ,p_width_o
305: => hr_wnp_shd.g_old_rec.width
306: ,p_x_position_o
307: => hr_wnp_shd.g_old_rec.x_position
308: ,p_y_position_o
309: => hr_wnp_shd.g_old_rec.y_position
303: => hr_wnp_shd.g_old_rec.height
304: ,p_width_o
305: => hr_wnp_shd.g_old_rec.width
306: ,p_x_position_o
307: => hr_wnp_shd.g_old_rec.x_position
308: ,p_y_position_o
309: => hr_wnp_shd.g_old_rec.y_position
310: ,p_information_category_o
311: => hr_wnp_shd.g_old_rec.information_category
305: => hr_wnp_shd.g_old_rec.width
306: ,p_x_position_o
307: => hr_wnp_shd.g_old_rec.x_position
308: ,p_y_position_o
309: => hr_wnp_shd.g_old_rec.y_position
310: ,p_information_category_o
311: => hr_wnp_shd.g_old_rec.information_category
312: ,p_information1_o
313: => hr_wnp_shd.g_old_rec.information1
307: => hr_wnp_shd.g_old_rec.x_position
308: ,p_y_position_o
309: => hr_wnp_shd.g_old_rec.y_position
310: ,p_information_category_o
311: => hr_wnp_shd.g_old_rec.information_category
312: ,p_information1_o
313: => hr_wnp_shd.g_old_rec.information1
314: ,p_information2_o
315: => hr_wnp_shd.g_old_rec.information2
309: => hr_wnp_shd.g_old_rec.y_position
310: ,p_information_category_o
311: => hr_wnp_shd.g_old_rec.information_category
312: ,p_information1_o
313: => hr_wnp_shd.g_old_rec.information1
314: ,p_information2_o
315: => hr_wnp_shd.g_old_rec.information2
316: ,p_information3_o
317: => hr_wnp_shd.g_old_rec.information3
311: => hr_wnp_shd.g_old_rec.information_category
312: ,p_information1_o
313: => hr_wnp_shd.g_old_rec.information1
314: ,p_information2_o
315: => hr_wnp_shd.g_old_rec.information2
316: ,p_information3_o
317: => hr_wnp_shd.g_old_rec.information3
318: ,p_information4_o
319: => hr_wnp_shd.g_old_rec.information4
313: => hr_wnp_shd.g_old_rec.information1
314: ,p_information2_o
315: => hr_wnp_shd.g_old_rec.information2
316: ,p_information3_o
317: => hr_wnp_shd.g_old_rec.information3
318: ,p_information4_o
319: => hr_wnp_shd.g_old_rec.information4
320: ,p_information5_o
321: => hr_wnp_shd.g_old_rec.information5
315: => hr_wnp_shd.g_old_rec.information2
316: ,p_information3_o
317: => hr_wnp_shd.g_old_rec.information3
318: ,p_information4_o
319: => hr_wnp_shd.g_old_rec.information4
320: ,p_information5_o
321: => hr_wnp_shd.g_old_rec.information5
322: ,p_information6_o
323: => hr_wnp_shd.g_old_rec.information6
317: => hr_wnp_shd.g_old_rec.information3
318: ,p_information4_o
319: => hr_wnp_shd.g_old_rec.information4
320: ,p_information5_o
321: => hr_wnp_shd.g_old_rec.information5
322: ,p_information6_o
323: => hr_wnp_shd.g_old_rec.information6
324: ,p_information7_o
325: => hr_wnp_shd.g_old_rec.information7
319: => hr_wnp_shd.g_old_rec.information4
320: ,p_information5_o
321: => hr_wnp_shd.g_old_rec.information5
322: ,p_information6_o
323: => hr_wnp_shd.g_old_rec.information6
324: ,p_information7_o
325: => hr_wnp_shd.g_old_rec.information7
326: ,p_information8_o
327: => hr_wnp_shd.g_old_rec.information8
321: => hr_wnp_shd.g_old_rec.information5
322: ,p_information6_o
323: => hr_wnp_shd.g_old_rec.information6
324: ,p_information7_o
325: => hr_wnp_shd.g_old_rec.information7
326: ,p_information8_o
327: => hr_wnp_shd.g_old_rec.information8
328: ,p_information9_o
329: => hr_wnp_shd.g_old_rec.information9
323: => hr_wnp_shd.g_old_rec.information6
324: ,p_information7_o
325: => hr_wnp_shd.g_old_rec.information7
326: ,p_information8_o
327: => hr_wnp_shd.g_old_rec.information8
328: ,p_information9_o
329: => hr_wnp_shd.g_old_rec.information9
330: ,p_information10_o
331: => hr_wnp_shd.g_old_rec.information10
325: => hr_wnp_shd.g_old_rec.information7
326: ,p_information8_o
327: => hr_wnp_shd.g_old_rec.information8
328: ,p_information9_o
329: => hr_wnp_shd.g_old_rec.information9
330: ,p_information10_o
331: => hr_wnp_shd.g_old_rec.information10
332: ,p_information11_o
333: => hr_wnp_shd.g_old_rec.information11
327: => hr_wnp_shd.g_old_rec.information8
328: ,p_information9_o
329: => hr_wnp_shd.g_old_rec.information9
330: ,p_information10_o
331: => hr_wnp_shd.g_old_rec.information10
332: ,p_information11_o
333: => hr_wnp_shd.g_old_rec.information11
334: ,p_information12_o
335: => hr_wnp_shd.g_old_rec.information12
329: => hr_wnp_shd.g_old_rec.information9
330: ,p_information10_o
331: => hr_wnp_shd.g_old_rec.information10
332: ,p_information11_o
333: => hr_wnp_shd.g_old_rec.information11
334: ,p_information12_o
335: => hr_wnp_shd.g_old_rec.information12
336: ,p_information13_o
337: => hr_wnp_shd.g_old_rec.information13
331: => hr_wnp_shd.g_old_rec.information10
332: ,p_information11_o
333: => hr_wnp_shd.g_old_rec.information11
334: ,p_information12_o
335: => hr_wnp_shd.g_old_rec.information12
336: ,p_information13_o
337: => hr_wnp_shd.g_old_rec.information13
338: ,p_information14_o
339: => hr_wnp_shd.g_old_rec.information14
333: => hr_wnp_shd.g_old_rec.information11
334: ,p_information12_o
335: => hr_wnp_shd.g_old_rec.information12
336: ,p_information13_o
337: => hr_wnp_shd.g_old_rec.information13
338: ,p_information14_o
339: => hr_wnp_shd.g_old_rec.information14
340: ,p_information15_o
341: => hr_wnp_shd.g_old_rec.information15
335: => hr_wnp_shd.g_old_rec.information12
336: ,p_information13_o
337: => hr_wnp_shd.g_old_rec.information13
338: ,p_information14_o
339: => hr_wnp_shd.g_old_rec.information14
340: ,p_information15_o
341: => hr_wnp_shd.g_old_rec.information15
342: ,p_information16_o
343: => hr_wnp_shd.g_old_rec.information16
337: => hr_wnp_shd.g_old_rec.information13
338: ,p_information14_o
339: => hr_wnp_shd.g_old_rec.information14
340: ,p_information15_o
341: => hr_wnp_shd.g_old_rec.information15
342: ,p_information16_o
343: => hr_wnp_shd.g_old_rec.information16
344: ,p_information17_o
345: => hr_wnp_shd.g_old_rec.information17
339: => hr_wnp_shd.g_old_rec.information14
340: ,p_information15_o
341: => hr_wnp_shd.g_old_rec.information15
342: ,p_information16_o
343: => hr_wnp_shd.g_old_rec.information16
344: ,p_information17_o
345: => hr_wnp_shd.g_old_rec.information17
346: ,p_information18_o
347: => hr_wnp_shd.g_old_rec.information18
341: => hr_wnp_shd.g_old_rec.information15
342: ,p_information16_o
343: => hr_wnp_shd.g_old_rec.information16
344: ,p_information17_o
345: => hr_wnp_shd.g_old_rec.information17
346: ,p_information18_o
347: => hr_wnp_shd.g_old_rec.information18
348: ,p_information19_o
349: => hr_wnp_shd.g_old_rec.information19
343: => hr_wnp_shd.g_old_rec.information16
344: ,p_information17_o
345: => hr_wnp_shd.g_old_rec.information17
346: ,p_information18_o
347: => hr_wnp_shd.g_old_rec.information18
348: ,p_information19_o
349: => hr_wnp_shd.g_old_rec.information19
350: ,p_information20_o
351: => hr_wnp_shd.g_old_rec.information20
345: => hr_wnp_shd.g_old_rec.information17
346: ,p_information18_o
347: => hr_wnp_shd.g_old_rec.information18
348: ,p_information19_o
349: => hr_wnp_shd.g_old_rec.information19
350: ,p_information20_o
351: => hr_wnp_shd.g_old_rec.information20
352: ,p_information21_o
353: => hr_wnp_shd.g_old_rec.information21
347: => hr_wnp_shd.g_old_rec.information18
348: ,p_information19_o
349: => hr_wnp_shd.g_old_rec.information19
350: ,p_information20_o
351: => hr_wnp_shd.g_old_rec.information20
352: ,p_information21_o
353: => hr_wnp_shd.g_old_rec.information21
354: ,p_information22_o
355: => hr_wnp_shd.g_old_rec.information22
349: => hr_wnp_shd.g_old_rec.information19
350: ,p_information20_o
351: => hr_wnp_shd.g_old_rec.information20
352: ,p_information21_o
353: => hr_wnp_shd.g_old_rec.information21
354: ,p_information22_o
355: => hr_wnp_shd.g_old_rec.information22
356: ,p_information23_o
357: => hr_wnp_shd.g_old_rec.information23
351: => hr_wnp_shd.g_old_rec.information20
352: ,p_information21_o
353: => hr_wnp_shd.g_old_rec.information21
354: ,p_information22_o
355: => hr_wnp_shd.g_old_rec.information22
356: ,p_information23_o
357: => hr_wnp_shd.g_old_rec.information23
358: ,p_information24_o
359: => hr_wnp_shd.g_old_rec.information24
353: => hr_wnp_shd.g_old_rec.information21
354: ,p_information22_o
355: => hr_wnp_shd.g_old_rec.information22
356: ,p_information23_o
357: => hr_wnp_shd.g_old_rec.information23
358: ,p_information24_o
359: => hr_wnp_shd.g_old_rec.information24
360: ,p_information25_o
361: => hr_wnp_shd.g_old_rec.information25
355: => hr_wnp_shd.g_old_rec.information22
356: ,p_information23_o
357: => hr_wnp_shd.g_old_rec.information23
358: ,p_information24_o
359: => hr_wnp_shd.g_old_rec.information24
360: ,p_information25_o
361: => hr_wnp_shd.g_old_rec.information25
362: ,p_information26_o
363: => hr_wnp_shd.g_old_rec.information26
357: => hr_wnp_shd.g_old_rec.information23
358: ,p_information24_o
359: => hr_wnp_shd.g_old_rec.information24
360: ,p_information25_o
361: => hr_wnp_shd.g_old_rec.information25
362: ,p_information26_o
363: => hr_wnp_shd.g_old_rec.information26
364: ,p_information27_o
365: => hr_wnp_shd.g_old_rec.information27
359: => hr_wnp_shd.g_old_rec.information24
360: ,p_information25_o
361: => hr_wnp_shd.g_old_rec.information25
362: ,p_information26_o
363: => hr_wnp_shd.g_old_rec.information26
364: ,p_information27_o
365: => hr_wnp_shd.g_old_rec.information27
366: ,p_information28_o
367: => hr_wnp_shd.g_old_rec.information28
361: => hr_wnp_shd.g_old_rec.information25
362: ,p_information26_o
363: => hr_wnp_shd.g_old_rec.information26
364: ,p_information27_o
365: => hr_wnp_shd.g_old_rec.information27
366: ,p_information28_o
367: => hr_wnp_shd.g_old_rec.information28
368: ,p_information29_o
369: => hr_wnp_shd.g_old_rec.information29
363: => hr_wnp_shd.g_old_rec.information26
364: ,p_information27_o
365: => hr_wnp_shd.g_old_rec.information27
366: ,p_information28_o
367: => hr_wnp_shd.g_old_rec.information28
368: ,p_information29_o
369: => hr_wnp_shd.g_old_rec.information29
370: ,p_information30_o
371: => hr_wnp_shd.g_old_rec.information30
365: => hr_wnp_shd.g_old_rec.information27
366: ,p_information28_o
367: => hr_wnp_shd.g_old_rec.information28
368: ,p_information29_o
369: => hr_wnp_shd.g_old_rec.information29
370: ,p_information30_o
371: => hr_wnp_shd.g_old_rec.information30
372: );
373: --
367: => hr_wnp_shd.g_old_rec.information28
368: ,p_information29_o
369: => hr_wnp_shd.g_old_rec.information29
370: ,p_information30_o
371: => hr_wnp_shd.g_old_rec.information30
372: );
373: --
374: exception
375: --
427: --
428: -- {End Of Comments}
429: -- ----------------------------------------------------------------------------
430: Procedure convert_defs
431: (p_rec in out nocopy hr_wnp_shd.g_rec_type
432: ) is
433: --
434: Begin
435: --
439: -- is being used then we must set to the 'current' argument value.
440: --
441: If (p_rec.form_window_id = hr_api.g_number) then
442: p_rec.form_window_id :=
443: hr_wnp_shd.g_old_rec.form_window_id;
444: End If;
445: If (p_rec.template_window_id = hr_api.g_number) then
446: p_rec.template_window_id :=
447: hr_wnp_shd.g_old_rec.template_window_id;
443: hr_wnp_shd.g_old_rec.form_window_id;
444: End If;
445: If (p_rec.template_window_id = hr_api.g_number) then
446: p_rec.template_window_id :=
447: hr_wnp_shd.g_old_rec.template_window_id;
448: End If;
449: If (p_rec.height = hr_api.g_number) then
450: p_rec.height :=
451: hr_wnp_shd.g_old_rec.height;
447: hr_wnp_shd.g_old_rec.template_window_id;
448: End If;
449: If (p_rec.height = hr_api.g_number) then
450: p_rec.height :=
451: hr_wnp_shd.g_old_rec.height;
452: End If;
453: If (p_rec.width = hr_api.g_number) then
454: p_rec.width :=
455: hr_wnp_shd.g_old_rec.width;
451: hr_wnp_shd.g_old_rec.height;
452: End If;
453: If (p_rec.width = hr_api.g_number) then
454: p_rec.width :=
455: hr_wnp_shd.g_old_rec.width;
456: End If;
457: If (p_rec.x_position = hr_api.g_number) then
458: p_rec.x_position :=
459: hr_wnp_shd.g_old_rec.x_position;
455: hr_wnp_shd.g_old_rec.width;
456: End If;
457: If (p_rec.x_position = hr_api.g_number) then
458: p_rec.x_position :=
459: hr_wnp_shd.g_old_rec.x_position;
460: End If;
461: If (p_rec.y_position = hr_api.g_number) then
462: p_rec.y_position :=
463: hr_wnp_shd.g_old_rec.y_position;
459: hr_wnp_shd.g_old_rec.x_position;
460: End If;
461: If (p_rec.y_position = hr_api.g_number) then
462: p_rec.y_position :=
463: hr_wnp_shd.g_old_rec.y_position;
464: End If;
465: If (p_rec.information_category = hr_api.g_varchar2) then
466: p_rec.information_category :=
467: hr_wnp_shd.g_old_rec.information_category;
463: hr_wnp_shd.g_old_rec.y_position;
464: End If;
465: If (p_rec.information_category = hr_api.g_varchar2) then
466: p_rec.information_category :=
467: hr_wnp_shd.g_old_rec.information_category;
468: End If;
469: If (p_rec.information1 = hr_api.g_varchar2) then
470: p_rec.information1 :=
471: hr_wnp_shd.g_old_rec.information1;
467: hr_wnp_shd.g_old_rec.information_category;
468: End If;
469: If (p_rec.information1 = hr_api.g_varchar2) then
470: p_rec.information1 :=
471: hr_wnp_shd.g_old_rec.information1;
472: End If;
473: If (p_rec.information2 = hr_api.g_varchar2) then
474: p_rec.information2 :=
475: hr_wnp_shd.g_old_rec.information2;
471: hr_wnp_shd.g_old_rec.information1;
472: End If;
473: If (p_rec.information2 = hr_api.g_varchar2) then
474: p_rec.information2 :=
475: hr_wnp_shd.g_old_rec.information2;
476: End If;
477: If (p_rec.information3 = hr_api.g_varchar2) then
478: p_rec.information3 :=
479: hr_wnp_shd.g_old_rec.information3;
475: hr_wnp_shd.g_old_rec.information2;
476: End If;
477: If (p_rec.information3 = hr_api.g_varchar2) then
478: p_rec.information3 :=
479: hr_wnp_shd.g_old_rec.information3;
480: End If;
481: If (p_rec.information4 = hr_api.g_varchar2) then
482: p_rec.information4 :=
483: hr_wnp_shd.g_old_rec.information4;
479: hr_wnp_shd.g_old_rec.information3;
480: End If;
481: If (p_rec.information4 = hr_api.g_varchar2) then
482: p_rec.information4 :=
483: hr_wnp_shd.g_old_rec.information4;
484: End If;
485: If (p_rec.information5 = hr_api.g_varchar2) then
486: p_rec.information5 :=
487: hr_wnp_shd.g_old_rec.information5;
483: hr_wnp_shd.g_old_rec.information4;
484: End If;
485: If (p_rec.information5 = hr_api.g_varchar2) then
486: p_rec.information5 :=
487: hr_wnp_shd.g_old_rec.information5;
488: End If;
489: If (p_rec.information6 = hr_api.g_varchar2) then
490: p_rec.information6 :=
491: hr_wnp_shd.g_old_rec.information6;
487: hr_wnp_shd.g_old_rec.information5;
488: End If;
489: If (p_rec.information6 = hr_api.g_varchar2) then
490: p_rec.information6 :=
491: hr_wnp_shd.g_old_rec.information6;
492: End If;
493: If (p_rec.information7 = hr_api.g_varchar2) then
494: p_rec.information7 :=
495: hr_wnp_shd.g_old_rec.information7;
491: hr_wnp_shd.g_old_rec.information6;
492: End If;
493: If (p_rec.information7 = hr_api.g_varchar2) then
494: p_rec.information7 :=
495: hr_wnp_shd.g_old_rec.information7;
496: End If;
497: If (p_rec.information8 = hr_api.g_varchar2) then
498: p_rec.information8 :=
499: hr_wnp_shd.g_old_rec.information8;
495: hr_wnp_shd.g_old_rec.information7;
496: End If;
497: If (p_rec.information8 = hr_api.g_varchar2) then
498: p_rec.information8 :=
499: hr_wnp_shd.g_old_rec.information8;
500: End If;
501: If (p_rec.information9 = hr_api.g_varchar2) then
502: p_rec.information9 :=
503: hr_wnp_shd.g_old_rec.information9;
499: hr_wnp_shd.g_old_rec.information8;
500: End If;
501: If (p_rec.information9 = hr_api.g_varchar2) then
502: p_rec.information9 :=
503: hr_wnp_shd.g_old_rec.information9;
504: End If;
505: If (p_rec.information10 = hr_api.g_varchar2) then
506: p_rec.information10 :=
507: hr_wnp_shd.g_old_rec.information10;
503: hr_wnp_shd.g_old_rec.information9;
504: End If;
505: If (p_rec.information10 = hr_api.g_varchar2) then
506: p_rec.information10 :=
507: hr_wnp_shd.g_old_rec.information10;
508: End If;
509: If (p_rec.information11 = hr_api.g_varchar2) then
510: p_rec.information11 :=
511: hr_wnp_shd.g_old_rec.information11;
507: hr_wnp_shd.g_old_rec.information10;
508: End If;
509: If (p_rec.information11 = hr_api.g_varchar2) then
510: p_rec.information11 :=
511: hr_wnp_shd.g_old_rec.information11;
512: End If;
513: If (p_rec.information12 = hr_api.g_varchar2) then
514: p_rec.information12 :=
515: hr_wnp_shd.g_old_rec.information12;
511: hr_wnp_shd.g_old_rec.information11;
512: End If;
513: If (p_rec.information12 = hr_api.g_varchar2) then
514: p_rec.information12 :=
515: hr_wnp_shd.g_old_rec.information12;
516: End If;
517: If (p_rec.information13 = hr_api.g_varchar2) then
518: p_rec.information13 :=
519: hr_wnp_shd.g_old_rec.information13;
515: hr_wnp_shd.g_old_rec.information12;
516: End If;
517: If (p_rec.information13 = hr_api.g_varchar2) then
518: p_rec.information13 :=
519: hr_wnp_shd.g_old_rec.information13;
520: End If;
521: If (p_rec.information14 = hr_api.g_varchar2) then
522: p_rec.information14 :=
523: hr_wnp_shd.g_old_rec.information14;
519: hr_wnp_shd.g_old_rec.information13;
520: End If;
521: If (p_rec.information14 = hr_api.g_varchar2) then
522: p_rec.information14 :=
523: hr_wnp_shd.g_old_rec.information14;
524: End If;
525: If (p_rec.information15 = hr_api.g_varchar2) then
526: p_rec.information15 :=
527: hr_wnp_shd.g_old_rec.information15;
523: hr_wnp_shd.g_old_rec.information14;
524: End If;
525: If (p_rec.information15 = hr_api.g_varchar2) then
526: p_rec.information15 :=
527: hr_wnp_shd.g_old_rec.information15;
528: End If;
529: If (p_rec.information16 = hr_api.g_varchar2) then
530: p_rec.information16 :=
531: hr_wnp_shd.g_old_rec.information16;
527: hr_wnp_shd.g_old_rec.information15;
528: End If;
529: If (p_rec.information16 = hr_api.g_varchar2) then
530: p_rec.information16 :=
531: hr_wnp_shd.g_old_rec.information16;
532: End If;
533: If (p_rec.information17 = hr_api.g_varchar2) then
534: p_rec.information17 :=
535: hr_wnp_shd.g_old_rec.information17;
531: hr_wnp_shd.g_old_rec.information16;
532: End If;
533: If (p_rec.information17 = hr_api.g_varchar2) then
534: p_rec.information17 :=
535: hr_wnp_shd.g_old_rec.information17;
536: End If;
537: If (p_rec.information18 = hr_api.g_varchar2) then
538: p_rec.information18 :=
539: hr_wnp_shd.g_old_rec.information18;
535: hr_wnp_shd.g_old_rec.information17;
536: End If;
537: If (p_rec.information18 = hr_api.g_varchar2) then
538: p_rec.information18 :=
539: hr_wnp_shd.g_old_rec.information18;
540: End If;
541: If (p_rec.information19 = hr_api.g_varchar2) then
542: p_rec.information19 :=
543: hr_wnp_shd.g_old_rec.information19;
539: hr_wnp_shd.g_old_rec.information18;
540: End If;
541: If (p_rec.information19 = hr_api.g_varchar2) then
542: p_rec.information19 :=
543: hr_wnp_shd.g_old_rec.information19;
544: End If;
545: If (p_rec.information20 = hr_api.g_varchar2) then
546: p_rec.information20 :=
547: hr_wnp_shd.g_old_rec.information20;
543: hr_wnp_shd.g_old_rec.information19;
544: End If;
545: If (p_rec.information20 = hr_api.g_varchar2) then
546: p_rec.information20 :=
547: hr_wnp_shd.g_old_rec.information20;
548: End If;
549: If (p_rec.information21 = hr_api.g_varchar2) then
550: p_rec.information21 :=
551: hr_wnp_shd.g_old_rec.information21;
547: hr_wnp_shd.g_old_rec.information20;
548: End If;
549: If (p_rec.information21 = hr_api.g_varchar2) then
550: p_rec.information21 :=
551: hr_wnp_shd.g_old_rec.information21;
552: End If;
553: If (p_rec.information22 = hr_api.g_varchar2) then
554: p_rec.information22 :=
555: hr_wnp_shd.g_old_rec.information22;
551: hr_wnp_shd.g_old_rec.information21;
552: End If;
553: If (p_rec.information22 = hr_api.g_varchar2) then
554: p_rec.information22 :=
555: hr_wnp_shd.g_old_rec.information22;
556: End If;
557: If (p_rec.information23 = hr_api.g_varchar2) then
558: p_rec.information23 :=
559: hr_wnp_shd.g_old_rec.information23;
555: hr_wnp_shd.g_old_rec.information22;
556: End If;
557: If (p_rec.information23 = hr_api.g_varchar2) then
558: p_rec.information23 :=
559: hr_wnp_shd.g_old_rec.information23;
560: End If;
561: If (p_rec.information24 = hr_api.g_varchar2) then
562: p_rec.information24 :=
563: hr_wnp_shd.g_old_rec.information24;
559: hr_wnp_shd.g_old_rec.information23;
560: End If;
561: If (p_rec.information24 = hr_api.g_varchar2) then
562: p_rec.information24 :=
563: hr_wnp_shd.g_old_rec.information24;
564: End If;
565: If (p_rec.information25 = hr_api.g_varchar2) then
566: p_rec.information25 :=
567: hr_wnp_shd.g_old_rec.information25;
563: hr_wnp_shd.g_old_rec.information24;
564: End If;
565: If (p_rec.information25 = hr_api.g_varchar2) then
566: p_rec.information25 :=
567: hr_wnp_shd.g_old_rec.information25;
568: End If;
569: If (p_rec.information26 = hr_api.g_varchar2) then
570: p_rec.information26 :=
571: hr_wnp_shd.g_old_rec.information26;
567: hr_wnp_shd.g_old_rec.information25;
568: End If;
569: If (p_rec.information26 = hr_api.g_varchar2) then
570: p_rec.information26 :=
571: hr_wnp_shd.g_old_rec.information26;
572: End If;
573: If (p_rec.information27 = hr_api.g_varchar2) then
574: p_rec.information27 :=
575: hr_wnp_shd.g_old_rec.information27;
571: hr_wnp_shd.g_old_rec.information26;
572: End If;
573: If (p_rec.information27 = hr_api.g_varchar2) then
574: p_rec.information27 :=
575: hr_wnp_shd.g_old_rec.information27;
576: End If;
577: If (p_rec.information28 = hr_api.g_varchar2) then
578: p_rec.information28 :=
579: hr_wnp_shd.g_old_rec.information28;
575: hr_wnp_shd.g_old_rec.information27;
576: End If;
577: If (p_rec.information28 = hr_api.g_varchar2) then
578: p_rec.information28 :=
579: hr_wnp_shd.g_old_rec.information28;
580: End If;
581: If (p_rec.information29 = hr_api.g_varchar2) then
582: p_rec.information29 :=
583: hr_wnp_shd.g_old_rec.information29;
579: hr_wnp_shd.g_old_rec.information28;
580: End If;
581: If (p_rec.information29 = hr_api.g_varchar2) then
582: p_rec.information29 :=
583: hr_wnp_shd.g_old_rec.information29;
584: End If;
585: If (p_rec.information30 = hr_api.g_varchar2) then
586: p_rec.information30 :=
587: hr_wnp_shd.g_old_rec.information30;
583: hr_wnp_shd.g_old_rec.information29;
584: End If;
585: If (p_rec.information30 = hr_api.g_varchar2) then
586: p_rec.information30 :=
587: hr_wnp_shd.g_old_rec.information30;
588: End If;
589: --
590: End convert_defs;
591: --
592: -- ----------------------------------------------------------------------------
593: -- |---------------------------------< upd >----------------------------------|
594: -- ----------------------------------------------------------------------------
595: Procedure upd
596: (p_rec in out nocopy hr_wnp_shd.g_rec_type
597: ) is
598: --
599: l_proc varchar2(72) := g_package||'upd';
600: --
602: hr_utility.set_location('Entering:'||l_proc, 5);
603: --
604: -- We must lock the row which we need to update.
605: --
606: hr_wnp_shd.lck
607: (p_rec.window_property_id
608: );
609: --
610: -- 1. During an update system defaults are used to determine if
676: ,p_information29 in varchar2 default hr_api.g_varchar2
677: ,p_information30 in varchar2 default hr_api.g_varchar2
678: ) is
679: --
680: l_rec hr_wnp_shd.g_rec_type;
681: l_proc varchar2(72) := g_package||'upd';
682: --
683: Begin
684: hr_utility.set_location('Entering:'||l_proc, 5);
686: -- Call conversion function to turn arguments into the
687: -- l_rec structure.
688: --
689: l_rec :=
690: hr_wnp_shd.convert_args
691: (p_window_property_id
692: ,p_form_window_id
693: ,p_template_window_id
694: ,p_height