eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PROCESS_PHONE_NUMBERS_SS dependencies on HR_API

Line 64: , p_contact_relationship_id in number default hr_api.g_number

60: , p_attribute28 in varchar2 default null
61: , p_attribute29 in varchar2 default null
62: , p_attribute30 in varchar2 default null
63: , p_error_message out nocopy varchar2
64: , p_contact_relationship_id in number default hr_api.g_number
65: )
66: as
67: l_transaction_id number default null;
68: l_transaction_step_id number default null;

Line 424: , p_attribute_category VARCHAR2 default hr_api.g_varchar2

420: -- Login person id is say employee who is adding the phones to his contact.
421: --
422: , p_login_person_id NUMBER default null
423: , p_business_group_id number default null
424: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
425: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
426: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
427: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2

Line 425: , p_attribute1 VARCHAR2 default hr_api.g_varchar2

421: --
422: , p_login_person_id NUMBER default null
423: , p_business_group_id number default null
424: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
425: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
426: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
427: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2

Line 426: , p_attribute2 VARCHAR2 default hr_api.g_varchar2

422: , p_login_person_id NUMBER default null
423: , p_business_group_id number default null
424: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
425: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
426: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
427: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2

Line 427: , p_attribute3 VARCHAR2 default hr_api.g_varchar2

423: , p_business_group_id number default null
424: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
425: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
426: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
427: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2

Line 428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2

424: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
425: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
426: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
427: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2

Line 429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2

425: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
426: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
427: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2

Line 430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2

426: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
427: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2

Line 431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2

427: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2

Line 432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2

428: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2

Line 433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2

429: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2

Line 434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2

430: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2

Line 435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2

431: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2

Line 436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2

432: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2

Line 437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2

433: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2

Line 438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2

434: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2

Line 439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2

435: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2

Line 440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2

436: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2

Line 441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2

437: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2

Line 442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2

438: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2

Line 443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2

439: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2

Line 444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2

440: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2

Line 445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2

441: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2

Line 446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2

442: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2

Line 447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2

443: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
451: , p_attribute27 VARCHAR2 default hr_api.g_varchar2

Line 448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2

444: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
451: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
452: , p_attribute28 VARCHAR2 default hr_api.g_varchar2

Line 449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2

445: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
451: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
452: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
453: , p_attribute29 VARCHAR2 default hr_api.g_varchar2

Line 450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2

446: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
451: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
452: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
453: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
454: , p_attribute30 VARCHAR2 default hr_api.g_varchar2

Line 451: , p_attribute27 VARCHAR2 default hr_api.g_varchar2

447: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
451: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
452: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
453: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
454: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
455: -- StartRegistration

Line 452: , p_attribute28 VARCHAR2 default hr_api.g_varchar2

448: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
451: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
452: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
453: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
454: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
455: -- StartRegistration
456: , p_per_or_contact varchar2 default null

Line 453: , p_attribute29 VARCHAR2 default hr_api.g_varchar2

449: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
451: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
452: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
453: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
454: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
455: -- StartRegistration
456: , p_per_or_contact varchar2 default null
457: , p_validate number

Line 454: , p_attribute30 VARCHAR2 default hr_api.g_varchar2

450: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
451: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
452: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
453: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
454: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
455: -- StartRegistration
456: , p_per_or_contact varchar2 default null
457: , p_validate number
458: , p_effective_date date

Line 467: , p_contact_relationship_id in number default hr_api.g_number

463: , p_activity_id in number
464: , p_phone_type_meaning in varchar2
465: , p_save_mode in varchar2 default null
466: , p_error_message out nocopy varchar2
467: , p_contact_relationship_id in number default hr_api.g_number
468: )
469: as
470:
471: l_transaction_id number default null;

Line 776: , p_login_person_id NUMBER default hr_api.g_number

772: -- The transaction steps have to be created by the login personid.
773: -- In case of adding phones for contacts parent_is is contact_person_id.
774: -- Login person id is say employee who is adding the phones to his contact.
775: --
776: , p_login_person_id NUMBER default hr_api.g_number
777: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
778: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
779: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2

Line 777: , p_attribute_category VARCHAR2 default hr_api.g_varchar2

773: -- In case of adding phones for contacts parent_is is contact_person_id.
774: -- Login person id is say employee who is adding the phones to his contact.
775: --
776: , p_login_person_id NUMBER default hr_api.g_number
777: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
778: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
779: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2

Line 778: , p_attribute1 VARCHAR2 default hr_api.g_varchar2

774: -- Login person id is say employee who is adding the phones to his contact.
775: --
776: , p_login_person_id NUMBER default hr_api.g_number
777: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
778: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
779: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2

Line 779: , p_attribute2 VARCHAR2 default hr_api.g_varchar2

775: --
776: , p_login_person_id NUMBER default hr_api.g_number
777: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
778: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
779: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2

Line 780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2

