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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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;
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;
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;
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;
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: