APPS.PQH_CEA_UPD dependencies on HR_API

Line 106: When hr_api.check_integrity_violated Then

102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: --
105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: pqh_cea_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then

Line 109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: pqh_cea_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: pqh_cea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 110: When hr_api.parent_integrity_violated Then

106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: pqh_cea_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: pqh_cea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then

Line 113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: pqh_cea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqh_cea_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 114: When hr_api.unique_integrity_violated Then

110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: pqh_cea_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqh_cea_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then

Line 117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqh_cea_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: Raise;
120: End update_dml;
121: --

Line 291: when hr_api.cannot_find_prog_unit then

287: );
288: --
289: exception
290: --
291: when hr_api.cannot_find_prog_unit then
292: --
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'pqh_copy_entity_attribs'
295: ,p_hook_type => 'AU');

Line 293: hr_api.cannot_find_prog_unit_error

289: exception
290: --
291: when hr_api.cannot_find_prog_unit then
292: --
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'pqh_copy_entity_attribs'
295: ,p_hook_type => 'AU');
296: --
297: end;

Line 361: If (p_rec.copy_entity_txn_id = hr_api.g_number) then

357: -- p_rec plsql record structure
358: -- to see if a system default is being used. If a system default
359: -- is being used then we must set to the 'current' argument value.
360: --
361: If (p_rec.copy_entity_txn_id = hr_api.g_number) then
362: p_rec.copy_entity_txn_id :=
363: pqh_cea_shd.g_old_rec.copy_entity_txn_id;
364: End If;
365: If (p_rec.row_type_cd = hr_api.g_varchar2) then

Line 365: If (p_rec.row_type_cd = hr_api.g_varchar2) then

361: If (p_rec.copy_entity_txn_id = hr_api.g_number) then
362: p_rec.copy_entity_txn_id :=
363: pqh_cea_shd.g_old_rec.copy_entity_txn_id;
364: End If;
365: If (p_rec.row_type_cd = hr_api.g_varchar2) then
366: p_rec.row_type_cd :=
367: pqh_cea_shd.g_old_rec.row_type_cd;
368: End If;
369: If (p_rec.information_category = hr_api.g_varchar2) then

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

365: If (p_rec.row_type_cd = hr_api.g_varchar2) then
366: p_rec.row_type_cd :=
367: pqh_cea_shd.g_old_rec.row_type_cd;
368: End If;
369: If (p_rec.information_category = hr_api.g_varchar2) then
370: p_rec.information_category :=
371: pqh_cea_shd.g_old_rec.information_category;
372: End If;
373: If (p_rec.information1 = hr_api.g_varchar2) then

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

369: If (p_rec.information_category = hr_api.g_varchar2) then
370: p_rec.information_category :=
371: pqh_cea_shd.g_old_rec.information_category;
372: End If;
373: If (p_rec.information1 = hr_api.g_varchar2) then
374: p_rec.information1 :=
375: pqh_cea_shd.g_old_rec.information1;
376: End If;
377: If (p_rec.information2 = hr_api.g_varchar2) then

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

373: If (p_rec.information1 = hr_api.g_varchar2) then
374: p_rec.information1 :=
375: pqh_cea_shd.g_old_rec.information1;
376: End If;
377: If (p_rec.information2 = hr_api.g_varchar2) then
378: p_rec.information2 :=
379: pqh_cea_shd.g_old_rec.information2;
380: End If;
381: If (p_rec.information3 = hr_api.g_varchar2) then

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

377: If (p_rec.information2 = hr_api.g_varchar2) then
378: p_rec.information2 :=
379: pqh_cea_shd.g_old_rec.information2;
380: End If;
381: If (p_rec.information3 = hr_api.g_varchar2) then
382: p_rec.information3 :=
383: pqh_cea_shd.g_old_rec.information3;
384: End If;
385: If (p_rec.information4 = hr_api.g_varchar2) then

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

381: If (p_rec.information3 = hr_api.g_varchar2) then
382: p_rec.information3 :=
383: pqh_cea_shd.g_old_rec.information3;
384: End If;
385: If (p_rec.information4 = hr_api.g_varchar2) then
386: p_rec.information4 :=
387: pqh_cea_shd.g_old_rec.information4;
388: End If;
389: If (p_rec.information5 = hr_api.g_varchar2) then

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

385: If (p_rec.information4 = hr_api.g_varchar2) then
386: p_rec.information4 :=
387: pqh_cea_shd.g_old_rec.information4;
388: End If;
389: If (p_rec.information5 = hr_api.g_varchar2) then
390: p_rec.information5 :=
391: pqh_cea_shd.g_old_rec.information5;
392: End If;
393: If (p_rec.information6 = hr_api.g_varchar2) then

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

389: If (p_rec.information5 = hr_api.g_varchar2) then
390: p_rec.information5 :=
391: pqh_cea_shd.g_old_rec.information5;
392: End If;
393: If (p_rec.information6 = hr_api.g_varchar2) then
394: p_rec.information6 :=
395: pqh_cea_shd.g_old_rec.information6;
396: End If;
397: If (p_rec.information7 = hr_api.g_varchar2) then

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

393: If (p_rec.information6 = hr_api.g_varchar2) then
394: p_rec.information6 :=
395: pqh_cea_shd.g_old_rec.information6;
396: End If;
397: If (p_rec.information7 = hr_api.g_varchar2) then
398: p_rec.information7 :=
399: pqh_cea_shd.g_old_rec.information7;
400: End If;
401: If (p_rec.information8 = hr_api.g_varchar2) then

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

397: If (p_rec.information7 = hr_api.g_varchar2) then
398: p_rec.information7 :=
399: pqh_cea_shd.g_old_rec.information7;
400: End If;
401: If (p_rec.information8 = hr_api.g_varchar2) then
402: p_rec.information8 :=
403: pqh_cea_shd.g_old_rec.information8;
404: End If;
405: If (p_rec.information9 = hr_api.g_varchar2) then

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

401: If (p_rec.information8 = hr_api.g_varchar2) then
402: p_rec.information8 :=
403: pqh_cea_shd.g_old_rec.information8;
404: End If;
405: If (p_rec.information9 = hr_api.g_varchar2) then
406: p_rec.information9 :=
407: pqh_cea_shd.g_old_rec.information9;
408: End If;
409: If (p_rec.information10 = hr_api.g_varchar2) then

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

405: If (p_rec.information9 = hr_api.g_varchar2) then
406: p_rec.information9 :=
407: pqh_cea_shd.g_old_rec.information9;
408: End If;
409: If (p_rec.information10 = hr_api.g_varchar2) then
410: p_rec.information10 :=
411: pqh_cea_shd.g_old_rec.information10;
412: End If;
413: If (p_rec.information11 = hr_api.g_varchar2) then

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

409: If (p_rec.information10 = hr_api.g_varchar2) then
410: p_rec.information10 :=
411: pqh_cea_shd.g_old_rec.information10;
412: End If;
413: If (p_rec.information11 = hr_api.g_varchar2) then
414: p_rec.information11 :=
415: pqh_cea_shd.g_old_rec.information11;
416: End If;
417: If (p_rec.information12 = hr_api.g_varchar2) then

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

413: If (p_rec.information11 = hr_api.g_varchar2) then
414: p_rec.information11 :=
415: pqh_cea_shd.g_old_rec.information11;
416: End If;
417: If (p_rec.information12 = hr_api.g_varchar2) then
418: p_rec.information12 :=
419: pqh_cea_shd.g_old_rec.information12;
420: End If;
421: If (p_rec.information13 = hr_api.g_varchar2) then

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

417: If (p_rec.information12 = hr_api.g_varchar2) then
418: p_rec.information12 :=
419: pqh_cea_shd.g_old_rec.information12;
420: End If;
421: If (p_rec.information13 = hr_api.g_varchar2) then
422: p_rec.information13 :=
423: pqh_cea_shd.g_old_rec.information13;
424: End If;
425: If (p_rec.information14 = hr_api.g_varchar2) then

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

421: If (p_rec.information13 = hr_api.g_varchar2) then
422: p_rec.information13 :=
423: pqh_cea_shd.g_old_rec.information13;
424: End If;
425: If (p_rec.information14 = hr_api.g_varchar2) then
426: p_rec.information14 :=
427: pqh_cea_shd.g_old_rec.information14;
428: End If;
429: If (p_rec.information15 = hr_api.g_varchar2) then

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

425: If (p_rec.information14 = hr_api.g_varchar2) then
426: p_rec.information14 :=
427: pqh_cea_shd.g_old_rec.information14;
428: End If;
429: If (p_rec.information15 = hr_api.g_varchar2) then
430: p_rec.information15 :=
431: pqh_cea_shd.g_old_rec.information15;
432: End If;
433: If (p_rec.information16 = hr_api.g_varchar2) then

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

429: If (p_rec.information15 = hr_api.g_varchar2) then
430: p_rec.information15 :=
431: pqh_cea_shd.g_old_rec.information15;
432: End If;
433: If (p_rec.information16 = hr_api.g_varchar2) then
434: p_rec.information16 :=
435: pqh_cea_shd.g_old_rec.information16;
436: End If;
437: If (p_rec.information17 = hr_api.g_varchar2) then

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

433: If (p_rec.information16 = hr_api.g_varchar2) then
434: p_rec.information16 :=
435: pqh_cea_shd.g_old_rec.information16;
436: End If;
437: If (p_rec.information17 = hr_api.g_varchar2) then
438: p_rec.information17 :=
439: pqh_cea_shd.g_old_rec.information17;
440: End If;
441: If (p_rec.information18 = hr_api.g_varchar2) then

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

437: If (p_rec.information17 = hr_api.g_varchar2) then
438: p_rec.information17 :=
439: pqh_cea_shd.g_old_rec.information17;
440: End If;
441: If (p_rec.information18 = hr_api.g_varchar2) then
442: p_rec.information18 :=
443: pqh_cea_shd.g_old_rec.information18;
444: End If;
445: If (p_rec.information19 = hr_api.g_varchar2) then

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

441: If (p_rec.information18 = hr_api.g_varchar2) then
442: p_rec.information18 :=
443: pqh_cea_shd.g_old_rec.information18;
444: End If;
445: If (p_rec.information19 = hr_api.g_varchar2) then
446: p_rec.information19 :=
447: pqh_cea_shd.g_old_rec.information19;
448: End If;
449: If (p_rec.information20 = hr_api.g_varchar2) then

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

445: If (p_rec.information19 = hr_api.g_varchar2) then
446: p_rec.information19 :=
447: pqh_cea_shd.g_old_rec.information19;
448: End If;
449: If (p_rec.information20 = hr_api.g_varchar2) then
450: p_rec.information20 :=
451: pqh_cea_shd.g_old_rec.information20;
452: End If;
453: If (p_rec.information21 = hr_api.g_varchar2) then

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

449: If (p_rec.information20 = hr_api.g_varchar2) then
450: p_rec.information20 :=
451: pqh_cea_shd.g_old_rec.information20;
452: End If;
453: If (p_rec.information21 = hr_api.g_varchar2) then
454: p_rec.information21 :=
455: pqh_cea_shd.g_old_rec.information21;
456: End If;
457: If (p_rec.information22 = hr_api.g_varchar2) then

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

453: If (p_rec.information21 = hr_api.g_varchar2) then
454: p_rec.information21 :=
455: pqh_cea_shd.g_old_rec.information21;
456: End If;
457: If (p_rec.information22 = hr_api.g_varchar2) then
458: p_rec.information22 :=
459: pqh_cea_shd.g_old_rec.information22;
460: End If;
461: If (p_rec.information23 = hr_api.g_varchar2) then

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

457: If (p_rec.information22 = hr_api.g_varchar2) then
458: p_rec.information22 :=
459: pqh_cea_shd.g_old_rec.information22;
460: End If;
461: If (p_rec.information23 = hr_api.g_varchar2) then
462: p_rec.information23 :=
463: pqh_cea_shd.g_old_rec.information23;
464: End If;
465: If (p_rec.information24 = hr_api.g_varchar2) then

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

461: If (p_rec.information23 = hr_api.g_varchar2) then
462: p_rec.information23 :=
463: pqh_cea_shd.g_old_rec.information23;
464: End If;
465: If (p_rec.information24 = hr_api.g_varchar2) then
466: p_rec.information24 :=
467: pqh_cea_shd.g_old_rec.information24;
468: End If;
469: If (p_rec.information25 = hr_api.g_varchar2) then

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

465: If (p_rec.information24 = hr_api.g_varchar2) then
466: p_rec.information24 :=
467: pqh_cea_shd.g_old_rec.information24;
468: End If;
469: If (p_rec.information25 = hr_api.g_varchar2) then
470: p_rec.information25 :=
471: pqh_cea_shd.g_old_rec.information25;
472: End If;
473: If (p_rec.information26 = hr_api.g_varchar2) then

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

469: If (p_rec.information25 = hr_api.g_varchar2) then
470: p_rec.information25 :=
471: pqh_cea_shd.g_old_rec.information25;
472: End If;
473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 :=
475: pqh_cea_shd.g_old_rec.information26;
476: End If;
477: If (p_rec.information27 = hr_api.g_varchar2) then

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

473: If (p_rec.information26 = hr_api.g_varchar2) then
474: p_rec.information26 :=
475: pqh_cea_shd.g_old_rec.information26;
476: End If;
477: If (p_rec.information27 = hr_api.g_varchar2) then
478: p_rec.information27 :=
479: pqh_cea_shd.g_old_rec.information27;
480: End If;
481: If (p_rec.information28 = hr_api.g_varchar2) then

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

477: If (p_rec.information27 = hr_api.g_varchar2) then
478: p_rec.information27 :=
479: pqh_cea_shd.g_old_rec.information27;
480: End If;
481: If (p_rec.information28 = hr_api.g_varchar2) then
482: p_rec.information28 :=
483: pqh_cea_shd.g_old_rec.information28;
484: End If;
485: If (p_rec.information29 = hr_api.g_varchar2) then

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

481: If (p_rec.information28 = hr_api.g_varchar2) then
482: p_rec.information28 :=
483: pqh_cea_shd.g_old_rec.information28;
484: End If;
485: If (p_rec.information29 = hr_api.g_varchar2) then
486: p_rec.information29 :=
487: pqh_cea_shd.g_old_rec.information29;
488: End If;
489: If (p_rec.information30 = hr_api.g_varchar2) then

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

485: If (p_rec.information29 = hr_api.g_varchar2) then
486: p_rec.information29 :=
487: pqh_cea_shd.g_old_rec.information29;
488: End If;
489: If (p_rec.information30 = hr_api.g_varchar2) then
490: p_rec.information30 :=
491: pqh_cea_shd.g_old_rec.information30;
492: End If;
493: If (p_rec.check_information1 = hr_api.g_varchar2) then

Line 493: If (p_rec.check_information1 = hr_api.g_varchar2) then

489: If (p_rec.information30 = hr_api.g_varchar2) then
490: p_rec.information30 :=
491: pqh_cea_shd.g_old_rec.information30;
492: End If;
493: If (p_rec.check_information1 = hr_api.g_varchar2) then
494: p_rec.check_information1 :=
495: pqh_cea_shd.g_old_rec.check_information1;
496: End If;
497: If (p_rec.check_information2 = hr_api.g_varchar2) then

Line 497: If (p_rec.check_information2 = hr_api.g_varchar2) then

493: If (p_rec.check_information1 = hr_api.g_varchar2) then
494: p_rec.check_information1 :=
495: pqh_cea_shd.g_old_rec.check_information1;
496: End If;
497: If (p_rec.check_information2 = hr_api.g_varchar2) then
498: p_rec.check_information2 :=
499: pqh_cea_shd.g_old_rec.check_information2;
500: End If;
501: If (p_rec.check_information3 = hr_api.g_varchar2) then

Line 501: If (p_rec.check_information3 = hr_api.g_varchar2) then

497: If (p_rec.check_information2 = hr_api.g_varchar2) then
498: p_rec.check_information2 :=
499: pqh_cea_shd.g_old_rec.check_information2;
500: End If;
501: If (p_rec.check_information3 = hr_api.g_varchar2) then
502: p_rec.check_information3 :=
503: pqh_cea_shd.g_old_rec.check_information3;
504: End If;
505:

Line 564: p_copy_entity_txn_id in number default hr_api.g_number,

