APPS.PER_FDL_UPD dependencies on HR_API

Line 105: When hr_api.check_integrity_violated Then

101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
108:
109: per_fdl_shd.constraint_error

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

106: -- A check constraint has been violated
107: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
108:
109: per_fdl_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
114:

Line 111: When hr_api.parent_integrity_violated Then

107: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
108:
109: per_fdl_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
114:
115: per_fdl_shd.constraint_error

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

112: -- Parent integrity has been violated
113: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
114:
115: per_fdl_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: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
120:

Line 117: When hr_api.unique_integrity_violated Then

113: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
114:
115: per_fdl_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: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
120:
121: per_fdl_shd.constraint_error

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

118: -- Unique integrity has been violated
119: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
120:
121: per_fdl_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: per_fdl_shd.g_api_dml := false; -- Unset the api dml status
125:
126: Raise;

Line 319: when hr_api.cannot_find_prog_unit then

315: NULL;
316: --
317: exception
318: --
319: when hr_api.cannot_find_prog_unit then
320: --
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'PER_FND_DOC_LINKS'
323: ,p_hook_type => 'AU');

Line 321: hr_api.cannot_find_prog_unit_error

317: exception
318: --
319: when hr_api.cannot_find_prog_unit then
320: --
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'PER_FND_DOC_LINKS'
323: ,p_hook_type => 'AU');
324: --
325: end;

Line 386: If (p_rec.entity_name = hr_api.g_varchar2) then

382: -- p_rec plsql record structure
383: -- to see if a system default is being used. If a system default
384: -- is being used then we must set to the 'current' argument value.
385: --
386: If (p_rec.entity_name = hr_api.g_varchar2) then
387: p_rec.entity_name :=
388: per_fdl_shd.g_old_rec.entity_name;
389: End If;
390: If (p_rec.sub_entity_name = hr_api.g_varchar2) then

Line 390: If (p_rec.sub_entity_name = hr_api.g_varchar2) then

386: If (p_rec.entity_name = hr_api.g_varchar2) then
387: p_rec.entity_name :=
388: per_fdl_shd.g_old_rec.entity_name;
389: End If;
390: If (p_rec.sub_entity_name = hr_api.g_varchar2) then
391: p_rec.sub_entity_name :=
392: per_fdl_shd.g_old_rec.sub_entity_name;
393: End If;
394: If (p_rec.entity_doc_id = hr_api.g_number) then

Line 394: If (p_rec.entity_doc_id = hr_api.g_number) then

390: If (p_rec.sub_entity_name = hr_api.g_varchar2) then
391: p_rec.sub_entity_name :=
392: per_fdl_shd.g_old_rec.sub_entity_name;
393: End If;
394: If (p_rec.entity_doc_id = hr_api.g_number) then
395: p_rec.entity_doc_id :=
396: per_fdl_shd.g_old_rec.entity_doc_id;
397: End If;
398: If (p_rec.fnd_doc_id = hr_api.g_number) then

Line 398: If (p_rec.fnd_doc_id = hr_api.g_number) then

394: If (p_rec.entity_doc_id = hr_api.g_number) then
395: p_rec.entity_doc_id :=
396: per_fdl_shd.g_old_rec.entity_doc_id;
397: End If;
398: If (p_rec.fnd_doc_id = hr_api.g_number) then
399: p_rec.fnd_doc_id :=
400: per_fdl_shd.g_old_rec.fnd_doc_id;
401: End If;
402: If (p_rec.person_id = hr_api.g_number) then

Line 402: If (p_rec.person_id = hr_api.g_number) then

398: If (p_rec.fnd_doc_id = hr_api.g_number) then
399: p_rec.fnd_doc_id :=
400: per_fdl_shd.g_old_rec.fnd_doc_id;
401: End If;
402: If (p_rec.person_id = hr_api.g_number) then
403: p_rec.person_id :=
404: per_fdl_shd.g_old_rec.person_id;
405: End If;
406: If (p_rec.assignment_id = hr_api.g_number) then

