APPS.PER_PHN_UPD dependencies on HR_API

Line 109: When hr_api.check_integrity_violated Then

105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: --
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: per_phn_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then

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

108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: per_phn_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: per_phn_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 113: When hr_api.parent_integrity_violated Then

109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: per_phn_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: per_phn_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then

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

112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: per_phn_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: per_phn_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 117: When hr_api.unique_integrity_violated Then

113: When hr_api.parent_integrity_violated Then
114: -- Parent integrity has been violated
115: per_phn_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: per_phn_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then

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

116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: per_phn_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: Raise;
123: End update_dml;
124: --

Line 297: when hr_api.cannot_find_prog_unit then

293: => per_phn_shd.g_old_rec.object_version_number
294: ,p_effective_date => p_effective_date
295: );
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'PER_PHONES'
300: ,p_hook_type => 'AU'
301: );

Line 298: hr_api.cannot_find_prog_unit_error

294: ,p_effective_date => p_effective_date
295: );
296: exception
297: when hr_api.cannot_find_prog_unit then
298: hr_api.cannot_find_prog_unit_error
299: (p_module_name => 'PER_PHONES'
300: ,p_hook_type => 'AU'
301: );
302: end;

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

361: -- p_rec plsql record structure
362: -- to see if a system default is being used. If a system default
363: -- is being used then we must set to the 'current' argument value.
364: --
365: If (p_rec.date_from = hr_api.g_date) then
366: p_rec.date_from :=
367: per_phn_shd.g_old_rec.date_from;
368: End If;
369: If (p_rec.date_to = hr_api.g_date) then

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

365: If (p_rec.date_from = hr_api.g_date) then
366: p_rec.date_from :=
367: per_phn_shd.g_old_rec.date_from;
368: End If;
369: If (p_rec.date_to = hr_api.g_date) then
370: p_rec.date_to :=
371: per_phn_shd.g_old_rec.date_to;
372: End If;
373: If (p_rec.phone_type = hr_api.g_varchar2) then

Line 373: If (p_rec.phone_type = hr_api.g_varchar2) then

369: If (p_rec.date_to = hr_api.g_date) then
370: p_rec.date_to :=
371: per_phn_shd.g_old_rec.date_to;
372: End If;
373: If (p_rec.phone_type = hr_api.g_varchar2) then
374: p_rec.phone_type :=
375: per_phn_shd.g_old_rec.phone_type;
376: End If;
377: If (p_rec.phone_number = hr_api.g_varchar2) then

Line 377: If (p_rec.phone_number = hr_api.g_varchar2) then

373: If (p_rec.phone_type = hr_api.g_varchar2) then
374: p_rec.phone_type :=
375: per_phn_shd.g_old_rec.phone_type;
376: End If;
377: If (p_rec.phone_number = hr_api.g_varchar2) then
378: p_rec.phone_number :=
379: per_phn_shd.g_old_rec.phone_number;
380: End If;
381: If (p_rec.parent_id = hr_api.g_number) then

Line 381: If (p_rec.parent_id = hr_api.g_number) then

377: If (p_rec.phone_number = hr_api.g_varchar2) then
378: p_rec.phone_number :=
379: per_phn_shd.g_old_rec.phone_number;
380: End If;
381: If (p_rec.parent_id = hr_api.g_number) then
382: p_rec.parent_id :=
383: per_phn_shd.g_old_rec.parent_id;
384: End If;
385: If (p_rec.parent_table = hr_api.g_varchar2) then

Line 385: If (p_rec.parent_table = hr_api.g_varchar2) then

381: If (p_rec.parent_id = hr_api.g_number) then
382: p_rec.parent_id :=
383: per_phn_shd.g_old_rec.parent_id;
384: End If;
385: If (p_rec.parent_table = hr_api.g_varchar2) then
386: p_rec.parent_table :=
387: per_phn_shd.g_old_rec.parent_table;
388: End If;
389: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 389: If (p_rec.attribute_category = hr_api.g_varchar2) then

385: If (p_rec.parent_table = hr_api.g_varchar2) then
386: p_rec.parent_table :=
387: per_phn_shd.g_old_rec.parent_table;
388: End If;
389: If (p_rec.attribute_category = hr_api.g_varchar2) then
390: p_rec.attribute_category :=
391: per_phn_shd.g_old_rec.attribute_category;
392: End If;
393: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 393: If (p_rec.attribute1 = hr_api.g_varchar2) then

389: If (p_rec.attribute_category = hr_api.g_varchar2) then
390: p_rec.attribute_category :=
391: per_phn_shd.g_old_rec.attribute_category;
392: End If;
393: If (p_rec.attribute1 = hr_api.g_varchar2) then
394: p_rec.attribute1 :=
395: per_phn_shd.g_old_rec.attribute1;
396: End If;
397: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 397: If (p_rec.attribute2 = hr_api.g_varchar2) then

393: If (p_rec.attribute1 = hr_api.g_varchar2) then
394: p_rec.attribute1 :=
395: per_phn_shd.g_old_rec.attribute1;
396: End If;
397: If (p_rec.attribute2 = hr_api.g_varchar2) then
398: p_rec.attribute2 :=
399: per_phn_shd.g_old_rec.attribute2;
400: End If;
401: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 401: If (p_rec.attribute3 = hr_api.g_varchar2) then

397: If (p_rec.attribute2 = hr_api.g_varchar2) then
398: p_rec.attribute2 :=
399: per_phn_shd.g_old_rec.attribute2;
400: End If;
401: If (p_rec.attribute3 = hr_api.g_varchar2) then
402: p_rec.attribute3 :=
403: per_phn_shd.g_old_rec.attribute3;
404: End If;
405: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 405: If (p_rec.attribute4 = hr_api.g_varchar2) then

401: If (p_rec.attribute3 = hr_api.g_varchar2) then
402: p_rec.attribute3 :=
403: per_phn_shd.g_old_rec.attribute3;
404: End If;
405: If (p_rec.attribute4 = hr_api.g_varchar2) then
406: p_rec.attribute4 :=
407: per_phn_shd.g_old_rec.attribute4;
408: End If;
409: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 409: If (p_rec.attribute5 = hr_api.g_varchar2) then

405: If (p_rec.attribute4 = hr_api.g_varchar2) then
406: p_rec.attribute4 :=
407: per_phn_shd.g_old_rec.attribute4;
408: End If;
409: If (p_rec.attribute5 = hr_api.g_varchar2) then
410: p_rec.attribute5 :=
411: per_phn_shd.g_old_rec.attribute5;
412: End If;
413: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 413: If (p_rec.attribute6 = hr_api.g_varchar2) then

409: If (p_rec.attribute5 = hr_api.g_varchar2) then
410: p_rec.attribute5 :=
411: per_phn_shd.g_old_rec.attribute5;
412: End If;
413: If (p_rec.attribute6 = hr_api.g_varchar2) then
414: p_rec.attribute6 :=
415: per_phn_shd.g_old_rec.attribute6;
416: End If;
417: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 417: If (p_rec.attribute7 = hr_api.g_varchar2) then

413: If (p_rec.attribute6 = hr_api.g_varchar2) then
414: p_rec.attribute6 :=
415: per_phn_shd.g_old_rec.attribute6;
416: End If;
417: If (p_rec.attribute7 = hr_api.g_varchar2) then
418: p_rec.attribute7 :=
419: per_phn_shd.g_old_rec.attribute7;
420: End If;
421: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 421: If (p_rec.attribute8 = hr_api.g_varchar2) then

417: If (p_rec.attribute7 = hr_api.g_varchar2) then
418: p_rec.attribute7 :=
419: per_phn_shd.g_old_rec.attribute7;
420: End If;
421: If (p_rec.attribute8 = hr_api.g_varchar2) then
422: p_rec.attribute8 :=
423: per_phn_shd.g_old_rec.attribute8;
424: End If;
425: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 425: If (p_rec.attribute9 = hr_api.g_varchar2) then

421: If (p_rec.attribute8 = hr_api.g_varchar2) then
422: p_rec.attribute8 :=
423: per_phn_shd.g_old_rec.attribute8;
424: End If;
425: If (p_rec.attribute9 = hr_api.g_varchar2) then
426: p_rec.attribute9 :=
427: per_phn_shd.g_old_rec.attribute9;
428: End If;
429: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 429: If (p_rec.attribute10 = hr_api.g_varchar2) then

425: If (p_rec.attribute9 = hr_api.g_varchar2) then
426: p_rec.attribute9 :=
427: per_phn_shd.g_old_rec.attribute9;
428: End If;
429: If (p_rec.attribute10 = hr_api.g_varchar2) then
430: p_rec.attribute10 :=
431: per_phn_shd.g_old_rec.attribute10;
432: End If;
433: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 433: If (p_rec.attribute11 = hr_api.g_varchar2) then

429: If (p_rec.attribute10 = hr_api.g_varchar2) then
430: p_rec.attribute10 :=
431: per_phn_shd.g_old_rec.attribute10;
432: End If;
433: If (p_rec.attribute11 = hr_api.g_varchar2) then
434: p_rec.attribute11 :=
435: per_phn_shd.g_old_rec.attribute11;
436: End If;
437: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 437: If (p_rec.attribute12 = hr_api.g_varchar2) then

433: If (p_rec.attribute11 = hr_api.g_varchar2) then
434: p_rec.attribute11 :=
435: per_phn_shd.g_old_rec.attribute11;
436: End If;
437: If (p_rec.attribute12 = hr_api.g_varchar2) then
438: p_rec.attribute12 :=
439: per_phn_shd.g_old_rec.attribute12;
440: End If;
441: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 441: If (p_rec.attribute13 = hr_api.g_varchar2) then

437: If (p_rec.attribute12 = hr_api.g_varchar2) then
438: p_rec.attribute12 :=
439: per_phn_shd.g_old_rec.attribute12;
440: End If;
441: If (p_rec.attribute13 = hr_api.g_varchar2) then
442: p_rec.attribute13 :=
443: per_phn_shd.g_old_rec.attribute13;
444: End If;
445: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 445: If (p_rec.attribute14 = hr_api.g_varchar2) then

441: If (p_rec.attribute13 = hr_api.g_varchar2) then
442: p_rec.attribute13 :=
443: per_phn_shd.g_old_rec.attribute13;
444: End If;
445: If (p_rec.attribute14 = hr_api.g_varchar2) then
446: p_rec.attribute14 :=
447: per_phn_shd.g_old_rec.attribute14;
448: End If;
449: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 449: If (p_rec.attribute15 = hr_api.g_varchar2) then

445: If (p_rec.attribute14 = hr_api.g_varchar2) then
446: p_rec.attribute14 :=
447: per_phn_shd.g_old_rec.attribute14;
448: End If;
449: If (p_rec.attribute15 = hr_api.g_varchar2) then
450: p_rec.attribute15 :=
451: per_phn_shd.g_old_rec.attribute15;
452: End If;
453: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 453: If (p_rec.attribute16 = hr_api.g_varchar2) then

