113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: --
116: Exception
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: hr_cnp_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.check_integrity_violated Then
118: -- A check constraint has been violated
119: --
120: hr_cnp_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: hr_cnp_shd.constraint_error
118: -- A check constraint has been violated
119: --
120: hr_cnp_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: hr_cnp_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: --
125: hr_cnp_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: hr_cnp_shd.constraint_error
123: -- Parent integrity has been violated
124: --
125: hr_cnp_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: hr_cnp_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.unique_integrity_violated Then
128: -- Unique integrity has been violated
129: --
130: hr_cnp_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When Others Then
133: --
134: Raise;
135: End update_dml;
305: );
306: --
307: exception
308: --
309: when hr_api.cannot_find_prog_unit then
310: --
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'HR_CANVAS_PROPERTIES'
313: ,p_hook_type => 'AU');
307: exception
308: --
309: when hr_api.cannot_find_prog_unit then
310: --
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'HR_CANVAS_PROPERTIES'
313: ,p_hook_type => 'AU');
314: --
315: end;
370: -- p_rec plsql record structure
371: -- to see if a system default is being used. If a system default
372: -- is being used then we must set to the 'current' argument value.
373: --
374: If (p_rec.form_canvas_id = hr_api.g_number) then
375: p_rec.form_canvas_id := hr_cnp_shd.g_old_rec.form_canvas_id;
376: End If;
377: If (p_rec.template_canvas_id = hr_api.g_number) then
378: p_rec.template_canvas_id := hr_cnp_shd.g_old_rec.template_canvas_id;
373: --
374: If (p_rec.form_canvas_id = hr_api.g_number) then
375: p_rec.form_canvas_id := hr_cnp_shd.g_old_rec.form_canvas_id;
376: End If;
377: If (p_rec.template_canvas_id = hr_api.g_number) then
378: p_rec.template_canvas_id := hr_cnp_shd.g_old_rec.template_canvas_id;
379: End If;
380: If (p_rec.height = hr_api.g_number) then
381: p_rec.height := hr_cnp_shd.g_old_rec.height;
376: End If;
377: If (p_rec.template_canvas_id = hr_api.g_number) then
378: p_rec.template_canvas_id := hr_cnp_shd.g_old_rec.template_canvas_id;
379: End If;
380: If (p_rec.height = hr_api.g_number) then
381: p_rec.height := hr_cnp_shd.g_old_rec.height;
382: End If;
383: If (p_rec.visible = hr_api.g_number) then
384: p_rec.visible := hr_cnp_shd.g_old_rec.visible;
379: End If;
380: If (p_rec.height = hr_api.g_number) then
381: p_rec.height := hr_cnp_shd.g_old_rec.height;
382: End If;
383: If (p_rec.visible = hr_api.g_number) then
384: p_rec.visible := hr_cnp_shd.g_old_rec.visible;
385: End If;
386: If (p_rec.width = hr_api.g_number) then
387: p_rec.width := hr_cnp_shd.g_old_rec.width;
382: End If;
383: If (p_rec.visible = hr_api.g_number) then
384: p_rec.visible := hr_cnp_shd.g_old_rec.visible;
385: End If;
386: If (p_rec.width = hr_api.g_number) then
387: p_rec.width := hr_cnp_shd.g_old_rec.width;
388: End If;
389: If (p_rec.x_position = hr_api.g_number) then
390: p_rec.x_position := hr_cnp_shd.g_old_rec.x_position;
385: End If;
386: If (p_rec.width = hr_api.g_number) then
387: p_rec.width := hr_cnp_shd.g_old_rec.width;
388: End If;
389: If (p_rec.x_position = hr_api.g_number) then
390: p_rec.x_position := hr_cnp_shd.g_old_rec.x_position;
391: End If;
392: If (p_rec.y_position = hr_api.g_number) then
393: p_rec.y_position := hr_cnp_shd.g_old_rec.y_position;
388: End If;
389: If (p_rec.x_position = hr_api.g_number) then
390: p_rec.x_position := hr_cnp_shd.g_old_rec.x_position;
391: End If;
392: If (p_rec.y_position = hr_api.g_number) then
393: p_rec.y_position := hr_cnp_shd.g_old_rec.y_position;
394: End If;
395: If (p_rec.information_category = hr_api.g_varchar2) then
396: p_rec.information_category := hr_cnp_shd.g_old_rec.information_category;
391: End If;
392: If (p_rec.y_position = hr_api.g_number) then
393: p_rec.y_position := hr_cnp_shd.g_old_rec.y_position;
394: End If;
395: If (p_rec.information_category = hr_api.g_varchar2) then
396: p_rec.information_category := hr_cnp_shd.g_old_rec.information_category;
397: End If;
398: If (p_rec.information1 = hr_api.g_varchar2) then
399: p_rec.information1 := hr_cnp_shd.g_old_rec.information1;
394: End If;
395: If (p_rec.information_category = hr_api.g_varchar2) then
396: p_rec.information_category := hr_cnp_shd.g_old_rec.information_category;
397: End If;
398: If (p_rec.information1 = hr_api.g_varchar2) then
399: p_rec.information1 := hr_cnp_shd.g_old_rec.information1;
400: End If;
401: If (p_rec.information2 = hr_api.g_varchar2) then
402: p_rec.information2 := hr_cnp_shd.g_old_rec.information2;
397: End If;
398: If (p_rec.information1 = hr_api.g_varchar2) then
399: p_rec.information1 := hr_cnp_shd.g_old_rec.information1;
400: End If;
401: If (p_rec.information2 = hr_api.g_varchar2) then
402: p_rec.information2 := hr_cnp_shd.g_old_rec.information2;
403: End If;
404: If (p_rec.information3 = hr_api.g_varchar2) then
405: p_rec.information3 := hr_cnp_shd.g_old_rec.information3;
400: End If;
401: If (p_rec.information2 = hr_api.g_varchar2) then
402: p_rec.information2 := hr_cnp_shd.g_old_rec.information2;
403: End If;
404: If (p_rec.information3 = hr_api.g_varchar2) then
405: p_rec.information3 := hr_cnp_shd.g_old_rec.information3;
406: End If;
407: If (p_rec.information4 = hr_api.g_varchar2) then
408: p_rec.information4 := hr_cnp_shd.g_old_rec.information4;
403: End If;
404: If (p_rec.information3 = hr_api.g_varchar2) then
405: p_rec.information3 := hr_cnp_shd.g_old_rec.information3;
406: End If;
407: If (p_rec.information4 = hr_api.g_varchar2) then
408: p_rec.information4 := hr_cnp_shd.g_old_rec.information4;
409: End If;
410: If (p_rec.information5 = hr_api.g_varchar2) then
411: p_rec.information5 := hr_cnp_shd.g_old_rec.information5;
406: End If;
407: If (p_rec.information4 = hr_api.g_varchar2) then
408: p_rec.information4 := hr_cnp_shd.g_old_rec.information4;
409: End If;
410: If (p_rec.information5 = hr_api.g_varchar2) then
411: p_rec.information5 := hr_cnp_shd.g_old_rec.information5;
412: End If;
413: If (p_rec.information6 = hr_api.g_varchar2) then
414: p_rec.information6 := hr_cnp_shd.g_old_rec.information6;
409: End If;
410: If (p_rec.information5 = hr_api.g_varchar2) then
411: p_rec.information5 := hr_cnp_shd.g_old_rec.information5;
412: End If;
413: If (p_rec.information6 = hr_api.g_varchar2) then
414: p_rec.information6 := hr_cnp_shd.g_old_rec.information6;
415: End If;
416: If (p_rec.information7 = hr_api.g_varchar2) then
417: p_rec.information7 := hr_cnp_shd.g_old_rec.information7;
412: End If;
413: If (p_rec.information6 = hr_api.g_varchar2) then
414: p_rec.information6 := hr_cnp_shd.g_old_rec.information6;
415: End If;
416: If (p_rec.information7 = hr_api.g_varchar2) then
417: p_rec.information7 := hr_cnp_shd.g_old_rec.information7;
418: End If;
419: If (p_rec.information8 = hr_api.g_varchar2) then
420: p_rec.information8 := hr_cnp_shd.g_old_rec.information8;
415: End If;
416: If (p_rec.information7 = hr_api.g_varchar2) then
417: p_rec.information7 := hr_cnp_shd.g_old_rec.information7;
418: End If;
419: If (p_rec.information8 = hr_api.g_varchar2) then
420: p_rec.information8 := hr_cnp_shd.g_old_rec.information8;
421: End If;
422: If (p_rec.information9 = hr_api.g_varchar2) then
423: p_rec.information9 := hr_cnp_shd.g_old_rec.information9;
418: End If;
419: If (p_rec.information8 = hr_api.g_varchar2) then
420: p_rec.information8 := hr_cnp_shd.g_old_rec.information8;
421: End If;
422: If (p_rec.information9 = hr_api.g_varchar2) then
423: p_rec.information9 := hr_cnp_shd.g_old_rec.information9;
424: End If;
425: If (p_rec.information10 = hr_api.g_varchar2) then
426: p_rec.information10 := hr_cnp_shd.g_old_rec.information10;
421: End If;
422: If (p_rec.information9 = hr_api.g_varchar2) then
423: p_rec.information9 := hr_cnp_shd.g_old_rec.information9;
424: End If;
425: If (p_rec.information10 = hr_api.g_varchar2) then
426: p_rec.information10 := hr_cnp_shd.g_old_rec.information10;
427: End If;
428: If (p_rec.information11 = hr_api.g_varchar2) then
429: p_rec.information11 := hr_cnp_shd.g_old_rec.information11;
424: End If;
425: If (p_rec.information10 = hr_api.g_varchar2) then
426: p_rec.information10 := hr_cnp_shd.g_old_rec.information10;
427: End If;
428: If (p_rec.information11 = hr_api.g_varchar2) then
429: p_rec.information11 := hr_cnp_shd.g_old_rec.information11;
430: End If;
431: If (p_rec.information12 = hr_api.g_varchar2) then
432: p_rec.information12 := hr_cnp_shd.g_old_rec.information12;
427: End If;
428: If (p_rec.information11 = hr_api.g_varchar2) then
429: p_rec.information11 := hr_cnp_shd.g_old_rec.information11;
430: End If;
431: If (p_rec.information12 = hr_api.g_varchar2) then
432: p_rec.information12 := hr_cnp_shd.g_old_rec.information12;
433: End If;
434: If (p_rec.information13 = hr_api.g_varchar2) then
435: p_rec.information13 := hr_cnp_shd.g_old_rec.information13;
430: End If;
431: If (p_rec.information12 = hr_api.g_varchar2) then
432: p_rec.information12 := hr_cnp_shd.g_old_rec.information12;
433: End If;
434: If (p_rec.information13 = hr_api.g_varchar2) then
435: p_rec.information13 := hr_cnp_shd.g_old_rec.information13;
436: End If;
437: If (p_rec.information14 = hr_api.g_varchar2) then
438: p_rec.information14 := hr_cnp_shd.g_old_rec.information14;
433: End If;
434: If (p_rec.information13 = hr_api.g_varchar2) then
435: p_rec.information13 := hr_cnp_shd.g_old_rec.information13;
436: End If;
437: If (p_rec.information14 = hr_api.g_varchar2) then
438: p_rec.information14 := hr_cnp_shd.g_old_rec.information14;
439: End If;
440: If (p_rec.information15 = hr_api.g_varchar2) then
441: p_rec.information15 := hr_cnp_shd.g_old_rec.information15;
436: End If;
437: If (p_rec.information14 = hr_api.g_varchar2) then
438: p_rec.information14 := hr_cnp_shd.g_old_rec.information14;
439: End If;
440: If (p_rec.information15 = hr_api.g_varchar2) then
441: p_rec.information15 := hr_cnp_shd.g_old_rec.information15;
442: End If;
443: If (p_rec.information16 = hr_api.g_varchar2) then
444: p_rec.information16 := hr_cnp_shd.g_old_rec.information16;
439: End If;
440: If (p_rec.information15 = hr_api.g_varchar2) then
441: p_rec.information15 := hr_cnp_shd.g_old_rec.information15;
442: End If;
443: If (p_rec.information16 = hr_api.g_varchar2) then
444: p_rec.information16 := hr_cnp_shd.g_old_rec.information16;
445: End If;
446: If (p_rec.information17 = hr_api.g_varchar2) then
447: p_rec.information17 := hr_cnp_shd.g_old_rec.information17;
442: End If;
443: If (p_rec.information16 = hr_api.g_varchar2) then
444: p_rec.information16 := hr_cnp_shd.g_old_rec.information16;
445: End If;
446: If (p_rec.information17 = hr_api.g_varchar2) then
447: p_rec.information17 := hr_cnp_shd.g_old_rec.information17;
448: End If;
449: If (p_rec.information18 = hr_api.g_varchar2) then
450: p_rec.information18 := hr_cnp_shd.g_old_rec.information18;
445: End If;
446: If (p_rec.information17 = hr_api.g_varchar2) then
447: p_rec.information17 := hr_cnp_shd.g_old_rec.information17;
448: End If;
449: If (p_rec.information18 = hr_api.g_varchar2) then
450: p_rec.information18 := hr_cnp_shd.g_old_rec.information18;
451: End If;
452: If (p_rec.information19 = hr_api.g_varchar2) then
453: p_rec.information19 := hr_cnp_shd.g_old_rec.information19;
448: End If;
449: If (p_rec.information18 = hr_api.g_varchar2) then
450: p_rec.information18 := hr_cnp_shd.g_old_rec.information18;
451: End If;
452: If (p_rec.information19 = hr_api.g_varchar2) then
453: p_rec.information19 := hr_cnp_shd.g_old_rec.information19;
454: End If;
455: If (p_rec.information20 = hr_api.g_varchar2) then
456: p_rec.information20 := hr_cnp_shd.g_old_rec.information20;
451: End If;
452: If (p_rec.information19 = hr_api.g_varchar2) then
453: p_rec.information19 := hr_cnp_shd.g_old_rec.information19;
454: End If;
455: If (p_rec.information20 = hr_api.g_varchar2) then
456: p_rec.information20 := hr_cnp_shd.g_old_rec.information20;
457: End If;
458: If (p_rec.information21 = hr_api.g_varchar2) then
459: p_rec.information21 := hr_cnp_shd.g_old_rec.information21;
454: End If;
455: If (p_rec.information20 = hr_api.g_varchar2) then
456: p_rec.information20 := hr_cnp_shd.g_old_rec.information20;
457: End If;
458: If (p_rec.information21 = hr_api.g_varchar2) then
459: p_rec.information21 := hr_cnp_shd.g_old_rec.information21;
460: End If;
461: If (p_rec.information22 = hr_api.g_varchar2) then
462: p_rec.information22 := hr_cnp_shd.g_old_rec.information22;
457: End If;
458: If (p_rec.information21 = hr_api.g_varchar2) then
459: p_rec.information21 := hr_cnp_shd.g_old_rec.information21;
460: End If;
461: If (p_rec.information22 = hr_api.g_varchar2) then
462: p_rec.information22 := hr_cnp_shd.g_old_rec.information22;
463: End If;
464: If (p_rec.information23 = hr_api.g_varchar2) then
465: p_rec.information23 := hr_cnp_shd.g_old_rec.information23;
460: End If;
461: If (p_rec.information22 = hr_api.g_varchar2) then
462: p_rec.information22 := hr_cnp_shd.g_old_rec.information22;
463: End If;
464: If (p_rec.information23 = hr_api.g_varchar2) then
465: p_rec.information23 := hr_cnp_shd.g_old_rec.information23;
466: End If;
467: If (p_rec.information24 = hr_api.g_varchar2) then
468: p_rec.information24 := hr_cnp_shd.g_old_rec.information24;
463: End If;
464: If (p_rec.information23 = hr_api.g_varchar2) then
465: p_rec.information23 := hr_cnp_shd.g_old_rec.information23;
466: End If;
467: If (p_rec.information24 = hr_api.g_varchar2) then
468: p_rec.information24 := hr_cnp_shd.g_old_rec.information24;
469: End If;
470: If (p_rec.information25 = hr_api.g_varchar2) then
471: p_rec.information25 := hr_cnp_shd.g_old_rec.information25;
466: End If;
467: If (p_rec.information24 = hr_api.g_varchar2) then
468: p_rec.information24 := hr_cnp_shd.g_old_rec.information24;
469: End If;
470: If (p_rec.information25 = hr_api.g_varchar2) then
471: p_rec.information25 := hr_cnp_shd.g_old_rec.information25;
472: End If;
473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 := hr_cnp_shd.g_old_rec.information26;
469: End If;
470: If (p_rec.information25 = hr_api.g_varchar2) then
471: p_rec.information25 := hr_cnp_shd.g_old_rec.information25;
472: End If;
473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 := hr_cnp_shd.g_old_rec.information26;
475: End If;
476: If (p_rec.information27 = hr_api.g_varchar2) then
477: p_rec.information27 := hr_cnp_shd.g_old_rec.information27;
472: End If;
473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 := hr_cnp_shd.g_old_rec.information26;
475: End If;
476: If (p_rec.information27 = hr_api.g_varchar2) then
477: p_rec.information27 := hr_cnp_shd.g_old_rec.information27;
478: End If;
479: If (p_rec.information28 = hr_api.g_varchar2) then
480: p_rec.information28 := hr_cnp_shd.g_old_rec.information28;
475: End If;
476: If (p_rec.information27 = hr_api.g_varchar2) then
477: p_rec.information27 := hr_cnp_shd.g_old_rec.information27;
478: End If;
479: If (p_rec.information28 = hr_api.g_varchar2) then
480: p_rec.information28 := hr_cnp_shd.g_old_rec.information28;
481: End If;
482: If (p_rec.information29 = hr_api.g_varchar2) then
483: p_rec.information29 := hr_cnp_shd.g_old_rec.information29;
478: End If;
479: If (p_rec.information28 = hr_api.g_varchar2) then
480: p_rec.information28 := hr_cnp_shd.g_old_rec.information28;
481: End If;
482: If (p_rec.information29 = hr_api.g_varchar2) then
483: p_rec.information29 := hr_cnp_shd.g_old_rec.information29;
484: End If;
485: If (p_rec.information30 = hr_api.g_varchar2) then
486: p_rec.information30 := hr_cnp_shd.g_old_rec.information30;
481: End If;
482: If (p_rec.information29 = hr_api.g_varchar2) then
483: p_rec.information29 := hr_cnp_shd.g_old_rec.information29;
484: End If;
485: If (p_rec.information30 = hr_api.g_varchar2) then
486: p_rec.information30 := hr_cnp_shd.g_old_rec.information30;
487: End If;
488: --
489: End convert_defs;
542: Procedure upd
543: (p_effective_date in date
544: ,p_canvas_property_id in number
545: ,p_object_version_number in out nocopy number
546: ,p_form_canvas_id in number default hr_api.g_number
547: ,p_template_canvas_id in number default hr_api.g_number
548: ,p_height in number default hr_api.g_number
549: ,p_visible in number default hr_api.g_number
550: ,p_width in number default hr_api.g_number
543: (p_effective_date in date
544: ,p_canvas_property_id in number
545: ,p_object_version_number in out nocopy number
546: ,p_form_canvas_id in number default hr_api.g_number
547: ,p_template_canvas_id in number default hr_api.g_number
548: ,p_height in number default hr_api.g_number
549: ,p_visible in number default hr_api.g_number
550: ,p_width in number default hr_api.g_number
551: ,p_x_position in number default hr_api.g_number
544: ,p_canvas_property_id in number
545: ,p_object_version_number in out nocopy number
546: ,p_form_canvas_id in number default hr_api.g_number
547: ,p_template_canvas_id in number default hr_api.g_number
548: ,p_height in number default hr_api.g_number
549: ,p_visible in number default hr_api.g_number
550: ,p_width in number default hr_api.g_number
551: ,p_x_position in number default hr_api.g_number
552: ,p_y_position in number default hr_api.g_number
545: ,p_object_version_number in out nocopy number
546: ,p_form_canvas_id in number default hr_api.g_number
547: ,p_template_canvas_id in number default hr_api.g_number
548: ,p_height in number default hr_api.g_number
549: ,p_visible in number default hr_api.g_number
550: ,p_width in number default hr_api.g_number
551: ,p_x_position in number default hr_api.g_number
552: ,p_y_position in number default hr_api.g_number
553: ,p_information_category in varchar2 default hr_api.g_varchar2
546: ,p_form_canvas_id in number default hr_api.g_number
547: ,p_template_canvas_id in number default hr_api.g_number
548: ,p_height in number default hr_api.g_number
549: ,p_visible in number default hr_api.g_number
550: ,p_width in number default hr_api.g_number
551: ,p_x_position in number default hr_api.g_number
552: ,p_y_position in number default hr_api.g_number
553: ,p_information_category in varchar2 default hr_api.g_varchar2
554: ,p_information1 in varchar2 default hr_api.g_varchar2
547: ,p_template_canvas_id in number default hr_api.g_number
548: ,p_height in number default hr_api.g_number
549: ,p_visible in number default hr_api.g_number
550: ,p_width in number default hr_api.g_number
551: ,p_x_position in number default hr_api.g_number
552: ,p_y_position in number default hr_api.g_number
553: ,p_information_category in varchar2 default hr_api.g_varchar2
554: ,p_information1 in varchar2 default hr_api.g_varchar2
555: ,p_information2 in varchar2 default hr_api.g_varchar2
548: ,p_height in number default hr_api.g_number
549: ,p_visible in number default hr_api.g_number
550: ,p_width in number default hr_api.g_number
551: ,p_x_position in number default hr_api.g_number
552: ,p_y_position in number default hr_api.g_number
553: ,p_information_category in varchar2 default hr_api.g_varchar2
554: ,p_information1 in varchar2 default hr_api.g_varchar2
555: ,p_information2 in varchar2 default hr_api.g_varchar2
556: ,p_information3 in varchar2 default hr_api.g_varchar2
549: ,p_visible in number default hr_api.g_number
550: ,p_width in number default hr_api.g_number
551: ,p_x_position in number default hr_api.g_number
552: ,p_y_position in number default hr_api.g_number
553: ,p_information_category in varchar2 default hr_api.g_varchar2
554: ,p_information1 in varchar2 default hr_api.g_varchar2
555: ,p_information2 in varchar2 default hr_api.g_varchar2
556: ,p_information3 in varchar2 default hr_api.g_varchar2
557: ,p_information4 in varchar2 default hr_api.g_varchar2
550: ,p_width in number default hr_api.g_number
551: ,p_x_position in number default hr_api.g_number
552: ,p_y_position in number default hr_api.g_number
553: ,p_information_category in varchar2 default hr_api.g_varchar2
554: ,p_information1 in varchar2 default hr_api.g_varchar2
555: ,p_information2 in varchar2 default hr_api.g_varchar2
556: ,p_information3 in varchar2 default hr_api.g_varchar2
557: ,p_information4 in varchar2 default hr_api.g_varchar2
558: ,p_information5 in varchar2 default hr_api.g_varchar2
551: ,p_x_position in number default hr_api.g_number
552: ,p_y_position in number default hr_api.g_number
553: ,p_information_category in varchar2 default hr_api.g_varchar2
554: ,p_information1 in varchar2 default hr_api.g_varchar2
555: ,p_information2 in varchar2 default hr_api.g_varchar2
556: ,p_information3 in varchar2 default hr_api.g_varchar2
557: ,p_information4 in varchar2 default hr_api.g_varchar2
558: ,p_information5 in varchar2 default hr_api.g_varchar2
559: ,p_information6 in varchar2 default hr_api.g_varchar2
552: ,p_y_position in number default hr_api.g_number
553: ,p_information_category in varchar2 default hr_api.g_varchar2
554: ,p_information1 in varchar2 default hr_api.g_varchar2
555: ,p_information2 in varchar2 default hr_api.g_varchar2
556: ,p_information3 in varchar2 default hr_api.g_varchar2
557: ,p_information4 in varchar2 default hr_api.g_varchar2
558: ,p_information5 in varchar2 default hr_api.g_varchar2
559: ,p_information6 in varchar2 default hr_api.g_varchar2
560: ,p_information7 in varchar2 default hr_api.g_varchar2
553: ,p_information_category in varchar2 default hr_api.g_varchar2
554: ,p_information1 in varchar2 default hr_api.g_varchar2
555: ,p_information2 in varchar2 default hr_api.g_varchar2
556: ,p_information3 in varchar2 default hr_api.g_varchar2
557: ,p_information4 in varchar2 default hr_api.g_varchar2
558: ,p_information5 in varchar2 default hr_api.g_varchar2
559: ,p_information6 in varchar2 default hr_api.g_varchar2
560: ,p_information7 in varchar2 default hr_api.g_varchar2
561: ,p_information8 in varchar2 default hr_api.g_varchar2
554: ,p_information1 in varchar2 default hr_api.g_varchar2
555: ,p_information2 in varchar2 default hr_api.g_varchar2
556: ,p_information3 in varchar2 default hr_api.g_varchar2
557: ,p_information4 in varchar2 default hr_api.g_varchar2
558: ,p_information5 in varchar2 default hr_api.g_varchar2
559: ,p_information6 in varchar2 default hr_api.g_varchar2
560: ,p_information7 in varchar2 default hr_api.g_varchar2
561: ,p_information8 in varchar2 default hr_api.g_varchar2
562: ,p_information9 in varchar2 default hr_api.g_varchar2
555: ,p_information2 in varchar2 default hr_api.g_varchar2
556: ,p_information3 in varchar2 default hr_api.g_varchar2
557: ,p_information4 in varchar2 default hr_api.g_varchar2
558: ,p_information5 in varchar2 default hr_api.g_varchar2
559: ,p_information6 in varchar2 default hr_api.g_varchar2
560: ,p_information7 in varchar2 default hr_api.g_varchar2
561: ,p_information8 in varchar2 default hr_api.g_varchar2
562: ,p_information9 in varchar2 default hr_api.g_varchar2
563: ,p_information10 in varchar2 default hr_api.g_varchar2
556: ,p_information3 in varchar2 default hr_api.g_varchar2
557: ,p_information4 in varchar2 default hr_api.g_varchar2
558: ,p_information5 in varchar2 default hr_api.g_varchar2
559: ,p_information6 in varchar2 default hr_api.g_varchar2
560: ,p_information7 in varchar2 default hr_api.g_varchar2
561: ,p_information8 in varchar2 default hr_api.g_varchar2
562: ,p_information9 in varchar2 default hr_api.g_varchar2
563: ,p_information10 in varchar2 default hr_api.g_varchar2
564: ,p_information11 in varchar2 default hr_api.g_varchar2
557: ,p_information4 in varchar2 default hr_api.g_varchar2
558: ,p_information5 in varchar2 default hr_api.g_varchar2
559: ,p_information6 in varchar2 default hr_api.g_varchar2
560: ,p_information7 in varchar2 default hr_api.g_varchar2
561: ,p_information8 in varchar2 default hr_api.g_varchar2
562: ,p_information9 in varchar2 default hr_api.g_varchar2
563: ,p_information10 in varchar2 default hr_api.g_varchar2
564: ,p_information11 in varchar2 default hr_api.g_varchar2
565: ,p_information12 in varchar2 default hr_api.g_varchar2
558: ,p_information5 in varchar2 default hr_api.g_varchar2
559: ,p_information6 in varchar2 default hr_api.g_varchar2
560: ,p_information7 in varchar2 default hr_api.g_varchar2
561: ,p_information8 in varchar2 default hr_api.g_varchar2
562: ,p_information9 in varchar2 default hr_api.g_varchar2
563: ,p_information10 in varchar2 default hr_api.g_varchar2
564: ,p_information11 in varchar2 default hr_api.g_varchar2
565: ,p_information12 in varchar2 default hr_api.g_varchar2
566: ,p_information13 in varchar2 default hr_api.g_varchar2
559: ,p_information6 in varchar2 default hr_api.g_varchar2
560: ,p_information7 in varchar2 default hr_api.g_varchar2
561: ,p_information8 in varchar2 default hr_api.g_varchar2
562: ,p_information9 in varchar2 default hr_api.g_varchar2
563: ,p_information10 in varchar2 default hr_api.g_varchar2
564: ,p_information11 in varchar2 default hr_api.g_varchar2
565: ,p_information12 in varchar2 default hr_api.g_varchar2
566: ,p_information13 in varchar2 default hr_api.g_varchar2
567: ,p_information14 in varchar2 default hr_api.g_varchar2
560: ,p_information7 in varchar2 default hr_api.g_varchar2
561: ,p_information8 in varchar2 default hr_api.g_varchar2
562: ,p_information9 in varchar2 default hr_api.g_varchar2
563: ,p_information10 in varchar2 default hr_api.g_varchar2
564: ,p_information11 in varchar2 default hr_api.g_varchar2
565: ,p_information12 in varchar2 default hr_api.g_varchar2
566: ,p_information13 in varchar2 default hr_api.g_varchar2
567: ,p_information14 in varchar2 default hr_api.g_varchar2
568: ,p_information15 in varchar2 default hr_api.g_varchar2
561: ,p_information8 in varchar2 default hr_api.g_varchar2
562: ,p_information9 in varchar2 default hr_api.g_varchar2
563: ,p_information10 in varchar2 default hr_api.g_varchar2
564: ,p_information11 in varchar2 default hr_api.g_varchar2
565: ,p_information12 in varchar2 default hr_api.g_varchar2
566: ,p_information13 in varchar2 default hr_api.g_varchar2
567: ,p_information14 in varchar2 default hr_api.g_varchar2
568: ,p_information15 in varchar2 default hr_api.g_varchar2
569: ,p_information16 in varchar2 default hr_api.g_varchar2
562: ,p_information9 in varchar2 default hr_api.g_varchar2
563: ,p_information10 in varchar2 default hr_api.g_varchar2
564: ,p_information11 in varchar2 default hr_api.g_varchar2
565: ,p_information12 in varchar2 default hr_api.g_varchar2
566: ,p_information13 in varchar2 default hr_api.g_varchar2
567: ,p_information14 in varchar2 default hr_api.g_varchar2
568: ,p_information15 in varchar2 default hr_api.g_varchar2
569: ,p_information16 in varchar2 default hr_api.g_varchar2
570: ,p_information17 in varchar2 default hr_api.g_varchar2
563: ,p_information10 in varchar2 default hr_api.g_varchar2
564: ,p_information11 in varchar2 default hr_api.g_varchar2
565: ,p_information12 in varchar2 default hr_api.g_varchar2
566: ,p_information13 in varchar2 default hr_api.g_varchar2
567: ,p_information14 in varchar2 default hr_api.g_varchar2
568: ,p_information15 in varchar2 default hr_api.g_varchar2
569: ,p_information16 in varchar2 default hr_api.g_varchar2
570: ,p_information17 in varchar2 default hr_api.g_varchar2
571: ,p_information18 in varchar2 default hr_api.g_varchar2
564: ,p_information11 in varchar2 default hr_api.g_varchar2
565: ,p_information12 in varchar2 default hr_api.g_varchar2
566: ,p_information13 in varchar2 default hr_api.g_varchar2
567: ,p_information14 in varchar2 default hr_api.g_varchar2
568: ,p_information15 in varchar2 default hr_api.g_varchar2
569: ,p_information16 in varchar2 default hr_api.g_varchar2
570: ,p_information17 in varchar2 default hr_api.g_varchar2
571: ,p_information18 in varchar2 default hr_api.g_varchar2
572: ,p_information19 in varchar2 default hr_api.g_varchar2
565: ,p_information12 in varchar2 default hr_api.g_varchar2
566: ,p_information13 in varchar2 default hr_api.g_varchar2
567: ,p_information14 in varchar2 default hr_api.g_varchar2
568: ,p_information15 in varchar2 default hr_api.g_varchar2
569: ,p_information16 in varchar2 default hr_api.g_varchar2
570: ,p_information17 in varchar2 default hr_api.g_varchar2
571: ,p_information18 in varchar2 default hr_api.g_varchar2
572: ,p_information19 in varchar2 default hr_api.g_varchar2
573: ,p_information20 in varchar2 default hr_api.g_varchar2
566: ,p_information13 in varchar2 default hr_api.g_varchar2
567: ,p_information14 in varchar2 default hr_api.g_varchar2
568: ,p_information15 in varchar2 default hr_api.g_varchar2
569: ,p_information16 in varchar2 default hr_api.g_varchar2
570: ,p_information17 in varchar2 default hr_api.g_varchar2
571: ,p_information18 in varchar2 default hr_api.g_varchar2
572: ,p_information19 in varchar2 default hr_api.g_varchar2
573: ,p_information20 in varchar2 default hr_api.g_varchar2
574: ,p_information21 in varchar2 default hr_api.g_varchar2
567: ,p_information14 in varchar2 default hr_api.g_varchar2
568: ,p_information15 in varchar2 default hr_api.g_varchar2
569: ,p_information16 in varchar2 default hr_api.g_varchar2
570: ,p_information17 in varchar2 default hr_api.g_varchar2
571: ,p_information18 in varchar2 default hr_api.g_varchar2
572: ,p_information19 in varchar2 default hr_api.g_varchar2
573: ,p_information20 in varchar2 default hr_api.g_varchar2
574: ,p_information21 in varchar2 default hr_api.g_varchar2
575: ,p_information22 in varchar2 default hr_api.g_varchar2
568: ,p_information15 in varchar2 default hr_api.g_varchar2
569: ,p_information16 in varchar2 default hr_api.g_varchar2
570: ,p_information17 in varchar2 default hr_api.g_varchar2
571: ,p_information18 in varchar2 default hr_api.g_varchar2
572: ,p_information19 in varchar2 default hr_api.g_varchar2
573: ,p_information20 in varchar2 default hr_api.g_varchar2
574: ,p_information21 in varchar2 default hr_api.g_varchar2
575: ,p_information22 in varchar2 default hr_api.g_varchar2
576: ,p_information23 in varchar2 default hr_api.g_varchar2
569: ,p_information16 in varchar2 default hr_api.g_varchar2
570: ,p_information17 in varchar2 default hr_api.g_varchar2
571: ,p_information18 in varchar2 default hr_api.g_varchar2
572: ,p_information19 in varchar2 default hr_api.g_varchar2
573: ,p_information20 in varchar2 default hr_api.g_varchar2
574: ,p_information21 in varchar2 default hr_api.g_varchar2
575: ,p_information22 in varchar2 default hr_api.g_varchar2
576: ,p_information23 in varchar2 default hr_api.g_varchar2
577: ,p_information24 in varchar2 default hr_api.g_varchar2
570: ,p_information17 in varchar2 default hr_api.g_varchar2
571: ,p_information18 in varchar2 default hr_api.g_varchar2
572: ,p_information19 in varchar2 default hr_api.g_varchar2
573: ,p_information20 in varchar2 default hr_api.g_varchar2
574: ,p_information21 in varchar2 default hr_api.g_varchar2
575: ,p_information22 in varchar2 default hr_api.g_varchar2
576: ,p_information23 in varchar2 default hr_api.g_varchar2
577: ,p_information24 in varchar2 default hr_api.g_varchar2
578: ,p_information25 in varchar2 default hr_api.g_varchar2
571: ,p_information18 in varchar2 default hr_api.g_varchar2
572: ,p_information19 in varchar2 default hr_api.g_varchar2
573: ,p_information20 in varchar2 default hr_api.g_varchar2
574: ,p_information21 in varchar2 default hr_api.g_varchar2
575: ,p_information22 in varchar2 default hr_api.g_varchar2
576: ,p_information23 in varchar2 default hr_api.g_varchar2
577: ,p_information24 in varchar2 default hr_api.g_varchar2
578: ,p_information25 in varchar2 default hr_api.g_varchar2
579: ,p_information26 in varchar2 default hr_api.g_varchar2
572: ,p_information19 in varchar2 default hr_api.g_varchar2
573: ,p_information20 in varchar2 default hr_api.g_varchar2
574: ,p_information21 in varchar2 default hr_api.g_varchar2
575: ,p_information22 in varchar2 default hr_api.g_varchar2
576: ,p_information23 in varchar2 default hr_api.g_varchar2
577: ,p_information24 in varchar2 default hr_api.g_varchar2
578: ,p_information25 in varchar2 default hr_api.g_varchar2
579: ,p_information26 in varchar2 default hr_api.g_varchar2
580: ,p_information27 in varchar2 default hr_api.g_varchar2
573: ,p_information20 in varchar2 default hr_api.g_varchar2
574: ,p_information21 in varchar2 default hr_api.g_varchar2
575: ,p_information22 in varchar2 default hr_api.g_varchar2
576: ,p_information23 in varchar2 default hr_api.g_varchar2
577: ,p_information24 in varchar2 default hr_api.g_varchar2
578: ,p_information25 in varchar2 default hr_api.g_varchar2
579: ,p_information26 in varchar2 default hr_api.g_varchar2
580: ,p_information27 in varchar2 default hr_api.g_varchar2
581: ,p_information28 in varchar2 default hr_api.g_varchar2
574: ,p_information21 in varchar2 default hr_api.g_varchar2
575: ,p_information22 in varchar2 default hr_api.g_varchar2
576: ,p_information23 in varchar2 default hr_api.g_varchar2
577: ,p_information24 in varchar2 default hr_api.g_varchar2
578: ,p_information25 in varchar2 default hr_api.g_varchar2
579: ,p_information26 in varchar2 default hr_api.g_varchar2
580: ,p_information27 in varchar2 default hr_api.g_varchar2
581: ,p_information28 in varchar2 default hr_api.g_varchar2
582: ,p_information29 in varchar2 default hr_api.g_varchar2
575: ,p_information22 in varchar2 default hr_api.g_varchar2
576: ,p_information23 in varchar2 default hr_api.g_varchar2
577: ,p_information24 in varchar2 default hr_api.g_varchar2
578: ,p_information25 in varchar2 default hr_api.g_varchar2
579: ,p_information26 in varchar2 default hr_api.g_varchar2
580: ,p_information27 in varchar2 default hr_api.g_varchar2
581: ,p_information28 in varchar2 default hr_api.g_varchar2
582: ,p_information29 in varchar2 default hr_api.g_varchar2
583: ,p_information30 in varchar2 default hr_api.g_varchar2
576: ,p_information23 in varchar2 default hr_api.g_varchar2
577: ,p_information24 in varchar2 default hr_api.g_varchar2
578: ,p_information25 in varchar2 default hr_api.g_varchar2
579: ,p_information26 in varchar2 default hr_api.g_varchar2
580: ,p_information27 in varchar2 default hr_api.g_varchar2
581: ,p_information28 in varchar2 default hr_api.g_varchar2
582: ,p_information29 in varchar2 default hr_api.g_varchar2
583: ,p_information30 in varchar2 default hr_api.g_varchar2
584: ) is
577: ,p_information24 in varchar2 default hr_api.g_varchar2
578: ,p_information25 in varchar2 default hr_api.g_varchar2
579: ,p_information26 in varchar2 default hr_api.g_varchar2
580: ,p_information27 in varchar2 default hr_api.g_varchar2
581: ,p_information28 in varchar2 default hr_api.g_varchar2
582: ,p_information29 in varchar2 default hr_api.g_varchar2
583: ,p_information30 in varchar2 default hr_api.g_varchar2
584: ) is
585: --
578: ,p_information25 in varchar2 default hr_api.g_varchar2
579: ,p_information26 in varchar2 default hr_api.g_varchar2
580: ,p_information27 in varchar2 default hr_api.g_varchar2
581: ,p_information28 in varchar2 default hr_api.g_varchar2
582: ,p_information29 in varchar2 default hr_api.g_varchar2
583: ,p_information30 in varchar2 default hr_api.g_varchar2
584: ) is
585: --
586: l_rec hr_cnp_shd.g_rec_type;
579: ,p_information26 in varchar2 default hr_api.g_varchar2
580: ,p_information27 in varchar2 default hr_api.g_varchar2
581: ,p_information28 in varchar2 default hr_api.g_varchar2
582: ,p_information29 in varchar2 default hr_api.g_varchar2
583: ,p_information30 in varchar2 default hr_api.g_varchar2
584: ) is
585: --
586: l_rec hr_cnp_shd.g_rec_type;
587: l_proc varchar2(72) := g_package||'upd';