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.GHR_PERSON_ADDRESS_API dependencies on HR_API

Line 128: raise hr_api.validate_enabled;

124: -- When in validation only mode raise the Validate_Enabled exception
125: --
126: if p_validate then
127: hr_utility.set_location(l_proc, 30);
128: raise hr_api.validate_enabled;
129: end if;
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 11);
132: exception

Line 133: when hr_api.validate_enabled then

129: end if;
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 11);
132: exception
133: when hr_api.validate_enabled then
134: hr_utility.set_location(l_proc, 35);
135: --
136: -- As the Validate_Enabled exception has been raised
137: -- we must rollback to the savepoint

Line 297: raise hr_api.validate_enabled;

293: -- When in validation only mode raise the Validate_Enabled exception
294: --
295: if p_validate then
296: hr_utility.set_location(l_proc, 30);
297: raise hr_api.validate_enabled;
298: end if;
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 11);
301: exception

Line 302: when hr_api.validate_enabled then

298: end if;
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 11);
301: exception
302: when hr_api.validate_enabled then
303: hr_utility.set_location(l_proc, 35);
304: --
305: -- As the Validate_Enabled exception has been raised
306: -- we must rollback to the savepoint

Line 332: ,p_date_from in date default hr_api.g_date

328: (p_validate in boolean default false
329: ,p_effective_date in date
330: ,p_address_id in number
331: ,p_object_version_number in out nocopy number
332: ,p_date_from in date default hr_api.g_date
333: ,p_date_to in date default hr_api.g_date
334: ,p_address_type in varchar2 default hr_api.g_varchar2
335: ,p_comments in long default hr_api.g_varchar2
336: ,p_address_line1 in varchar2 default hr_api.g_varchar2

Line 333: ,p_date_to in date default hr_api.g_date

329: ,p_effective_date in date
330: ,p_address_id in number
331: ,p_object_version_number in out nocopy number
332: ,p_date_from in date default hr_api.g_date
333: ,p_date_to in date default hr_api.g_date
334: ,p_address_type in varchar2 default hr_api.g_varchar2
335: ,p_comments in long default hr_api.g_varchar2
336: ,p_address_line1 in varchar2 default hr_api.g_varchar2
337: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 334: ,p_address_type in varchar2 default hr_api.g_varchar2

330: ,p_address_id in number
331: ,p_object_version_number in out nocopy number
332: ,p_date_from in date default hr_api.g_date
333: ,p_date_to in date default hr_api.g_date
334: ,p_address_type in varchar2 default hr_api.g_varchar2
335: ,p_comments in long default hr_api.g_varchar2
336: ,p_address_line1 in varchar2 default hr_api.g_varchar2
337: ,p_address_line2 in varchar2 default hr_api.g_varchar2
338: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 335: ,p_comments in long default hr_api.g_varchar2

331: ,p_object_version_number in out nocopy number
332: ,p_date_from in date default hr_api.g_date
333: ,p_date_to in date default hr_api.g_date
334: ,p_address_type in varchar2 default hr_api.g_varchar2
335: ,p_comments in long default hr_api.g_varchar2
336: ,p_address_line1 in varchar2 default hr_api.g_varchar2
337: ,p_address_line2 in varchar2 default hr_api.g_varchar2
338: ,p_address_line3 in varchar2 default hr_api.g_varchar2
339: ,p_city in varchar2 default hr_api.g_varchar2

Line 336: ,p_address_line1 in varchar2 default hr_api.g_varchar2

332: ,p_date_from in date default hr_api.g_date
333: ,p_date_to in date default hr_api.g_date
334: ,p_address_type in varchar2 default hr_api.g_varchar2
335: ,p_comments in long default hr_api.g_varchar2
336: ,p_address_line1 in varchar2 default hr_api.g_varchar2
337: ,p_address_line2 in varchar2 default hr_api.g_varchar2
338: ,p_address_line3 in varchar2 default hr_api.g_varchar2
339: ,p_city in varchar2 default hr_api.g_varchar2
340: ,p_state in varchar2 default hr_api.g_varchar2

Line 337: ,p_address_line2 in varchar2 default hr_api.g_varchar2

333: ,p_date_to in date default hr_api.g_date
334: ,p_address_type in varchar2 default hr_api.g_varchar2
335: ,p_comments in long default hr_api.g_varchar2
336: ,p_address_line1 in varchar2 default hr_api.g_varchar2
337: ,p_address_line2 in varchar2 default hr_api.g_varchar2
338: ,p_address_line3 in varchar2 default hr_api.g_varchar2
339: ,p_city in varchar2 default hr_api.g_varchar2
340: ,p_state in varchar2 default hr_api.g_varchar2
341: ,p_zip_code in varchar2 default hr_api.g_varchar2

Line 338: ,p_address_line3 in varchar2 default hr_api.g_varchar2

334: ,p_address_type in varchar2 default hr_api.g_varchar2
335: ,p_comments in long default hr_api.g_varchar2
336: ,p_address_line1 in varchar2 default hr_api.g_varchar2
337: ,p_address_line2 in varchar2 default hr_api.g_varchar2
338: ,p_address_line3 in varchar2 default hr_api.g_varchar2
339: ,p_city in varchar2 default hr_api.g_varchar2
340: ,p_state in varchar2 default hr_api.g_varchar2
341: ,p_zip_code in varchar2 default hr_api.g_varchar2
342: ,p_county in varchar2 default hr_api.g_varchar2

Line 339: ,p_city in varchar2 default hr_api.g_varchar2

335: ,p_comments in long default hr_api.g_varchar2
336: ,p_address_line1 in varchar2 default hr_api.g_varchar2
337: ,p_address_line2 in varchar2 default hr_api.g_varchar2
338: ,p_address_line3 in varchar2 default hr_api.g_varchar2
339: ,p_city in varchar2 default hr_api.g_varchar2
340: ,p_state in varchar2 default hr_api.g_varchar2
341: ,p_zip_code in varchar2 default hr_api.g_varchar2
342: ,p_county in varchar2 default hr_api.g_varchar2
343: ,p_country in varchar2 default hr_api.g_varchar2

Line 340: ,p_state in varchar2 default hr_api.g_varchar2

336: ,p_address_line1 in varchar2 default hr_api.g_varchar2
337: ,p_address_line2 in varchar2 default hr_api.g_varchar2
338: ,p_address_line3 in varchar2 default hr_api.g_varchar2
339: ,p_city in varchar2 default hr_api.g_varchar2
340: ,p_state in varchar2 default hr_api.g_varchar2
341: ,p_zip_code in varchar2 default hr_api.g_varchar2
342: ,p_county in varchar2 default hr_api.g_varchar2
343: ,p_country in varchar2 default hr_api.g_varchar2
344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 341: ,p_zip_code in varchar2 default hr_api.g_varchar2

337: ,p_address_line2 in varchar2 default hr_api.g_varchar2
338: ,p_address_line3 in varchar2 default hr_api.g_varchar2
339: ,p_city in varchar2 default hr_api.g_varchar2
340: ,p_state in varchar2 default hr_api.g_varchar2
341: ,p_zip_code in varchar2 default hr_api.g_varchar2
342: ,p_county in varchar2 default hr_api.g_varchar2
343: ,p_country in varchar2 default hr_api.g_varchar2
344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 342: ,p_county in varchar2 default hr_api.g_varchar2

338: ,p_address_line3 in varchar2 default hr_api.g_varchar2
339: ,p_city in varchar2 default hr_api.g_varchar2
340: ,p_state in varchar2 default hr_api.g_varchar2
341: ,p_zip_code in varchar2 default hr_api.g_varchar2
342: ,p_county in varchar2 default hr_api.g_varchar2
343: ,p_country in varchar2 default hr_api.g_varchar2
344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 343: ,p_country in varchar2 default hr_api.g_varchar2

339: ,p_city in varchar2 default hr_api.g_varchar2
340: ,p_state in varchar2 default hr_api.g_varchar2
341: ,p_zip_code in varchar2 default hr_api.g_varchar2
342: ,p_county in varchar2 default hr_api.g_varchar2
343: ,p_country in varchar2 default hr_api.g_varchar2
344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

340: ,p_state in varchar2 default hr_api.g_varchar2
341: ,p_zip_code in varchar2 default hr_api.g_varchar2
342: ,p_county in varchar2 default hr_api.g_varchar2
343: ,p_country in varchar2 default hr_api.g_varchar2
344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

341: ,p_zip_code in varchar2 default hr_api.g_varchar2
342: ,p_county in varchar2 default hr_api.g_varchar2
343: ,p_country in varchar2 default hr_api.g_varchar2
344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

342: ,p_county in varchar2 default hr_api.g_varchar2
343: ,p_country in varchar2 default hr_api.g_varchar2
344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

343: ,p_country in varchar2 default hr_api.g_varchar2
344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

344: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

345: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

346: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

347: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

348: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

349: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

350: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

351: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

352: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

353: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

354: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

355: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
363: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

356: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
363: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
364: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

357: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
363: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
364: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
365: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

358: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
363: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
364: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
365: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
366: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 363: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

359: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
363: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
364: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
365: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
366: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
367: ) is