776: , p_login_person_id NUMBER default hr_api.g_number
777: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
778: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
779: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2

Line 781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2

777: , p_attribute_category VARCHAR2 default hr_api.g_varchar2
778: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
779: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2

Line 782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2

778: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
779: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2

Line 783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2

779: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2

Line 784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2

780: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2

Line 785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2

781: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2

Line 786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2

782: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2

Line 787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2

783: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2

Line 788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2

784: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2

Line 789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2

785: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2

Line 790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2

786: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2

Line 791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2

787: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2

Line 792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2

788: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2

Line 793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2

789: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2

Line 794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2

790: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2

Line 795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2

791: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2

Line 796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2

792: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2

Line 797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2

793: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2

Line 798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2

794: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2

Line 799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2

795: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2

Line 800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2

796: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
804: , p_attribute27 VARCHAR2 default hr_api.g_varchar2

Line 801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2

797: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
804: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
805: , p_attribute28 VARCHAR2 default hr_api.g_varchar2

Line 802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2

798: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
804: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
805: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
806: , p_attribute29 VARCHAR2 default hr_api.g_varchar2

Line 803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2

799: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
804: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
805: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
806: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
807: , p_attribute30 VARCHAR2 default hr_api.g_varchar2

Line 804: , p_attribute27 VARCHAR2 default hr_api.g_varchar2

800: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
804: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
805: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
806: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
807: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
808: , p_object_version_number in out nocopy NUMBER

Line 805: , p_attribute28 VARCHAR2 default hr_api.g_varchar2

801: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
804: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
805: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
806: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
807: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
808: , p_object_version_number in out nocopy NUMBER
809: , p_validate number

Line 806: , p_attribute29 VARCHAR2 default hr_api.g_varchar2

802: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
804: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
805: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
806: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
807: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
808: , p_object_version_number in out nocopy NUMBER
809: , p_validate number
810: , p_effective_date date

Line 807: , p_attribute30 VARCHAR2 default hr_api.g_varchar2

803: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
804: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
805: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
806: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
807: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
808: , p_object_version_number in out nocopy NUMBER
809: , p_validate number
810: , p_effective_date date
811: , p_parent_id NUMBER

Line 818: , p_contact_relationship_id in number default hr_api.g_number

814: , p_activity_id in number
815: , p_phone_type_meaning in varchar2
816: , p_save_mode in varchar2 default null
817: , p_error_message out nocopy varchar2
818: , p_contact_relationship_id in number default hr_api.g_number
819: )
820: as
821:
822: l_transaction_id number default null;

Line 1015: , p_login_person_id NUMBER default hr_api.g_number

1011: -- The transaction steps have to be created by the login personid.
1012: -- In case of adding phones for contacts parent_is is contact_person_id.
1013: -- Login person id is say employee who is adding the phones to his contact.
1014: --
1015: , p_login_person_id NUMBER default hr_api.g_number
1016: , p_item_type in varchar2
1017: , p_item_key in varchar2
1018: , p_activity_id in number
1019: , p_phone_type_meaning in varchar2

Line 1147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2

1143: , p_phone_number VARCHAR2
1144: , p_parent_id NUMBER
1145: , p_parent_table VARCHAR2
1146: , p_attribute_category VARCHAR2
1147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
1148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
1149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
1150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2

Line 1148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2

1144: , p_parent_id NUMBER
1145: , p_parent_table VARCHAR2
1146: , p_attribute_category VARCHAR2
1147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
1148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
1149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
1150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2

Line 1149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2

1145: , p_parent_table VARCHAR2
1146: , p_attribute_category VARCHAR2
1147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
1148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
1149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
1150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2

Line 1150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2

1146: , p_attribute_category VARCHAR2
1147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
1148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
1149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
1150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2

Line 1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2

1147: , p_attribute1 VARCHAR2 default hr_api.g_varchar2
1148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
1149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
1150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2

Line 1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2

1148: , p_attribute2 VARCHAR2 default hr_api.g_varchar2
1149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
1150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2

Line 1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2

1149: , p_attribute3 VARCHAR2 default hr_api.g_varchar2
1150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2

Line 1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2

1150: , p_attribute4 VARCHAR2 default hr_api.g_varchar2
1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2

Line 1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2

1151: , p_attribute5 VARCHAR2 default hr_api.g_varchar2
1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2

Line 1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2

1152: , p_attribute6 VARCHAR2 default hr_api.g_varchar2
1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2

Line 1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2

1153: , p_attribute7 VARCHAR2 default hr_api.g_varchar2
1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2

Line 1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2

1154: , p_attribute8 VARCHAR2 default hr_api.g_varchar2
1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2

Line 1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2

1155: , p_attribute9 VARCHAR2 default hr_api.g_varchar2
1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2

Line 1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2

1156: , p_attribute10 VARCHAR2 default hr_api.g_varchar2
1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2

Line 1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2

