APPS.OTA_CTU_UPD dependencies on HR_API

Line 112: When hr_api.check_integrity_violated Then

108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: --
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: ota_ctu_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.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: ota_ctu_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
120: ota_ctu_shd.constraint_error

Line 117: When hr_api.parent_integrity_violated Then

113: -- A check constraint has been violated
114: --
115: ota_ctu_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
120: ota_ctu_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.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
120: ota_ctu_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: ota_ctu_shd.constraint_error

Line 122: When hr_api.unique_integrity_violated Then

118: -- Parent integrity has been violated
119: --
120: ota_ctu_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: ota_ctu_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.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: ota_ctu_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: --
129: Raise;
130: End update_dml;

Line 356: when hr_api.cannot_find_prog_unit then

352: );
353: --
354: exception
355: --
356: when hr_api.cannot_find_prog_unit then
357: --
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'OTA_CATEGORY_USAGES'
360: ,p_hook_type => 'AU');

Line 358: hr_api.cannot_find_prog_unit_error

354: exception
355: --
356: when hr_api.cannot_find_prog_unit then
357: --
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'OTA_CATEGORY_USAGES'
360: ,p_hook_type => 'AU');
361: --
362: end;

Line 421: If (p_rec.business_group_id = hr_api.g_number) then

417: -- p_rec plsql record structure
418: -- to see if a system default is being used. If a system default
419: -- is being used then we must set to the 'current' argument value.
420: --
421: If (p_rec.business_group_id = hr_api.g_number) then
422: p_rec.business_group_id :=
423: ota_ctu_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.category = hr_api.g_varchar2) then

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

421: If (p_rec.business_group_id = hr_api.g_number) then
422: p_rec.business_group_id :=
423: ota_ctu_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.category = hr_api.g_varchar2) then
426: p_rec.category :=
427: ota_ctu_shd.g_old_rec.category;
428: End If;
429: If (p_rec.type = hr_api.g_varchar2) then

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

425: If (p_rec.category = hr_api.g_varchar2) then
426: p_rec.category :=
427: ota_ctu_shd.g_old_rec.category;
428: End If;
429: If (p_rec.type = hr_api.g_varchar2) then
430: p_rec.type :=
431: ota_ctu_shd.g_old_rec.type;
432: End If;
433: If (p_rec.start_date_active = hr_api.g_date) then

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

429: If (p_rec.type = hr_api.g_varchar2) then
430: p_rec.type :=
431: ota_ctu_shd.g_old_rec.type;
432: End If;
433: If (p_rec.start_date_active = hr_api.g_date) then
434: p_rec.start_date_active :=
435: ota_ctu_shd.g_old_rec.start_date_active;
436: End If;
437: If (p_rec.end_date_active = hr_api.g_date) then

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

433: If (p_rec.start_date_active = hr_api.g_date) then
434: p_rec.start_date_active :=
435: ota_ctu_shd.g_old_rec.start_date_active;
436: End If;
437: If (p_rec.end_date_active = hr_api.g_date) then
438: p_rec.end_date_active :=
439: ota_ctu_shd.g_old_rec.end_date_active;
440: End If;
441: If (p_rec.parent_cat_usage_id = hr_api.g_number) then

Line 441: If (p_rec.parent_cat_usage_id = hr_api.g_number) then

437: If (p_rec.end_date_active = hr_api.g_date) then
438: p_rec.end_date_active :=
439: ota_ctu_shd.g_old_rec.end_date_active;
440: End If;
441: If (p_rec.parent_cat_usage_id = hr_api.g_number) then
442: p_rec.parent_cat_usage_id :=
443: ota_ctu_shd.g_old_rec.parent_cat_usage_id;
444: End If;
445: If (p_rec.synchronous_flag = hr_api.g_varchar2) then

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

441: If (p_rec.parent_cat_usage_id = hr_api.g_number) then
442: p_rec.parent_cat_usage_id :=
443: ota_ctu_shd.g_old_rec.parent_cat_usage_id;
444: End If;
445: If (p_rec.synchronous_flag = hr_api.g_varchar2) then
446: p_rec.synchronous_flag :=
447: ota_ctu_shd.g_old_rec.synchronous_flag;
448: End If;
449: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

445: If (p_rec.synchronous_flag = hr_api.g_varchar2) then
446: p_rec.synchronous_flag :=
447: ota_ctu_shd.g_old_rec.synchronous_flag;
448: End If;
449: If (p_rec.attribute_category = hr_api.g_varchar2) then
450: p_rec.attribute_category :=
451: ota_ctu_shd.g_old_rec.attribute_category;
452: End If;
453: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

449: If (p_rec.attribute_category = hr_api.g_varchar2) then
450: p_rec.attribute_category :=
451: ota_ctu_shd.g_old_rec.attribute_category;
452: End If;
453: If (p_rec.attribute1 = hr_api.g_varchar2) then
454: p_rec.attribute1 :=
455: ota_ctu_shd.g_old_rec.attribute1;
456: End If;
457: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

453: If (p_rec.attribute1 = hr_api.g_varchar2) then
454: p_rec.attribute1 :=
455: ota_ctu_shd.g_old_rec.attribute1;
456: End If;
457: If (p_rec.attribute2 = hr_api.g_varchar2) then
458: p_rec.attribute2 :=
459: ota_ctu_shd.g_old_rec.attribute2;
460: End If;
461: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

457: If (p_rec.attribute2 = hr_api.g_varchar2) then
458: p_rec.attribute2 :=
459: ota_ctu_shd.g_old_rec.attribute2;
460: End If;
461: If (p_rec.attribute3 = hr_api.g_varchar2) then
462: p_rec.attribute3 :=
463: ota_ctu_shd.g_old_rec.attribute3;
464: End If;
465: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

461: If (p_rec.attribute3 = hr_api.g_varchar2) then
462: p_rec.attribute3 :=
463: ota_ctu_shd.g_old_rec.attribute3;
464: End If;
465: If (p_rec.attribute4 = hr_api.g_varchar2) then
466: p_rec.attribute4 :=
467: ota_ctu_shd.g_old_rec.attribute4;
468: End If;
469: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

465: If (p_rec.attribute4 = hr_api.g_varchar2) then
466: p_rec.attribute4 :=
467: ota_ctu_shd.g_old_rec.attribute4;
468: End If;
469: If (p_rec.attribute5 = hr_api.g_varchar2) then
470: p_rec.attribute5 :=
471: ota_ctu_shd.g_old_rec.attribute5;
472: End If;
473: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

469: If (p_rec.attribute5 = hr_api.g_varchar2) then
470: p_rec.attribute5 :=
471: ota_ctu_shd.g_old_rec.attribute5;
472: End If;
473: If (p_rec.attribute6 = hr_api.g_varchar2) then
474: p_rec.attribute6 :=
475: ota_ctu_shd.g_old_rec.attribute6;
476: End If;
477: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

473: If (p_rec.attribute6 = hr_api.g_varchar2) then
474: p_rec.attribute6 :=
475: ota_ctu_shd.g_old_rec.attribute6;
476: End If;
477: If (p_rec.attribute7 = hr_api.g_varchar2) then
478: p_rec.attribute7 :=
479: ota_ctu_shd.g_old_rec.attribute7;
480: End If;
481: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

477: If (p_rec.attribute7 = hr_api.g_varchar2) then
478: p_rec.attribute7 :=
479: ota_ctu_shd.g_old_rec.attribute7;
480: End If;
481: If (p_rec.attribute8 = hr_api.g_varchar2) then
482: p_rec.attribute8 :=
483: ota_ctu_shd.g_old_rec.attribute8;
484: End If;
485: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

481: If (p_rec.attribute8 = hr_api.g_varchar2) then
482: p_rec.attribute8 :=
483: ota_ctu_shd.g_old_rec.attribute8;
484: End If;
485: If (p_rec.attribute9 = hr_api.g_varchar2) then
486: p_rec.attribute9 :=
487: ota_ctu_shd.g_old_rec.attribute9;
488: End If;
489: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

485: If (p_rec.attribute9 = hr_api.g_varchar2) then
486: p_rec.attribute9 :=
487: ota_ctu_shd.g_old_rec.attribute9;
488: End If;
489: If (p_rec.attribute10 = hr_api.g_varchar2) then
490: p_rec.attribute10 :=
491: ota_ctu_shd.g_old_rec.attribute10;
492: End If;
493: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

489: If (p_rec.attribute10 = hr_api.g_varchar2) then
490: p_rec.attribute10 :=
491: ota_ctu_shd.g_old_rec.attribute10;
492: End If;
493: If (p_rec.attribute11 = hr_api.g_varchar2) then
494: p_rec.attribute11 :=
495: ota_ctu_shd.g_old_rec.attribute11;
496: End If;
497: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

493: If (p_rec.attribute11 = hr_api.g_varchar2) then
494: p_rec.attribute11 :=
495: ota_ctu_shd.g_old_rec.attribute11;
496: End If;
497: If (p_rec.attribute12 = hr_api.g_varchar2) then
498: p_rec.attribute12 :=
499: ota_ctu_shd.g_old_rec.attribute12;
500: End If;
501: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

497: If (p_rec.attribute12 = hr_api.g_varchar2) then
498: p_rec.attribute12 :=
499: ota_ctu_shd.g_old_rec.attribute12;
500: End If;
501: If (p_rec.attribute13 = hr_api.g_varchar2) then
502: p_rec.attribute13 :=
503: ota_ctu_shd.g_old_rec.attribute13;
504: End If;
505: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

501: If (p_rec.attribute13 = hr_api.g_varchar2) then
502: p_rec.attribute13 :=
503: ota_ctu_shd.g_old_rec.attribute13;
504: End If;
505: If (p_rec.attribute14 = hr_api.g_varchar2) then
506: p_rec.attribute14 :=
507: ota_ctu_shd.g_old_rec.attribute14;
508: End If;
509: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

505: If (p_rec.attribute14 = hr_api.g_varchar2) then
506: p_rec.attribute14 :=
507: ota_ctu_shd.g_old_rec.attribute14;
508: End If;
509: If (p_rec.attribute15 = hr_api.g_varchar2) then
510: p_rec.attribute15 :=
511: ota_ctu_shd.g_old_rec.attribute15;
512: End If;
513: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

509: If (p_rec.attribute15 = hr_api.g_varchar2) then
510: p_rec.attribute15 :=
511: ota_ctu_shd.g_old_rec.attribute15;
512: End If;
513: If (p_rec.attribute16 = hr_api.g_varchar2) then
514: p_rec.attribute16 :=
515: ota_ctu_shd.g_old_rec.attribute16;
516: End If;
517: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

513: If (p_rec.attribute16 = hr_api.g_varchar2) then
514: p_rec.attribute16 :=
515: ota_ctu_shd.g_old_rec.attribute16;
516: End If;
517: If (p_rec.attribute17 = hr_api.g_varchar2) then
518: p_rec.attribute17 :=
519: ota_ctu_shd.g_old_rec.attribute17;
520: End If;
521: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

517: If (p_rec.attribute17 = hr_api.g_varchar2) then
518: p_rec.attribute17 :=
519: ota_ctu_shd.g_old_rec.attribute17;
520: End If;
521: If (p_rec.attribute18 = hr_api.g_varchar2) then
522: p_rec.attribute18 :=
523: ota_ctu_shd.g_old_rec.attribute18;
524: End If;
525: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

521: If (p_rec.attribute18 = hr_api.g_varchar2) then
522: p_rec.attribute18 :=
523: ota_ctu_shd.g_old_rec.attribute18;
524: End If;
525: If (p_rec.attribute19 = hr_api.g_varchar2) then
526: p_rec.attribute19 :=
527: ota_ctu_shd.g_old_rec.attribute19;
528: End If;
529: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

525: If (p_rec.attribute19 = hr_api.g_varchar2) then
526: p_rec.attribute19 :=
527: ota_ctu_shd.g_old_rec.attribute19;
528: End If;
529: If (p_rec.attribute20 = hr_api.g_varchar2) then
530: p_rec.attribute20 :=
531: ota_ctu_shd.g_old_rec.attribute20;
532: End If;
533: If (p_rec.data_source = hr_api.g_varchar2) then

Line 533: If (p_rec.data_source = hr_api.g_varchar2) then

