APPS.OTA_LCI_UPD dependencies on HR_API

Line 107: When hr_api.check_integrity_violated Then

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

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

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

Line 112: When hr_api.parent_integrity_violated Then

108: -- A check constraint has been violated
109: --
110: ota_lci_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: ota_lci_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 117: When hr_api.unique_integrity_violated Then

113: -- Parent integrity has been violated
114: --
115: ota_lci_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: ota_lci_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.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: ota_lci_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
124: Raise;
125: End update_dml;

Line 324: when hr_api.cannot_find_prog_unit then

320: );
321: --
322: exception
323: --
324: when hr_api.cannot_find_prog_unit then
325: --
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'OTA_LP_CAT_INCLUSIONS'
328: ,p_hook_type => 'AU');

Line 326: hr_api.cannot_find_prog_unit_error

322: exception
323: --
324: when hr_api.cannot_find_prog_unit then
325: --
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'OTA_LP_CAT_INCLUSIONS'
328: ,p_hook_type => 'AU');
329: --
330: end;

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

385: -- p_rec plsql record structure
386: -- to see if a system default is being used. If a system default
387: -- is being used then we must set to the 'current' argument value.
388: --
389: If (p_rec.primary_flag = hr_api.g_varchar2) then
390: p_rec.primary_flag :=
391: ota_lci_shd.g_old_rec.primary_flag;
392: End If;
393: If (p_rec.start_date_active = hr_api.g_date) then

Line 393: If (p_rec.start_date_active = hr_api.g_date) then

389: If (p_rec.primary_flag = hr_api.g_varchar2) then
390: p_rec.primary_flag :=
391: ota_lci_shd.g_old_rec.primary_flag;
392: End If;
393: If (p_rec.start_date_active = hr_api.g_date) then
394: p_rec.start_date_active :=
395: ota_lci_shd.g_old_rec.start_date_active;
396: End If;
397: If (p_rec.end_date_active = hr_api.g_date) then

Line 397: If (p_rec.end_date_active = hr_api.g_date) then

393: If (p_rec.start_date_active = hr_api.g_date) then
394: p_rec.start_date_active :=
395: ota_lci_shd.g_old_rec.start_date_active;
396: End If;
397: If (p_rec.end_date_active = hr_api.g_date) then
398: p_rec.end_date_active :=
399: ota_lci_shd.g_old_rec.end_date_active;
400: End If;
401: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

397: If (p_rec.end_date_active = hr_api.g_date) then
398: p_rec.end_date_active :=
399: ota_lci_shd.g_old_rec.end_date_active;
400: End If;
401: If (p_rec.attribute_category = hr_api.g_varchar2) then
402: p_rec.attribute_category :=
403: ota_lci_shd.g_old_rec.attribute_category;
404: End If;
405: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

401: If (p_rec.attribute_category = hr_api.g_varchar2) then
402: p_rec.attribute_category :=
403: ota_lci_shd.g_old_rec.attribute_category;
404: End If;
405: If (p_rec.attribute1 = hr_api.g_varchar2) then
406: p_rec.attribute1 :=
407: ota_lci_shd.g_old_rec.attribute1;
408: End If;
409: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

405: If (p_rec.attribute1 = hr_api.g_varchar2) then
406: p_rec.attribute1 :=
407: ota_lci_shd.g_old_rec.attribute1;
408: End If;
409: If (p_rec.attribute2 = hr_api.g_varchar2) then
410: p_rec.attribute2 :=
411: ota_lci_shd.g_old_rec.attribute2;
412: End If;
413: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

409: If (p_rec.attribute2 = hr_api.g_varchar2) then
410: p_rec.attribute2 :=
411: ota_lci_shd.g_old_rec.attribute2;
412: End If;
413: If (p_rec.attribute3 = hr_api.g_varchar2) then
414: p_rec.attribute3 :=
415: ota_lci_shd.g_old_rec.attribute3;
416: End If;
417: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

413: If (p_rec.attribute3 = hr_api.g_varchar2) then
414: p_rec.attribute3 :=
415: ota_lci_shd.g_old_rec.attribute3;
416: End If;
417: If (p_rec.attribute4 = hr_api.g_varchar2) then
418: p_rec.attribute4 :=
419: ota_lci_shd.g_old_rec.attribute4;
420: End If;
421: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

417: If (p_rec.attribute4 = hr_api.g_varchar2) then
418: p_rec.attribute4 :=
419: ota_lci_shd.g_old_rec.attribute4;
420: End If;
421: If (p_rec.attribute5 = hr_api.g_varchar2) then
422: p_rec.attribute5 :=
423: ota_lci_shd.g_old_rec.attribute5;
424: End If;
425: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

421: If (p_rec.attribute5 = hr_api.g_varchar2) then
422: p_rec.attribute5 :=
423: ota_lci_shd.g_old_rec.attribute5;
424: End If;
425: If (p_rec.attribute6 = hr_api.g_varchar2) then
426: p_rec.attribute6 :=
427: ota_lci_shd.g_old_rec.attribute6;
428: End If;
429: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

425: If (p_rec.attribute6 = hr_api.g_varchar2) then
426: p_rec.attribute6 :=
427: ota_lci_shd.g_old_rec.attribute6;
428: End If;
429: If (p_rec.attribute7 = hr_api.g_varchar2) then
430: p_rec.attribute7 :=
431: ota_lci_shd.g_old_rec.attribute7;
432: End If;
433: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

429: If (p_rec.attribute7 = hr_api.g_varchar2) then
430: p_rec.attribute7 :=
431: ota_lci_shd.g_old_rec.attribute7;
432: End If;
433: If (p_rec.attribute8 = hr_api.g_varchar2) then
434: p_rec.attribute8 :=
435: ota_lci_shd.g_old_rec.attribute8;
436: End If;
437: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

433: If (p_rec.attribute8 = hr_api.g_varchar2) then
434: p_rec.attribute8 :=
435: ota_lci_shd.g_old_rec.attribute8;
436: End If;
437: If (p_rec.attribute9 = hr_api.g_varchar2) then
438: p_rec.attribute9 :=
439: ota_lci_shd.g_old_rec.attribute9;
440: End If;
441: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

437: If (p_rec.attribute9 = hr_api.g_varchar2) then
438: p_rec.attribute9 :=
439: ota_lci_shd.g_old_rec.attribute9;
440: End If;
441: If (p_rec.attribute10 = hr_api.g_varchar2) then
442: p_rec.attribute10 :=
443: ota_lci_shd.g_old_rec.attribute10;
444: End If;
445: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

441: If (p_rec.attribute10 = hr_api.g_varchar2) then
442: p_rec.attribute10 :=
443: ota_lci_shd.g_old_rec.attribute10;
444: End If;
445: If (p_rec.attribute11 = hr_api.g_varchar2) then
446: p_rec.attribute11 :=
447: ota_lci_shd.g_old_rec.attribute11;
448: End If;
449: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

445: If (p_rec.attribute11 = hr_api.g_varchar2) then
446: p_rec.attribute11 :=
447: ota_lci_shd.g_old_rec.attribute11;
448: End If;
449: If (p_rec.attribute12 = hr_api.g_varchar2) then
450: p_rec.attribute12 :=
451: ota_lci_shd.g_old_rec.attribute12;
452: End If;
453: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

449: If (p_rec.attribute12 = hr_api.g_varchar2) then
450: p_rec.attribute12 :=
451: ota_lci_shd.g_old_rec.attribute12;
452: End If;
453: If (p_rec.attribute13 = hr_api.g_varchar2) then
454: p_rec.attribute13 :=
455: ota_lci_shd.g_old_rec.attribute13;
456: End If;
457: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

453: If (p_rec.attribute13 = hr_api.g_varchar2) then
454: p_rec.attribute13 :=
455: ota_lci_shd.g_old_rec.attribute13;
456: End If;
457: If (p_rec.attribute14 = hr_api.g_varchar2) then
458: p_rec.attribute14 :=
459: ota_lci_shd.g_old_rec.attribute14;
460: End If;
461: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

457: If (p_rec.attribute14 = hr_api.g_varchar2) then
458: p_rec.attribute14 :=
459: ota_lci_shd.g_old_rec.attribute14;
460: End If;
461: If (p_rec.attribute15 = hr_api.g_varchar2) then
462: p_rec.attribute15 :=
463: ota_lci_shd.g_old_rec.attribute15;
464: End If;
465: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

461: If (p_rec.attribute15 = hr_api.g_varchar2) then
462: p_rec.attribute15 :=
463: ota_lci_shd.g_old_rec.attribute15;
464: End If;
465: If (p_rec.attribute16 = hr_api.g_varchar2) then
466: p_rec.attribute16 :=
467: ota_lci_shd.g_old_rec.attribute16;
468: End If;
469: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

465: If (p_rec.attribute16 = hr_api.g_varchar2) then
466: p_rec.attribute16 :=
467: ota_lci_shd.g_old_rec.attribute16;
468: End If;
469: If (p_rec.attribute17 = hr_api.g_varchar2) then
470: p_rec.attribute17 :=
471: ota_lci_shd.g_old_rec.attribute17;
472: End If;
473: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

469: If (p_rec.attribute17 = hr_api.g_varchar2) then
470: p_rec.attribute17 :=
471: ota_lci_shd.g_old_rec.attribute17;
472: End If;
473: If (p_rec.attribute18 = hr_api.g_varchar2) then
474: p_rec.attribute18 :=
475: ota_lci_shd.g_old_rec.attribute18;
476: End If;
477: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

473: If (p_rec.attribute18 = hr_api.g_varchar2) then
474: p_rec.attribute18 :=
475: ota_lci_shd.g_old_rec.attribute18;
476: End If;
477: If (p_rec.attribute19 = hr_api.g_varchar2) then
478: p_rec.attribute19 :=
479: ota_lci_shd.g_old_rec.attribute19;
480: End If;
481: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

477: If (p_rec.attribute19 = hr_api.g_varchar2) then
478: p_rec.attribute19 :=
479: ota_lci_shd.g_old_rec.attribute19;
480: End If;
481: If (p_rec.attribute20 = hr_api.g_varchar2) then
482: p_rec.attribute20 :=
483: ota_lci_shd.g_old_rec.attribute20;
484: End If;
485: --

Line 551: ,p_start_date_active in date default hr_api.g_date