1157: , p_attribute11 VARCHAR2 default hr_api.g_varchar2
1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2

Line 1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2

1158: , p_attribute12 VARCHAR2 default hr_api.g_varchar2
1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2

Line 1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2

1159: , p_attribute13 VARCHAR2 default hr_api.g_varchar2
1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2

Line 1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2

1160: , p_attribute14 VARCHAR2 default hr_api.g_varchar2
1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2

Line 1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2

1161: , p_attribute15 VARCHAR2 default hr_api.g_varchar2
1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2

Line 1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2

1162: , p_attribute16 VARCHAR2 default hr_api.g_varchar2
1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2

Line 1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2

1163: , p_attribute17 VARCHAR2 default hr_api.g_varchar2
1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2

Line 1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2

1164: , p_attribute18 VARCHAR2 default hr_api.g_varchar2
1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2

Line 1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2

1165: , p_attribute19 VARCHAR2 default hr_api.g_varchar2
1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
1173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2

Line 1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2

1166: , p_attribute20 VARCHAR2 default hr_api.g_varchar2
1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
1173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
1174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2

Line 1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2

1167: , p_attribute21 VARCHAR2 default hr_api.g_varchar2
1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
1173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
1174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
1175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2

Line 1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2

1168: , p_attribute22 VARCHAR2 default hr_api.g_varchar2
1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
1173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
1174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
1175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
1176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2

Line 1173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2

1169: , p_attribute23 VARCHAR2 default hr_api.g_varchar2
1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
1173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
1174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
1175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
1176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
1177: , p_validate number

Line 1174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2

1170: , p_attribute24 VARCHAR2 default hr_api.g_varchar2
1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
1173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
1174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
1175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
1176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
1177: , p_validate number
1178: , p_effective_date date

Line 1175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2

1171: , p_attribute25 VARCHAR2 default hr_api.g_varchar2
1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
1173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
1174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
1175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
1176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
1177: , p_validate number
1178: , p_effective_date date
1179: , p_item_type in varchar2

Line 1176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2

1172: , p_attribute26 VARCHAR2 default hr_api.g_varchar2
1173: , p_attribute27 VARCHAR2 default hr_api.g_varchar2
1174: , p_attribute28 VARCHAR2 default hr_api.g_varchar2
1175: , p_attribute29 VARCHAR2 default hr_api.g_varchar2
1176: , p_attribute30 VARCHAR2 default hr_api.g_varchar2
1177: , p_validate number
1178: , p_effective_date date
1179: , p_item_type in varchar2
1180: , p_item_key in varchar2

Line 1259: from hr_api_transaction_values hatv

1255: -- Cursor to detect phone type transaction data.
1256: cursor csr_hatv(cv_transaction_step_id in number,
1257: cv_name in varchar2) is
1258: select hatv.number_value
1259: from hr_api_transaction_values hatv
1260: where hatv.transaction_step_id = cv_transaction_step_id
1261: and hatv.name = cv_name;
1262: --
1263: l_trans_step_id number default null;

Line 1447: from hr_api_transaction_values hatv

1443: -- Cursor to detect phone type transaction data.
1444: cursor csr_hatv(cv_transaction_step_id in number,
1445: cv_name in varchar2) is
1446: select hatv.number_value
1447: from hr_api_transaction_values hatv
1448: where hatv.transaction_step_id = cv_transaction_step_id
1449: and hatv.name = cv_name;
1450: --
1451: l_trans_step_id number default null;

Line 1687: from hr_api_transaction_values hatv

1683: -- Cursor to detect phone type transaction data.
1684: cursor csr_hatv(cv_transaction_step_id in number,
1685: cv_name in varchar2) is
1686: select hatv.number_value
1687: from hr_api_transaction_values hatv
1688: where hatv.transaction_step_id = cv_transaction_step_id
1689: and hatv.name = cv_name;
1690: --
1691: l_trans_step_id number default null;

Line 1947: hr_api_transaction_steps.object_version_number%type;

1943: l_effective_date date;
1944: l_person_id per_all_people_f.person_id%TYPE;
1945: l_per_or_contact varchar2(30);
1946: l_trs_object_version_number
1947: hr_api_transaction_steps.object_version_number%type;
1948: l_transaction_step_id
1949: hr_api_transaction_steps.transaction_step_id%type;
1950: l_check_for_sfl varchar2(10);
1951: l_sfl_g_contact_step_id NUMBER;

Line 1949: hr_api_transaction_steps.transaction_step_id%type;

1945: l_per_or_contact varchar2(30);
1946: l_trs_object_version_number
1947: hr_api_transaction_steps.object_version_number%type;
1948: l_transaction_step_id
1949: hr_api_transaction_steps.transaction_step_id%type;
1950: l_check_for_sfl varchar2(10);
1951: l_sfl_g_contact_step_id NUMBER;
1952: l_proc varchar2(72) := g_package||'process_api';
1953: