APPS.OTA_CFS_UPD dependencies on HR_API

Line 108: When hr_api.check_integrity_violated Then

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

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

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

Line 113: When hr_api.parent_integrity_violated Then

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

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

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

Line 118: When hr_api.unique_integrity_violated Then

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

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

118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: --
121: ota_cfs_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: --
125: Raise;
126: End update_dml;

Line 335: when hr_api.cannot_find_prog_unit then

331: );
332: --
333: exception
334: --
335: when hr_api.cannot_find_prog_unit then
336: --
337: hr_api.cannot_find_prog_unit_error
338: (p_module_name => 'OTA_CONFERENCE_SERVERS'
339: ,p_hook_type => 'AU');

Line 337: hr_api.cannot_find_prog_unit_error

333: exception
334: --
335: when hr_api.cannot_find_prog_unit then
336: --
337: hr_api.cannot_find_prog_unit_error
338: (p_module_name => 'OTA_CONFERENCE_SERVERS'
339: ,p_hook_type => 'AU');
340: --
341: end;

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

397: -- to see if a system default is being used. If a system default
398: -- is being used then we must set to the 'current' argument value.
399: --
400:
401: If (p_rec.url = hr_api.g_varchar2) then
402: p_rec.url :=
403: ota_cfs_shd.g_old_rec.url;
404: End If;
405: If (p_rec.type = hr_api.g_varchar2) then

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

401: If (p_rec.url = hr_api.g_varchar2) then
402: p_rec.url :=
403: ota_cfs_shd.g_old_rec.url;
404: End If;
405: If (p_rec.type = hr_api.g_varchar2) then
406: p_rec.type :=
407: ota_cfs_shd.g_old_rec.type;
408: End If;
409: If (p_rec.owc_site_id = hr_api.g_varchar2) then

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

405: If (p_rec.type = hr_api.g_varchar2) then
406: p_rec.type :=
407: ota_cfs_shd.g_old_rec.type;
408: End If;
409: If (p_rec.owc_site_id = hr_api.g_varchar2) then
410: p_rec.owc_site_id :=
411: ota_cfs_shd.g_old_rec.owc_site_id;
412: End If;
413: If (p_rec.owc_auth_token = hr_api.g_varchar2) then

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

409: If (p_rec.owc_site_id = hr_api.g_varchar2) then
410: p_rec.owc_site_id :=
411: ota_cfs_shd.g_old_rec.owc_site_id;
412: End If;
413: If (p_rec.owc_auth_token = hr_api.g_varchar2) then
414: p_rec.owc_auth_token :=
415: ota_cfs_shd.g_old_rec.owc_auth_token;
416: End If;
417: If (p_rec.end_date_active = hr_api.g_date) then

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

413: If (p_rec.owc_auth_token = hr_api.g_varchar2) then
414: p_rec.owc_auth_token :=
415: ota_cfs_shd.g_old_rec.owc_auth_token;
416: End If;
417: If (p_rec.end_date_active = hr_api.g_date) then
418: p_rec.end_date_active :=
419: ota_cfs_shd.g_old_rec.end_date_active;
420: End If;
421: If (p_rec.business_group_id = hr_api.g_number) then

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

417: If (p_rec.end_date_active = hr_api.g_date) then
418: p_rec.end_date_active :=
419: ota_cfs_shd.g_old_rec.end_date_active;
420: End If;
421: If (p_rec.business_group_id = hr_api.g_number) then
422: p_rec.business_group_id :=
423: ota_cfs_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 425: If (p_rec.attribute_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_cfs_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.attribute_category = hr_api.g_varchar2) then
426: p_rec.attribute_category :=
427: ota_cfs_shd.g_old_rec.attribute_category;
428: End If;
429: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

425: If (p_rec.attribute_category = hr_api.g_varchar2) then
426: p_rec.attribute_category :=
427: ota_cfs_shd.g_old_rec.attribute_category;
428: End If;
429: If (p_rec.attribute1 = hr_api.g_varchar2) then
430: p_rec.attribute1 :=
431: ota_cfs_shd.g_old_rec.attribute1;
432: End If;
433: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

429: If (p_rec.attribute1 = hr_api.g_varchar2) then
430: p_rec.attribute1 :=
431: ota_cfs_shd.g_old_rec.attribute1;
432: End If;
433: If (p_rec.attribute2 = hr_api.g_varchar2) then
434: p_rec.attribute2 :=
435: ota_cfs_shd.g_old_rec.attribute2;
436: End If;
437: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

433: If (p_rec.attribute2 = hr_api.g_varchar2) then
434: p_rec.attribute2 :=
435: ota_cfs_shd.g_old_rec.attribute2;
436: End If;
437: If (p_rec.attribute3 = hr_api.g_varchar2) then
438: p_rec.attribute3 :=
439: ota_cfs_shd.g_old_rec.attribute3;
440: End If;
441: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

437: If (p_rec.attribute3 = hr_api.g_varchar2) then
438: p_rec.attribute3 :=
439: ota_cfs_shd.g_old_rec.attribute3;
440: End If;
441: If (p_rec.attribute4 = hr_api.g_varchar2) then
442: p_rec.attribute4 :=
443: ota_cfs_shd.g_old_rec.attribute4;
444: End If;
445: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

441: If (p_rec.attribute4 = hr_api.g_varchar2) then
442: p_rec.attribute4 :=
443: ota_cfs_shd.g_old_rec.attribute4;
444: End If;
445: If (p_rec.attribute5 = hr_api.g_varchar2) then
446: p_rec.attribute5 :=
447: ota_cfs_shd.g_old_rec.attribute5;
448: End If;
449: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

445: If (p_rec.attribute5 = hr_api.g_varchar2) then
446: p_rec.attribute5 :=
447: ota_cfs_shd.g_old_rec.attribute5;
448: End If;
449: If (p_rec.attribute6 = hr_api.g_varchar2) then
450: p_rec.attribute6 :=
451: ota_cfs_shd.g_old_rec.attribute6;
452: End If;
453: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

449: If (p_rec.attribute6 = hr_api.g_varchar2) then
450: p_rec.attribute6 :=
451: ota_cfs_shd.g_old_rec.attribute6;
452: End If;
453: If (p_rec.attribute7 = hr_api.g_varchar2) then
454: p_rec.attribute7 :=
455: ota_cfs_shd.g_old_rec.attribute7;
456: End If;
457: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

453: If (p_rec.attribute7 = hr_api.g_varchar2) then
454: p_rec.attribute7 :=
455: ota_cfs_shd.g_old_rec.attribute7;
456: End If;
457: If (p_rec.attribute8 = hr_api.g_varchar2) then
458: p_rec.attribute8 :=
459: ota_cfs_shd.g_old_rec.attribute8;
460: End If;
461: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

457: If (p_rec.attribute8 = hr_api.g_varchar2) then
458: p_rec.attribute8 :=
459: ota_cfs_shd.g_old_rec.attribute8;
460: End If;
461: If (p_rec.attribute9 = hr_api.g_varchar2) then
462: p_rec.attribute9 :=
463: ota_cfs_shd.g_old_rec.attribute9;
464: End If;
465: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

461: If (p_rec.attribute9 = hr_api.g_varchar2) then
462: p_rec.attribute9 :=
463: ota_cfs_shd.g_old_rec.attribute9;
464: End If;
465: If (p_rec.attribute10 = hr_api.g_varchar2) then
466: p_rec.attribute10 :=
467: ota_cfs_shd.g_old_rec.attribute10;
468: End If;
469: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

465: If (p_rec.attribute10 = hr_api.g_varchar2) then
466: p_rec.attribute10 :=
467: ota_cfs_shd.g_old_rec.attribute10;
468: End If;
469: If (p_rec.attribute11 = hr_api.g_varchar2) then
470: p_rec.attribute11 :=
471: ota_cfs_shd.g_old_rec.attribute11;
472: End If;
473: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

469: If (p_rec.attribute11 = hr_api.g_varchar2) then
470: p_rec.attribute11 :=
471: ota_cfs_shd.g_old_rec.attribute11;
472: End If;
473: If (p_rec.attribute12 = hr_api.g_varchar2) then
474: p_rec.attribute12 :=
475: ota_cfs_shd.g_old_rec.attribute12;
476: End If;
477: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

473: If (p_rec.attribute12 = hr_api.g_varchar2) then
474: p_rec.attribute12 :=
475: ota_cfs_shd.g_old_rec.attribute12;
476: End If;
477: If (p_rec.attribute13 = hr_api.g_varchar2) then
478: p_rec.attribute13 :=
479: ota_cfs_shd.g_old_rec.attribute13;
480: End If;
481: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

477: If (p_rec.attribute13 = hr_api.g_varchar2) then
478: p_rec.attribute13 :=
479: ota_cfs_shd.g_old_rec.attribute13;
480: End If;
481: If (p_rec.attribute14 = hr_api.g_varchar2) then
482: p_rec.attribute14 :=
483: ota_cfs_shd.g_old_rec.attribute14;
484: End If;
485: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

481: If (p_rec.attribute14 = hr_api.g_varchar2) then
482: p_rec.attribute14 :=
483: ota_cfs_shd.g_old_rec.attribute14;
484: End If;
485: If (p_rec.attribute15 = hr_api.g_varchar2) then
486: p_rec.attribute15 :=
487: ota_cfs_shd.g_old_rec.attribute15;
488: End If;
489: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

485: If (p_rec.attribute15 = hr_api.g_varchar2) then
486: p_rec.attribute15 :=
487: ota_cfs_shd.g_old_rec.attribute15;
488: End If;
489: If (p_rec.attribute16 = hr_api.g_varchar2) then
490: p_rec.attribute16 :=
491: ota_cfs_shd.g_old_rec.attribute16;
492: End If;
493: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

489: If (p_rec.attribute16 = hr_api.g_varchar2) then
490: p_rec.attribute16 :=
491: ota_cfs_shd.g_old_rec.attribute16;
492: End If;
493: If (p_rec.attribute17 = hr_api.g_varchar2) then
494: p_rec.attribute17 :=
495: ota_cfs_shd.g_old_rec.attribute17;
496: End If;
497: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

493: If (p_rec.attribute17 = hr_api.g_varchar2) then
494: p_rec.attribute17 :=
495: ota_cfs_shd.g_old_rec.attribute17;
496: End If;
497: If (p_rec.attribute18 = hr_api.g_varchar2) then
498: p_rec.attribute18 :=
499: ota_cfs_shd.g_old_rec.attribute18;
500: End If;
501: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

497: If (p_rec.attribute18 = hr_api.g_varchar2) then
498: p_rec.attribute18 :=
499: ota_cfs_shd.g_old_rec.attribute18;
500: End If;
501: If (p_rec.attribute19 = hr_api.g_varchar2) then
502: p_rec.attribute19 :=
503: ota_cfs_shd.g_old_rec.attribute19;
504: End If;
505: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

501: If (p_rec.attribute19 = hr_api.g_varchar2) then
502: p_rec.attribute19 :=
503: ota_cfs_shd.g_old_rec.attribute19;
504: End If;
505: If (p_rec.attribute20 = hr_api.g_varchar2) then
506: p_rec.attribute20 :=
507: ota_cfs_shd.g_old_rec.attribute20;
508: End If;
509: --

Line 575: ,p_name in varchar2 default hr_api.g_varchar2

571: Procedure upd
572: (p_effective_date in date
573: ,p_conference_server_id in number
574: ,p_object_version_number in out nocopy number
575: ,p_name in varchar2 default hr_api.g_varchar2
576: ,p_url in varchar2 default hr_api.g_varchar2
577: ,p_type in varchar2 default hr_api.g_varchar2
578: ,p_business_group_id in number default hr_api.g_number
579: ,p_description in varchar2 default hr_api.g_varchar2

Line 576: ,p_url in varchar2 default hr_api.g_varchar2

572: (p_effective_date in date
573: ,p_conference_server_id in number
574: ,p_object_version_number in out nocopy number
575: ,p_name in varchar2 default hr_api.g_varchar2
576: ,p_url in varchar2 default hr_api.g_varchar2
577: ,p_type in varchar2 default hr_api.g_varchar2
578: ,p_business_group_id in number default hr_api.g_number
579: ,p_description in varchar2 default hr_api.g_varchar2
580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2

Line 577: ,p_type in varchar2 default hr_api.g_varchar2

573: ,p_conference_server_id in number
574: ,p_object_version_number in out nocopy number
575: ,p_name in varchar2 default hr_api.g_varchar2
576: ,p_url in varchar2 default hr_api.g_varchar2
577: ,p_type in varchar2 default hr_api.g_varchar2
578: ,p_business_group_id in number default hr_api.g_number
579: ,p_description in varchar2 default hr_api.g_varchar2
580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2
581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2

Line 578: ,p_business_group_id in number default hr_api.g_number

574: ,p_object_version_number in out nocopy number
575: ,p_name in varchar2 default hr_api.g_varchar2
576: ,p_url in varchar2 default hr_api.g_varchar2
577: ,p_type in varchar2 default hr_api.g_varchar2
578: ,p_business_group_id in number default hr_api.g_number
579: ,p_description in varchar2 default hr_api.g_varchar2
580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2
581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2
582: ,p_end_date_active in date default hr_api.g_date

Line 579: ,p_description in varchar2 default hr_api.g_varchar2

575: ,p_name in varchar2 default hr_api.g_varchar2
576: ,p_url in varchar2 default hr_api.g_varchar2
577: ,p_type in varchar2 default hr_api.g_varchar2
578: ,p_business_group_id in number default hr_api.g_number
579: ,p_description in varchar2 default hr_api.g_varchar2
580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2
581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2
582: ,p_end_date_active in date default hr_api.g_date
583: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2

576: ,p_url in varchar2 default hr_api.g_varchar2
577: ,p_type in varchar2 default hr_api.g_varchar2
578: ,p_business_group_id in number default hr_api.g_number
579: ,p_description in varchar2 default hr_api.g_varchar2
580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2
581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2
582: ,p_end_date_active in date default hr_api.g_date
583: ,p_attribute_category in varchar2 default hr_api.g_varchar2
584: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2

577: ,p_type in varchar2 default hr_api.g_varchar2
578: ,p_business_group_id in number default hr_api.g_number
579: ,p_description in varchar2 default hr_api.g_varchar2
580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2
581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2
582: ,p_end_date_active in date default hr_api.g_date
583: ,p_attribute_category in varchar2 default hr_api.g_varchar2
584: ,p_attribute1 in varchar2 default hr_api.g_varchar2
585: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 582: ,p_end_date_active in date default hr_api.g_date

578: ,p_business_group_id in number default hr_api.g_number
579: ,p_description in varchar2 default hr_api.g_varchar2
580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2
581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2
582: ,p_end_date_active in date default hr_api.g_date
583: ,p_attribute_category in varchar2 default hr_api.g_varchar2
584: ,p_attribute1 in varchar2 default hr_api.g_varchar2
585: ,p_attribute2 in varchar2 default hr_api.g_varchar2
586: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 583: ,p_attribute_category in varchar2 default hr_api.g_varchar2

579: ,p_description in varchar2 default hr_api.g_varchar2
580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2
581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2
582: ,p_end_date_active in date default hr_api.g_date
583: ,p_attribute_category in varchar2 default hr_api.g_varchar2
584: ,p_attribute1 in varchar2 default hr_api.g_varchar2
585: ,p_attribute2 in varchar2 default hr_api.g_varchar2
586: ,p_attribute3 in varchar2 default hr_api.g_varchar2
587: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 584: ,p_attribute1 in varchar2 default hr_api.g_varchar2

580: ,p_owc_site_id in varchar2 default hr_api.g_varchar2
581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2
582: ,p_end_date_active in date default hr_api.g_date
583: ,p_attribute_category in varchar2 default hr_api.g_varchar2
584: ,p_attribute1 in varchar2 default hr_api.g_varchar2
585: ,p_attribute2 in varchar2 default hr_api.g_varchar2
586: ,p_attribute3 in varchar2 default hr_api.g_varchar2
587: ,p_attribute4 in varchar2 default hr_api.g_varchar2
588: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 585: ,p_attribute2 in varchar2 default hr_api.g_varchar2

581: ,p_owc_auth_token in varchar2 default hr_api.g_varchar2
582: ,p_end_date_active in date default hr_api.g_date
583: ,p_attribute_category in varchar2 default hr_api.g_varchar2
584: ,p_attribute1 in varchar2 default hr_api.g_varchar2
585: ,p_attribute2 in varchar2 default hr_api.g_varchar2
586: ,p_attribute3 in varchar2 default hr_api.g_varchar2
587: ,p_attribute4 in varchar2 default hr_api.g_varchar2
588: ,p_attribute5 in varchar2 default hr_api.g_varchar2
589: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 586: ,p_attribute3 in varchar2 default hr_api.g_varchar2

582: ,p_end_date_active in date default hr_api.g_date
583: ,p_attribute_category in varchar2 default hr_api.g_varchar2
584: ,p_attribute1 in varchar2 default hr_api.g_varchar2
585: ,p_attribute2 in varchar2 default hr_api.g_varchar2
586: ,p_attribute3 in varchar2 default hr_api.g_varchar2
587: ,p_attribute4 in varchar2 default hr_api.g_varchar2
588: ,p_attribute5 in varchar2 default hr_api.g_varchar2
589: ,p_attribute6 in varchar2 default hr_api.g_varchar2
590: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 587: ,p_attribute4 in varchar2 default hr_api.g_varchar2

583: ,p_attribute_category in varchar2 default hr_api.g_varchar2
584: ,p_attribute1 in varchar2 default hr_api.g_varchar2
585: ,p_attribute2 in varchar2 default hr_api.g_varchar2
586: ,p_attribute3 in varchar2 default hr_api.g_varchar2
587: ,p_attribute4 in varchar2 default hr_api.g_varchar2
588: ,p_attribute5 in varchar2 default hr_api.g_varchar2
589: ,p_attribute6 in varchar2 default hr_api.g_varchar2
590: ,p_attribute7 in varchar2 default hr_api.g_varchar2
591: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 588: ,p_attribute5 in varchar2 default hr_api.g_varchar2

584: ,p_attribute1 in varchar2 default hr_api.g_varchar2
585: ,p_attribute2 in varchar2 default hr_api.g_varchar2
586: ,p_attribute3 in varchar2 default hr_api.g_varchar2
587: ,p_attribute4 in varchar2 default hr_api.g_varchar2
588: ,p_attribute5 in varchar2 default hr_api.g_varchar2
589: ,p_attribute6 in varchar2 default hr_api.g_varchar2
590: ,p_attribute7 in varchar2 default hr_api.g_varchar2
591: ,p_attribute8 in varchar2 default hr_api.g_varchar2
592: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 589: ,p_attribute6 in varchar2 default hr_api.g_varchar2

585: ,p_attribute2 in varchar2 default hr_api.g_varchar2
586: ,p_attribute3 in varchar2 default hr_api.g_varchar2
587: ,p_attribute4 in varchar2 default hr_api.g_varchar2
588: ,p_attribute5 in varchar2 default hr_api.g_varchar2
589: ,p_attribute6 in varchar2 default hr_api.g_varchar2
590: ,p_attribute7 in varchar2 default hr_api.g_varchar2
591: ,p_attribute8 in varchar2 default hr_api.g_varchar2
592: ,p_attribute9 in varchar2 default hr_api.g_varchar2
593: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 590: ,p_attribute7 in varchar2 default hr_api.g_varchar2

586: ,p_attribute3 in varchar2 default hr_api.g_varchar2
587: ,p_attribute4 in varchar2 default hr_api.g_varchar2
588: ,p_attribute5 in varchar2 default hr_api.g_varchar2
589: ,p_attribute6 in varchar2 default hr_api.g_varchar2
590: ,p_attribute7 in varchar2 default hr_api.g_varchar2
591: ,p_attribute8 in varchar2 default hr_api.g_varchar2
592: ,p_attribute9 in varchar2 default hr_api.g_varchar2
593: ,p_attribute10 in varchar2 default hr_api.g_varchar2
594: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 591: ,p_attribute8 in varchar2 default hr_api.g_varchar2

587: ,p_attribute4 in varchar2 default hr_api.g_varchar2
588: ,p_attribute5 in varchar2 default hr_api.g_varchar2
589: ,p_attribute6 in varchar2 default hr_api.g_varchar2
590: ,p_attribute7 in varchar2 default hr_api.g_varchar2
591: ,p_attribute8 in varchar2 default hr_api.g_varchar2
592: ,p_attribute9 in varchar2 default hr_api.g_varchar2
593: ,p_attribute10 in varchar2 default hr_api.g_varchar2
594: ,p_attribute11 in varchar2 default hr_api.g_varchar2
595: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 592: ,p_attribute9 in varchar2 default hr_api.g_varchar2

588: ,p_attribute5 in varchar2 default hr_api.g_varchar2
589: ,p_attribute6 in varchar2 default hr_api.g_varchar2
590: ,p_attribute7 in varchar2 default hr_api.g_varchar2
591: ,p_attribute8 in varchar2 default hr_api.g_varchar2
592: ,p_attribute9 in varchar2 default hr_api.g_varchar2
593: ,p_attribute10 in varchar2 default hr_api.g_varchar2
594: ,p_attribute11 in varchar2 default hr_api.g_varchar2
595: ,p_attribute12 in varchar2 default hr_api.g_varchar2
596: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 593: ,p_attribute10 in varchar2 default hr_api.g_varchar2

589: ,p_attribute6 in varchar2 default hr_api.g_varchar2
590: ,p_attribute7 in varchar2 default hr_api.g_varchar2
591: ,p_attribute8 in varchar2 default hr_api.g_varchar2
592: ,p_attribute9 in varchar2 default hr_api.g_varchar2
593: ,p_attribute10 in varchar2 default hr_api.g_varchar2
594: ,p_attribute11 in varchar2 default hr_api.g_varchar2
595: ,p_attribute12 in varchar2 default hr_api.g_varchar2
596: ,p_attribute13 in varchar2 default hr_api.g_varchar2
597: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 594: ,p_attribute11 in varchar2 default hr_api.g_varchar2

590: ,p_attribute7 in varchar2 default hr_api.g_varchar2
591: ,p_attribute8 in varchar2 default hr_api.g_varchar2
592: ,p_attribute9 in varchar2 default hr_api.g_varchar2
593: ,p_attribute10 in varchar2 default hr_api.g_varchar2
594: ,p_attribute11 in varchar2 default hr_api.g_varchar2
595: ,p_attribute12 in varchar2 default hr_api.g_varchar2
596: ,p_attribute13 in varchar2 default hr_api.g_varchar2
597: ,p_attribute14 in varchar2 default hr_api.g_varchar2
598: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 595: ,p_attribute12 in varchar2 default hr_api.g_varchar2

591: ,p_attribute8 in varchar2 default hr_api.g_varchar2
592: ,p_attribute9 in varchar2 default hr_api.g_varchar2
593: ,p_attribute10 in varchar2 default hr_api.g_varchar2
594: ,p_attribute11 in varchar2 default hr_api.g_varchar2
595: ,p_attribute12 in varchar2 default hr_api.g_varchar2
596: ,p_attribute13 in varchar2 default hr_api.g_varchar2
597: ,p_attribute14 in varchar2 default hr_api.g_varchar2
598: ,p_attribute15 in varchar2 default hr_api.g_varchar2
599: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 596: ,p_attribute13 in varchar2 default hr_api.g_varchar2

592: ,p_attribute9 in varchar2 default hr_api.g_varchar2
593: ,p_attribute10 in varchar2 default hr_api.g_varchar2
594: ,p_attribute11 in varchar2 default hr_api.g_varchar2
595: ,p_attribute12 in varchar2 default hr_api.g_varchar2
596: ,p_attribute13 in varchar2 default hr_api.g_varchar2
597: ,p_attribute14 in varchar2 default hr_api.g_varchar2
598: ,p_attribute15 in varchar2 default hr_api.g_varchar2
599: ,p_attribute16 in varchar2 default hr_api.g_varchar2
600: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 597: ,p_attribute14 in varchar2 default hr_api.g_varchar2

593: ,p_attribute10 in varchar2 default hr_api.g_varchar2
594: ,p_attribute11 in varchar2 default hr_api.g_varchar2
595: ,p_attribute12 in varchar2 default hr_api.g_varchar2
596: ,p_attribute13 in varchar2 default hr_api.g_varchar2
597: ,p_attribute14 in varchar2 default hr_api.g_varchar2
598: ,p_attribute15 in varchar2 default hr_api.g_varchar2
599: ,p_attribute16 in varchar2 default hr_api.g_varchar2
600: ,p_attribute17 in varchar2 default hr_api.g_varchar2
601: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 598: ,p_attribute15 in varchar2 default hr_api.g_varchar2

594: ,p_attribute11 in varchar2 default hr_api.g_varchar2
595: ,p_attribute12 in varchar2 default hr_api.g_varchar2
596: ,p_attribute13 in varchar2 default hr_api.g_varchar2
597: ,p_attribute14 in varchar2 default hr_api.g_varchar2
598: ,p_attribute15 in varchar2 default hr_api.g_varchar2
599: ,p_attribute16 in varchar2 default hr_api.g_varchar2
600: ,p_attribute17 in varchar2 default hr_api.g_varchar2
601: ,p_attribute18 in varchar2 default hr_api.g_varchar2
602: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 599: ,p_attribute16 in varchar2 default hr_api.g_varchar2

595: ,p_attribute12 in varchar2 default hr_api.g_varchar2
596: ,p_attribute13 in varchar2 default hr_api.g_varchar2
597: ,p_attribute14 in varchar2 default hr_api.g_varchar2
598: ,p_attribute15 in varchar2 default hr_api.g_varchar2
599: ,p_attribute16 in varchar2 default hr_api.g_varchar2
600: ,p_attribute17 in varchar2 default hr_api.g_varchar2
601: ,p_attribute18 in varchar2 default hr_api.g_varchar2
602: ,p_attribute19 in varchar2 default hr_api.g_varchar2
603: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 600: ,p_attribute17 in varchar2 default hr_api.g_varchar2

596: ,p_attribute13 in varchar2 default hr_api.g_varchar2
597: ,p_attribute14 in varchar2 default hr_api.g_varchar2
598: ,p_attribute15 in varchar2 default hr_api.g_varchar2
599: ,p_attribute16 in varchar2 default hr_api.g_varchar2
600: ,p_attribute17 in varchar2 default hr_api.g_varchar2
601: ,p_attribute18 in varchar2 default hr_api.g_varchar2
602: ,p_attribute19 in varchar2 default hr_api.g_varchar2
603: ,p_attribute20 in varchar2 default hr_api.g_varchar2
604: ) is

Line 601: ,p_attribute18 in varchar2 default hr_api.g_varchar2

597: ,p_attribute14 in varchar2 default hr_api.g_varchar2
598: ,p_attribute15 in varchar2 default hr_api.g_varchar2
599: ,p_attribute16 in varchar2 default hr_api.g_varchar2
600: ,p_attribute17 in varchar2 default hr_api.g_varchar2
601: ,p_attribute18 in varchar2 default hr_api.g_varchar2
602: ,p_attribute19 in varchar2 default hr_api.g_varchar2
603: ,p_attribute20 in varchar2 default hr_api.g_varchar2
604: ) is
605: --

Line 602: ,p_attribute19 in varchar2 default hr_api.g_varchar2

598: ,p_attribute15 in varchar2 default hr_api.g_varchar2
599: ,p_attribute16 in varchar2 default hr_api.g_varchar2
600: ,p_attribute17 in varchar2 default hr_api.g_varchar2
601: ,p_attribute18 in varchar2 default hr_api.g_varchar2
602: ,p_attribute19 in varchar2 default hr_api.g_varchar2
603: ,p_attribute20 in varchar2 default hr_api.g_varchar2
604: ) is
605: --
606: l_rec ota_cfs_shd.g_rec_type;

Line 603: ,p_attribute20 in varchar2 default hr_api.g_varchar2

599: ,p_attribute16 in varchar2 default hr_api.g_varchar2
600: ,p_attribute17 in varchar2 default hr_api.g_varchar2
601: ,p_attribute18 in varchar2 default hr_api.g_varchar2
602: ,p_attribute19 in varchar2 default hr_api.g_varchar2
603: ,p_attribute20 in varchar2 default hr_api.g_varchar2
604: ) is
605: --
606: l_rec ota_cfs_shd.g_rec_type;
607: l_proc varchar2(72) := g_package||'upd';