449: If (p_rec.attribute15 = hr_api.g_varchar2) then
450: p_rec.attribute15 :=
451: per_phn_shd.g_old_rec.attribute15;
452: End If;
453: If (p_rec.attribute16 = hr_api.g_varchar2) then
454: p_rec.attribute16 :=
455: per_phn_shd.g_old_rec.attribute16;
456: End If;
457: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 457: If (p_rec.attribute17 = hr_api.g_varchar2) then

453: If (p_rec.attribute16 = hr_api.g_varchar2) then
454: p_rec.attribute16 :=
455: per_phn_shd.g_old_rec.attribute16;
456: End If;
457: If (p_rec.attribute17 = hr_api.g_varchar2) then
458: p_rec.attribute17 :=
459: per_phn_shd.g_old_rec.attribute17;
460: End If;
461: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 461: If (p_rec.attribute18 = hr_api.g_varchar2) then

457: If (p_rec.attribute17 = hr_api.g_varchar2) then
458: p_rec.attribute17 :=
459: per_phn_shd.g_old_rec.attribute17;
460: End If;
461: If (p_rec.attribute18 = hr_api.g_varchar2) then
462: p_rec.attribute18 :=
463: per_phn_shd.g_old_rec.attribute18;
464: End If;
465: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 465: If (p_rec.attribute19 = hr_api.g_varchar2) then

461: If (p_rec.attribute18 = hr_api.g_varchar2) then
462: p_rec.attribute18 :=
463: per_phn_shd.g_old_rec.attribute18;
464: End If;
465: If (p_rec.attribute19 = hr_api.g_varchar2) then
466: p_rec.attribute19 :=
467: per_phn_shd.g_old_rec.attribute19;
468: End If;
469: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 469: If (p_rec.attribute20 = hr_api.g_varchar2) then

465: If (p_rec.attribute19 = hr_api.g_varchar2) then
466: p_rec.attribute19 :=
467: per_phn_shd.g_old_rec.attribute19;
468: End If;
469: If (p_rec.attribute20 = hr_api.g_varchar2) then
470: p_rec.attribute20 :=
471: per_phn_shd.g_old_rec.attribute20;
472: End If;
473: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 473: If (p_rec.attribute21 = hr_api.g_varchar2) then

469: If (p_rec.attribute20 = hr_api.g_varchar2) then
470: p_rec.attribute20 :=
471: per_phn_shd.g_old_rec.attribute20;
472: End If;
473: If (p_rec.attribute21 = hr_api.g_varchar2) then
474: p_rec.attribute21 :=
475: per_phn_shd.g_old_rec.attribute21;
476: End If;
477: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 477: If (p_rec.attribute22 = hr_api.g_varchar2) then

473: If (p_rec.attribute21 = hr_api.g_varchar2) then
474: p_rec.attribute21 :=
475: per_phn_shd.g_old_rec.attribute21;
476: End If;
477: If (p_rec.attribute22 = hr_api.g_varchar2) then
478: p_rec.attribute22 :=
479: per_phn_shd.g_old_rec.attribute22;
480: End If;
481: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 481: If (p_rec.attribute23 = hr_api.g_varchar2) then

477: If (p_rec.attribute22 = hr_api.g_varchar2) then
478: p_rec.attribute22 :=
479: per_phn_shd.g_old_rec.attribute22;
480: End If;
481: If (p_rec.attribute23 = hr_api.g_varchar2) then
482: p_rec.attribute23 :=
483: per_phn_shd.g_old_rec.attribute23;
484: End If;
485: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 485: If (p_rec.attribute24 = hr_api.g_varchar2) then

481: If (p_rec.attribute23 = hr_api.g_varchar2) then
482: p_rec.attribute23 :=
483: per_phn_shd.g_old_rec.attribute23;
484: End If;
485: If (p_rec.attribute24 = hr_api.g_varchar2) then
486: p_rec.attribute24 :=
487: per_phn_shd.g_old_rec.attribute24;
488: End If;
489: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 489: If (p_rec.attribute25 = hr_api.g_varchar2) then

485: If (p_rec.attribute24 = hr_api.g_varchar2) then
486: p_rec.attribute24 :=
487: per_phn_shd.g_old_rec.attribute24;
488: End If;
489: If (p_rec.attribute25 = hr_api.g_varchar2) then
490: p_rec.attribute25 :=
491: per_phn_shd.g_old_rec.attribute25;
492: End If;
493: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 493: If (p_rec.attribute26 = hr_api.g_varchar2) then

489: If (p_rec.attribute25 = hr_api.g_varchar2) then
490: p_rec.attribute25 :=
491: per_phn_shd.g_old_rec.attribute25;
492: End If;
493: If (p_rec.attribute26 = hr_api.g_varchar2) then
494: p_rec.attribute26 :=
495: per_phn_shd.g_old_rec.attribute26;
496: End If;
497: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 497: If (p_rec.attribute27 = hr_api.g_varchar2) then

493: If (p_rec.attribute26 = hr_api.g_varchar2) then
494: p_rec.attribute26 :=
495: per_phn_shd.g_old_rec.attribute26;
496: End If;
497: If (p_rec.attribute27 = hr_api.g_varchar2) then
498: p_rec.attribute27 :=
499: per_phn_shd.g_old_rec.attribute27;
500: End If;
501: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 501: If (p_rec.attribute28 = hr_api.g_varchar2) then

497: If (p_rec.attribute27 = hr_api.g_varchar2) then
498: p_rec.attribute27 :=
499: per_phn_shd.g_old_rec.attribute27;
500: End If;
501: If (p_rec.attribute28 = hr_api.g_varchar2) then
502: p_rec.attribute28 :=
503: per_phn_shd.g_old_rec.attribute28;
504: End If;
505: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 505: If (p_rec.attribute29 = hr_api.g_varchar2) then

501: If (p_rec.attribute28 = hr_api.g_varchar2) then
502: p_rec.attribute28 :=
503: per_phn_shd.g_old_rec.attribute28;
504: End If;
505: If (p_rec.attribute29 = hr_api.g_varchar2) then
506: p_rec.attribute29 :=
507: per_phn_shd.g_old_rec.attribute29;
508: End If;
509: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 509: If (p_rec.attribute30 = hr_api.g_varchar2) then

505: If (p_rec.attribute29 = hr_api.g_varchar2) then
506: p_rec.attribute29 :=
507: per_phn_shd.g_old_rec.attribute29;
508: End If;
509: If (p_rec.attribute30 = hr_api.g_varchar2) then
510: p_rec.attribute30 :=
511: per_phn_shd.g_old_rec.attribute30;
512: End If;
513: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge

Line 513: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge

509: If (p_rec.attribute30 = hr_api.g_varchar2) then
510: p_rec.attribute30 :=
511: per_phn_shd.g_old_rec.attribute30;
512: End If;
513: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
514: p_rec.party_id := --
515: per_phn_shd.g_old_rec.party_id; --
516: End If;
517: If (p_rec.validity = hr_api.g_varchar2) then

Line 517: If (p_rec.validity = hr_api.g_varchar2) then

513: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
514: p_rec.party_id := --
515: per_phn_shd.g_old_rec.party_id; --
516: End If;
517: If (p_rec.validity = hr_api.g_varchar2) then
518: p_rec.validity :=
519: per_phn_shd.g_old_rec.validity;
520: End If;
521: --

Line 592: Raise HR_Api.Validate_Enabled;

588: --
589: -- If we are validating then raise the Validate_Enabled exception
590: --
591: If p_validate then
592: Raise HR_Api.Validate_Enabled;
593: End If;
594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 10);
596: Exception

Line 597: When HR_Api.Validate_Enabled Then

593: End If;
594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 10);
596: Exception
597: When HR_Api.Validate_Enabled Then
598: --
599: -- As the Validate_Enabled exception has been raised
600: -- we must rollback to the savepoint
601: --

Line 611: p_date_from in date default hr_api.g_date,

607: -- ----------------------------------------------------------------------------
608: Procedure upd
609: (
610: p_phone_id in number,
611: p_date_from in date default hr_api.g_date,
612: p_date_to in date default hr_api.g_date,
613: p_phone_type in varchar2 default hr_api.g_varchar2,
614: p_phone_number in varchar2 default hr_api.g_varchar2,
615: p_parent_id in number default hr_api.g_number,

Line 612: p_date_to in date default hr_api.g_date,

608: Procedure upd
609: (
610: p_phone_id in number,
611: p_date_from in date default hr_api.g_date,
612: p_date_to in date default hr_api.g_date,
613: p_phone_type in varchar2 default hr_api.g_varchar2,
614: p_phone_number in varchar2 default hr_api.g_varchar2,
615: p_parent_id in number default hr_api.g_number,
616: p_parent_table in varchar2 default hr_api.g_varchar2,

Line 613: p_phone_type in varchar2 default hr_api.g_varchar2,

609: (
610: p_phone_id in number,
611: p_date_from in date default hr_api.g_date,
612: p_date_to in date default hr_api.g_date,
613: p_phone_type in varchar2 default hr_api.g_varchar2,
614: p_phone_number in varchar2 default hr_api.g_varchar2,
615: p_parent_id in number default hr_api.g_number,
616: p_parent_table in varchar2 default hr_api.g_varchar2,
617: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 614: p_phone_number in varchar2 default hr_api.g_varchar2,

610: p_phone_id in number,
611: p_date_from in date default hr_api.g_date,
612: p_date_to in date default hr_api.g_date,
613: p_phone_type in varchar2 default hr_api.g_varchar2,
614: p_phone_number in varchar2 default hr_api.g_varchar2,
615: p_parent_id in number default hr_api.g_number,
616: p_parent_table in varchar2 default hr_api.g_varchar2,
617: p_attribute_category in varchar2 default hr_api.g_varchar2,
618: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 615: p_parent_id in number default hr_api.g_number,

611: p_date_from in date default hr_api.g_date,
612: p_date_to in date default hr_api.g_date,
613: p_phone_type in varchar2 default hr_api.g_varchar2,
614: p_phone_number in varchar2 default hr_api.g_varchar2,
615: p_parent_id in number default hr_api.g_number,
616: p_parent_table in varchar2 default hr_api.g_varchar2,
617: p_attribute_category in varchar2 default hr_api.g_varchar2,
618: p_attribute1 in varchar2 default hr_api.g_varchar2,
619: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 616: p_parent_table in varchar2 default hr_api.g_varchar2,

612: p_date_to in date default hr_api.g_date,
613: p_phone_type in varchar2 default hr_api.g_varchar2,
614: p_phone_number in varchar2 default hr_api.g_varchar2,
615: p_parent_id in number default hr_api.g_number,
616: p_parent_table in varchar2 default hr_api.g_varchar2,
617: p_attribute_category in varchar2 default hr_api.g_varchar2,
618: p_attribute1 in varchar2 default hr_api.g_varchar2,
619: p_attribute2 in varchar2 default hr_api.g_varchar2,
620: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 617: p_attribute_category in varchar2 default hr_api.g_varchar2,

613: p_phone_type in varchar2 default hr_api.g_varchar2,
614: p_phone_number in varchar2 default hr_api.g_varchar2,
615: p_parent_id in number default hr_api.g_number,
616: p_parent_table in varchar2 default hr_api.g_varchar2,
617: p_attribute_category in varchar2 default hr_api.g_varchar2,
618: p_attribute1 in varchar2 default hr_api.g_varchar2,
619: p_attribute2 in varchar2 default hr_api.g_varchar2,
620: p_attribute3 in varchar2 default hr_api.g_varchar2,
621: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 618: p_attribute1 in varchar2 default hr_api.g_varchar2,

614: p_phone_number in varchar2 default hr_api.g_varchar2,
615: p_parent_id in number default hr_api.g_number,
616: p_parent_table in varchar2 default hr_api.g_varchar2,
617: p_attribute_category in varchar2 default hr_api.g_varchar2,
618: p_attribute1 in varchar2 default hr_api.g_varchar2,
619: p_attribute2 in varchar2 default hr_api.g_varchar2,
620: p_attribute3 in varchar2 default hr_api.g_varchar2,
621: p_attribute4 in varchar2 default hr_api.g_varchar2,
622: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 619: p_attribute2 in varchar2 default hr_api.g_varchar2,

615: p_parent_id in number default hr_api.g_number,
616: p_parent_table in varchar2 default hr_api.g_varchar2,
617: p_attribute_category in varchar2 default hr_api.g_varchar2,
618: p_attribute1 in varchar2 default hr_api.g_varchar2,
619: p_attribute2 in varchar2 default hr_api.g_varchar2,
620: p_attribute3 in varchar2 default hr_api.g_varchar2,
621: p_attribute4 in varchar2 default hr_api.g_varchar2,
622: p_attribute5 in varchar2 default hr_api.g_varchar2,
623: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 620: p_attribute3 in varchar2 default hr_api.g_varchar2,

616: p_parent_table in varchar2 default hr_api.g_varchar2,
617: p_attribute_category in varchar2 default hr_api.g_varchar2,
618: p_attribute1 in varchar2 default hr_api.g_varchar2,
619: p_attribute2 in varchar2 default hr_api.g_varchar2,
620: p_attribute3 in varchar2 default hr_api.g_varchar2,
621: p_attribute4 in varchar2 default hr_api.g_varchar2,
622: p_attribute5 in varchar2 default hr_api.g_varchar2,
623: p_attribute6 in varchar2 default hr_api.g_varchar2,
624: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 621: p_attribute4 in varchar2 default hr_api.g_varchar2,

617: p_attribute_category in varchar2 default hr_api.g_varchar2,
618: p_attribute1 in varchar2 default hr_api.g_varchar2,
619: p_attribute2 in varchar2 default hr_api.g_varchar2,
620: p_attribute3 in varchar2 default hr_api.g_varchar2,
621: p_attribute4 in varchar2 default hr_api.g_varchar2,
622: p_attribute5 in varchar2 default hr_api.g_varchar2,
623: p_attribute6 in varchar2 default hr_api.g_varchar2,
624: p_attribute7 in varchar2 default hr_api.g_varchar2,
625: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 622: p_attribute5 in varchar2 default hr_api.g_varchar2,

618: p_attribute1 in varchar2 default hr_api.g_varchar2,
619: p_attribute2 in varchar2 default hr_api.g_varchar2,
620: p_attribute3 in varchar2 default hr_api.g_varchar2,
621: p_attribute4 in varchar2 default hr_api.g_varchar2,
622: p_attribute5 in varchar2 default hr_api.g_varchar2,
623: p_attribute6 in varchar2 default hr_api.g_varchar2,
624: p_attribute7 in varchar2 default hr_api.g_varchar2,
625: p_attribute8 in varchar2 default hr_api.g_varchar2,
626: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 623: p_attribute6 in varchar2 default hr_api.g_varchar2,

619: p_attribute2 in varchar2 default hr_api.g_varchar2,
620: p_attribute3 in varchar2 default hr_api.g_varchar2,
621: p_attribute4 in varchar2 default hr_api.g_varchar2,
622: p_attribute5 in varchar2 default hr_api.g_varchar2,
623: p_attribute6 in varchar2 default hr_api.g_varchar2,
624: p_attribute7 in varchar2 default hr_api.g_varchar2,
625: p_attribute8 in varchar2 default hr_api.g_varchar2,
626: p_attribute9 in varchar2 default hr_api.g_varchar2,
627: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 624: p_attribute7 in varchar2 default hr_api.g_varchar2,

620: p_attribute3 in varchar2 default hr_api.g_varchar2,
621: p_attribute4 in varchar2 default hr_api.g_varchar2,
622: p_attribute5 in varchar2 default hr_api.g_varchar2,
623: p_attribute6 in varchar2 default hr_api.g_varchar2,
624: p_attribute7 in varchar2 default hr_api.g_varchar2,
625: p_attribute8 in varchar2 default hr_api.g_varchar2,
626: p_attribute9 in varchar2 default hr_api.g_varchar2,
627: p_attribute10 in varchar2 default hr_api.g_varchar2,
628: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 625: p_attribute8 in varchar2 default hr_api.g_varchar2,

621: p_attribute4 in varchar2 default hr_api.g_varchar2,
622: p_attribute5 in varchar2 default hr_api.g_varchar2,
623: p_attribute6 in varchar2 default hr_api.g_varchar2,
624: p_attribute7 in varchar2 default hr_api.g_varchar2,
625: p_attribute8 in varchar2 default hr_api.g_varchar2,
626: p_attribute9 in varchar2 default hr_api.g_varchar2,
627: p_attribute10 in varchar2 default hr_api.g_varchar2,
628: p_attribute11 in varchar2 default hr_api.g_varchar2,
629: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 626: p_attribute9 in varchar2 default hr_api.g_varchar2,

622: p_attribute5 in varchar2 default hr_api.g_varchar2,
623: p_attribute6 in varchar2 default hr_api.g_varchar2,
624: p_attribute7 in varchar2 default hr_api.g_varchar2,
625: p_attribute8 in varchar2 default hr_api.g_varchar2,
626: p_attribute9 in varchar2 default hr_api.g_varchar2,
627: p_attribute10 in varchar2 default hr_api.g_varchar2,
628: p_attribute11 in varchar2 default hr_api.g_varchar2,
629: p_attribute12 in varchar2 default hr_api.g_varchar2,
630: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 627: p_attribute10 in varchar2 default hr_api.g_varchar2,

623: p_attribute6 in varchar2 default hr_api.g_varchar2,
624: p_attribute7 in varchar2 default hr_api.g_varchar2,
625: p_attribute8 in varchar2 default hr_api.g_varchar2,
626: p_attribute9 in varchar2 default hr_api.g_varchar2,
627: p_attribute10 in varchar2 default hr_api.g_varchar2,
628: p_attribute11 in varchar2 default hr_api.g_varchar2,
629: p_attribute12 in varchar2 default hr_api.g_varchar2,
630: p_attribute13 in varchar2 default hr_api.g_varchar2,
631: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 628: p_attribute11 in varchar2 default hr_api.g_varchar2,

624: p_attribute7 in varchar2 default hr_api.g_varchar2,
625: p_attribute8 in varchar2 default hr_api.g_varchar2,
626: p_attribute9 in varchar2 default hr_api.g_varchar2,
627: p_attribute10 in varchar2 default hr_api.g_varchar2,
628: p_attribute11 in varchar2 default hr_api.g_varchar2,
629: p_attribute12 in varchar2 default hr_api.g_varchar2,
630: p_attribute13 in varchar2 default hr_api.g_varchar2,
631: p_attribute14 in varchar2 default hr_api.g_varchar2,
632: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 629: p_attribute12 in varchar2 default hr_api.g_varchar2,

625: p_attribute8 in varchar2 default hr_api.g_varchar2,
626: p_attribute9 in varchar2 default hr_api.g_varchar2,
627: p_attribute10 in varchar2 default hr_api.g_varchar2,
628: p_attribute11 in varchar2 default hr_api.g_varchar2,
629: p_attribute12 in varchar2 default hr_api.g_varchar2,
630: p_attribute13 in varchar2 default hr_api.g_varchar2,
631: p_attribute14 in varchar2 default hr_api.g_varchar2,
632: p_attribute15 in varchar2 default hr_api.g_varchar2,
633: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 630: p_attribute13 in varchar2 default hr_api.g_varchar2,

626: p_attribute9 in varchar2 default hr_api.g_varchar2,
627: p_attribute10 in varchar2 default hr_api.g_varchar2,
628: p_attribute11 in varchar2 default hr_api.g_varchar2,
629: p_attribute12 in varchar2 default hr_api.g_varchar2,
630: p_attribute13 in varchar2 default hr_api.g_varchar2,
631: p_attribute14 in varchar2 default hr_api.g_varchar2,
632: p_attribute15 in varchar2 default hr_api.g_varchar2,
633: p_attribute16 in varchar2 default hr_api.g_varchar2,
634: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 631: p_attribute14 in varchar2 default hr_api.g_varchar2,

627: p_attribute10 in varchar2 default hr_api.g_varchar2,
628: p_attribute11 in varchar2 default hr_api.g_varchar2,
629: p_attribute12 in varchar2 default hr_api.g_varchar2,
630: p_attribute13 in varchar2 default hr_api.g_varchar2,
631: p_attribute14 in varchar2 default hr_api.g_varchar2,
632: p_attribute15 in varchar2 default hr_api.g_varchar2,
633: p_attribute16 in varchar2 default hr_api.g_varchar2,
634: p_attribute17 in varchar2 default hr_api.g_varchar2,
635: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 632: p_attribute15 in varchar2 default hr_api.g_varchar2,

628: p_attribute11 in varchar2 default hr_api.g_varchar2,
629: p_attribute12 in varchar2 default hr_api.g_varchar2,
630: p_attribute13 in varchar2 default hr_api.g_varchar2,
631: p_attribute14 in varchar2 default hr_api.g_varchar2,
632: p_attribute15 in varchar2 default hr_api.g_varchar2,
633: p_attribute16 in varchar2 default hr_api.g_varchar2,
634: p_attribute17 in varchar2 default hr_api.g_varchar2,
635: p_attribute18 in varchar2 default hr_api.g_varchar2,
636: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 633: p_attribute16 in varchar2 default hr_api.g_varchar2,

629: p_attribute12 in varchar2 default hr_api.g_varchar2,
630: p_attribute13 in varchar2 default hr_api.g_varchar2,
631: p_attribute14 in varchar2 default hr_api.g_varchar2,
632: p_attribute15 in varchar2 default hr_api.g_varchar2,
633: p_attribute16 in varchar2 default hr_api.g_varchar2,
634: p_attribute17 in varchar2 default hr_api.g_varchar2,
635: p_attribute18 in varchar2 default hr_api.g_varchar2,
636: p_attribute19 in varchar2 default hr_api.g_varchar2,
637: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 634: p_attribute17 in varchar2 default hr_api.g_varchar2,

630: p_attribute13 in varchar2 default hr_api.g_varchar2,
631: p_attribute14 in varchar2 default hr_api.g_varchar2,
632: p_attribute15 in varchar2 default hr_api.g_varchar2,
633: p_attribute16 in varchar2 default hr_api.g_varchar2,
634: p_attribute17 in varchar2 default hr_api.g_varchar2,
635: p_attribute18 in varchar2 default hr_api.g_varchar2,
636: p_attribute19 in varchar2 default hr_api.g_varchar2,
637: p_attribute20 in varchar2 default hr_api.g_varchar2,
638: p_attribute21 in varchar2 default hr_api.g_varchar2,

Line 635: p_attribute18 in varchar2 default hr_api.g_varchar2,

631: p_attribute14 in varchar2 default hr_api.g_varchar2,
632: p_attribute15 in varchar2 default hr_api.g_varchar2,
633: p_attribute16 in varchar2 default hr_api.g_varchar2,
634: p_attribute17 in varchar2 default hr_api.g_varchar2,
635: p_attribute18 in varchar2 default hr_api.g_varchar2,
636: p_attribute19 in varchar2 default hr_api.g_varchar2,
637: p_attribute20 in varchar2 default hr_api.g_varchar2,
638: p_attribute21 in varchar2 default hr_api.g_varchar2,
639: p_attribute22 in varchar2 default hr_api.g_varchar2,

Line 636: p_attribute19 in varchar2 default hr_api.g_varchar2,

632: p_attribute15 in varchar2 default hr_api.g_varchar2,
633: p_attribute16 in varchar2 default hr_api.g_varchar2,
634: p_attribute17 in varchar2 default hr_api.g_varchar2,
635: p_attribute18 in varchar2 default hr_api.g_varchar2,
636: p_attribute19 in varchar2 default hr_api.g_varchar2,
637: p_attribute20 in varchar2 default hr_api.g_varchar2,
638: p_attribute21 in varchar2 default hr_api.g_varchar2,
639: p_attribute22 in varchar2 default hr_api.g_varchar2,
640: p_attribute23 in varchar2 default hr_api.g_varchar2,

Line 637: p_attribute20 in varchar2 default hr_api.g_varchar2,

633: p_attribute16 in varchar2 default hr_api.g_varchar2,
634: p_attribute17 in varchar2 default hr_api.g_varchar2,
635: p_attribute18 in varchar2 default hr_api.g_varchar2,
636: p_attribute19 in varchar2 default hr_api.g_varchar2,
637: p_attribute20 in varchar2 default hr_api.g_varchar2,
638: p_attribute21 in varchar2 default hr_api.g_varchar2,
639: p_attribute22 in varchar2 default hr_api.g_varchar2,
640: p_attribute23 in varchar2 default hr_api.g_varchar2,
641: p_attribute24 in varchar2 default hr_api.g_varchar2,

Line 638: p_attribute21 in varchar2 default hr_api.g_varchar2,

634: p_attribute17 in varchar2 default hr_api.g_varchar2,
635: p_attribute18 in varchar2 default hr_api.g_varchar2,
636: p_attribute19 in varchar2 default hr_api.g_varchar2,
637: p_attribute20 in varchar2 default hr_api.g_varchar2,
638: p_attribute21 in varchar2 default hr_api.g_varchar2,
639: p_attribute22 in varchar2 default hr_api.g_varchar2,
640: p_attribute23 in varchar2 default hr_api.g_varchar2,
641: p_attribute24 in varchar2 default hr_api.g_varchar2,
642: p_attribute25 in varchar2 default hr_api.g_varchar2,

Line 639: p_attribute22 in varchar2 default hr_api.g_varchar2,

635: p_attribute18 in varchar2 default hr_api.g_varchar2,
636: p_attribute19 in varchar2 default hr_api.g_varchar2,
637: p_attribute20 in varchar2 default hr_api.g_varchar2,
638: p_attribute21 in varchar2 default hr_api.g_varchar2,
639: p_attribute22 in varchar2 default hr_api.g_varchar2,
640: p_attribute23 in varchar2 default hr_api.g_varchar2,
641: p_attribute24 in varchar2 default hr_api.g_varchar2,
642: p_attribute25 in varchar2 default hr_api.g_varchar2,
643: p_attribute26 in varchar2 default hr_api.g_varchar2,

Line 640: p_attribute23 in varchar2 default hr_api.g_varchar2,

636: p_attribute19 in varchar2 default hr_api.g_varchar2,
637: p_attribute20 in varchar2 default hr_api.g_varchar2,
638: p_attribute21 in varchar2 default hr_api.g_varchar2,
639: p_attribute22 in varchar2 default hr_api.g_varchar2,
640: p_attribute23 in varchar2 default hr_api.g_varchar2,
641: p_attribute24 in varchar2 default hr_api.g_varchar2,
642: p_attribute25 in varchar2 default hr_api.g_varchar2,
643: p_attribute26 in varchar2 default hr_api.g_varchar2,
644: p_attribute27 in varchar2 default hr_api.g_varchar2,

Line 641: p_attribute24 in varchar2 default hr_api.g_varchar2,

637: p_attribute20 in varchar2 default hr_api.g_varchar2,
638: p_attribute21 in varchar2 default hr_api.g_varchar2,
639: p_attribute22 in varchar2 default hr_api.g_varchar2,
640: p_attribute23 in varchar2 default hr_api.g_varchar2,
641: p_attribute24 in varchar2 default hr_api.g_varchar2,
642: p_attribute25 in varchar2 default hr_api.g_varchar2,
643: p_attribute26 in varchar2 default hr_api.g_varchar2,
644: p_attribute27 in varchar2 default hr_api.g_varchar2,
645: p_attribute28 in varchar2 default hr_api.g_varchar2,

Line 642: p_attribute25 in varchar2 default hr_api.g_varchar2,

638: p_attribute21 in varchar2 default hr_api.g_varchar2,
639: p_attribute22 in varchar2 default hr_api.g_varchar2,
640: p_attribute23 in varchar2 default hr_api.g_varchar2,
641: p_attribute24 in varchar2 default hr_api.g_varchar2,
642: p_attribute25 in varchar2 default hr_api.g_varchar2,
643: p_attribute26 in varchar2 default hr_api.g_varchar2,
644: p_attribute27 in varchar2 default hr_api.g_varchar2,
645: p_attribute28 in varchar2 default hr_api.g_varchar2,
646: p_attribute29 in varchar2 default hr_api.g_varchar2,

Line 643: p_attribute26 in varchar2 default hr_api.g_varchar2,

639: p_attribute22 in varchar2 default hr_api.g_varchar2,
640: p_attribute23 in varchar2 default hr_api.g_varchar2,
641: p_attribute24 in varchar2 default hr_api.g_varchar2,
642: p_attribute25 in varchar2 default hr_api.g_varchar2,
643: p_attribute26 in varchar2 default hr_api.g_varchar2,
644: p_attribute27 in varchar2 default hr_api.g_varchar2,
645: p_attribute28 in varchar2 default hr_api.g_varchar2,
646: p_attribute29 in varchar2 default hr_api.g_varchar2,
647: p_attribute30 in varchar2 default hr_api.g_varchar2,

Line 644: p_attribute27 in varchar2 default hr_api.g_varchar2,

640: p_attribute23 in varchar2 default hr_api.g_varchar2,
641: p_attribute24 in varchar2 default hr_api.g_varchar2,
642: p_attribute25 in varchar2 default hr_api.g_varchar2,
643: p_attribute26 in varchar2 default hr_api.g_varchar2,
644: p_attribute27 in varchar2 default hr_api.g_varchar2,
645: p_attribute28 in varchar2 default hr_api.g_varchar2,
646: p_attribute29 in varchar2 default hr_api.g_varchar2,
647: p_attribute30 in varchar2 default hr_api.g_varchar2,
648: p_object_version_number in out nocopy number,

Line 645: p_attribute28 in varchar2 default hr_api.g_varchar2,

641: p_attribute24 in varchar2 default hr_api.g_varchar2,
642: p_attribute25 in varchar2 default hr_api.g_varchar2,
643: p_attribute26 in varchar2 default hr_api.g_varchar2,
644: p_attribute27 in varchar2 default hr_api.g_varchar2,
645: p_attribute28 in varchar2 default hr_api.g_varchar2,
646: p_attribute29 in varchar2 default hr_api.g_varchar2,
647: p_attribute30 in varchar2 default hr_api.g_varchar2,
648: p_object_version_number in out nocopy number,
649: p_validate in boolean default false,

Line 646: p_attribute29 in varchar2 default hr_api.g_varchar2,

642: p_attribute25 in varchar2 default hr_api.g_varchar2,
643: p_attribute26 in varchar2 default hr_api.g_varchar2,
644: p_attribute27 in varchar2 default hr_api.g_varchar2,
645: p_attribute28 in varchar2 default hr_api.g_varchar2,
646: p_attribute29 in varchar2 default hr_api.g_varchar2,
647: p_attribute30 in varchar2 default hr_api.g_varchar2,
648: p_object_version_number in out nocopy number,
649: p_validate in boolean default false,
650: p_effective_date in date,

Line 647: p_attribute30 in varchar2 default hr_api.g_varchar2,

643: p_attribute26 in varchar2 default hr_api.g_varchar2,
644: p_attribute27 in varchar2 default hr_api.g_varchar2,
645: p_attribute28 in varchar2 default hr_api.g_varchar2,
646: p_attribute29 in varchar2 default hr_api.g_varchar2,
647: p_attribute30 in varchar2 default hr_api.g_varchar2,
648: p_object_version_number in out nocopy number,
649: p_validate in boolean default false,
650: p_effective_date in date,
651: p_party_id in number default hr_api.g_number,

Line 651: p_party_id in number default hr_api.g_number,

647: p_attribute30 in varchar2 default hr_api.g_varchar2,
648: p_object_version_number in out nocopy number,
649: p_validate in boolean default false,
650: p_effective_date in date,
651: p_party_id in number default hr_api.g_number,
652: p_validity in varchar2 default hr_api.g_varchar2
653: ) is
654: --
655: l_rec per_phn_shd.g_rec_type;

Line 652: p_validity in varchar2 default hr_api.g_varchar2

648: p_object_version_number in out nocopy number,
649: p_validate in boolean default false,
650: p_effective_date in date,
651: p_party_id in number default hr_api.g_number,
652: p_validity in varchar2 default hr_api.g_varchar2
653: ) is
654: --
655: l_rec per_phn_shd.g_rec_type;
656: l_proc varchar2(72) := g_package||'upd';

Line 674: -- hr_api.g_number,

670: p_phone_type,
671: p_phone_number,
672: p_parent_id,
673: p_parent_table,
674: -- hr_api.g_number,
675: -- hr_api.g_varchar2,
676: p_attribute_category,
677: p_attribute1,
678: p_attribute2,

Line 675: -- hr_api.g_varchar2,

671: p_phone_number,
672: p_parent_id,
673: p_parent_table,
674: -- hr_api.g_number,
675: -- hr_api.g_varchar2,
676: p_attribute_category,
677: p_attribute1,
678: p_attribute2,
679: p_attribute3,