Line 364: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

360: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
363: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
364: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
365: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
366: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
367: ) is
368: --

Line 365: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

361: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
363: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
364: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
365: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
366: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
367: ) is
368: --
369: -- Declare cursors and local variables

Line 366: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

362: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
363: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
364: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
365: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
366: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
367: ) is
368: --
369: -- Declare cursors and local variables
370: --

Line 436: raise hr_api.validate_enabled;

432: hr_utility.set_location(l_proc, 25);
433: ghr_history_api.post_update_process;
434: hr_utility.set_location(' Leaving:'||l_proc, 30);
435: if p_validate then
436: raise hr_api.validate_enabled;
437: end if;
438: --
439: hr_utility.set_location(l_proc, 40);
440: exception

Line 441: when hr_api.validate_enabled then

437: end if;
438: --
439: hr_utility.set_location(l_proc, 40);
440: exception
441: when hr_api.validate_enabled then
442: --
443: -- As the Validate_Enabled exception has been raised
444: -- we must rollback to the savepoint
445: --

Line 472: ,p_date_from in date default hr_api.g_date

468: ,p_effective_date in date
469: ,p_validate_county in boolean default true
470: ,p_address_id in number
471: ,p_object_version_number in out nocopy number
472: ,p_date_from in date default hr_api.g_date
473: ,p_date_to in date default hr_api.g_date
474: ,p_address_type in varchar2 default hr_api.g_varchar2
475: ,p_comments in long default hr_api.g_varchar2
476: ,p_address_line1 in varchar2 default hr_api.g_varchar2

Line 473: ,p_date_to in date default hr_api.g_date

469: ,p_validate_county in boolean default true
470: ,p_address_id in number
471: ,p_object_version_number in out nocopy number
472: ,p_date_from in date default hr_api.g_date
473: ,p_date_to in date default hr_api.g_date
474: ,p_address_type in varchar2 default hr_api.g_varchar2
475: ,p_comments in long default hr_api.g_varchar2
476: ,p_address_line1 in varchar2 default hr_api.g_varchar2
477: ,p_address_line2 in varchar2 default hr_api.g_varchar2

Line 474: ,p_address_type in varchar2 default hr_api.g_varchar2

470: ,p_address_id in number
471: ,p_object_version_number in out nocopy number
472: ,p_date_from in date default hr_api.g_date
473: ,p_date_to in date default hr_api.g_date
474: ,p_address_type in varchar2 default hr_api.g_varchar2
475: ,p_comments in long default hr_api.g_varchar2
476: ,p_address_line1 in varchar2 default hr_api.g_varchar2
477: ,p_address_line2 in varchar2 default hr_api.g_varchar2
478: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 475: ,p_comments in long default hr_api.g_varchar2

471: ,p_object_version_number in out nocopy number
472: ,p_date_from in date default hr_api.g_date
473: ,p_date_to in date default hr_api.g_date
474: ,p_address_type in varchar2 default hr_api.g_varchar2
475: ,p_comments in long default hr_api.g_varchar2
476: ,p_address_line1 in varchar2 default hr_api.g_varchar2
477: ,p_address_line2 in varchar2 default hr_api.g_varchar2
478: ,p_address_line3 in varchar2 default hr_api.g_varchar2
479: ,p_city in varchar2 default hr_api.g_varchar2

Line 476: ,p_address_line1 in varchar2 default hr_api.g_varchar2

472: ,p_date_from in date default hr_api.g_date
473: ,p_date_to in date default hr_api.g_date
474: ,p_address_type in varchar2 default hr_api.g_varchar2
475: ,p_comments in long default hr_api.g_varchar2
476: ,p_address_line1 in varchar2 default hr_api.g_varchar2
477: ,p_address_line2 in varchar2 default hr_api.g_varchar2
478: ,p_address_line3 in varchar2 default hr_api.g_varchar2
479: ,p_city in varchar2 default hr_api.g_varchar2
480: ,p_state in varchar2 default hr_api.g_varchar2

Line 477: ,p_address_line2 in varchar2 default hr_api.g_varchar2

473: ,p_date_to in date default hr_api.g_date
474: ,p_address_type in varchar2 default hr_api.g_varchar2
475: ,p_comments in long default hr_api.g_varchar2
476: ,p_address_line1 in varchar2 default hr_api.g_varchar2
477: ,p_address_line2 in varchar2 default hr_api.g_varchar2
478: ,p_address_line3 in varchar2 default hr_api.g_varchar2
479: ,p_city in varchar2 default hr_api.g_varchar2
480: ,p_state in varchar2 default hr_api.g_varchar2
481: ,p_zip_code in varchar2 default hr_api.g_varchar2

Line 478: ,p_address_line3 in varchar2 default hr_api.g_varchar2

474: ,p_address_type in varchar2 default hr_api.g_varchar2
475: ,p_comments in long default hr_api.g_varchar2
476: ,p_address_line1 in varchar2 default hr_api.g_varchar2
477: ,p_address_line2 in varchar2 default hr_api.g_varchar2
478: ,p_address_line3 in varchar2 default hr_api.g_varchar2
479: ,p_city in varchar2 default hr_api.g_varchar2
480: ,p_state in varchar2 default hr_api.g_varchar2
481: ,p_zip_code in varchar2 default hr_api.g_varchar2
482: ,p_county in varchar2 default hr_api.g_varchar2

Line 479: ,p_city in varchar2 default hr_api.g_varchar2

475: ,p_comments in long default hr_api.g_varchar2
476: ,p_address_line1 in varchar2 default hr_api.g_varchar2
477: ,p_address_line2 in varchar2 default hr_api.g_varchar2
478: ,p_address_line3 in varchar2 default hr_api.g_varchar2
479: ,p_city in varchar2 default hr_api.g_varchar2
480: ,p_state in varchar2 default hr_api.g_varchar2
481: ,p_zip_code in varchar2 default hr_api.g_varchar2
482: ,p_county in varchar2 default hr_api.g_varchar2
483: ,p_country in varchar2 default hr_api.g_varchar2

Line 480: ,p_state in varchar2 default hr_api.g_varchar2

476: ,p_address_line1 in varchar2 default hr_api.g_varchar2
477: ,p_address_line2 in varchar2 default hr_api.g_varchar2
478: ,p_address_line3 in varchar2 default hr_api.g_varchar2
479: ,p_city in varchar2 default hr_api.g_varchar2
480: ,p_state in varchar2 default hr_api.g_varchar2
481: ,p_zip_code in varchar2 default hr_api.g_varchar2
482: ,p_county in varchar2 default hr_api.g_varchar2
483: ,p_country in varchar2 default hr_api.g_varchar2
484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 481: ,p_zip_code in varchar2 default hr_api.g_varchar2

477: ,p_address_line2 in varchar2 default hr_api.g_varchar2
478: ,p_address_line3 in varchar2 default hr_api.g_varchar2
479: ,p_city in varchar2 default hr_api.g_varchar2
480: ,p_state in varchar2 default hr_api.g_varchar2
481: ,p_zip_code in varchar2 default hr_api.g_varchar2
482: ,p_county in varchar2 default hr_api.g_varchar2
483: ,p_country in varchar2 default hr_api.g_varchar2
484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 482: ,p_county in varchar2 default hr_api.g_varchar2