529: If (p_rec.attribute20 = hr_api.g_varchar2) then
530: p_rec.attribute20 :=
531: ota_ctu_shd.g_old_rec.attribute20;
532: End If;
533: If (p_rec.data_source = hr_api.g_varchar2) then
534: p_rec.data_source :=
535: ota_ctu_shd.g_old_rec.data_source;
536: End If;
537: If (p_rec.online_flag = hr_api.g_varchar2) then

Line 537: If (p_rec.online_flag = hr_api.g_varchar2) then

533: If (p_rec.data_source = hr_api.g_varchar2) then
534: p_rec.data_source :=
535: ota_ctu_shd.g_old_rec.data_source;
536: End If;
537: If (p_rec.online_flag = hr_api.g_varchar2) then
538: p_rec.online_flag :=
539: ota_ctu_shd.g_old_rec.online_flag;
540: End If;
541: If (p_rec.comments = hr_api.g_varchar2) then

Line 541: If (p_rec.comments = hr_api.g_varchar2) then

537: If (p_rec.online_flag = hr_api.g_varchar2) then
538: p_rec.online_flag :=
539: ota_ctu_shd.g_old_rec.online_flag;
540: End If;
541: If (p_rec.comments = hr_api.g_varchar2) then
542: p_rec.comments :=
543: ota_ctu_shd.g_old_rec.comments;
544: End If;
545:

Line 610: ,p_business_group_id in number default hr_api.g_number

606: Procedure upd
607: (p_effective_date in date
608: ,p_category_usage_id in number
609: ,p_object_version_number in out nocopy number
610: ,p_business_group_id in number default hr_api.g_number
611: ,p_category in varchar2 default hr_api.g_varchar2
612: ,p_type in varchar2 default hr_api.g_varchar2
613: ,p_start_date_active in date default hr_api.g_date
614: ,p_end_date_active in date default hr_api.g_date

Line 611: ,p_category in varchar2 default hr_api.g_varchar2

607: (p_effective_date in date
608: ,p_category_usage_id in number
609: ,p_object_version_number in out nocopy number
610: ,p_business_group_id in number default hr_api.g_number
611: ,p_category in varchar2 default hr_api.g_varchar2
612: ,p_type in varchar2 default hr_api.g_varchar2
613: ,p_start_date_active in date default hr_api.g_date
614: ,p_end_date_active in date default hr_api.g_date
615: ,p_parent_cat_usage_id in number default hr_api.g_number

Line 612: ,p_type in varchar2 default hr_api.g_varchar2

608: ,p_category_usage_id in number
609: ,p_object_version_number in out nocopy number
610: ,p_business_group_id in number default hr_api.g_number
611: ,p_category in varchar2 default hr_api.g_varchar2
612: ,p_type in varchar2 default hr_api.g_varchar2
613: ,p_start_date_active in date default hr_api.g_date
614: ,p_end_date_active in date default hr_api.g_date
615: ,p_parent_cat_usage_id in number default hr_api.g_number
616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2

Line 613: ,p_start_date_active in date default hr_api.g_date

609: ,p_object_version_number in out nocopy number
610: ,p_business_group_id in number default hr_api.g_number
611: ,p_category in varchar2 default hr_api.g_varchar2
612: ,p_type in varchar2 default hr_api.g_varchar2
613: ,p_start_date_active in date default hr_api.g_date
614: ,p_end_date_active in date default hr_api.g_date
615: ,p_parent_cat_usage_id in number default hr_api.g_number
616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2
617: ,p_online_flag in varchar2 default hr_api.g_varchar2

Line 614: ,p_end_date_active in date default hr_api.g_date

610: ,p_business_group_id in number default hr_api.g_number
611: ,p_category in varchar2 default hr_api.g_varchar2
612: ,p_type in varchar2 default hr_api.g_varchar2
613: ,p_start_date_active in date default hr_api.g_date
614: ,p_end_date_active in date default hr_api.g_date
615: ,p_parent_cat_usage_id in number default hr_api.g_number
616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2
617: ,p_online_flag in varchar2 default hr_api.g_varchar2
618: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 615: ,p_parent_cat_usage_id in number default hr_api.g_number

611: ,p_category in varchar2 default hr_api.g_varchar2
612: ,p_type in varchar2 default hr_api.g_varchar2
613: ,p_start_date_active in date default hr_api.g_date
614: ,p_end_date_active in date default hr_api.g_date
615: ,p_parent_cat_usage_id in number default hr_api.g_number
616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2
617: ,p_online_flag in varchar2 default hr_api.g_varchar2
618: ,p_attribute_category in varchar2 default hr_api.g_varchar2
619: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2

612: ,p_type in varchar2 default hr_api.g_varchar2
613: ,p_start_date_active in date default hr_api.g_date
614: ,p_end_date_active in date default hr_api.g_date
615: ,p_parent_cat_usage_id in number default hr_api.g_number
616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2
617: ,p_online_flag in varchar2 default hr_api.g_varchar2
618: ,p_attribute_category in varchar2 default hr_api.g_varchar2
619: ,p_attribute1 in varchar2 default hr_api.g_varchar2
620: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 617: ,p_online_flag in varchar2 default hr_api.g_varchar2

613: ,p_start_date_active in date default hr_api.g_date
614: ,p_end_date_active in date default hr_api.g_date
615: ,p_parent_cat_usage_id in number default hr_api.g_number
616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2
617: ,p_online_flag in varchar2 default hr_api.g_varchar2
618: ,p_attribute_category in varchar2 default hr_api.g_varchar2
619: ,p_attribute1 in varchar2 default hr_api.g_varchar2
620: ,p_attribute2 in varchar2 default hr_api.g_varchar2
621: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 618: ,p_attribute_category in varchar2 default hr_api.g_varchar2

614: ,p_end_date_active in date default hr_api.g_date
615: ,p_parent_cat_usage_id in number default hr_api.g_number
616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2
617: ,p_online_flag in varchar2 default hr_api.g_varchar2
618: ,p_attribute_category in varchar2 default hr_api.g_varchar2
619: ,p_attribute1 in varchar2 default hr_api.g_varchar2
620: ,p_attribute2 in varchar2 default hr_api.g_varchar2
621: ,p_attribute3 in varchar2 default hr_api.g_varchar2
622: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 619: ,p_attribute1 in varchar2 default hr_api.g_varchar2

615: ,p_parent_cat_usage_id in number default hr_api.g_number
616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2
617: ,p_online_flag in varchar2 default hr_api.g_varchar2
618: ,p_attribute_category in varchar2 default hr_api.g_varchar2
619: ,p_attribute1 in varchar2 default hr_api.g_varchar2
620: ,p_attribute2 in varchar2 default hr_api.g_varchar2
621: ,p_attribute3 in varchar2 default hr_api.g_varchar2
622: ,p_attribute4 in varchar2 default hr_api.g_varchar2
623: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 620: ,p_attribute2 in varchar2 default hr_api.g_varchar2

616: ,p_synchronous_flag in varchar2 default hr_api.g_varchar2
617: ,p_online_flag in varchar2 default hr_api.g_varchar2
618: ,p_attribute_category in varchar2 default hr_api.g_varchar2
619: ,p_attribute1 in varchar2 default hr_api.g_varchar2
620: ,p_attribute2 in varchar2 default hr_api.g_varchar2
621: ,p_attribute3 in varchar2 default hr_api.g_varchar2
622: ,p_attribute4 in varchar2 default hr_api.g_varchar2
623: ,p_attribute5 in varchar2 default hr_api.g_varchar2
624: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 621: ,p_attribute3 in varchar2 default hr_api.g_varchar2

617: ,p_online_flag in varchar2 default hr_api.g_varchar2
618: ,p_attribute_category in varchar2 default hr_api.g_varchar2
619: ,p_attribute1 in varchar2 default hr_api.g_varchar2
620: ,p_attribute2 in varchar2 default hr_api.g_varchar2
621: ,p_attribute3 in varchar2 default hr_api.g_varchar2
622: ,p_attribute4 in varchar2 default hr_api.g_varchar2
623: ,p_attribute5 in varchar2 default hr_api.g_varchar2
624: ,p_attribute6 in varchar2 default hr_api.g_varchar2
625: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 622: ,p_attribute4 in varchar2 default hr_api.g_varchar2

618: ,p_attribute_category in varchar2 default hr_api.g_varchar2
619: ,p_attribute1 in varchar2 default hr_api.g_varchar2
620: ,p_attribute2 in varchar2 default hr_api.g_varchar2
621: ,p_attribute3 in varchar2 default hr_api.g_varchar2
622: ,p_attribute4 in varchar2 default hr_api.g_varchar2
623: ,p_attribute5 in varchar2 default hr_api.g_varchar2
624: ,p_attribute6 in varchar2 default hr_api.g_varchar2
625: ,p_attribute7 in varchar2 default hr_api.g_varchar2
626: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 623: ,p_attribute5 in varchar2 default hr_api.g_varchar2

619: ,p_attribute1 in varchar2 default hr_api.g_varchar2
620: ,p_attribute2 in varchar2 default hr_api.g_varchar2
621: ,p_attribute3 in varchar2 default hr_api.g_varchar2
622: ,p_attribute4 in varchar2 default hr_api.g_varchar2
623: ,p_attribute5 in varchar2 default hr_api.g_varchar2
624: ,p_attribute6 in varchar2 default hr_api.g_varchar2
625: ,p_attribute7 in varchar2 default hr_api.g_varchar2
626: ,p_attribute8 in varchar2 default hr_api.g_varchar2
627: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 624: ,p_attribute6 in varchar2 default hr_api.g_varchar2

620: ,p_attribute2 in varchar2 default hr_api.g_varchar2
621: ,p_attribute3 in varchar2 default hr_api.g_varchar2
622: ,p_attribute4 in varchar2 default hr_api.g_varchar2
623: ,p_attribute5 in varchar2 default hr_api.g_varchar2
624: ,p_attribute6 in varchar2 default hr_api.g_varchar2
625: ,p_attribute7 in varchar2 default hr_api.g_varchar2
626: ,p_attribute8 in varchar2 default hr_api.g_varchar2
627: ,p_attribute9 in varchar2 default hr_api.g_varchar2
628: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 625: ,p_attribute7 in varchar2 default hr_api.g_varchar2

621: ,p_attribute3 in varchar2 default hr_api.g_varchar2
622: ,p_attribute4 in varchar2 default hr_api.g_varchar2
623: ,p_attribute5 in varchar2 default hr_api.g_varchar2
624: ,p_attribute6 in varchar2 default hr_api.g_varchar2
625: ,p_attribute7 in varchar2 default hr_api.g_varchar2
626: ,p_attribute8 in varchar2 default hr_api.g_varchar2
627: ,p_attribute9 in varchar2 default hr_api.g_varchar2
628: ,p_attribute10 in varchar2 default hr_api.g_varchar2
629: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 626: ,p_attribute8 in varchar2 default hr_api.g_varchar2

622: ,p_attribute4 in varchar2 default hr_api.g_varchar2
623: ,p_attribute5 in varchar2 default hr_api.g_varchar2
624: ,p_attribute6 in varchar2 default hr_api.g_varchar2
625: ,p_attribute7 in varchar2 default hr_api.g_varchar2
626: ,p_attribute8 in varchar2 default hr_api.g_varchar2
627: ,p_attribute9 in varchar2 default hr_api.g_varchar2
628: ,p_attribute10 in varchar2 default hr_api.g_varchar2
629: ,p_attribute11 in varchar2 default hr_api.g_varchar2
630: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 627: ,p_attribute9 in varchar2 default hr_api.g_varchar2

623: ,p_attribute5 in varchar2 default hr_api.g_varchar2
624: ,p_attribute6 in varchar2 default hr_api.g_varchar2
625: ,p_attribute7 in varchar2 default hr_api.g_varchar2
626: ,p_attribute8 in varchar2 default hr_api.g_varchar2
627: ,p_attribute9 in varchar2 default hr_api.g_varchar2
628: ,p_attribute10 in varchar2 default hr_api.g_varchar2
629: ,p_attribute11 in varchar2 default hr_api.g_varchar2
630: ,p_attribute12 in varchar2 default hr_api.g_varchar2
631: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 628: ,p_attribute10 in varchar2 default hr_api.g_varchar2

624: ,p_attribute6 in varchar2 default hr_api.g_varchar2
625: ,p_attribute7 in varchar2 default hr_api.g_varchar2
626: ,p_attribute8 in varchar2 default hr_api.g_varchar2
627: ,p_attribute9 in varchar2 default hr_api.g_varchar2
628: ,p_attribute10 in varchar2 default hr_api.g_varchar2
629: ,p_attribute11 in varchar2 default hr_api.g_varchar2
630: ,p_attribute12 in varchar2 default hr_api.g_varchar2
631: ,p_attribute13 in varchar2 default hr_api.g_varchar2
632: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 629: ,p_attribute11 in varchar2 default hr_api.g_varchar2

625: ,p_attribute7 in varchar2 default hr_api.g_varchar2
626: ,p_attribute8 in varchar2 default hr_api.g_varchar2
627: ,p_attribute9 in varchar2 default hr_api.g_varchar2
628: ,p_attribute10 in varchar2 default hr_api.g_varchar2
629: ,p_attribute11 in varchar2 default hr_api.g_varchar2
630: ,p_attribute12 in varchar2 default hr_api.g_varchar2
631: ,p_attribute13 in varchar2 default hr_api.g_varchar2
632: ,p_attribute14 in varchar2 default hr_api.g_varchar2
633: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 630: ,p_attribute12 in varchar2 default hr_api.g_varchar2

626: ,p_attribute8 in varchar2 default hr_api.g_varchar2
627: ,p_attribute9 in varchar2 default hr_api.g_varchar2
628: ,p_attribute10 in varchar2 default hr_api.g_varchar2
629: ,p_attribute11 in varchar2 default hr_api.g_varchar2
630: ,p_attribute12 in varchar2 default hr_api.g_varchar2
631: ,p_attribute13 in varchar2 default hr_api.g_varchar2
632: ,p_attribute14 in varchar2 default hr_api.g_varchar2
633: ,p_attribute15 in varchar2 default hr_api.g_varchar2
634: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 631: ,p_attribute13 in varchar2 default hr_api.g_varchar2

627: ,p_attribute9 in varchar2 default hr_api.g_varchar2
628: ,p_attribute10 in varchar2 default hr_api.g_varchar2
629: ,p_attribute11 in varchar2 default hr_api.g_varchar2
630: ,p_attribute12 in varchar2 default hr_api.g_varchar2
631: ,p_attribute13 in varchar2 default hr_api.g_varchar2
632: ,p_attribute14 in varchar2 default hr_api.g_varchar2
633: ,p_attribute15 in varchar2 default hr_api.g_varchar2
634: ,p_attribute16 in varchar2 default hr_api.g_varchar2
635: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 632: ,p_attribute14 in varchar2 default hr_api.g_varchar2

628: ,p_attribute10 in varchar2 default hr_api.g_varchar2
629: ,p_attribute11 in varchar2 default hr_api.g_varchar2
630: ,p_attribute12 in varchar2 default hr_api.g_varchar2
631: ,p_attribute13 in varchar2 default hr_api.g_varchar2
632: ,p_attribute14 in varchar2 default hr_api.g_varchar2
633: ,p_attribute15 in varchar2 default hr_api.g_varchar2
634: ,p_attribute16 in varchar2 default hr_api.g_varchar2
635: ,p_attribute17 in varchar2 default hr_api.g_varchar2
636: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 633: ,p_attribute15 in varchar2 default hr_api.g_varchar2

629: ,p_attribute11 in varchar2 default hr_api.g_varchar2
630: ,p_attribute12 in varchar2 default hr_api.g_varchar2
631: ,p_attribute13 in varchar2 default hr_api.g_varchar2
632: ,p_attribute14 in varchar2 default hr_api.g_varchar2
633: ,p_attribute15 in varchar2 default hr_api.g_varchar2
634: ,p_attribute16 in varchar2 default hr_api.g_varchar2
635: ,p_attribute17 in varchar2 default hr_api.g_varchar2
636: ,p_attribute18 in varchar2 default hr_api.g_varchar2
637: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 634: ,p_attribute16 in varchar2 default hr_api.g_varchar2

630: ,p_attribute12 in varchar2 default hr_api.g_varchar2
631: ,p_attribute13 in varchar2 default hr_api.g_varchar2
632: ,p_attribute14 in varchar2 default hr_api.g_varchar2
633: ,p_attribute15 in varchar2 default hr_api.g_varchar2
634: ,p_attribute16 in varchar2 default hr_api.g_varchar2
635: ,p_attribute17 in varchar2 default hr_api.g_varchar2
636: ,p_attribute18 in varchar2 default hr_api.g_varchar2
637: ,p_attribute19 in varchar2 default hr_api.g_varchar2
638: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 635: ,p_attribute17 in varchar2 default hr_api.g_varchar2

631: ,p_attribute13 in varchar2 default hr_api.g_varchar2
632: ,p_attribute14 in varchar2 default hr_api.g_varchar2
633: ,p_attribute15 in varchar2 default hr_api.g_varchar2
634: ,p_attribute16 in varchar2 default hr_api.g_varchar2
635: ,p_attribute17 in varchar2 default hr_api.g_varchar2
636: ,p_attribute18 in varchar2 default hr_api.g_varchar2
637: ,p_attribute19 in varchar2 default hr_api.g_varchar2
638: ,p_attribute20 in varchar2 default hr_api.g_varchar2
639: ,p_data_source in varchar2 default hr_api.g_varchar2

Line 636: ,p_attribute18 in varchar2 default hr_api.g_varchar2

632: ,p_attribute14 in varchar2 default hr_api.g_varchar2
633: ,p_attribute15 in varchar2 default hr_api.g_varchar2
634: ,p_attribute16 in varchar2 default hr_api.g_varchar2
635: ,p_attribute17 in varchar2 default hr_api.g_varchar2
636: ,p_attribute18 in varchar2 default hr_api.g_varchar2
637: ,p_attribute19 in varchar2 default hr_api.g_varchar2
638: ,p_attribute20 in varchar2 default hr_api.g_varchar2
639: ,p_data_source in varchar2 default hr_api.g_varchar2
640: ,p_comments in varchar2 default hr_api.g_varchar2

Line 637: ,p_attribute19 in varchar2 default hr_api.g_varchar2

633: ,p_attribute15 in varchar2 default hr_api.g_varchar2
634: ,p_attribute16 in varchar2 default hr_api.g_varchar2
635: ,p_attribute17 in varchar2 default hr_api.g_varchar2
636: ,p_attribute18 in varchar2 default hr_api.g_varchar2
637: ,p_attribute19 in varchar2 default hr_api.g_varchar2
638: ,p_attribute20 in varchar2 default hr_api.g_varchar2
639: ,p_data_source in varchar2 default hr_api.g_varchar2
640: ,p_comments in varchar2 default hr_api.g_varchar2
641: ) is

Line 638: ,p_attribute20 in varchar2 default hr_api.g_varchar2

634: ,p_attribute16 in varchar2 default hr_api.g_varchar2
635: ,p_attribute17 in varchar2 default hr_api.g_varchar2
636: ,p_attribute18 in varchar2 default hr_api.g_varchar2
637: ,p_attribute19 in varchar2 default hr_api.g_varchar2
638: ,p_attribute20 in varchar2 default hr_api.g_varchar2
639: ,p_data_source in varchar2 default hr_api.g_varchar2
640: ,p_comments in varchar2 default hr_api.g_varchar2
641: ) is
642: --

Line 639: ,p_data_source in varchar2 default hr_api.g_varchar2

635: ,p_attribute17 in varchar2 default hr_api.g_varchar2
636: ,p_attribute18 in varchar2 default hr_api.g_varchar2
637: ,p_attribute19 in varchar2 default hr_api.g_varchar2
638: ,p_attribute20 in varchar2 default hr_api.g_varchar2
639: ,p_data_source in varchar2 default hr_api.g_varchar2
640: ,p_comments in varchar2 default hr_api.g_varchar2
641: ) is
642: --
643: l_rec ota_ctu_shd.g_rec_type;

Line 640: ,p_comments in varchar2 default hr_api.g_varchar2

636: ,p_attribute18 in varchar2 default hr_api.g_varchar2
637: ,p_attribute19 in varchar2 default hr_api.g_varchar2
638: ,p_attribute20 in varchar2 default hr_api.g_varchar2
639: ,p_data_source in varchar2 default hr_api.g_varchar2
640: ,p_comments in varchar2 default hr_api.g_varchar2
641: ) is
642: --
643: l_rec ota_ctu_shd.g_rec_type;
644: l_proc varchar2(72) := g_package||'upd';