Line 406: If (p_rec.assignment_id = hr_api.g_number) then

402: If (p_rec.person_id = hr_api.g_number) then
403: p_rec.person_id :=
404: per_fdl_shd.g_old_rec.person_id;
405: End If;
406: If (p_rec.assignment_id = hr_api.g_number) then
407: p_rec.assignment_id :=
408: per_fdl_shd.g_old_rec.assignment_id;
409: End If;
410: If (p_rec.application_id = hr_api.g_number) then

Line 410: If (p_rec.application_id = hr_api.g_number) then

406: If (p_rec.assignment_id = hr_api.g_number) then
407: p_rec.assignment_id :=
408: per_fdl_shd.g_old_rec.assignment_id;
409: End If;
410: If (p_rec.application_id = hr_api.g_number) then
411: p_rec.application_id :=
412: per_fdl_shd.g_old_rec.application_id;
413: End If;
414: If (p_rec.doc_upload_date = hr_api.g_date) then

Line 414: If (p_rec.doc_upload_date = hr_api.g_date) then

410: If (p_rec.application_id = hr_api.g_number) then
411: p_rec.application_id :=
412: per_fdl_shd.g_old_rec.application_id;
413: End If;
414: If (p_rec.doc_upload_date = hr_api.g_date) then
415: p_rec.doc_upload_date :=
416: per_fdl_shd.g_old_rec.doc_upload_date;
417: End If;
418: If (p_rec.transaction_type = hr_api.g_varchar2) then

Line 418: If (p_rec.transaction_type = hr_api.g_varchar2) then

414: If (p_rec.doc_upload_date = hr_api.g_date) then
415: p_rec.doc_upload_date :=
416: per_fdl_shd.g_old_rec.doc_upload_date;
417: End If;
418: If (p_rec.transaction_type = hr_api.g_varchar2) then
419: p_rec.transaction_type :=
420: per_fdl_shd.g_old_rec.transaction_type;
421: End If;
422: If (p_rec.transaction_status = hr_api.g_varchar2) then

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

418: If (p_rec.transaction_type = hr_api.g_varchar2) then
419: p_rec.transaction_type :=
420: per_fdl_shd.g_old_rec.transaction_type;
421: End If;
422: If (p_rec.transaction_status = hr_api.g_varchar2) then
423: p_rec.transaction_status :=
424: per_fdl_shd.g_old_rec.transaction_status;
425: End If;
426: If (p_rec.status = hr_api.g_varchar2) then

Line 426: If (p_rec.status = hr_api.g_varchar2) then

422: If (p_rec.transaction_status = hr_api.g_varchar2) then
423: p_rec.transaction_status :=
424: per_fdl_shd.g_old_rec.transaction_status;
425: End If;
426: If (p_rec.status = hr_api.g_varchar2) then
427: p_rec.status :=
428: per_fdl_shd.g_old_rec.status;
429: End If;
430: If (p_rec.fdl_information_category = hr_api.g_varchar2) then

Line 430: If (p_rec.fdl_information_category = hr_api.g_varchar2) then

426: If (p_rec.status = hr_api.g_varchar2) then
427: p_rec.status :=
428: per_fdl_shd.g_old_rec.status;
429: End If;
430: If (p_rec.fdl_information_category = hr_api.g_varchar2) then
431: p_rec.fdl_information_category :=
432: per_fdl_shd.g_old_rec.fdl_information_category;
433: End If;
434: If (p_rec.fdl_information1 = hr_api.g_varchar2) then

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

430: If (p_rec.fdl_information_category = hr_api.g_varchar2) then
431: p_rec.fdl_information_category :=
432: per_fdl_shd.g_old_rec.fdl_information_category;
433: End If;
434: If (p_rec.fdl_information1 = hr_api.g_varchar2) then
435: p_rec.fdl_information1 :=
436: per_fdl_shd.g_old_rec.fdl_information1;
437: End If;
438: If (p_rec.fdl_information2 = hr_api.g_varchar2) then

Line 438: If (p_rec.fdl_information2 = hr_api.g_varchar2) then

434: If (p_rec.fdl_information1 = hr_api.g_varchar2) then
435: p_rec.fdl_information1 :=
436: per_fdl_shd.g_old_rec.fdl_information1;
437: End If;
438: If (p_rec.fdl_information2 = hr_api.g_varchar2) then
439: p_rec.fdl_information2 :=
440: per_fdl_shd.g_old_rec.fdl_information2;
441: End If;
442: If (p_rec.fdl_information3 = hr_api.g_varchar2) then

Line 442: If (p_rec.fdl_information3 = hr_api.g_varchar2) then

438: If (p_rec.fdl_information2 = hr_api.g_varchar2) then
439: p_rec.fdl_information2 :=
440: per_fdl_shd.g_old_rec.fdl_information2;
441: End If;
442: If (p_rec.fdl_information3 = hr_api.g_varchar2) then
443: p_rec.fdl_information3 :=
444: per_fdl_shd.g_old_rec.fdl_information3;
445: End If;
446: If (p_rec.fdl_information4 = hr_api.g_varchar2) then

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

442: If (p_rec.fdl_information3 = hr_api.g_varchar2) then
443: p_rec.fdl_information3 :=
444: per_fdl_shd.g_old_rec.fdl_information3;
445: End If;
446: If (p_rec.fdl_information4 = hr_api.g_varchar2) then
447: p_rec.fdl_information4 :=
448: per_fdl_shd.g_old_rec.fdl_information4;
449: End If;
450: If (p_rec.fdl_information5 = hr_api.g_varchar2) then

Line 450: If (p_rec.fdl_information5 = hr_api.g_varchar2) then

446: If (p_rec.fdl_information4 = hr_api.g_varchar2) then
447: p_rec.fdl_information4 :=
448: per_fdl_shd.g_old_rec.fdl_information4;
449: End If;
450: If (p_rec.fdl_information5 = hr_api.g_varchar2) then
451: p_rec.fdl_information5 :=
452: per_fdl_shd.g_old_rec.fdl_information5;
453: End If;
454: If (p_rec.fdl_information6 = hr_api.g_varchar2) then

Line 454: If (p_rec.fdl_information6 = hr_api.g_varchar2) then

450: If (p_rec.fdl_information5 = hr_api.g_varchar2) then
451: p_rec.fdl_information5 :=
452: per_fdl_shd.g_old_rec.fdl_information5;
453: End If;
454: If (p_rec.fdl_information6 = hr_api.g_varchar2) then
455: p_rec.fdl_information6 :=
456: per_fdl_shd.g_old_rec.fdl_information6;
457: End If;
458: If (p_rec.fdl_information7 = hr_api.g_varchar2) then

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

454: If (p_rec.fdl_information6 = hr_api.g_varchar2) then
455: p_rec.fdl_information6 :=
456: per_fdl_shd.g_old_rec.fdl_information6;
457: End If;
458: If (p_rec.fdl_information7 = hr_api.g_varchar2) then
459: p_rec.fdl_information7 :=
460: per_fdl_shd.g_old_rec.fdl_information7;
461: End If;
462: If (p_rec.fdl_information8 = hr_api.g_varchar2) then

Line 462: If (p_rec.fdl_information8 = hr_api.g_varchar2) then

458: If (p_rec.fdl_information7 = hr_api.g_varchar2) then
459: p_rec.fdl_information7 :=
460: per_fdl_shd.g_old_rec.fdl_information7;
461: End If;
462: If (p_rec.fdl_information8 = hr_api.g_varchar2) then
463: p_rec.fdl_information8 :=
464: per_fdl_shd.g_old_rec.fdl_information8;
465: End If;
466: If (p_rec.fdl_information9 = hr_api.g_varchar2) then

Line 466: If (p_rec.fdl_information9 = hr_api.g_varchar2) then

462: If (p_rec.fdl_information8 = hr_api.g_varchar2) then
463: p_rec.fdl_information8 :=
464: per_fdl_shd.g_old_rec.fdl_information8;
465: End If;
466: If (p_rec.fdl_information9 = hr_api.g_varchar2) then
467: p_rec.fdl_information9 :=
468: per_fdl_shd.g_old_rec.fdl_information9;
469: End If;
470: If (p_rec.fdl_information10 = hr_api.g_varchar2) then

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

466: If (p_rec.fdl_information9 = hr_api.g_varchar2) then
467: p_rec.fdl_information9 :=
468: per_fdl_shd.g_old_rec.fdl_information9;
469: End If;
470: If (p_rec.fdl_information10 = hr_api.g_varchar2) then
471: p_rec.fdl_information10 :=
472: per_fdl_shd.g_old_rec.fdl_information10;
473: End If;
474:

Line 537: ,p_entity_name in varchar2 default hr_api.g_varchar2

533: -- ----------------------------------------------------------------------------
534: Procedure upd
535: (p_fnd_doc_link_id in number
536: ,p_object_version_number in out nocopy number
537: ,p_entity_name in varchar2 default hr_api.g_varchar2
538: ,p_sub_entity_name in varchar2 default hr_api.g_varchar2
539: ,p_person_id in number default hr_api.g_number
540: ,p_doc_upload_date in date default hr_api.g_date
541: ,p_transaction_type in varchar2 default hr_api.g_varchar2

Line 538: ,p_sub_entity_name in varchar2 default hr_api.g_varchar2

534: Procedure upd
535: (p_fnd_doc_link_id in number
536: ,p_object_version_number in out nocopy number
537: ,p_entity_name in varchar2 default hr_api.g_varchar2
538: ,p_sub_entity_name in varchar2 default hr_api.g_varchar2
539: ,p_person_id in number default hr_api.g_number
540: ,p_doc_upload_date in date default hr_api.g_date
541: ,p_transaction_type in varchar2 default hr_api.g_varchar2
542: ,p_transaction_status in varchar2 default hr_api.g_varchar2

Line 539: ,p_person_id in number default hr_api.g_number

535: (p_fnd_doc_link_id in number
536: ,p_object_version_number in out nocopy number
537: ,p_entity_name in varchar2 default hr_api.g_varchar2
538: ,p_sub_entity_name in varchar2 default hr_api.g_varchar2
539: ,p_person_id in number default hr_api.g_number
540: ,p_doc_upload_date in date default hr_api.g_date
541: ,p_transaction_type in varchar2 default hr_api.g_varchar2
542: ,p_transaction_status in varchar2 default hr_api.g_varchar2
543: ,p_status in varchar2 default hr_api.g_varchar2

Line 540: ,p_doc_upload_date in date default hr_api.g_date

536: ,p_object_version_number in out nocopy number
537: ,p_entity_name in varchar2 default hr_api.g_varchar2
538: ,p_sub_entity_name in varchar2 default hr_api.g_varchar2
539: ,p_person_id in number default hr_api.g_number
540: ,p_doc_upload_date in date default hr_api.g_date
541: ,p_transaction_type in varchar2 default hr_api.g_varchar2
542: ,p_transaction_status in varchar2 default hr_api.g_varchar2
543: ,p_status in varchar2 default hr_api.g_varchar2
544: ,p_entity_doc_id in number default hr_api.g_number

Line 541: ,p_transaction_type in varchar2 default hr_api.g_varchar2

537: ,p_entity_name in varchar2 default hr_api.g_varchar2
538: ,p_sub_entity_name in varchar2 default hr_api.g_varchar2
539: ,p_person_id in number default hr_api.g_number
540: ,p_doc_upload_date in date default hr_api.g_date
541: ,p_transaction_type in varchar2 default hr_api.g_varchar2
542: ,p_transaction_status in varchar2 default hr_api.g_varchar2
543: ,p_status in varchar2 default hr_api.g_varchar2
544: ,p_entity_doc_id in number default hr_api.g_number
545: ,p_fnd_doc_id in number default hr_api.g_number

Line 542: ,p_transaction_status in varchar2 default hr_api.g_varchar2

538: ,p_sub_entity_name in varchar2 default hr_api.g_varchar2
539: ,p_person_id in number default hr_api.g_number
540: ,p_doc_upload_date in date default hr_api.g_date
541: ,p_transaction_type in varchar2 default hr_api.g_varchar2
542: ,p_transaction_status in varchar2 default hr_api.g_varchar2
543: ,p_status in varchar2 default hr_api.g_varchar2
544: ,p_entity_doc_id in number default hr_api.g_number
545: ,p_fnd_doc_id in number default hr_api.g_number
546: ,p_assignment_id in number default hr_api.g_number

Line 543: ,p_status in varchar2 default hr_api.g_varchar2

539: ,p_person_id in number default hr_api.g_number
540: ,p_doc_upload_date in date default hr_api.g_date
541: ,p_transaction_type in varchar2 default hr_api.g_varchar2
542: ,p_transaction_status in varchar2 default hr_api.g_varchar2
543: ,p_status in varchar2 default hr_api.g_varchar2
544: ,p_entity_doc_id in number default hr_api.g_number
545: ,p_fnd_doc_id in number default hr_api.g_number
546: ,p_assignment_id in number default hr_api.g_number
547: ,p_application_id in number default hr_api.g_number

Line 544: ,p_entity_doc_id in number default hr_api.g_number

540: ,p_doc_upload_date in date default hr_api.g_date
541: ,p_transaction_type in varchar2 default hr_api.g_varchar2
542: ,p_transaction_status in varchar2 default hr_api.g_varchar2
543: ,p_status in varchar2 default hr_api.g_varchar2
544: ,p_entity_doc_id in number default hr_api.g_number
545: ,p_fnd_doc_id in number default hr_api.g_number
546: ,p_assignment_id in number default hr_api.g_number
547: ,p_application_id in number default hr_api.g_number
548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2

Line 545: ,p_fnd_doc_id in number default hr_api.g_number

541: ,p_transaction_type in varchar2 default hr_api.g_varchar2
542: ,p_transaction_status in varchar2 default hr_api.g_varchar2
543: ,p_status in varchar2 default hr_api.g_varchar2
544: ,p_entity_doc_id in number default hr_api.g_number
545: ,p_fnd_doc_id in number default hr_api.g_number
546: ,p_assignment_id in number default hr_api.g_number
547: ,p_application_id in number default hr_api.g_number
548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2
549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2

Line 546: ,p_assignment_id in number default hr_api.g_number

542: ,p_transaction_status in varchar2 default hr_api.g_varchar2
543: ,p_status in varchar2 default hr_api.g_varchar2
544: ,p_entity_doc_id in number default hr_api.g_number
545: ,p_fnd_doc_id in number default hr_api.g_number
546: ,p_assignment_id in number default hr_api.g_number
547: ,p_application_id in number default hr_api.g_number
548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2
549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2
550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2

Line 547: ,p_application_id in number default hr_api.g_number

543: ,p_status in varchar2 default hr_api.g_varchar2
544: ,p_entity_doc_id in number default hr_api.g_number
545: ,p_fnd_doc_id in number default hr_api.g_number
546: ,p_assignment_id in number default hr_api.g_number
547: ,p_application_id in number default hr_api.g_number
548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2
549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2
550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2
551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2

Line 548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2

544: ,p_entity_doc_id in number default hr_api.g_number
545: ,p_fnd_doc_id in number default hr_api.g_number
546: ,p_assignment_id in number default hr_api.g_number
547: ,p_application_id in number default hr_api.g_number
548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2
549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2
550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2
551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2
552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2

Line 549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2

545: ,p_fnd_doc_id in number default hr_api.g_number
546: ,p_assignment_id in number default hr_api.g_number
547: ,p_application_id in number default hr_api.g_number
548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2
549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2
550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2
551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2
552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2
553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2

Line 550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2

546: ,p_assignment_id in number default hr_api.g_number
547: ,p_application_id in number default hr_api.g_number
548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2
549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2
550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2
551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2
552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2
553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2
554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2

Line 551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2

547: ,p_application_id in number default hr_api.g_number
548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2
549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2
550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2
551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2
552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2
553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2
554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2
555: ,p_fdl_information7 in varchar2 default hr_api.g_varchar2

Line 552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2

548: ,p_fdl_information_category in varchar2 default hr_api.g_varchar2
549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2
550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2
551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2
552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2
553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2
554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2
555: ,p_fdl_information7 in varchar2 default hr_api.g_varchar2
556: ,p_fdl_information8 in varchar2 default hr_api.g_varchar2

Line 553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2

549: ,p_fdl_information1 in varchar2 default hr_api.g_varchar2
550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2
551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2
552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2
553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2
554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2
555: ,p_fdl_information7 in varchar2 default hr_api.g_varchar2
556: ,p_fdl_information8 in varchar2 default hr_api.g_varchar2
557: ,p_fdl_information9 in varchar2 default hr_api.g_varchar2

Line 554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2

550: ,p_fdl_information2 in varchar2 default hr_api.g_varchar2
551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2
552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2
553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2
554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2
555: ,p_fdl_information7 in varchar2 default hr_api.g_varchar2
556: ,p_fdl_information8 in varchar2 default hr_api.g_varchar2
557: ,p_fdl_information9 in varchar2 default hr_api.g_varchar2
558: ,p_fdl_information10 in varchar2 default hr_api.g_varchar2

Line 555: ,p_fdl_information7 in varchar2 default hr_api.g_varchar2

551: ,p_fdl_information3 in varchar2 default hr_api.g_varchar2
552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2
553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2
554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2
555: ,p_fdl_information7 in varchar2 default hr_api.g_varchar2
556: ,p_fdl_information8 in varchar2 default hr_api.g_varchar2
557: ,p_fdl_information9 in varchar2 default hr_api.g_varchar2
558: ,p_fdl_information10 in varchar2 default hr_api.g_varchar2
559: ) is

Line 556: ,p_fdl_information8 in varchar2 default hr_api.g_varchar2

552: ,p_fdl_information4 in varchar2 default hr_api.g_varchar2
553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2
554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2
555: ,p_fdl_information7 in varchar2 default hr_api.g_varchar2
556: ,p_fdl_information8 in varchar2 default hr_api.g_varchar2
557: ,p_fdl_information9 in varchar2 default hr_api.g_varchar2
558: ,p_fdl_information10 in varchar2 default hr_api.g_varchar2
559: ) is
560: --

Line 557: ,p_fdl_information9 in varchar2 default hr_api.g_varchar2

553: ,p_fdl_information5 in varchar2 default hr_api.g_varchar2
554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2
555: ,p_fdl_information7 in varchar2 default hr_api.g_varchar2
556: ,p_fdl_information8 in varchar2 default hr_api.g_varchar2
557: ,p_fdl_information9 in varchar2 default hr_api.g_varchar2
558: ,p_fdl_information10 in varchar2 default hr_api.g_varchar2
559: ) is
560: --
561: l_rec per_fdl_shd.g_rec_type;

Line 558: ,p_fdl_information10 in varchar2 default hr_api.g_varchar2

554: ,p_fdl_information6 in varchar2 default hr_api.g_varchar2
555: ,p_fdl_information7 in varchar2 default hr_api.g_varchar2
556: ,p_fdl_information8 in varchar2 default hr_api.g_varchar2
557: ,p_fdl_information9 in varchar2 default hr_api.g_varchar2
558: ,p_fdl_information10 in varchar2 default hr_api.g_varchar2
559: ) is
560: --
561: l_rec per_fdl_shd.g_rec_type;
562: l_proc varchar2(72) := g_package||'upd';