547: (p_effective_date in date
548: ,p_learning_path_id in number
549: ,p_category_usage_id in number
550: ,p_object_version_number in out nocopy number
551: ,p_start_date_active in date default hr_api.g_date
552: ,p_primary_flag in varchar2 default hr_api.g_varchar2
553: ,p_end_date_active in date default hr_api.g_date
554: ,p_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 552: ,p_primary_flag in varchar2 default hr_api.g_varchar2

548: ,p_learning_path_id in number
549: ,p_category_usage_id in number
550: ,p_object_version_number in out nocopy number
551: ,p_start_date_active in date default hr_api.g_date
552: ,p_primary_flag in varchar2 default hr_api.g_varchar2
553: ,p_end_date_active in date default hr_api.g_date
554: ,p_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 553: ,p_end_date_active in date default hr_api.g_date

549: ,p_category_usage_id in number
550: ,p_object_version_number in out nocopy number
551: ,p_start_date_active in date default hr_api.g_date
552: ,p_primary_flag in varchar2 default hr_api.g_varchar2
553: ,p_end_date_active in date default hr_api.g_date
554: ,p_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 554: ,p_attribute_category in varchar2 default hr_api.g_varchar2

550: ,p_object_version_number in out nocopy number
551: ,p_start_date_active in date default hr_api.g_date
552: ,p_primary_flag in varchar2 default hr_api.g_varchar2
553: ,p_end_date_active in date default hr_api.g_date
554: ,p_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 555: ,p_attribute1 in varchar2 default hr_api.g_varchar2

551: ,p_start_date_active in date default hr_api.g_date
552: ,p_primary_flag in varchar2 default hr_api.g_varchar2
553: ,p_end_date_active in date default hr_api.g_date
554: ,p_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 556: ,p_attribute2 in varchar2 default hr_api.g_varchar2

552: ,p_primary_flag in varchar2 default hr_api.g_varchar2
553: ,p_end_date_active in date default hr_api.g_date
554: ,p_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 557: ,p_attribute3 in varchar2 default hr_api.g_varchar2

553: ,p_end_date_active in date default hr_api.g_date
554: ,p_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 558: ,p_attribute4 in varchar2 default hr_api.g_varchar2

554: ,p_attribute_category in varchar2 default hr_api.g_varchar2
555: ,p_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 559: ,p_attribute5 in varchar2 default hr_api.g_varchar2

555: ,p_attribute1 in varchar2 default hr_api.g_varchar2
556: ,p_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 560: ,p_attribute6 in varchar2 default hr_api.g_varchar2

556: ,p_attribute2 in varchar2 default hr_api.g_varchar2
557: ,p_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 561: ,p_attribute7 in varchar2 default hr_api.g_varchar2

557: ,p_attribute3 in varchar2 default hr_api.g_varchar2
558: ,p_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 562: ,p_attribute8 in varchar2 default hr_api.g_varchar2

558: ,p_attribute4 in varchar2 default hr_api.g_varchar2
559: ,p_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 563: ,p_attribute9 in varchar2 default hr_api.g_varchar2

559: ,p_attribute5 in varchar2 default hr_api.g_varchar2
560: ,p_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 564: ,p_attribute10 in varchar2 default hr_api.g_varchar2

560: ,p_attribute6 in varchar2 default hr_api.g_varchar2
561: ,p_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 565: ,p_attribute11 in varchar2 default hr_api.g_varchar2

561: ,p_attribute7 in varchar2 default hr_api.g_varchar2
562: ,p_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 566: ,p_attribute12 in varchar2 default hr_api.g_varchar2

562: ,p_attribute8 in varchar2 default hr_api.g_varchar2
563: ,p_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 567: ,p_attribute13 in varchar2 default hr_api.g_varchar2

563: ,p_attribute9 in varchar2 default hr_api.g_varchar2
564: ,p_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 568: ,p_attribute14 in varchar2 default hr_api.g_varchar2

564: ,p_attribute10 in varchar2 default hr_api.g_varchar2
565: ,p_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 569: ,p_attribute15 in varchar2 default hr_api.g_varchar2

565: ,p_attribute11 in varchar2 default hr_api.g_varchar2
566: ,p_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 570: ,p_attribute16 in varchar2 default hr_api.g_varchar2

566: ,p_attribute12 in varchar2 default hr_api.g_varchar2
567: ,p_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 571: ,p_attribute17 in varchar2 default hr_api.g_varchar2

567: ,p_attribute13 in varchar2 default hr_api.g_varchar2
568: ,p_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_attribute20 in varchar2 default hr_api.g_varchar2
575: ) is

Line 572: ,p_attribute18 in varchar2 default hr_api.g_varchar2

568: ,p_attribute14 in varchar2 default hr_api.g_varchar2
569: ,p_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_attribute20 in varchar2 default hr_api.g_varchar2
575: ) is
576: --

Line 573: ,p_attribute19 in varchar2 default hr_api.g_varchar2

569: ,p_attribute15 in varchar2 default hr_api.g_varchar2
570: ,p_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_attribute20 in varchar2 default hr_api.g_varchar2
575: ) is
576: --
577: l_rec ota_lci_shd.g_rec_type;

Line 574: ,p_attribute20 in varchar2 default hr_api.g_varchar2

570: ,p_attribute16 in varchar2 default hr_api.g_varchar2
571: ,p_attribute17 in varchar2 default hr_api.g_varchar2
572: ,p_attribute18 in varchar2 default hr_api.g_varchar2
573: ,p_attribute19 in varchar2 default hr_api.g_varchar2
574: ,p_attribute20 in varchar2 default hr_api.g_varchar2
575: ) is
576: --
577: l_rec ota_lci_shd.g_rec_type;
578: l_proc varchar2(72) := g_package||'upd';