478: ,p_address_line3 in varchar2 default hr_api.g_varchar2
479: ,p_city in varchar2 default hr_api.g_varchar2
480: ,p_state in varchar2 default hr_api.g_varchar2
481: ,p_zip_code in varchar2 default hr_api.g_varchar2
482: ,p_county in varchar2 default hr_api.g_varchar2
483: ,p_country in varchar2 default hr_api.g_varchar2
484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 483: ,p_country in varchar2 default hr_api.g_varchar2

479: ,p_city in varchar2 default hr_api.g_varchar2
480: ,p_state in varchar2 default hr_api.g_varchar2
481: ,p_zip_code in varchar2 default hr_api.g_varchar2
482: ,p_county in varchar2 default hr_api.g_varchar2
483: ,p_country in varchar2 default hr_api.g_varchar2
484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

480: ,p_state in varchar2 default hr_api.g_varchar2
481: ,p_zip_code in varchar2 default hr_api.g_varchar2
482: ,p_county in varchar2 default hr_api.g_varchar2
483: ,p_country in varchar2 default hr_api.g_varchar2
484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

481: ,p_zip_code in varchar2 default hr_api.g_varchar2
482: ,p_county in varchar2 default hr_api.g_varchar2
483: ,p_country in varchar2 default hr_api.g_varchar2
484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

482: ,p_county in varchar2 default hr_api.g_varchar2
483: ,p_country in varchar2 default hr_api.g_varchar2
484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

483: ,p_country in varchar2 default hr_api.g_varchar2
484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

484: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

485: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

486: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

487: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

488: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

489: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

490: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

491: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

492: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

493: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

494: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

495: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

496: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

497: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

498: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

499: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
507: ,p_add_information13 in varchar2 default hr_api.g_varchar2

Line 504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

500: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
507: ,p_add_information13 in varchar2 default hr_api.g_varchar2
508: ,p_add_information14 in varchar2 default hr_api.g_varchar2

Line 505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

501: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
507: ,p_add_information13 in varchar2 default hr_api.g_varchar2
508: ,p_add_information14 in varchar2 default hr_api.g_varchar2
509: ,p_add_information15 in varchar2 default hr_api.g_varchar2

Line 506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

502: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
507: ,p_add_information13 in varchar2 default hr_api.g_varchar2
508: ,p_add_information14 in varchar2 default hr_api.g_varchar2
509: ,p_add_information15 in varchar2 default hr_api.g_varchar2
510: ,p_add_information16 in varchar2 default hr_api.g_varchar2

Line 507: ,p_add_information13 in varchar2 default hr_api.g_varchar2

503: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
507: ,p_add_information13 in varchar2 default hr_api.g_varchar2
508: ,p_add_information14 in varchar2 default hr_api.g_varchar2
509: ,p_add_information15 in varchar2 default hr_api.g_varchar2
510: ,p_add_information16 in varchar2 default hr_api.g_varchar2
511: ,p_add_information17 in varchar2 default hr_api.g_varchar2

Line 508: ,p_add_information14 in varchar2 default hr_api.g_varchar2

504: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
507: ,p_add_information13 in varchar2 default hr_api.g_varchar2
508: ,p_add_information14 in varchar2 default hr_api.g_varchar2
509: ,p_add_information15 in varchar2 default hr_api.g_varchar2
510: ,p_add_information16 in varchar2 default hr_api.g_varchar2
511: ,p_add_information17 in varchar2 default hr_api.g_varchar2
512: ,p_add_information18 in varchar2 default hr_api.g_varchar2

Line 509: ,p_add_information15 in varchar2 default hr_api.g_varchar2

505: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
507: ,p_add_information13 in varchar2 default hr_api.g_varchar2
508: ,p_add_information14 in varchar2 default hr_api.g_varchar2
509: ,p_add_information15 in varchar2 default hr_api.g_varchar2
510: ,p_add_information16 in varchar2 default hr_api.g_varchar2
511: ,p_add_information17 in varchar2 default hr_api.g_varchar2
512: ,p_add_information18 in varchar2 default hr_api.g_varchar2
513: ,p_add_information19 in varchar2 default hr_api.g_varchar2

Line 510: ,p_add_information16 in varchar2 default hr_api.g_varchar2

506: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
507: ,p_add_information13 in varchar2 default hr_api.g_varchar2
508: ,p_add_information14 in varchar2 default hr_api.g_varchar2
509: ,p_add_information15 in varchar2 default hr_api.g_varchar2
510: ,p_add_information16 in varchar2 default hr_api.g_varchar2
511: ,p_add_information17 in varchar2 default hr_api.g_varchar2
512: ,p_add_information18 in varchar2 default hr_api.g_varchar2
513: ,p_add_information19 in varchar2 default hr_api.g_varchar2
514: ,p_add_information20 in varchar2 default hr_api.g_varchar2

Line 511: ,p_add_information17 in varchar2 default hr_api.g_varchar2

507: ,p_add_information13 in varchar2 default hr_api.g_varchar2
508: ,p_add_information14 in varchar2 default hr_api.g_varchar2
509: ,p_add_information15 in varchar2 default hr_api.g_varchar2
510: ,p_add_information16 in varchar2 default hr_api.g_varchar2
511: ,p_add_information17 in varchar2 default hr_api.g_varchar2
512: ,p_add_information18 in varchar2 default hr_api.g_varchar2
513: ,p_add_information19 in varchar2 default hr_api.g_varchar2
514: ,p_add_information20 in varchar2 default hr_api.g_varchar2
515: ) is

Line 512: ,p_add_information18 in varchar2 default hr_api.g_varchar2

508: ,p_add_information14 in varchar2 default hr_api.g_varchar2
509: ,p_add_information15 in varchar2 default hr_api.g_varchar2
510: ,p_add_information16 in varchar2 default hr_api.g_varchar2
511: ,p_add_information17 in varchar2 default hr_api.g_varchar2
512: ,p_add_information18 in varchar2 default hr_api.g_varchar2
513: ,p_add_information19 in varchar2 default hr_api.g_varchar2
514: ,p_add_information20 in varchar2 default hr_api.g_varchar2
515: ) is
516: --

Line 513: ,p_add_information19 in varchar2 default hr_api.g_varchar2

509: ,p_add_information15 in varchar2 default hr_api.g_varchar2
510: ,p_add_information16 in varchar2 default hr_api.g_varchar2
511: ,p_add_information17 in varchar2 default hr_api.g_varchar2
512: ,p_add_information18 in varchar2 default hr_api.g_varchar2
513: ,p_add_information19 in varchar2 default hr_api.g_varchar2
514: ,p_add_information20 in varchar2 default hr_api.g_varchar2
515: ) is
516: --
517: -- Declare cursors and local variables

Line 514: ,p_add_information20 in varchar2 default hr_api.g_varchar2

510: ,p_add_information16 in varchar2 default hr_api.g_varchar2
511: ,p_add_information17 in varchar2 default hr_api.g_varchar2
512: ,p_add_information18 in varchar2 default hr_api.g_varchar2
513: ,p_add_information19 in varchar2 default hr_api.g_varchar2
514: ,p_add_information20 in varchar2 default hr_api.g_varchar2
515: ) is
516: --
517: -- Declare cursors and local variables
518: --

Line 620: raise hr_api.validate_enabled;

616: hr_utility.set_location(l_proc, 25);
617: ghr_history_api.post_update_process;
618: hr_utility.set_location(' Leaving:'||l_proc, 30);
619: if p_validate then
620: raise hr_api.validate_enabled;
621: end if;
622: --
623: hr_utility.set_location(l_proc, 40);
624: exception

Line 625: when hr_api.validate_enabled then

621: end if;
622: --
623: hr_utility.set_location(l_proc, 40);
624: exception
625: when hr_api.validate_enabled then
626: --
627: -- As the Validate_Enabled exception has been raised
628: -- we must rollback to the savepoint
629: --