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