560: Procedure upd
561: (
562: p_effective_date in date,
563: p_copy_entity_attrib_id in number,
564: p_copy_entity_txn_id in number default hr_api.g_number,
565: p_row_type_cd in varchar2 default hr_api.g_varchar2,
566: p_information_category in varchar2 default hr_api.g_varchar2,
567: p_information1 in varchar2 default hr_api.g_varchar2,
568: p_information2 in varchar2 default hr_api.g_varchar2,

Line 565: p_row_type_cd in varchar2 default hr_api.g_varchar2,

561: (
562: p_effective_date in date,
563: p_copy_entity_attrib_id in number,
564: p_copy_entity_txn_id in number default hr_api.g_number,
565: p_row_type_cd in varchar2 default hr_api.g_varchar2,
566: p_information_category in varchar2 default hr_api.g_varchar2,
567: p_information1 in varchar2 default hr_api.g_varchar2,
568: p_information2 in varchar2 default hr_api.g_varchar2,
569: p_information3 in varchar2 default hr_api.g_varchar2,

Line 566: p_information_category in varchar2 default hr_api.g_varchar2,

562: p_effective_date in date,
563: p_copy_entity_attrib_id in number,
564: p_copy_entity_txn_id in number default hr_api.g_number,
565: p_row_type_cd in varchar2 default hr_api.g_varchar2,
566: p_information_category in varchar2 default hr_api.g_varchar2,
567: p_information1 in varchar2 default hr_api.g_varchar2,
568: p_information2 in varchar2 default hr_api.g_varchar2,
569: p_information3 in varchar2 default hr_api.g_varchar2,
570: p_information4 in varchar2 default hr_api.g_varchar2,

Line 567: p_information1 in varchar2 default hr_api.g_varchar2,

563: p_copy_entity_attrib_id in number,
564: p_copy_entity_txn_id in number default hr_api.g_number,
565: p_row_type_cd in varchar2 default hr_api.g_varchar2,
566: p_information_category in varchar2 default hr_api.g_varchar2,
567: p_information1 in varchar2 default hr_api.g_varchar2,
568: p_information2 in varchar2 default hr_api.g_varchar2,
569: p_information3 in varchar2 default hr_api.g_varchar2,
570: p_information4 in varchar2 default hr_api.g_varchar2,
571: p_information5 in varchar2 default hr_api.g_varchar2,

Line 568: p_information2 in varchar2 default hr_api.g_varchar2,

564: p_copy_entity_txn_id in number default hr_api.g_number,
565: p_row_type_cd in varchar2 default hr_api.g_varchar2,
566: p_information_category in varchar2 default hr_api.g_varchar2,
567: p_information1 in varchar2 default hr_api.g_varchar2,
568: p_information2 in varchar2 default hr_api.g_varchar2,
569: p_information3 in varchar2 default hr_api.g_varchar2,
570: p_information4 in varchar2 default hr_api.g_varchar2,
571: p_information5 in varchar2 default hr_api.g_varchar2,
572: p_information6 in varchar2 default hr_api.g_varchar2,

Line 569: p_information3 in varchar2 default hr_api.g_varchar2,

565: p_row_type_cd in varchar2 default hr_api.g_varchar2,
566: p_information_category in varchar2 default hr_api.g_varchar2,
567: p_information1 in varchar2 default hr_api.g_varchar2,
568: p_information2 in varchar2 default hr_api.g_varchar2,
569: p_information3 in varchar2 default hr_api.g_varchar2,
570: p_information4 in varchar2 default hr_api.g_varchar2,
571: p_information5 in varchar2 default hr_api.g_varchar2,
572: p_information6 in varchar2 default hr_api.g_varchar2,
573: p_information7 in varchar2 default hr_api.g_varchar2,

Line 570: p_information4 in varchar2 default hr_api.g_varchar2,

566: p_information_category in varchar2 default hr_api.g_varchar2,
567: p_information1 in varchar2 default hr_api.g_varchar2,
568: p_information2 in varchar2 default hr_api.g_varchar2,
569: p_information3 in varchar2 default hr_api.g_varchar2,
570: p_information4 in varchar2 default hr_api.g_varchar2,
571: p_information5 in varchar2 default hr_api.g_varchar2,
572: p_information6 in varchar2 default hr_api.g_varchar2,
573: p_information7 in varchar2 default hr_api.g_varchar2,
574: p_information8 in varchar2 default hr_api.g_varchar2,

Line 571: p_information5 in varchar2 default hr_api.g_varchar2,

567: p_information1 in varchar2 default hr_api.g_varchar2,
568: p_information2 in varchar2 default hr_api.g_varchar2,
569: p_information3 in varchar2 default hr_api.g_varchar2,
570: p_information4 in varchar2 default hr_api.g_varchar2,
571: p_information5 in varchar2 default hr_api.g_varchar2,
572: p_information6 in varchar2 default hr_api.g_varchar2,
573: p_information7 in varchar2 default hr_api.g_varchar2,
574: p_information8 in varchar2 default hr_api.g_varchar2,
575: p_information9 in varchar2 default hr_api.g_varchar2,

Line 572: p_information6 in varchar2 default hr_api.g_varchar2,

568: p_information2 in varchar2 default hr_api.g_varchar2,
569: p_information3 in varchar2 default hr_api.g_varchar2,
570: p_information4 in varchar2 default hr_api.g_varchar2,
571: p_information5 in varchar2 default hr_api.g_varchar2,
572: p_information6 in varchar2 default hr_api.g_varchar2,
573: p_information7 in varchar2 default hr_api.g_varchar2,
574: p_information8 in varchar2 default hr_api.g_varchar2,
575: p_information9 in varchar2 default hr_api.g_varchar2,
576: p_information10 in varchar2 default hr_api.g_varchar2,

Line 573: p_information7 in varchar2 default hr_api.g_varchar2,

569: p_information3 in varchar2 default hr_api.g_varchar2,
570: p_information4 in varchar2 default hr_api.g_varchar2,
571: p_information5 in varchar2 default hr_api.g_varchar2,
572: p_information6 in varchar2 default hr_api.g_varchar2,
573: p_information7 in varchar2 default hr_api.g_varchar2,
574: p_information8 in varchar2 default hr_api.g_varchar2,
575: p_information9 in varchar2 default hr_api.g_varchar2,
576: p_information10 in varchar2 default hr_api.g_varchar2,
577: p_information11 in varchar2 default hr_api.g_varchar2,

Line 574: p_information8 in varchar2 default hr_api.g_varchar2,

570: p_information4 in varchar2 default hr_api.g_varchar2,
571: p_information5 in varchar2 default hr_api.g_varchar2,
572: p_information6 in varchar2 default hr_api.g_varchar2,
573: p_information7 in varchar2 default hr_api.g_varchar2,
574: p_information8 in varchar2 default hr_api.g_varchar2,
575: p_information9 in varchar2 default hr_api.g_varchar2,
576: p_information10 in varchar2 default hr_api.g_varchar2,
577: p_information11 in varchar2 default hr_api.g_varchar2,
578: p_information12 in varchar2 default hr_api.g_varchar2,

Line 575: p_information9 in varchar2 default hr_api.g_varchar2,

571: p_information5 in varchar2 default hr_api.g_varchar2,
572: p_information6 in varchar2 default hr_api.g_varchar2,
573: p_information7 in varchar2 default hr_api.g_varchar2,
574: p_information8 in varchar2 default hr_api.g_varchar2,
575: p_information9 in varchar2 default hr_api.g_varchar2,
576: p_information10 in varchar2 default hr_api.g_varchar2,
577: p_information11 in varchar2 default hr_api.g_varchar2,
578: p_information12 in varchar2 default hr_api.g_varchar2,
579: p_information13 in varchar2 default hr_api.g_varchar2,

Line 576: p_information10 in varchar2 default hr_api.g_varchar2,

572: p_information6 in varchar2 default hr_api.g_varchar2,
573: p_information7 in varchar2 default hr_api.g_varchar2,
574: p_information8 in varchar2 default hr_api.g_varchar2,
575: p_information9 in varchar2 default hr_api.g_varchar2,
576: p_information10 in varchar2 default hr_api.g_varchar2,
577: p_information11 in varchar2 default hr_api.g_varchar2,
578: p_information12 in varchar2 default hr_api.g_varchar2,
579: p_information13 in varchar2 default hr_api.g_varchar2,
580: p_information14 in varchar2 default hr_api.g_varchar2,

Line 577: p_information11 in varchar2 default hr_api.g_varchar2,

573: p_information7 in varchar2 default hr_api.g_varchar2,
574: p_information8 in varchar2 default hr_api.g_varchar2,
575: p_information9 in varchar2 default hr_api.g_varchar2,
576: p_information10 in varchar2 default hr_api.g_varchar2,
577: p_information11 in varchar2 default hr_api.g_varchar2,
578: p_information12 in varchar2 default hr_api.g_varchar2,
579: p_information13 in varchar2 default hr_api.g_varchar2,
580: p_information14 in varchar2 default hr_api.g_varchar2,
581: p_information15 in varchar2 default hr_api.g_varchar2,

Line 578: p_information12 in varchar2 default hr_api.g_varchar2,

574: p_information8 in varchar2 default hr_api.g_varchar2,
575: p_information9 in varchar2 default hr_api.g_varchar2,
576: p_information10 in varchar2 default hr_api.g_varchar2,
577: p_information11 in varchar2 default hr_api.g_varchar2,
578: p_information12 in varchar2 default hr_api.g_varchar2,
579: p_information13 in varchar2 default hr_api.g_varchar2,
580: p_information14 in varchar2 default hr_api.g_varchar2,
581: p_information15 in varchar2 default hr_api.g_varchar2,
582: p_information16 in varchar2 default hr_api.g_varchar2,

Line 579: p_information13 in varchar2 default hr_api.g_varchar2,

575: p_information9 in varchar2 default hr_api.g_varchar2,
576: p_information10 in varchar2 default hr_api.g_varchar2,
577: p_information11 in varchar2 default hr_api.g_varchar2,
578: p_information12 in varchar2 default hr_api.g_varchar2,
579: p_information13 in varchar2 default hr_api.g_varchar2,
580: p_information14 in varchar2 default hr_api.g_varchar2,
581: p_information15 in varchar2 default hr_api.g_varchar2,
582: p_information16 in varchar2 default hr_api.g_varchar2,
583: p_information17 in varchar2 default hr_api.g_varchar2,

Line 580: p_information14 in varchar2 default hr_api.g_varchar2,

576: p_information10 in varchar2 default hr_api.g_varchar2,
577: p_information11 in varchar2 default hr_api.g_varchar2,
578: p_information12 in varchar2 default hr_api.g_varchar2,
579: p_information13 in varchar2 default hr_api.g_varchar2,
580: p_information14 in varchar2 default hr_api.g_varchar2,
581: p_information15 in varchar2 default hr_api.g_varchar2,
582: p_information16 in varchar2 default hr_api.g_varchar2,
583: p_information17 in varchar2 default hr_api.g_varchar2,
584: p_information18 in varchar2 default hr_api.g_varchar2,

Line 581: p_information15 in varchar2 default hr_api.g_varchar2,

577: p_information11 in varchar2 default hr_api.g_varchar2,
578: p_information12 in varchar2 default hr_api.g_varchar2,
579: p_information13 in varchar2 default hr_api.g_varchar2,
580: p_information14 in varchar2 default hr_api.g_varchar2,
581: p_information15 in varchar2 default hr_api.g_varchar2,
582: p_information16 in varchar2 default hr_api.g_varchar2,
583: p_information17 in varchar2 default hr_api.g_varchar2,
584: p_information18 in varchar2 default hr_api.g_varchar2,
585: p_information19 in varchar2 default hr_api.g_varchar2,

Line 582: p_information16 in varchar2 default hr_api.g_varchar2,

578: p_information12 in varchar2 default hr_api.g_varchar2,
579: p_information13 in varchar2 default hr_api.g_varchar2,
580: p_information14 in varchar2 default hr_api.g_varchar2,
581: p_information15 in varchar2 default hr_api.g_varchar2,
582: p_information16 in varchar2 default hr_api.g_varchar2,
583: p_information17 in varchar2 default hr_api.g_varchar2,
584: p_information18 in varchar2 default hr_api.g_varchar2,
585: p_information19 in varchar2 default hr_api.g_varchar2,
586: p_information20 in varchar2 default hr_api.g_varchar2,

Line 583: p_information17 in varchar2 default hr_api.g_varchar2,

579: p_information13 in varchar2 default hr_api.g_varchar2,
580: p_information14 in varchar2 default hr_api.g_varchar2,
581: p_information15 in varchar2 default hr_api.g_varchar2,
582: p_information16 in varchar2 default hr_api.g_varchar2,
583: p_information17 in varchar2 default hr_api.g_varchar2,
584: p_information18 in varchar2 default hr_api.g_varchar2,
585: p_information19 in varchar2 default hr_api.g_varchar2,
586: p_information20 in varchar2 default hr_api.g_varchar2,
587: p_information21 in varchar2 default hr_api.g_varchar2,

Line 584: p_information18 in varchar2 default hr_api.g_varchar2,

580: p_information14 in varchar2 default hr_api.g_varchar2,
581: p_information15 in varchar2 default hr_api.g_varchar2,
582: p_information16 in varchar2 default hr_api.g_varchar2,
583: p_information17 in varchar2 default hr_api.g_varchar2,
584: p_information18 in varchar2 default hr_api.g_varchar2,
585: p_information19 in varchar2 default hr_api.g_varchar2,
586: p_information20 in varchar2 default hr_api.g_varchar2,
587: p_information21 in varchar2 default hr_api.g_varchar2,
588: p_information22 in varchar2 default hr_api.g_varchar2,

Line 585: p_information19 in varchar2 default hr_api.g_varchar2,

581: p_information15 in varchar2 default hr_api.g_varchar2,
582: p_information16 in varchar2 default hr_api.g_varchar2,
583: p_information17 in varchar2 default hr_api.g_varchar2,
584: p_information18 in varchar2 default hr_api.g_varchar2,
585: p_information19 in varchar2 default hr_api.g_varchar2,
586: p_information20 in varchar2 default hr_api.g_varchar2,
587: p_information21 in varchar2 default hr_api.g_varchar2,
588: p_information22 in varchar2 default hr_api.g_varchar2,
589: p_information23 in varchar2 default hr_api.g_varchar2,

Line 586: p_information20 in varchar2 default hr_api.g_varchar2,

582: p_information16 in varchar2 default hr_api.g_varchar2,
583: p_information17 in varchar2 default hr_api.g_varchar2,
584: p_information18 in varchar2 default hr_api.g_varchar2,
585: p_information19 in varchar2 default hr_api.g_varchar2,
586: p_information20 in varchar2 default hr_api.g_varchar2,
587: p_information21 in varchar2 default hr_api.g_varchar2,
588: p_information22 in varchar2 default hr_api.g_varchar2,
589: p_information23 in varchar2 default hr_api.g_varchar2,
590: p_information24 in varchar2 default hr_api.g_varchar2,

Line 587: p_information21 in varchar2 default hr_api.g_varchar2,

583: p_information17 in varchar2 default hr_api.g_varchar2,
584: p_information18 in varchar2 default hr_api.g_varchar2,
585: p_information19 in varchar2 default hr_api.g_varchar2,
586: p_information20 in varchar2 default hr_api.g_varchar2,
587: p_information21 in varchar2 default hr_api.g_varchar2,
588: p_information22 in varchar2 default hr_api.g_varchar2,
589: p_information23 in varchar2 default hr_api.g_varchar2,
590: p_information24 in varchar2 default hr_api.g_varchar2,
591: p_information25 in varchar2 default hr_api.g_varchar2,

Line 588: p_information22 in varchar2 default hr_api.g_varchar2,

584: p_information18 in varchar2 default hr_api.g_varchar2,
585: p_information19 in varchar2 default hr_api.g_varchar2,
586: p_information20 in varchar2 default hr_api.g_varchar2,
587: p_information21 in varchar2 default hr_api.g_varchar2,
588: p_information22 in varchar2 default hr_api.g_varchar2,
589: p_information23 in varchar2 default hr_api.g_varchar2,
590: p_information24 in varchar2 default hr_api.g_varchar2,
591: p_information25 in varchar2 default hr_api.g_varchar2,
592: p_information26 in varchar2 default hr_api.g_varchar2,

Line 589: p_information23 in varchar2 default hr_api.g_varchar2,

585: p_information19 in varchar2 default hr_api.g_varchar2,
586: p_information20 in varchar2 default hr_api.g_varchar2,
587: p_information21 in varchar2 default hr_api.g_varchar2,
588: p_information22 in varchar2 default hr_api.g_varchar2,
589: p_information23 in varchar2 default hr_api.g_varchar2,
590: p_information24 in varchar2 default hr_api.g_varchar2,
591: p_information25 in varchar2 default hr_api.g_varchar2,
592: p_information26 in varchar2 default hr_api.g_varchar2,
593: p_information27 in varchar2 default hr_api.g_varchar2,

Line 590: p_information24 in varchar2 default hr_api.g_varchar2,

586: p_information20 in varchar2 default hr_api.g_varchar2,
587: p_information21 in varchar2 default hr_api.g_varchar2,
588: p_information22 in varchar2 default hr_api.g_varchar2,
589: p_information23 in varchar2 default hr_api.g_varchar2,
590: p_information24 in varchar2 default hr_api.g_varchar2,
591: p_information25 in varchar2 default hr_api.g_varchar2,
592: p_information26 in varchar2 default hr_api.g_varchar2,
593: p_information27 in varchar2 default hr_api.g_varchar2,
594: p_information28 in varchar2 default hr_api.g_varchar2,

Line 591: p_information25 in varchar2 default hr_api.g_varchar2,

587: p_information21 in varchar2 default hr_api.g_varchar2,
588: p_information22 in varchar2 default hr_api.g_varchar2,
589: p_information23 in varchar2 default hr_api.g_varchar2,
590: p_information24 in varchar2 default hr_api.g_varchar2,
591: p_information25 in varchar2 default hr_api.g_varchar2,
592: p_information26 in varchar2 default hr_api.g_varchar2,
593: p_information27 in varchar2 default hr_api.g_varchar2,
594: p_information28 in varchar2 default hr_api.g_varchar2,
595: p_information29 in varchar2 default hr_api.g_varchar2,

Line 592: p_information26 in varchar2 default hr_api.g_varchar2,

588: p_information22 in varchar2 default hr_api.g_varchar2,
589: p_information23 in varchar2 default hr_api.g_varchar2,
590: p_information24 in varchar2 default hr_api.g_varchar2,
591: p_information25 in varchar2 default hr_api.g_varchar2,
592: p_information26 in varchar2 default hr_api.g_varchar2,
593: p_information27 in varchar2 default hr_api.g_varchar2,
594: p_information28 in varchar2 default hr_api.g_varchar2,
595: p_information29 in varchar2 default hr_api.g_varchar2,
596: p_information30 in varchar2 default hr_api.g_varchar2,

Line 593: p_information27 in varchar2 default hr_api.g_varchar2,

589: p_information23 in varchar2 default hr_api.g_varchar2,
590: p_information24 in varchar2 default hr_api.g_varchar2,
591: p_information25 in varchar2 default hr_api.g_varchar2,
592: p_information26 in varchar2 default hr_api.g_varchar2,
593: p_information27 in varchar2 default hr_api.g_varchar2,
594: p_information28 in varchar2 default hr_api.g_varchar2,
595: p_information29 in varchar2 default hr_api.g_varchar2,
596: p_information30 in varchar2 default hr_api.g_varchar2,
597: p_check_information1 in varchar2 default hr_api.g_varchar2,

Line 594: p_information28 in varchar2 default hr_api.g_varchar2,

590: p_information24 in varchar2 default hr_api.g_varchar2,
591: p_information25 in varchar2 default hr_api.g_varchar2,
592: p_information26 in varchar2 default hr_api.g_varchar2,
593: p_information27 in varchar2 default hr_api.g_varchar2,
594: p_information28 in varchar2 default hr_api.g_varchar2,
595: p_information29 in varchar2 default hr_api.g_varchar2,
596: p_information30 in varchar2 default hr_api.g_varchar2,
597: p_check_information1 in varchar2 default hr_api.g_varchar2,
598: p_check_information2 in varchar2 default hr_api.g_varchar2,

Line 595: p_information29 in varchar2 default hr_api.g_varchar2,

591: p_information25 in varchar2 default hr_api.g_varchar2,
592: p_information26 in varchar2 default hr_api.g_varchar2,
593: p_information27 in varchar2 default hr_api.g_varchar2,
594: p_information28 in varchar2 default hr_api.g_varchar2,
595: p_information29 in varchar2 default hr_api.g_varchar2,
596: p_information30 in varchar2 default hr_api.g_varchar2,
597: p_check_information1 in varchar2 default hr_api.g_varchar2,
598: p_check_information2 in varchar2 default hr_api.g_varchar2,
599: p_check_information3 in varchar2 default hr_api.g_varchar2,

Line 596: p_information30 in varchar2 default hr_api.g_varchar2,

592: p_information26 in varchar2 default hr_api.g_varchar2,
593: p_information27 in varchar2 default hr_api.g_varchar2,
594: p_information28 in varchar2 default hr_api.g_varchar2,
595: p_information29 in varchar2 default hr_api.g_varchar2,
596: p_information30 in varchar2 default hr_api.g_varchar2,
597: p_check_information1 in varchar2 default hr_api.g_varchar2,
598: p_check_information2 in varchar2 default hr_api.g_varchar2,
599: p_check_information3 in varchar2 default hr_api.g_varchar2,
600: p_object_version_number in out nocopy number

Line 597: p_check_information1 in varchar2 default hr_api.g_varchar2,

593: p_information27 in varchar2 default hr_api.g_varchar2,
594: p_information28 in varchar2 default hr_api.g_varchar2,
595: p_information29 in varchar2 default hr_api.g_varchar2,
596: p_information30 in varchar2 default hr_api.g_varchar2,
597: p_check_information1 in varchar2 default hr_api.g_varchar2,
598: p_check_information2 in varchar2 default hr_api.g_varchar2,
599: p_check_information3 in varchar2 default hr_api.g_varchar2,
600: p_object_version_number in out nocopy number
601: ) is

Line 598: p_check_information2 in varchar2 default hr_api.g_varchar2,

594: p_information28 in varchar2 default hr_api.g_varchar2,
595: p_information29 in varchar2 default hr_api.g_varchar2,
596: p_information30 in varchar2 default hr_api.g_varchar2,
597: p_check_information1 in varchar2 default hr_api.g_varchar2,
598: p_check_information2 in varchar2 default hr_api.g_varchar2,
599: p_check_information3 in varchar2 default hr_api.g_varchar2,
600: p_object_version_number in out nocopy number
601: ) is
602: --

Line 599: p_check_information3 in varchar2 default hr_api.g_varchar2,

595: p_information29 in varchar2 default hr_api.g_varchar2,
596: p_information30 in varchar2 default hr_api.g_varchar2,
597: p_check_information1 in varchar2 default hr_api.g_varchar2,
598: p_check_information2 in varchar2 default hr_api.g_varchar2,
599: p_check_information3 in varchar2 default hr_api.g_varchar2,
600: p_object_version_number in out nocopy number
601: ) is
602: --
603: l_rec pqh_cea_shd.g_rec_type;