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_KIOSK_ADDRESS_API dependencies on HR_API

Line 84: hr_api.mandatory_arg_error

80: --
81: -- Check that p_person_id, p_date_from are not null as they are used in the
82: -- cursor.
83: --
84: hr_api.mandatory_arg_error
85: (p_api_name => l_proc,
86: p_argument => 'person_id',
87: p_argument_value => p_person_id);
88: --

Line 89: hr_api.mandatory_arg_error

85: (p_api_name => l_proc,
86: p_argument => 'person_id',
87: p_argument_value => p_person_id);
88: --
89: hr_api.mandatory_arg_error
90: (p_api_name => l_proc,
91: p_argument => 'date_from',
92: p_argument_value => p_date_from);
93: --

Line 169: raise hr_api.validate_enabled;

165: --
166: -- When in validation only mode raise the Validate_Enabled exception
167: --
168: if p_validate then
169: raise hr_api.validate_enabled;
170: end if;
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 11);
173: exception

Line 174: when hr_api.validate_enabled then

170: end if;
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 11);
173: exception
174: when hr_api.validate_enabled then
175: --
176: -- As the Validate_Enabled exception has been raised
177: -- we must rollback to the savepoint
178: --

Line 404: ,p_date_from in date default hr_api.g_date

400: (p_validate in boolean default false
401: ,p_effective_date in date
402: ,p_address_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_date_from in date default hr_api.g_date
405: ,p_date_to in date default hr_api.g_date
406: ,p_address_type in varchar2 default hr_api.g_varchar2
407: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
408: ,p_address_line1 in varchar2 default hr_api.g_varchar2

Line 405: ,p_date_to in date default hr_api.g_date

401: ,p_effective_date in date
402: ,p_address_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_date_from in date default hr_api.g_date
405: ,p_date_to in date default hr_api.g_date
406: ,p_address_type in varchar2 default hr_api.g_varchar2
407: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
408: ,p_address_line1 in varchar2 default hr_api.g_varchar2
409: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 406: ,p_address_type in varchar2 default hr_api.g_varchar2

402: ,p_address_id in number
403: ,p_object_version_number in out nocopy number
404: ,p_date_from in date default hr_api.g_date
405: ,p_date_to in date default hr_api.g_date
406: ,p_address_type in varchar2 default hr_api.g_varchar2
407: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
408: ,p_address_line1 in varchar2 default hr_api.g_varchar2
409: ,p_address_line2 in varchar2 default hr_api.g_varchar2
410: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 407: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792

403: ,p_object_version_number in out nocopy number
404: ,p_date_from in date default hr_api.g_date
405: ,p_date_to in date default hr_api.g_date
406: ,p_address_type in varchar2 default hr_api.g_varchar2
407: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
408: ,p_address_line1 in varchar2 default hr_api.g_varchar2
409: ,p_address_line2 in varchar2 default hr_api.g_varchar2
410: ,p_address_line3 in varchar2 default hr_api.g_varchar2
411: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 408: ,p_address_line1 in varchar2 default hr_api.g_varchar2

404: ,p_date_from in date default hr_api.g_date
405: ,p_date_to in date default hr_api.g_date
406: ,p_address_type in varchar2 default hr_api.g_varchar2
407: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
408: ,p_address_line1 in varchar2 default hr_api.g_varchar2
409: ,p_address_line2 in varchar2 default hr_api.g_varchar2
410: ,p_address_line3 in varchar2 default hr_api.g_varchar2
411: ,p_town_or_city in varchar2 default hr_api.g_varchar2
412: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 409: ,p_address_line2 in varchar2 default hr_api.g_varchar2

405: ,p_date_to in date default hr_api.g_date
406: ,p_address_type in varchar2 default hr_api.g_varchar2
407: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
408: ,p_address_line1 in varchar2 default hr_api.g_varchar2
409: ,p_address_line2 in varchar2 default hr_api.g_varchar2
410: ,p_address_line3 in varchar2 default hr_api.g_varchar2
411: ,p_town_or_city in varchar2 default hr_api.g_varchar2
412: ,p_region_1 in varchar2 default hr_api.g_varchar2
413: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 410: ,p_address_line3 in varchar2 default hr_api.g_varchar2

406: ,p_address_type in varchar2 default hr_api.g_varchar2
407: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
408: ,p_address_line1 in varchar2 default hr_api.g_varchar2
409: ,p_address_line2 in varchar2 default hr_api.g_varchar2
410: ,p_address_line3 in varchar2 default hr_api.g_varchar2
411: ,p_town_or_city in varchar2 default hr_api.g_varchar2
412: ,p_region_1 in varchar2 default hr_api.g_varchar2
413: ,p_region_2 in varchar2 default hr_api.g_varchar2
414: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 411: ,p_town_or_city in varchar2 default hr_api.g_varchar2

407: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
408: ,p_address_line1 in varchar2 default hr_api.g_varchar2
409: ,p_address_line2 in varchar2 default hr_api.g_varchar2
410: ,p_address_line3 in varchar2 default hr_api.g_varchar2
411: ,p_town_or_city in varchar2 default hr_api.g_varchar2
412: ,p_region_1 in varchar2 default hr_api.g_varchar2
413: ,p_region_2 in varchar2 default hr_api.g_varchar2
414: ,p_region_3 in varchar2 default hr_api.g_varchar2
415: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 412: ,p_region_1 in varchar2 default hr_api.g_varchar2

408: ,p_address_line1 in varchar2 default hr_api.g_varchar2
409: ,p_address_line2 in varchar2 default hr_api.g_varchar2
410: ,p_address_line3 in varchar2 default hr_api.g_varchar2
411: ,p_town_or_city in varchar2 default hr_api.g_varchar2
412: ,p_region_1 in varchar2 default hr_api.g_varchar2
413: ,p_region_2 in varchar2 default hr_api.g_varchar2
414: ,p_region_3 in varchar2 default hr_api.g_varchar2
415: ,p_postal_code in varchar2 default hr_api.g_varchar2
416: ,p_country in varchar2 default hr_api.g_varchar2

Line 413: ,p_region_2 in varchar2 default hr_api.g_varchar2

409: ,p_address_line2 in varchar2 default hr_api.g_varchar2
410: ,p_address_line3 in varchar2 default hr_api.g_varchar2
411: ,p_town_or_city in varchar2 default hr_api.g_varchar2
412: ,p_region_1 in varchar2 default hr_api.g_varchar2
413: ,p_region_2 in varchar2 default hr_api.g_varchar2
414: ,p_region_3 in varchar2 default hr_api.g_varchar2
415: ,p_postal_code in varchar2 default hr_api.g_varchar2
416: ,p_country in varchar2 default hr_api.g_varchar2
417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 414: ,p_region_3 in varchar2 default hr_api.g_varchar2

410: ,p_address_line3 in varchar2 default hr_api.g_varchar2
411: ,p_town_or_city in varchar2 default hr_api.g_varchar2
412: ,p_region_1 in varchar2 default hr_api.g_varchar2
413: ,p_region_2 in varchar2 default hr_api.g_varchar2
414: ,p_region_3 in varchar2 default hr_api.g_varchar2
415: ,p_postal_code in varchar2 default hr_api.g_varchar2
416: ,p_country in varchar2 default hr_api.g_varchar2
417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 415: ,p_postal_code in varchar2 default hr_api.g_varchar2

411: ,p_town_or_city in varchar2 default hr_api.g_varchar2
412: ,p_region_1 in varchar2 default hr_api.g_varchar2
413: ,p_region_2 in varchar2 default hr_api.g_varchar2
414: ,p_region_3 in varchar2 default hr_api.g_varchar2
415: ,p_postal_code in varchar2 default hr_api.g_varchar2
416: ,p_country in varchar2 default hr_api.g_varchar2
417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 416: ,p_country in varchar2 default hr_api.g_varchar2

412: ,p_region_1 in varchar2 default hr_api.g_varchar2
413: ,p_region_2 in varchar2 default hr_api.g_varchar2
414: ,p_region_3 in varchar2 default hr_api.g_varchar2
415: ,p_postal_code in varchar2 default hr_api.g_varchar2
416: ,p_country in varchar2 default hr_api.g_varchar2
417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

413: ,p_region_2 in varchar2 default hr_api.g_varchar2
414: ,p_region_3 in varchar2 default hr_api.g_varchar2
415: ,p_postal_code in varchar2 default hr_api.g_varchar2
416: ,p_country in varchar2 default hr_api.g_varchar2
417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

414: ,p_region_3 in varchar2 default hr_api.g_varchar2
415: ,p_postal_code in varchar2 default hr_api.g_varchar2
416: ,p_country in varchar2 default hr_api.g_varchar2
417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

415: ,p_postal_code in varchar2 default hr_api.g_varchar2
416: ,p_country in varchar2 default hr_api.g_varchar2
417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

416: ,p_country in varchar2 default hr_api.g_varchar2
417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

417: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

418: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

419: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

420: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

421: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

422: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

423: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

424: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

425: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

426: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

427: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

428: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

429: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
437: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

430: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
437: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
438: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

431: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
437: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
438: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
439: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

432: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
437: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
438: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
439: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
440: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 437: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

433: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
437: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
438: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
439: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
440: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
441: ) is

Line 438: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

434: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
437: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
438: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
439: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
440: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
441: ) is
442: --

Line 439: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

435: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
437: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
438: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
439: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
440: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
441: ) is
442: --
443: -- Declare cursors and local variables

Line 440: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

436: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
437: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
438: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
439: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
440: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
441: ) is
442: --
443: -- Declare cursors and local variables
444: --

Line 511: raise hr_api.validate_enabled;

507: --
508: -- When in validation only mode raise the Validate_Enabled exception
509: --
510: if p_validate then
511: raise hr_api.validate_enabled;
512: end if;
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 11);
515: exception

Line 516: when hr_api.validate_enabled then

512: end if;
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 11);
515: exception
516: when hr_api.validate_enabled then
517: --
518: -- As the Validate_Enabled exception has been raised
519: -- we must rollback to the savepoint
520: --

Line 539: ,p_date_from in date default hr_api.g_date

535: (p_validate in boolean default false
536: ,p_effective_date in date
537: ,p_address_id in number
538: ,p_object_version_number in out nocopy number
539: ,p_date_from in date default hr_api.g_date
540: ,p_date_to in date default hr_api.g_date
541: ,p_address_type in varchar2 default hr_api.g_varchar2
542: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
543: ,p_address_line1 in varchar2 default hr_api.g_varchar2

Line 540: ,p_date_to in date default hr_api.g_date

536: ,p_effective_date in date
537: ,p_address_id in number
538: ,p_object_version_number in out nocopy number
539: ,p_date_from in date default hr_api.g_date
540: ,p_date_to in date default hr_api.g_date
541: ,p_address_type in varchar2 default hr_api.g_varchar2
542: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
543: ,p_address_line1 in varchar2 default hr_api.g_varchar2
544: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 541: ,p_address_type in varchar2 default hr_api.g_varchar2

537: ,p_address_id in number
538: ,p_object_version_number in out nocopy number
539: ,p_date_from in date default hr_api.g_date
540: ,p_date_to in date default hr_api.g_date
541: ,p_address_type in varchar2 default hr_api.g_varchar2
542: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
543: ,p_address_line1 in varchar2 default hr_api.g_varchar2
544: ,p_address_line2 in varchar2 default hr_api.g_varchar2
545: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 542: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792

538: ,p_object_version_number in out nocopy number
539: ,p_date_from in date default hr_api.g_date
540: ,p_date_to in date default hr_api.g_date
541: ,p_address_type in varchar2 default hr_api.g_varchar2
542: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
543: ,p_address_line1 in varchar2 default hr_api.g_varchar2
544: ,p_address_line2 in varchar2 default hr_api.g_varchar2
545: ,p_address_line3 in varchar2 default hr_api.g_varchar2
546: ,p_town in varchar2 default hr_api.g_varchar2

Line 543: ,p_address_line1 in varchar2 default hr_api.g_varchar2

539: ,p_date_from in date default hr_api.g_date
540: ,p_date_to in date default hr_api.g_date
541: ,p_address_type in varchar2 default hr_api.g_varchar2
542: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
543: ,p_address_line1 in varchar2 default hr_api.g_varchar2
544: ,p_address_line2 in varchar2 default hr_api.g_varchar2
545: ,p_address_line3 in varchar2 default hr_api.g_varchar2
546: ,p_town in varchar2 default hr_api.g_varchar2
547: ,p_county in varchar2 default hr_api.g_varchar2

Line 544: ,p_address_line2 in varchar2 default hr_api.g_varchar2

540: ,p_date_to in date default hr_api.g_date
541: ,p_address_type in varchar2 default hr_api.g_varchar2
542: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
543: ,p_address_line1 in varchar2 default hr_api.g_varchar2
544: ,p_address_line2 in varchar2 default hr_api.g_varchar2
545: ,p_address_line3 in varchar2 default hr_api.g_varchar2
546: ,p_town in varchar2 default hr_api.g_varchar2
547: ,p_county in varchar2 default hr_api.g_varchar2
548: ,p_postcode in varchar2 default hr_api.g_varchar2

Line 545: ,p_address_line3 in varchar2 default hr_api.g_varchar2

541: ,p_address_type in varchar2 default hr_api.g_varchar2
542: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
543: ,p_address_line1 in varchar2 default hr_api.g_varchar2
544: ,p_address_line2 in varchar2 default hr_api.g_varchar2
545: ,p_address_line3 in varchar2 default hr_api.g_varchar2
546: ,p_town in varchar2 default hr_api.g_varchar2
547: ,p_county in varchar2 default hr_api.g_varchar2
548: ,p_postcode in varchar2 default hr_api.g_varchar2
549: ,p_country in varchar2 default hr_api.g_varchar2

Line 546: ,p_town in varchar2 default hr_api.g_varchar2

542: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
543: ,p_address_line1 in varchar2 default hr_api.g_varchar2
544: ,p_address_line2 in varchar2 default hr_api.g_varchar2
545: ,p_address_line3 in varchar2 default hr_api.g_varchar2
546: ,p_town in varchar2 default hr_api.g_varchar2
547: ,p_county in varchar2 default hr_api.g_varchar2
548: ,p_postcode in varchar2 default hr_api.g_varchar2
549: ,p_country in varchar2 default hr_api.g_varchar2
550: ,p_telephone_number in varchar2 default hr_api.g_varchar2

Line 547: ,p_county in varchar2 default hr_api.g_varchar2

543: ,p_address_line1 in varchar2 default hr_api.g_varchar2
544: ,p_address_line2 in varchar2 default hr_api.g_varchar2
545: ,p_address_line3 in varchar2 default hr_api.g_varchar2
546: ,p_town in varchar2 default hr_api.g_varchar2
547: ,p_county in varchar2 default hr_api.g_varchar2
548: ,p_postcode in varchar2 default hr_api.g_varchar2
549: ,p_country in varchar2 default hr_api.g_varchar2
550: ,p_telephone_number in varchar2 default hr_api.g_varchar2
551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 548: ,p_postcode in varchar2 default hr_api.g_varchar2

544: ,p_address_line2 in varchar2 default hr_api.g_varchar2
545: ,p_address_line3 in varchar2 default hr_api.g_varchar2
546: ,p_town in varchar2 default hr_api.g_varchar2
547: ,p_county in varchar2 default hr_api.g_varchar2
548: ,p_postcode in varchar2 default hr_api.g_varchar2
549: ,p_country in varchar2 default hr_api.g_varchar2
550: ,p_telephone_number in varchar2 default hr_api.g_varchar2
551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 549: ,p_country in varchar2 default hr_api.g_varchar2

545: ,p_address_line3 in varchar2 default hr_api.g_varchar2
546: ,p_town in varchar2 default hr_api.g_varchar2
547: ,p_county in varchar2 default hr_api.g_varchar2
548: ,p_postcode in varchar2 default hr_api.g_varchar2
549: ,p_country in varchar2 default hr_api.g_varchar2
550: ,p_telephone_number in varchar2 default hr_api.g_varchar2
551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 550: ,p_telephone_number in varchar2 default hr_api.g_varchar2

546: ,p_town in varchar2 default hr_api.g_varchar2
547: ,p_county in varchar2 default hr_api.g_varchar2
548: ,p_postcode in varchar2 default hr_api.g_varchar2
549: ,p_country in varchar2 default hr_api.g_varchar2
550: ,p_telephone_number in varchar2 default hr_api.g_varchar2
551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

547: ,p_county in varchar2 default hr_api.g_varchar2
548: ,p_postcode in varchar2 default hr_api.g_varchar2
549: ,p_country in varchar2 default hr_api.g_varchar2
550: ,p_telephone_number in varchar2 default hr_api.g_varchar2
551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

548: ,p_postcode in varchar2 default hr_api.g_varchar2
549: ,p_country in varchar2 default hr_api.g_varchar2
550: ,p_telephone_number in varchar2 default hr_api.g_varchar2
551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

549: ,p_country in varchar2 default hr_api.g_varchar2
550: ,p_telephone_number in varchar2 default hr_api.g_varchar2
551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

550: ,p_telephone_number in varchar2 default hr_api.g_varchar2
551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

551: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

552: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

553: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

554: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

555: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

556: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

557: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

558: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

559: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

560: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
568: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

561: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
568: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
569: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

562: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
568: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
569: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
570: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

563: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
568: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
569: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
570: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
571: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 568: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

564: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
568: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
569: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
570: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
571: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
572: ) is

Line 569: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

565: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
568: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
569: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
570: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
571: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
572: ) is
573: --

Line 570: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

566: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
568: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
569: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
570: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
571: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
572: ) is
573: --
574: -- Declare cursors and local variables

Line 571: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

567: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
568: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
569: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
570: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
571: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
572: ) is
573: --
574: -- Declare cursors and local variables
575: --

Line 671: ,p_date_from in date default hr_api.g_date

667: (p_validate in boolean default false
668: ,p_effective_date in date
669: ,p_address_id in number
670: ,p_object_version_number in out nocopy number
671: ,p_date_from in date default hr_api.g_date
672: ,p_date_to in date default hr_api.g_date
673: ,p_address_type in varchar2 default hr_api.g_varchar2
674: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
675: ,p_address_line1 in varchar2 default hr_api.g_varchar2

Line 672: ,p_date_to in date default hr_api.g_date

668: ,p_effective_date in date
669: ,p_address_id in number
670: ,p_object_version_number in out nocopy number
671: ,p_date_from in date default hr_api.g_date
672: ,p_date_to in date default hr_api.g_date
673: ,p_address_type in varchar2 default hr_api.g_varchar2
674: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
675: ,p_address_line1 in varchar2 default hr_api.g_varchar2
676: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 673: ,p_address_type in varchar2 default hr_api.g_varchar2

669: ,p_address_id in number
670: ,p_object_version_number in out nocopy number
671: ,p_date_from in date default hr_api.g_date
672: ,p_date_to in date default hr_api.g_date
673: ,p_address_type in varchar2 default hr_api.g_varchar2
674: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
675: ,p_address_line1 in varchar2 default hr_api.g_varchar2
676: ,p_address_line2 in varchar2 default hr_api.g_varchar2
677: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 674: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792

670: ,p_object_version_number in out nocopy number
671: ,p_date_from in date default hr_api.g_date
672: ,p_date_to in date default hr_api.g_date
673: ,p_address_type in varchar2 default hr_api.g_varchar2
674: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
675: ,p_address_line1 in varchar2 default hr_api.g_varchar2
676: ,p_address_line2 in varchar2 default hr_api.g_varchar2
677: ,p_address_line3 in varchar2 default hr_api.g_varchar2
678: ,p_city in varchar2 default hr_api.g_varchar2

Line 675: ,p_address_line1 in varchar2 default hr_api.g_varchar2

671: ,p_date_from in date default hr_api.g_date
672: ,p_date_to in date default hr_api.g_date
673: ,p_address_type in varchar2 default hr_api.g_varchar2
674: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
675: ,p_address_line1 in varchar2 default hr_api.g_varchar2
676: ,p_address_line2 in varchar2 default hr_api.g_varchar2
677: ,p_address_line3 in varchar2 default hr_api.g_varchar2
678: ,p_city in varchar2 default hr_api.g_varchar2
679: ,p_state in varchar2 default hr_api.g_varchar2

Line 676: ,p_address_line2 in varchar2 default hr_api.g_varchar2

672: ,p_date_to in date default hr_api.g_date
673: ,p_address_type in varchar2 default hr_api.g_varchar2
674: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
675: ,p_address_line1 in varchar2 default hr_api.g_varchar2
676: ,p_address_line2 in varchar2 default hr_api.g_varchar2
677: ,p_address_line3 in varchar2 default hr_api.g_varchar2
678: ,p_city in varchar2 default hr_api.g_varchar2
679: ,p_state in varchar2 default hr_api.g_varchar2
680: ,p_zip_code in varchar2 default hr_api.g_varchar2

Line 677: ,p_address_line3 in varchar2 default hr_api.g_varchar2

673: ,p_address_type in varchar2 default hr_api.g_varchar2
674: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
675: ,p_address_line1 in varchar2 default hr_api.g_varchar2
676: ,p_address_line2 in varchar2 default hr_api.g_varchar2
677: ,p_address_line3 in varchar2 default hr_api.g_varchar2
678: ,p_city in varchar2 default hr_api.g_varchar2
679: ,p_state in varchar2 default hr_api.g_varchar2
680: ,p_zip_code in varchar2 default hr_api.g_varchar2
681: ,p_county in varchar2 default hr_api.g_varchar2

Line 678: ,p_city in varchar2 default hr_api.g_varchar2

674: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
675: ,p_address_line1 in varchar2 default hr_api.g_varchar2
676: ,p_address_line2 in varchar2 default hr_api.g_varchar2
677: ,p_address_line3 in varchar2 default hr_api.g_varchar2
678: ,p_city in varchar2 default hr_api.g_varchar2
679: ,p_state in varchar2 default hr_api.g_varchar2
680: ,p_zip_code in varchar2 default hr_api.g_varchar2
681: ,p_county in varchar2 default hr_api.g_varchar2
682: ,p_country in varchar2 default hr_api.g_varchar2

Line 679: ,p_state in varchar2 default hr_api.g_varchar2

675: ,p_address_line1 in varchar2 default hr_api.g_varchar2
676: ,p_address_line2 in varchar2 default hr_api.g_varchar2
677: ,p_address_line3 in varchar2 default hr_api.g_varchar2
678: ,p_city in varchar2 default hr_api.g_varchar2
679: ,p_state in varchar2 default hr_api.g_varchar2
680: ,p_zip_code in varchar2 default hr_api.g_varchar2
681: ,p_county in varchar2 default hr_api.g_varchar2
682: ,p_country in varchar2 default hr_api.g_varchar2
683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 680: ,p_zip_code in varchar2 default hr_api.g_varchar2

676: ,p_address_line2 in varchar2 default hr_api.g_varchar2
677: ,p_address_line3 in varchar2 default hr_api.g_varchar2
678: ,p_city in varchar2 default hr_api.g_varchar2
679: ,p_state in varchar2 default hr_api.g_varchar2
680: ,p_zip_code in varchar2 default hr_api.g_varchar2
681: ,p_county in varchar2 default hr_api.g_varchar2
682: ,p_country in varchar2 default hr_api.g_varchar2
683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 681: ,p_county in varchar2 default hr_api.g_varchar2

677: ,p_address_line3 in varchar2 default hr_api.g_varchar2
678: ,p_city in varchar2 default hr_api.g_varchar2
679: ,p_state in varchar2 default hr_api.g_varchar2
680: ,p_zip_code in varchar2 default hr_api.g_varchar2
681: ,p_county in varchar2 default hr_api.g_varchar2
682: ,p_country in varchar2 default hr_api.g_varchar2
683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 682: ,p_country in varchar2 default hr_api.g_varchar2

678: ,p_city in varchar2 default hr_api.g_varchar2
679: ,p_state in varchar2 default hr_api.g_varchar2
680: ,p_zip_code in varchar2 default hr_api.g_varchar2
681: ,p_county in varchar2 default hr_api.g_varchar2
682: ,p_country in varchar2 default hr_api.g_varchar2
683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

679: ,p_state in varchar2 default hr_api.g_varchar2
680: ,p_zip_code in varchar2 default hr_api.g_varchar2
681: ,p_county in varchar2 default hr_api.g_varchar2
682: ,p_country in varchar2 default hr_api.g_varchar2
683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

680: ,p_zip_code in varchar2 default hr_api.g_varchar2
681: ,p_county in varchar2 default hr_api.g_varchar2
682: ,p_country in varchar2 default hr_api.g_varchar2
683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

681: ,p_county in varchar2 default hr_api.g_varchar2
682: ,p_country in varchar2 default hr_api.g_varchar2
683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

682: ,p_country in varchar2 default hr_api.g_varchar2
683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

683: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

684: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

685: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

686: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

687: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

688: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

689: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

690: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

691: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

692: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

693: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

694: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
702: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

695: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
702: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
703: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

696: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
702: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
703: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
704: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

697: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
702: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
703: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
704: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
705: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 702: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

698: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
702: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
703: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
704: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
705: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
706: ) is

Line 703: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

699: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
702: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
703: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
704: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
705: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
706: ) is
707: --

Line 704: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

700: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
702: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
703: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
704: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
705: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
706: ) is
707: --
708: -- Declare cursors and local variables

Line 705: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

701: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
702: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
703: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
704: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
705: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
706: ) is
707: --
708: -- Declare cursors and local variables
709: --