APPS.PER_KAD_UPD dependencies on HR_API

Line 126: When hr_api.check_integrity_violated Then

122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: --
125: Exception
126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: per_kad_shd.g_api_dml := false; -- Unset the api dml status
129: per_kad_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

126: When hr_api.check_integrity_violated Then
127: -- A check constraint has been violated
128: per_kad_shd.g_api_dml := false; -- Unset the api dml status
129: per_kad_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: per_kad_shd.g_api_dml := false; -- Unset the api dml status
134: per_kad_shd.constraint_error

Line 131: When hr_api.parent_integrity_violated Then

127: -- A check constraint has been violated
128: per_kad_shd.g_api_dml := false; -- Unset the api dml status
129: per_kad_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: per_kad_shd.g_api_dml := false; -- Unset the api dml status
134: per_kad_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: per_kad_shd.g_api_dml := false; -- Unset the api dml status
134: per_kad_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_kad_shd.g_api_dml := false; -- Unset the api dml status
139: per_kad_shd.constraint_error

Line 136: When hr_api.unique_integrity_violated Then

132: -- Parent integrity has been violated
133: per_kad_shd.g_api_dml := false; -- Unset the api dml status
134: per_kad_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_kad_shd.g_api_dml := false; -- Unset the api dml status
139: per_kad_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_kad_shd.g_api_dml := false; -- Unset the api dml status
139: per_kad_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When Others Then
142: per_kad_shd.g_api_dml := false; -- Unset the api dml status
143: Raise;
144: End update_dml;

Line 322: If (p_rec.business_group_id = hr_api.g_number) then

318: -- p_rec plsql record structure
319: -- to see if a system default is being used. If a system default
320: -- is being used then we must set to the 'current' argument value.
321: --
322: If (p_rec.business_group_id = hr_api.g_number) then
323: p_rec.business_group_id :=
324: per_kad_shd.g_old_rec.business_group_id;
325: End If;
326: If (p_rec.person_id = hr_api.g_number) then

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

322: If (p_rec.business_group_id = hr_api.g_number) then
323: p_rec.business_group_id :=
324: per_kad_shd.g_old_rec.business_group_id;
325: End If;
326: If (p_rec.person_id = hr_api.g_number) then
327: p_rec.person_id :=
328: per_kad_shd.g_old_rec.person_id;
329: End If;
330: If (p_rec.date_from = hr_api.g_date) then

Line 330: If (p_rec.date_from = hr_api.g_date) then

326: If (p_rec.person_id = hr_api.g_number) then
327: p_rec.person_id :=
328: per_kad_shd.g_old_rec.person_id;
329: End If;
330: If (p_rec.date_from = hr_api.g_date) then
331: p_rec.date_from :=
332: per_kad_shd.g_old_rec.date_from;
333: End If;
334: If (p_rec.primary_flag = hr_api.g_varchar2) then

Line 334: If (p_rec.primary_flag = hr_api.g_varchar2) then

330: If (p_rec.date_from = hr_api.g_date) then
331: p_rec.date_from :=
332: per_kad_shd.g_old_rec.date_from;
333: End If;
334: If (p_rec.primary_flag = hr_api.g_varchar2) then
335: p_rec.primary_flag :=
336: per_kad_shd.g_old_rec.primary_flag;
337: End If;
338: If (p_rec.style = hr_api.g_varchar2) then

Line 338: If (p_rec.style = hr_api.g_varchar2) then

334: If (p_rec.primary_flag = hr_api.g_varchar2) then
335: p_rec.primary_flag :=
336: per_kad_shd.g_old_rec.primary_flag;
337: End If;
338: If (p_rec.style = hr_api.g_varchar2) then
339: p_rec.style :=
340: per_kad_shd.g_old_rec.style;
341: End If;
342: If (p_rec.address_line1 = hr_api.g_varchar2) then

Line 342: If (p_rec.address_line1 = hr_api.g_varchar2) then

338: If (p_rec.style = hr_api.g_varchar2) then
339: p_rec.style :=
340: per_kad_shd.g_old_rec.style;
341: End If;
342: If (p_rec.address_line1 = hr_api.g_varchar2) then
343: p_rec.address_line1 :=
344: per_kad_shd.g_old_rec.address_line1;
345: End If;
346: If (p_rec.address_line2 = hr_api.g_varchar2) then

Line 346: If (p_rec.address_line2 = hr_api.g_varchar2) then

342: If (p_rec.address_line1 = hr_api.g_varchar2) then
343: p_rec.address_line1 :=
344: per_kad_shd.g_old_rec.address_line1;
345: End If;
346: If (p_rec.address_line2 = hr_api.g_varchar2) then
347: p_rec.address_line2 :=
348: per_kad_shd.g_old_rec.address_line2;
349: End If;
350: If (p_rec.address_line3 = hr_api.g_varchar2) then

Line 350: If (p_rec.address_line3 = hr_api.g_varchar2) then

346: If (p_rec.address_line2 = hr_api.g_varchar2) then
347: p_rec.address_line2 :=
348: per_kad_shd.g_old_rec.address_line2;
349: End If;
350: If (p_rec.address_line3 = hr_api.g_varchar2) then
351: p_rec.address_line3 :=
352: per_kad_shd.g_old_rec.address_line3;
353: End If;
354: If (p_rec.address_type = hr_api.g_varchar2) then

Line 354: If (p_rec.address_type = hr_api.g_varchar2) then

350: If (p_rec.address_line3 = hr_api.g_varchar2) then
351: p_rec.address_line3 :=
352: per_kad_shd.g_old_rec.address_line3;
353: End If;
354: If (p_rec.address_type = hr_api.g_varchar2) then
355: p_rec.address_type :=
356: per_kad_shd.g_old_rec.address_type;
357: End If;
358: If (p_rec.comments = hr_api.g_varchar2) then

Line 358: If (p_rec.comments = hr_api.g_varchar2) then

354: If (p_rec.address_type = hr_api.g_varchar2) then
355: p_rec.address_type :=
356: per_kad_shd.g_old_rec.address_type;
357: End If;
358: If (p_rec.comments = hr_api.g_varchar2) then
359: p_rec.comments :=
360: per_kad_shd.g_old_rec.comments;
361: End If;
362: If (p_rec.country = hr_api.g_varchar2) then

Line 362: If (p_rec.country = hr_api.g_varchar2) then

358: If (p_rec.comments = hr_api.g_varchar2) then
359: p_rec.comments :=
360: per_kad_shd.g_old_rec.comments;
361: End If;
362: If (p_rec.country = hr_api.g_varchar2) then
363: p_rec.country :=
364: per_kad_shd.g_old_rec.country;
365: End If;
366: If (p_rec.date_to = hr_api.g_date) then

Line 366: If (p_rec.date_to = hr_api.g_date) then

362: If (p_rec.country = hr_api.g_varchar2) then
363: p_rec.country :=
364: per_kad_shd.g_old_rec.country;
365: End If;
366: If (p_rec.date_to = hr_api.g_date) then
367: p_rec.date_to :=
368: per_kad_shd.g_old_rec.date_to;
369: End If;
370: If (p_rec.postal_code = hr_api.g_varchar2) then

Line 370: If (p_rec.postal_code = hr_api.g_varchar2) then

366: If (p_rec.date_to = hr_api.g_date) then
367: p_rec.date_to :=
368: per_kad_shd.g_old_rec.date_to;
369: End If;
370: If (p_rec.postal_code = hr_api.g_varchar2) then
371: p_rec.postal_code :=
372: per_kad_shd.g_old_rec.postal_code;
373: End If;
374: If (p_rec.region_1 = hr_api.g_varchar2) then

Line 374: If (p_rec.region_1 = hr_api.g_varchar2) then

370: If (p_rec.postal_code = hr_api.g_varchar2) then
371: p_rec.postal_code :=
372: per_kad_shd.g_old_rec.postal_code;
373: End If;
374: If (p_rec.region_1 = hr_api.g_varchar2) then
375: p_rec.region_1 :=
376: per_kad_shd.g_old_rec.region_1;
377: End If;
378: If (p_rec.region_2 = hr_api.g_varchar2) then

Line 378: If (p_rec.region_2 = hr_api.g_varchar2) then

374: If (p_rec.region_1 = hr_api.g_varchar2) then
375: p_rec.region_1 :=
376: per_kad_shd.g_old_rec.region_1;
377: End If;
378: If (p_rec.region_2 = hr_api.g_varchar2) then
379: p_rec.region_2 :=
380: per_kad_shd.g_old_rec.region_2;
381: End If;
382: If (p_rec.region_3 = hr_api.g_varchar2) then

Line 382: If (p_rec.region_3 = hr_api.g_varchar2) then

378: If (p_rec.region_2 = hr_api.g_varchar2) then
379: p_rec.region_2 :=
380: per_kad_shd.g_old_rec.region_2;
381: End If;
382: If (p_rec.region_3 = hr_api.g_varchar2) then
383: p_rec.region_3 :=
384: per_kad_shd.g_old_rec.region_3;
385: End If;
386: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then

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

