DBA Data[Home] [Help]

APPS.HR_CNP_UPD dependencies on HR_API

Line 117: When hr_api.check_integrity_violated Then

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));

Line 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

Line 122: When hr_api.parent_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
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 127: When hr_api.unique_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
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 309: when hr_api.cannot_find_prog_unit then

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');

Line 311: hr_api.cannot_find_prog_unit_error

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;

Line 374: If (p_rec.form_canvas_id = hr_api.g_number) then

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;

Line 377: If (p_rec.template_canvas_id = hr_api.g_number) then

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;

Line 380: If (p_rec.height = hr_api.g_number) then

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;

Line 383: If (p_rec.visible = hr_api.g_number) then

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;

Line 386: If (p_rec.width = hr_api.g_number) then

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;

Line 389: If (p_rec.x_position = hr_api.g_number) then

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;

Line 392: If (p_rec.y_position = hr_api.g_number) then

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;

Line 395: If (p_rec.information_category = hr_api.g_varchar2) then

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;

Line 398: If (p_rec.information1 = hr_api.g_varchar2) then

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;

Line 401: If (p_rec.information2 = hr_api.g_varchar2) then

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;

Line 404: If (p_rec.information3 = hr_api.g_varchar2) then

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;

Line 407: If (p_rec.information4 = hr_api.g_varchar2) then

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;

Line 410: If (p_rec.information5 = hr_api.g_varchar2) then

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;

Line 413: If (p_rec.information6 = hr_api.g_varchar2) then

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;

Line 416: If (p_rec.information7 = hr_api.g_varchar2) then

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;

Line 419: If (p_rec.information8 = hr_api.g_varchar2) then

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;

Line 422: If (p_rec.information9 = hr_api.g_varchar2) then

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;

Line 425: If (p_rec.information10 = hr_api.g_varchar2) then

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;

Line 428: If (p_rec.information11 = hr_api.g_varchar2) then

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;

Line 431: If (p_rec.information12 = hr_api.g_varchar2) then

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;

Line 434: If (p_rec.information13 = hr_api.g_varchar2) then

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;

Line 437: If (p_rec.information14 = hr_api.g_varchar2) then

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;

Line 440: If (p_rec.information15 = hr_api.g_varchar2) then

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;

Line 443: If (p_rec.information16 = hr_api.g_varchar2) then

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;

Line 446: If (p_rec.information17 = hr_api.g_varchar2) then

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;

Line 449: If (p_rec.information18 = hr_api.g_varchar2) then

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;

Line 452: If (p_rec.information19 = hr_api.g_varchar2) then

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;

Line 455: If (p_rec.information20 = hr_api.g_varchar2) then

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;

Line 458: If (p_rec.information21 = hr_api.g_varchar2) then

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;

Line 461: If (p_rec.information22 = hr_api.g_varchar2) then

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;

Line 464: If (p_rec.information23 = hr_api.g_varchar2) then

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;

Line 467: If (p_rec.information24 = hr_api.g_varchar2) then

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;

Line 470: If (p_rec.information25 = hr_api.g_varchar2) then

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;

Line 473: If (p_rec.information26 = hr_api.g_varchar2) then

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;

Line 476: If (p_rec.information27 = hr_api.g_varchar2) then

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;

Line 479: If (p_rec.information28 = hr_api.g_varchar2) then

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;

Line 482: If (p_rec.information29 = hr_api.g_varchar2) then

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;

Line 485: If (p_rec.information30 = hr_api.g_varchar2) then

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;

Line 546: ,p_form_canvas_id in number default hr_api.g_number

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

Line 547: ,p_template_canvas_id 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

Line 548: ,p_height 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

Line 549: ,p_visible 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

Line 550: ,p_width in number default hr_api.g_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
554: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 551: ,p_x_position 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
555: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 552: ,p_y_position 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
556: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 553: ,p_information_category 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

Line 554: ,p_information1 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

Line 555: ,p_information2 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

Line 556: ,p_information3 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

Line 557: ,p_information4 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

Line 558: ,p_information5 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

Line 559: ,p_information6 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

Line 560: ,p_information7 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

Line 561: ,p_information8 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

Line 562: ,p_information9 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

Line 563: ,p_information10 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

Line 564: ,p_information11 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

Line 565: ,p_information12 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

Line 566: ,p_information13 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

Line 567: ,p_information14 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

Line 568: ,p_information15 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

Line 569: ,p_information16 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

Line 570: ,p_information17 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

Line 571: ,p_information18 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

Line 572: ,p_information19 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

Line 573: ,p_information20 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

Line 574: ,p_information21 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

Line 575: ,p_information22 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

Line 576: ,p_information23 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

Line 577: ,p_information24 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

Line 578: ,p_information25 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

Line 579: ,p_information26 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

Line 580: ,p_information27 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

Line 581: ,p_information28 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
585: --

Line 582: ,p_information29 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: --
586: l_rec hr_cnp_shd.g_rec_type;

Line 583: ,p_information30 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;
587: l_proc varchar2(72) := g_package||'upd';