382: If (p_rec.region_3 = hr_api.g_varchar2) then
383: p_rec.region_3 :=
384: per_kad_shd.g_old_rec.region_3;
385: End If;
386: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
387: p_rec.telephone_number_1 :=
388: per_kad_shd.g_old_rec.telephone_number_1;
389: End If;
390: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then

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

386: If (p_rec.telephone_number_1 = hr_api.g_varchar2) then
387: p_rec.telephone_number_1 :=
388: per_kad_shd.g_old_rec.telephone_number_1;
389: End If;
390: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
391: p_rec.telephone_number_2 :=
392: per_kad_shd.g_old_rec.telephone_number_2;
393: End If;
394: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then

Line 394: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then

390: If (p_rec.telephone_number_2 = hr_api.g_varchar2) then
391: p_rec.telephone_number_2 :=
392: per_kad_shd.g_old_rec.telephone_number_2;
393: End If;
394: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
395: p_rec.telephone_number_3 :=
396: per_kad_shd.g_old_rec.telephone_number_3;
397: End If;
398: If (p_rec.town_or_city = hr_api.g_varchar2) then

Line 398: If (p_rec.town_or_city = hr_api.g_varchar2) then

394: If (p_rec.telephone_number_3 = hr_api.g_varchar2) then
395: p_rec.telephone_number_3 :=
396: per_kad_shd.g_old_rec.telephone_number_3;
397: End If;
398: If (p_rec.town_or_city = hr_api.g_varchar2) then
399: p_rec.town_or_city :=
400: per_kad_shd.g_old_rec.town_or_city;
401: End If;
402: If (p_rec.request_id = hr_api.g_number) then

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

398: If (p_rec.town_or_city = hr_api.g_varchar2) then
399: p_rec.town_or_city :=
400: per_kad_shd.g_old_rec.town_or_city;
401: End If;
402: If (p_rec.request_id = hr_api.g_number) then
403: p_rec.request_id :=
404: per_kad_shd.g_old_rec.request_id;
405: End If;
406: If (p_rec.program_application_id = hr_api.g_number) then

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

402: If (p_rec.request_id = hr_api.g_number) then
403: p_rec.request_id :=
404: per_kad_shd.g_old_rec.request_id;
405: End If;
406: If (p_rec.program_application_id = hr_api.g_number) then
407: p_rec.program_application_id :=
408: per_kad_shd.g_old_rec.program_application_id;
409: End If;
410: If (p_rec.program_id = hr_api.g_number) then

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

406: If (p_rec.program_application_id = hr_api.g_number) then
407: p_rec.program_application_id :=
408: per_kad_shd.g_old_rec.program_application_id;
409: End If;
410: If (p_rec.program_id = hr_api.g_number) then
411: p_rec.program_id :=
412: per_kad_shd.g_old_rec.program_id;
413: End If;
414: If (p_rec.program_update_date = hr_api.g_date) then

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

410: If (p_rec.program_id = hr_api.g_number) then
411: p_rec.program_id :=
412: per_kad_shd.g_old_rec.program_id;
413: End If;
414: If (p_rec.program_update_date = hr_api.g_date) then
415: p_rec.program_update_date :=
416: per_kad_shd.g_old_rec.program_update_date;
417: End If;
418: If (p_rec.addr_attribute_category = hr_api.g_varchar2) then

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

414: If (p_rec.program_update_date = hr_api.g_date) then
415: p_rec.program_update_date :=
416: per_kad_shd.g_old_rec.program_update_date;
417: End If;
418: If (p_rec.addr_attribute_category = hr_api.g_varchar2) then
419: p_rec.addr_attribute_category :=
420: per_kad_shd.g_old_rec.addr_attribute_category;
421: End If;
422: If (p_rec.addr_attribute1 = hr_api.g_varchar2) then

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

418: If (p_rec.addr_attribute_category = hr_api.g_varchar2) then
419: p_rec.addr_attribute_category :=
420: per_kad_shd.g_old_rec.addr_attribute_category;
421: End If;
422: If (p_rec.addr_attribute1 = hr_api.g_varchar2) then
423: p_rec.addr_attribute1 :=
424: per_kad_shd.g_old_rec.addr_attribute1;
425: End If;
426: If (p_rec.addr_attribute2 = hr_api.g_varchar2) then

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

422: If (p_rec.addr_attribute1 = hr_api.g_varchar2) then
423: p_rec.addr_attribute1 :=
424: per_kad_shd.g_old_rec.addr_attribute1;
425: End If;
426: If (p_rec.addr_attribute2 = hr_api.g_varchar2) then
427: p_rec.addr_attribute2 :=
428: per_kad_shd.g_old_rec.addr_attribute2;
429: End If;
430: If (p_rec.addr_attribute3 = hr_api.g_varchar2) then

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

426: If (p_rec.addr_attribute2 = hr_api.g_varchar2) then
427: p_rec.addr_attribute2 :=
428: per_kad_shd.g_old_rec.addr_attribute2;
429: End If;
430: If (p_rec.addr_attribute3 = hr_api.g_varchar2) then
431: p_rec.addr_attribute3 :=
432: per_kad_shd.g_old_rec.addr_attribute3;
433: End If;
434: If (p_rec.addr_attribute4 = hr_api.g_varchar2) then

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

430: If (p_rec.addr_attribute3 = hr_api.g_varchar2) then
431: p_rec.addr_attribute3 :=
432: per_kad_shd.g_old_rec.addr_attribute3;
433: End If;
434: If (p_rec.addr_attribute4 = hr_api.g_varchar2) then
435: p_rec.addr_attribute4 :=
436: per_kad_shd.g_old_rec.addr_attribute4;
437: End If;
438: If (p_rec.addr_attribute5 = hr_api.g_varchar2) then

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

434: If (p_rec.addr_attribute4 = hr_api.g_varchar2) then
435: p_rec.addr_attribute4 :=
436: per_kad_shd.g_old_rec.addr_attribute4;
437: End If;
438: If (p_rec.addr_attribute5 = hr_api.g_varchar2) then
439: p_rec.addr_attribute5 :=
440: per_kad_shd.g_old_rec.addr_attribute5;
441: End If;
442: If (p_rec.addr_attribute6 = hr_api.g_varchar2) then

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

438: If (p_rec.addr_attribute5 = hr_api.g_varchar2) then
439: p_rec.addr_attribute5 :=
440: per_kad_shd.g_old_rec.addr_attribute5;
441: End If;
442: If (p_rec.addr_attribute6 = hr_api.g_varchar2) then
443: p_rec.addr_attribute6 :=
444: per_kad_shd.g_old_rec.addr_attribute6;
445: End If;
446: If (p_rec.addr_attribute7 = hr_api.g_varchar2) then

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

442: If (p_rec.addr_attribute6 = hr_api.g_varchar2) then
443: p_rec.addr_attribute6 :=
444: per_kad_shd.g_old_rec.addr_attribute6;
445: End If;
446: If (p_rec.addr_attribute7 = hr_api.g_varchar2) then
447: p_rec.addr_attribute7 :=
448: per_kad_shd.g_old_rec.addr_attribute7;
449: End If;
450: If (p_rec.addr_attribute8 = hr_api.g_varchar2) then

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

446: If (p_rec.addr_attribute7 = hr_api.g_varchar2) then
447: p_rec.addr_attribute7 :=
448: per_kad_shd.g_old_rec.addr_attribute7;
449: End If;
450: If (p_rec.addr_attribute8 = hr_api.g_varchar2) then
451: p_rec.addr_attribute8 :=
452: per_kad_shd.g_old_rec.addr_attribute8;
453: End If;
454: If (p_rec.addr_attribute9 = hr_api.g_varchar2) then

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

450: If (p_rec.addr_attribute8 = hr_api.g_varchar2) then
451: p_rec.addr_attribute8 :=
452: per_kad_shd.g_old_rec.addr_attribute8;
453: End If;
454: If (p_rec.addr_attribute9 = hr_api.g_varchar2) then
455: p_rec.addr_attribute9 :=
456: per_kad_shd.g_old_rec.addr_attribute9;
457: End If;
458: If (p_rec.addr_attribute10 = hr_api.g_varchar2) then

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

454: If (p_rec.addr_attribute9 = hr_api.g_varchar2) then
455: p_rec.addr_attribute9 :=
456: per_kad_shd.g_old_rec.addr_attribute9;
457: End If;
458: If (p_rec.addr_attribute10 = hr_api.g_varchar2) then
459: p_rec.addr_attribute10 :=
460: per_kad_shd.g_old_rec.addr_attribute10;
461: End If;
462: If (p_rec.addr_attribute11 = hr_api.g_varchar2) then

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

458: If (p_rec.addr_attribute10 = hr_api.g_varchar2) then
459: p_rec.addr_attribute10 :=
460: per_kad_shd.g_old_rec.addr_attribute10;
461: End If;
462: If (p_rec.addr_attribute11 = hr_api.g_varchar2) then
463: p_rec.addr_attribute11 :=
464: per_kad_shd.g_old_rec.addr_attribute11;
465: End If;
466: If (p_rec.addr_attribute12 = hr_api.g_varchar2) then

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

462: If (p_rec.addr_attribute11 = hr_api.g_varchar2) then
463: p_rec.addr_attribute11 :=
464: per_kad_shd.g_old_rec.addr_attribute11;
465: End If;
466: If (p_rec.addr_attribute12 = hr_api.g_varchar2) then
467: p_rec.addr_attribute12 :=
468: per_kad_shd.g_old_rec.addr_attribute12;
469: End If;
470: If (p_rec.addr_attribute13 = hr_api.g_varchar2) then

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

466: If (p_rec.addr_attribute12 = hr_api.g_varchar2) then
467: p_rec.addr_attribute12 :=
468: per_kad_shd.g_old_rec.addr_attribute12;
469: End If;
470: If (p_rec.addr_attribute13 = hr_api.g_varchar2) then
471: p_rec.addr_attribute13 :=
472: per_kad_shd.g_old_rec.addr_attribute13;
473: End If;
474: If (p_rec.addr_attribute14 = hr_api.g_varchar2) then

Line 474: If (p_rec.addr_attribute14 = hr_api.g_varchar2) then

470: If (p_rec.addr_attribute13 = hr_api.g_varchar2) then
471: p_rec.addr_attribute13 :=
472: per_kad_shd.g_old_rec.addr_attribute13;
473: End If;
474: If (p_rec.addr_attribute14 = hr_api.g_varchar2) then
475: p_rec.addr_attribute14 :=
476: per_kad_shd.g_old_rec.addr_attribute14;
477: End If;
478: If (p_rec.addr_attribute15 = hr_api.g_varchar2) then

Line 478: If (p_rec.addr_attribute15 = hr_api.g_varchar2) then

474: If (p_rec.addr_attribute14 = hr_api.g_varchar2) then
475: p_rec.addr_attribute14 :=
476: per_kad_shd.g_old_rec.addr_attribute14;
477: End If;
478: If (p_rec.addr_attribute15 = hr_api.g_varchar2) then
479: p_rec.addr_attribute15 :=
480: per_kad_shd.g_old_rec.addr_attribute15;
481: End If;
482: If (p_rec.addr_attribute16 = hr_api.g_varchar2) then

Line 482: If (p_rec.addr_attribute16 = hr_api.g_varchar2) then

478: If (p_rec.addr_attribute15 = hr_api.g_varchar2) then
479: p_rec.addr_attribute15 :=
480: per_kad_shd.g_old_rec.addr_attribute15;
481: End If;
482: If (p_rec.addr_attribute16 = hr_api.g_varchar2) then
483: p_rec.addr_attribute16 :=
484: per_kad_shd.g_old_rec.addr_attribute16;
485: End If;
486: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then

Line 486: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then

482: If (p_rec.addr_attribute16 = hr_api.g_varchar2) then
483: p_rec.addr_attribute16 :=
484: per_kad_shd.g_old_rec.addr_attribute16;
485: End If;
486: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then
487: p_rec.addr_attribute17 :=
488: per_kad_shd.g_old_rec.addr_attribute17;
489: End If;
490: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then

Line 490: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then

486: If (p_rec.addr_attribute17 = hr_api.g_varchar2) then
487: p_rec.addr_attribute17 :=
488: per_kad_shd.g_old_rec.addr_attribute17;
489: End If;
490: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then
491: p_rec.addr_attribute18 :=
492: per_kad_shd.g_old_rec.addr_attribute18;
493: End If;
494: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then

Line 494: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then

490: If (p_rec.addr_attribute18 = hr_api.g_varchar2) then
491: p_rec.addr_attribute18 :=
492: per_kad_shd.g_old_rec.addr_attribute18;
493: End If;
494: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then
495: p_rec.addr_attribute19 :=
496: per_kad_shd.g_old_rec.addr_attribute19;
497: End If;
498: If (p_rec.addr_attribute20 = hr_api.g_varchar2) then

Line 498: If (p_rec.addr_attribute20 = hr_api.g_varchar2) then

494: If (p_rec.addr_attribute19 = hr_api.g_varchar2) then
495: p_rec.addr_attribute19 :=
496: per_kad_shd.g_old_rec.addr_attribute19;
497: End If;
498: If (p_rec.addr_attribute20 = hr_api.g_varchar2) then
499: p_rec.addr_attribute20 :=
500: per_kad_shd.g_old_rec.addr_attribute20;
501: End If;
502:

Line 571: Raise HR_Api.Validate_Enabled;

567: --
568: -- If we are validating then raise the Validate_Enabled exception
569: --
570: If p_validate then
571: Raise HR_Api.Validate_Enabled;
572: End If;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: Exception

Line 576: When HR_Api.Validate_Enabled Then

572: End If;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: Exception
576: When HR_Api.Validate_Enabled Then
577: --
578: -- As the Validate_Enabled exception has been raised
579: -- we must rollback to the savepoint
580: --

Line 591: ,p_date_from in date default hr_api.g_date

587: Procedure upd
588: (
589: p_address_id in number
590: -- 70.2 change a start.
591: ,p_date_from in date default hr_api.g_date
592: -- 70.2 change a end.
593: ,p_address_line1 in varchar2 default hr_api.g_varchar2
594: ,p_address_line2 in varchar2 default hr_api.g_varchar2
595: ,p_address_line3 in varchar2 default hr_api.g_varchar2

Line 593: ,p_address_line1 in varchar2 default hr_api.g_varchar2

589: p_address_id in number
590: -- 70.2 change a start.
591: ,p_date_from in date default hr_api.g_date
592: -- 70.2 change a end.
593: ,p_address_line1 in varchar2 default hr_api.g_varchar2
594: ,p_address_line2 in varchar2 default hr_api.g_varchar2
595: ,p_address_line3 in varchar2 default hr_api.g_varchar2
596: ,p_address_type in varchar2 default hr_api.g_varchar2
597: ,p_comments in clob default hr_api.g_varchar2

Line 594: ,p_address_line2 in varchar2 default hr_api.g_varchar2

590: -- 70.2 change a start.
591: ,p_date_from in date default hr_api.g_date
592: -- 70.2 change a end.
593: ,p_address_line1 in varchar2 default hr_api.g_varchar2
594: ,p_address_line2 in varchar2 default hr_api.g_varchar2
595: ,p_address_line3 in varchar2 default hr_api.g_varchar2
596: ,p_address_type in varchar2 default hr_api.g_varchar2
597: ,p_comments in clob default hr_api.g_varchar2
598: ,p_country in varchar2 default hr_api.g_varchar2

Line 595: ,p_address_line3 in varchar2 default hr_api.g_varchar2

591: ,p_date_from in date default hr_api.g_date
592: -- 70.2 change a end.
593: ,p_address_line1 in varchar2 default hr_api.g_varchar2
594: ,p_address_line2 in varchar2 default hr_api.g_varchar2
595: ,p_address_line3 in varchar2 default hr_api.g_varchar2
596: ,p_address_type in varchar2 default hr_api.g_varchar2
597: ,p_comments in clob default hr_api.g_varchar2
598: ,p_country in varchar2 default hr_api.g_varchar2
599: ,p_date_to in date default hr_api.g_date

Line 596: ,p_address_type in varchar2 default hr_api.g_varchar2

592: -- 70.2 change a end.
593: ,p_address_line1 in varchar2 default hr_api.g_varchar2
594: ,p_address_line2 in varchar2 default hr_api.g_varchar2
595: ,p_address_line3 in varchar2 default hr_api.g_varchar2
596: ,p_address_type in varchar2 default hr_api.g_varchar2
597: ,p_comments in clob default hr_api.g_varchar2
598: ,p_country in varchar2 default hr_api.g_varchar2
599: ,p_date_to in date default hr_api.g_date
600: ,p_postal_code in varchar2 default hr_api.g_varchar2

Line 597: ,p_comments in clob default hr_api.g_varchar2

593: ,p_address_line1 in varchar2 default hr_api.g_varchar2
594: ,p_address_line2 in varchar2 default hr_api.g_varchar2
595: ,p_address_line3 in varchar2 default hr_api.g_varchar2
596: ,p_address_type in varchar2 default hr_api.g_varchar2
597: ,p_comments in clob default hr_api.g_varchar2
598: ,p_country in varchar2 default hr_api.g_varchar2
599: ,p_date_to in date default hr_api.g_date
600: ,p_postal_code in varchar2 default hr_api.g_varchar2
601: ,p_region_1 in varchar2 default hr_api.g_varchar2

Line 598: ,p_country in varchar2 default hr_api.g_varchar2

594: ,p_address_line2 in varchar2 default hr_api.g_varchar2
595: ,p_address_line3 in varchar2 default hr_api.g_varchar2
596: ,p_address_type in varchar2 default hr_api.g_varchar2
597: ,p_comments in clob default hr_api.g_varchar2
598: ,p_country in varchar2 default hr_api.g_varchar2
599: ,p_date_to in date default hr_api.g_date
600: ,p_postal_code in varchar2 default hr_api.g_varchar2
601: ,p_region_1 in varchar2 default hr_api.g_varchar2
602: ,p_region_2 in varchar2 default hr_api.g_varchar2

Line 599: ,p_date_to in date default hr_api.g_date

595: ,p_address_line3 in varchar2 default hr_api.g_varchar2
596: ,p_address_type in varchar2 default hr_api.g_varchar2
597: ,p_comments in clob default hr_api.g_varchar2
598: ,p_country in varchar2 default hr_api.g_varchar2
599: ,p_date_to in date default hr_api.g_date
600: ,p_postal_code in varchar2 default hr_api.g_varchar2
601: ,p_region_1 in varchar2 default hr_api.g_varchar2
602: ,p_region_2 in varchar2 default hr_api.g_varchar2
603: ,p_region_3 in varchar2 default hr_api.g_varchar2

Line 600: ,p_postal_code in varchar2 default hr_api.g_varchar2

596: ,p_address_type in varchar2 default hr_api.g_varchar2
597: ,p_comments in clob default hr_api.g_varchar2
598: ,p_country in varchar2 default hr_api.g_varchar2
599: ,p_date_to in date default hr_api.g_date
600: ,p_postal_code in varchar2 default hr_api.g_varchar2
601: ,p_region_1 in varchar2 default hr_api.g_varchar2
602: ,p_region_2 in varchar2 default hr_api.g_varchar2
603: ,p_region_3 in varchar2 default hr_api.g_varchar2
604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

Line 601: ,p_region_1 in varchar2 default hr_api.g_varchar2

597: ,p_comments in clob default hr_api.g_varchar2
598: ,p_country in varchar2 default hr_api.g_varchar2
599: ,p_date_to in date default hr_api.g_date
600: ,p_postal_code in varchar2 default hr_api.g_varchar2
601: ,p_region_1 in varchar2 default hr_api.g_varchar2
602: ,p_region_2 in varchar2 default hr_api.g_varchar2
603: ,p_region_3 in varchar2 default hr_api.g_varchar2
604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

Line 602: ,p_region_2 in varchar2 default hr_api.g_varchar2

598: ,p_country in varchar2 default hr_api.g_varchar2
599: ,p_date_to in date default hr_api.g_date
600: ,p_postal_code in varchar2 default hr_api.g_varchar2
601: ,p_region_1 in varchar2 default hr_api.g_varchar2
602: ,p_region_2 in varchar2 default hr_api.g_varchar2
603: ,p_region_3 in varchar2 default hr_api.g_varchar2
604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

Line 603: ,p_region_3 in varchar2 default hr_api.g_varchar2

599: ,p_date_to in date default hr_api.g_date
600: ,p_postal_code in varchar2 default hr_api.g_varchar2
601: ,p_region_1 in varchar2 default hr_api.g_varchar2
602: ,p_region_2 in varchar2 default hr_api.g_varchar2
603: ,p_region_3 in varchar2 default hr_api.g_varchar2
604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
607: ,p_town_or_city in varchar2 default hr_api.g_varchar2

Line 604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2

600: ,p_postal_code in varchar2 default hr_api.g_varchar2
601: ,p_region_1 in varchar2 default hr_api.g_varchar2
602: ,p_region_2 in varchar2 default hr_api.g_varchar2
603: ,p_region_3 in varchar2 default hr_api.g_varchar2
604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
607: ,p_town_or_city in varchar2 default hr_api.g_varchar2
608: ,p_request_id in number default hr_api.g_number

Line 605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2

601: ,p_region_1 in varchar2 default hr_api.g_varchar2
602: ,p_region_2 in varchar2 default hr_api.g_varchar2
603: ,p_region_3 in varchar2 default hr_api.g_varchar2
604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
607: ,p_town_or_city in varchar2 default hr_api.g_varchar2
608: ,p_request_id in number default hr_api.g_number
609: ,p_program_application_id in number default hr_api.g_number

Line 606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2

602: ,p_region_2 in varchar2 default hr_api.g_varchar2
603: ,p_region_3 in varchar2 default hr_api.g_varchar2
604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
607: ,p_town_or_city in varchar2 default hr_api.g_varchar2
608: ,p_request_id in number default hr_api.g_number
609: ,p_program_application_id in number default hr_api.g_number
610: ,p_program_id in number default hr_api.g_number

Line 607: ,p_town_or_city in varchar2 default hr_api.g_varchar2

603: ,p_region_3 in varchar2 default hr_api.g_varchar2
604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
607: ,p_town_or_city in varchar2 default hr_api.g_varchar2
608: ,p_request_id in number default hr_api.g_number
609: ,p_program_application_id in number default hr_api.g_number
610: ,p_program_id in number default hr_api.g_number
611: ,p_program_update_date in date default hr_api.g_date

Line 608: ,p_request_id in number default hr_api.g_number

604: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
607: ,p_town_or_city in varchar2 default hr_api.g_varchar2
608: ,p_request_id in number default hr_api.g_number
609: ,p_program_application_id in number default hr_api.g_number
610: ,p_program_id in number default hr_api.g_number
611: ,p_program_update_date in date default hr_api.g_date
612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

Line 609: ,p_program_application_id in number default hr_api.g_number

605: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
607: ,p_town_or_city in varchar2 default hr_api.g_varchar2
608: ,p_request_id in number default hr_api.g_number
609: ,p_program_application_id in number default hr_api.g_number
610: ,p_program_id in number default hr_api.g_number
611: ,p_program_update_date in date default hr_api.g_date
612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

Line 610: ,p_program_id in number default hr_api.g_number

606: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
607: ,p_town_or_city in varchar2 default hr_api.g_varchar2
608: ,p_request_id in number default hr_api.g_number
609: ,p_program_application_id in number default hr_api.g_number
610: ,p_program_id in number default hr_api.g_number
611: ,p_program_update_date in date default hr_api.g_date
612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

Line 611: ,p_program_update_date in date default hr_api.g_date

607: ,p_town_or_city in varchar2 default hr_api.g_varchar2
608: ,p_request_id in number default hr_api.g_number
609: ,p_program_application_id in number default hr_api.g_number
610: ,p_program_id in number default hr_api.g_number
611: ,p_program_update_date in date default hr_api.g_date
612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

Line 612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2

608: ,p_request_id in number default hr_api.g_number
609: ,p_program_application_id in number default hr_api.g_number
610: ,p_program_id in number default hr_api.g_number
611: ,p_program_update_date in date default hr_api.g_date
612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

Line 613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2

609: ,p_program_application_id in number default hr_api.g_number
610: ,p_program_id in number default hr_api.g_number
611: ,p_program_update_date in date default hr_api.g_date
612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

Line 614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2

610: ,p_program_id in number default hr_api.g_number
611: ,p_program_update_date in date default hr_api.g_date
612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

Line 615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2

611: ,p_program_update_date in date default hr_api.g_date
612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

Line 616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2

612: ,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

Line 617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2

613: ,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

Line 618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2

614: ,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

Line 619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2

615: ,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

Line 620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2

616: ,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

Line 621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2

617: ,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

Line 622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2

618: ,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

Line 623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2

619: ,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

Line 624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2

620: ,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

Line 625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2

621: ,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
629: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

Line 626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2

622: ,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
629: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
630: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

Line 627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2

623: ,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
629: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
630: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
631: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

Line 628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2

624: ,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
629: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
630: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
631: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
632: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

Line 629: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2

625: ,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
629: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
630: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
631: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
632: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
633: ,p_object_version_number in out nocopy number

Line 630: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2

626: ,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
629: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
630: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
631: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
632: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
633: ,p_object_version_number in out nocopy number
634: ,p_validate in boolean default false

Line 631: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2

627: ,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
629: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
630: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
631: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
632: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
633: ,p_object_version_number in out nocopy number
634: ,p_validate in boolean default false
635: ,p_effective_date in date

Line 632: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2

628: ,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
629: ,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
630: ,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
631: ,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
632: ,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
633: ,p_object_version_number in out nocopy number
634: ,p_validate in boolean default false
635: ,p_effective_date in date
636: ) is

Line 652: hr_api.g_number,

648: per_kad_shd.convert_args
649: (
650: p_address_id,
651: -- 70.2 change a start.
652: hr_api.g_number,
653: hr_api.g_number,
654: p_date_from,
655: hr_api.g_varchar2,
656: hr_api.g_varchar2,

Line 653: hr_api.g_number,

649: (
650: p_address_id,
651: -- 70.2 change a start.
652: hr_api.g_number,
653: hr_api.g_number,
654: p_date_from,
655: hr_api.g_varchar2,
656: hr_api.g_varchar2,
657: -- 70.2 change a end.

Line 655: hr_api.g_varchar2,

651: -- 70.2 change a start.
652: hr_api.g_number,
653: hr_api.g_number,
654: p_date_from,
655: hr_api.g_varchar2,
656: hr_api.g_varchar2,
657: -- 70.2 change a end.
658: p_address_line1,
659: p_address_line2,

Line 656: hr_api.g_varchar2,

652: hr_api.g_number,
653: hr_api.g_number,
654: p_date_from,
655: hr_api.g_varchar2,
656: hr_api.g_varchar2,
657: -- 70.2 change a end.
658: p_address_line1,
659: p_address_line2,
660: p_address_line3,