DBA Data[Home] [Help]

APPS.BEN_XFI_UPD dependencies on HR_API

Line 121: When hr_api.check_integrity_violated Then

117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: --
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
124: ben_xfi_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
124: ben_xfi_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
129: ben_xfi_shd.constraint_error

Line 126: When hr_api.parent_integrity_violated Then

122: -- A check constraint has been violated
123: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
124: ben_xfi_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
129: ben_xfi_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.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
129: ben_xfi_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
134: ben_xfi_shd.constraint_error

Line 131: When hr_api.unique_integrity_violated Then

127: -- Parent integrity has been violated
128: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
129: ben_xfi_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
134: ben_xfi_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.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
134: ben_xfi_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: ben_xfi_shd.g_api_dml := false; -- Unset the api dml status
138: Raise;
139: End update_dml;

Line 312: when hr_api.cannot_find_prog_unit then

308: );
309: --
310: exception
311: --
312: when hr_api.cannot_find_prog_unit then
313: --
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'ben_ext_file'
316: ,p_hook_type => 'AU');

Line 314: hr_api.cannot_find_prog_unit_error

310: exception
311: --
312: when hr_api.cannot_find_prog_unit then
313: --
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'ben_ext_file'
316: ,p_hook_type => 'AU');
317: --
318: end;

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

378: -- p_rec plsql record structure
379: -- to see if a system default is being used. If a system default
380: -- is being used then we must set to the 'current' argument value.
381: --
382: If (p_rec.name = hr_api.g_varchar2) then
383: p_rec.name :=
384: ben_xfi_shd.g_old_rec.name;
385: End If;
386:

Line 387: If (p_rec.xml_tag_name = hr_api.g_varchar2) then

383: p_rec.name :=
384: ben_xfi_shd.g_old_rec.name;
385: End If;
386:
387: If (p_rec.xml_tag_name = hr_api.g_varchar2) then
388: p_rec.xml_tag_name :=
389: ben_xfi_shd.g_old_rec.xml_tag_name;
390: End If;
391: If (p_rec.business_group_id = hr_api.g_number) then

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

387: If (p_rec.xml_tag_name = hr_api.g_varchar2) then
388: p_rec.xml_tag_name :=
389: ben_xfi_shd.g_old_rec.xml_tag_name;
390: End If;
391: If (p_rec.business_group_id = hr_api.g_number) then
392: p_rec.business_group_id :=
393: ben_xfi_shd.g_old_rec.business_group_id;
394: End If;
395: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 395: If (p_rec.legislation_code = hr_api.g_varchar2) then

391: If (p_rec.business_group_id = hr_api.g_number) then
392: p_rec.business_group_id :=
393: ben_xfi_shd.g_old_rec.business_group_id;
394: End If;
395: If (p_rec.legislation_code = hr_api.g_varchar2) then
396: p_rec.legislation_code :=
397: ben_xfi_shd.g_old_rec.legislation_code;
398: End If;
399: If (p_rec.xfi_attribute_category = hr_api.g_varchar2) then

Line 399: If (p_rec.xfi_attribute_category = hr_api.g_varchar2) then

395: If (p_rec.legislation_code = hr_api.g_varchar2) then
396: p_rec.legislation_code :=
397: ben_xfi_shd.g_old_rec.legislation_code;
398: End If;
399: If (p_rec.xfi_attribute_category = hr_api.g_varchar2) then
400: p_rec.xfi_attribute_category :=
401: ben_xfi_shd.g_old_rec.xfi_attribute_category;
402: End If;
403: If (p_rec.xfi_attribute1 = hr_api.g_varchar2) then

Line 403: If (p_rec.xfi_attribute1 = hr_api.g_varchar2) then

399: If (p_rec.xfi_attribute_category = hr_api.g_varchar2) then
400: p_rec.xfi_attribute_category :=
401: ben_xfi_shd.g_old_rec.xfi_attribute_category;
402: End If;
403: If (p_rec.xfi_attribute1 = hr_api.g_varchar2) then
404: p_rec.xfi_attribute1 :=
405: ben_xfi_shd.g_old_rec.xfi_attribute1;
406: End If;
407: If (p_rec.xfi_attribute2 = hr_api.g_varchar2) then

Line 407: If (p_rec.xfi_attribute2 = hr_api.g_varchar2) then

403: If (p_rec.xfi_attribute1 = hr_api.g_varchar2) then
404: p_rec.xfi_attribute1 :=
405: ben_xfi_shd.g_old_rec.xfi_attribute1;
406: End If;
407: If (p_rec.xfi_attribute2 = hr_api.g_varchar2) then
408: p_rec.xfi_attribute2 :=
409: ben_xfi_shd.g_old_rec.xfi_attribute2;
410: End If;
411: If (p_rec.xfi_attribute3 = hr_api.g_varchar2) then

Line 411: If (p_rec.xfi_attribute3 = hr_api.g_varchar2) then

407: If (p_rec.xfi_attribute2 = hr_api.g_varchar2) then
408: p_rec.xfi_attribute2 :=
409: ben_xfi_shd.g_old_rec.xfi_attribute2;
410: End If;
411: If (p_rec.xfi_attribute3 = hr_api.g_varchar2) then
412: p_rec.xfi_attribute3 :=
413: ben_xfi_shd.g_old_rec.xfi_attribute3;
414: End If;
415: If (p_rec.xfi_attribute4 = hr_api.g_varchar2) then

Line 415: If (p_rec.xfi_attribute4 = hr_api.g_varchar2) then

411: If (p_rec.xfi_attribute3 = hr_api.g_varchar2) then
412: p_rec.xfi_attribute3 :=
413: ben_xfi_shd.g_old_rec.xfi_attribute3;
414: End If;
415: If (p_rec.xfi_attribute4 = hr_api.g_varchar2) then
416: p_rec.xfi_attribute4 :=
417: ben_xfi_shd.g_old_rec.xfi_attribute4;
418: End If;
419: If (p_rec.xfi_attribute5 = hr_api.g_varchar2) then

Line 419: If (p_rec.xfi_attribute5 = hr_api.g_varchar2) then

415: If (p_rec.xfi_attribute4 = hr_api.g_varchar2) then
416: p_rec.xfi_attribute4 :=
417: ben_xfi_shd.g_old_rec.xfi_attribute4;
418: End If;
419: If (p_rec.xfi_attribute5 = hr_api.g_varchar2) then
420: p_rec.xfi_attribute5 :=
421: ben_xfi_shd.g_old_rec.xfi_attribute5;
422: End If;
423: If (p_rec.xfi_attribute6 = hr_api.g_varchar2) then

Line 423: If (p_rec.xfi_attribute6 = hr_api.g_varchar2) then

419: If (p_rec.xfi_attribute5 = hr_api.g_varchar2) then
420: p_rec.xfi_attribute5 :=
421: ben_xfi_shd.g_old_rec.xfi_attribute5;
422: End If;
423: If (p_rec.xfi_attribute6 = hr_api.g_varchar2) then
424: p_rec.xfi_attribute6 :=
425: ben_xfi_shd.g_old_rec.xfi_attribute6;
426: End If;
427: If (p_rec.xfi_attribute7 = hr_api.g_varchar2) then

Line 427: If (p_rec.xfi_attribute7 = hr_api.g_varchar2) then

423: If (p_rec.xfi_attribute6 = hr_api.g_varchar2) then
424: p_rec.xfi_attribute6 :=
425: ben_xfi_shd.g_old_rec.xfi_attribute6;
426: End If;
427: If (p_rec.xfi_attribute7 = hr_api.g_varchar2) then
428: p_rec.xfi_attribute7 :=
429: ben_xfi_shd.g_old_rec.xfi_attribute7;
430: End If;
431: If (p_rec.xfi_attribute8 = hr_api.g_varchar2) then

Line 431: If (p_rec.xfi_attribute8 = hr_api.g_varchar2) then

427: If (p_rec.xfi_attribute7 = hr_api.g_varchar2) then
428: p_rec.xfi_attribute7 :=
429: ben_xfi_shd.g_old_rec.xfi_attribute7;
430: End If;
431: If (p_rec.xfi_attribute8 = hr_api.g_varchar2) then
432: p_rec.xfi_attribute8 :=
433: ben_xfi_shd.g_old_rec.xfi_attribute8;
434: End If;
435: If (p_rec.xfi_attribute9 = hr_api.g_varchar2) then

Line 435: If (p_rec.xfi_attribute9 = hr_api.g_varchar2) then

431: If (p_rec.xfi_attribute8 = hr_api.g_varchar2) then
432: p_rec.xfi_attribute8 :=
433: ben_xfi_shd.g_old_rec.xfi_attribute8;
434: End If;
435: If (p_rec.xfi_attribute9 = hr_api.g_varchar2) then
436: p_rec.xfi_attribute9 :=
437: ben_xfi_shd.g_old_rec.xfi_attribute9;
438: End If;
439: If (p_rec.xfi_attribute10 = hr_api.g_varchar2) then

Line 439: If (p_rec.xfi_attribute10 = hr_api.g_varchar2) then

435: If (p_rec.xfi_attribute9 = hr_api.g_varchar2) then
436: p_rec.xfi_attribute9 :=
437: ben_xfi_shd.g_old_rec.xfi_attribute9;
438: End If;
439: If (p_rec.xfi_attribute10 = hr_api.g_varchar2) then
440: p_rec.xfi_attribute10 :=
441: ben_xfi_shd.g_old_rec.xfi_attribute10;
442: End If;
443: If (p_rec.xfi_attribute11 = hr_api.g_varchar2) then

Line 443: If (p_rec.xfi_attribute11 = hr_api.g_varchar2) then

439: If (p_rec.xfi_attribute10 = hr_api.g_varchar2) then
440: p_rec.xfi_attribute10 :=
441: ben_xfi_shd.g_old_rec.xfi_attribute10;
442: End If;
443: If (p_rec.xfi_attribute11 = hr_api.g_varchar2) then
444: p_rec.xfi_attribute11 :=
445: ben_xfi_shd.g_old_rec.xfi_attribute11;
446: End If;
447: If (p_rec.xfi_attribute12 = hr_api.g_varchar2) then

Line 447: If (p_rec.xfi_attribute12 = hr_api.g_varchar2) then

443: If (p_rec.xfi_attribute11 = hr_api.g_varchar2) then
444: p_rec.xfi_attribute11 :=
445: ben_xfi_shd.g_old_rec.xfi_attribute11;
446: End If;
447: If (p_rec.xfi_attribute12 = hr_api.g_varchar2) then
448: p_rec.xfi_attribute12 :=
449: ben_xfi_shd.g_old_rec.xfi_attribute12;
450: End If;
451: If (p_rec.xfi_attribute13 = hr_api.g_varchar2) then

Line 451: If (p_rec.xfi_attribute13 = hr_api.g_varchar2) then

447: If (p_rec.xfi_attribute12 = hr_api.g_varchar2) then
448: p_rec.xfi_attribute12 :=
449: ben_xfi_shd.g_old_rec.xfi_attribute12;
450: End If;
451: If (p_rec.xfi_attribute13 = hr_api.g_varchar2) then
452: p_rec.xfi_attribute13 :=
453: ben_xfi_shd.g_old_rec.xfi_attribute13;
454: End If;
455: If (p_rec.xfi_attribute14 = hr_api.g_varchar2) then

Line 455: If (p_rec.xfi_attribute14 = hr_api.g_varchar2) then

451: If (p_rec.xfi_attribute13 = hr_api.g_varchar2) then
452: p_rec.xfi_attribute13 :=
453: ben_xfi_shd.g_old_rec.xfi_attribute13;
454: End If;
455: If (p_rec.xfi_attribute14 = hr_api.g_varchar2) then
456: p_rec.xfi_attribute14 :=
457: ben_xfi_shd.g_old_rec.xfi_attribute14;
458: End If;
459: If (p_rec.xfi_attribute15 = hr_api.g_varchar2) then

Line 459: If (p_rec.xfi_attribute15 = hr_api.g_varchar2) then

455: If (p_rec.xfi_attribute14 = hr_api.g_varchar2) then
456: p_rec.xfi_attribute14 :=
457: ben_xfi_shd.g_old_rec.xfi_attribute14;
458: End If;
459: If (p_rec.xfi_attribute15 = hr_api.g_varchar2) then
460: p_rec.xfi_attribute15 :=
461: ben_xfi_shd.g_old_rec.xfi_attribute15;
462: End If;
463: If (p_rec.xfi_attribute16 = hr_api.g_varchar2) then

Line 463: If (p_rec.xfi_attribute16 = hr_api.g_varchar2) then

459: If (p_rec.xfi_attribute15 = hr_api.g_varchar2) then
460: p_rec.xfi_attribute15 :=
461: ben_xfi_shd.g_old_rec.xfi_attribute15;
462: End If;
463: If (p_rec.xfi_attribute16 = hr_api.g_varchar2) then
464: p_rec.xfi_attribute16 :=
465: ben_xfi_shd.g_old_rec.xfi_attribute16;
466: End If;
467: If (p_rec.xfi_attribute17 = hr_api.g_varchar2) then

Line 467: If (p_rec.xfi_attribute17 = hr_api.g_varchar2) then

463: If (p_rec.xfi_attribute16 = hr_api.g_varchar2) then
464: p_rec.xfi_attribute16 :=
465: ben_xfi_shd.g_old_rec.xfi_attribute16;
466: End If;
467: If (p_rec.xfi_attribute17 = hr_api.g_varchar2) then
468: p_rec.xfi_attribute17 :=
469: ben_xfi_shd.g_old_rec.xfi_attribute17;
470: End If;
471: If (p_rec.xfi_attribute18 = hr_api.g_varchar2) then

Line 471: If (p_rec.xfi_attribute18 = hr_api.g_varchar2) then

467: If (p_rec.xfi_attribute17 = hr_api.g_varchar2) then
468: p_rec.xfi_attribute17 :=
469: ben_xfi_shd.g_old_rec.xfi_attribute17;
470: End If;
471: If (p_rec.xfi_attribute18 = hr_api.g_varchar2) then
472: p_rec.xfi_attribute18 :=
473: ben_xfi_shd.g_old_rec.xfi_attribute18;
474: End If;
475: If (p_rec.xfi_attribute19 = hr_api.g_varchar2) then

Line 475: If (p_rec.xfi_attribute19 = hr_api.g_varchar2) then

471: If (p_rec.xfi_attribute18 = hr_api.g_varchar2) then
472: p_rec.xfi_attribute18 :=
473: ben_xfi_shd.g_old_rec.xfi_attribute18;
474: End If;
475: If (p_rec.xfi_attribute19 = hr_api.g_varchar2) then
476: p_rec.xfi_attribute19 :=
477: ben_xfi_shd.g_old_rec.xfi_attribute19;
478: End If;
479: If (p_rec.xfi_attribute20 = hr_api.g_varchar2) then

Line 479: If (p_rec.xfi_attribute20 = hr_api.g_varchar2) then

475: If (p_rec.xfi_attribute19 = hr_api.g_varchar2) then
476: p_rec.xfi_attribute19 :=
477: ben_xfi_shd.g_old_rec.xfi_attribute19;
478: End If;
479: If (p_rec.xfi_attribute20 = hr_api.g_varchar2) then
480: p_rec.xfi_attribute20 :=
481: ben_xfi_shd.g_old_rec.xfi_attribute20;
482: End If;
483: If (p_rec.xfi_attribute21 = hr_api.g_varchar2) then

Line 483: If (p_rec.xfi_attribute21 = hr_api.g_varchar2) then

479: If (p_rec.xfi_attribute20 = hr_api.g_varchar2) then
480: p_rec.xfi_attribute20 :=
481: ben_xfi_shd.g_old_rec.xfi_attribute20;
482: End If;
483: If (p_rec.xfi_attribute21 = hr_api.g_varchar2) then
484: p_rec.xfi_attribute21 :=
485: ben_xfi_shd.g_old_rec.xfi_attribute21;
486: End If;
487: If (p_rec.xfi_attribute22 = hr_api.g_varchar2) then

Line 487: If (p_rec.xfi_attribute22 = hr_api.g_varchar2) then

483: If (p_rec.xfi_attribute21 = hr_api.g_varchar2) then
484: p_rec.xfi_attribute21 :=
485: ben_xfi_shd.g_old_rec.xfi_attribute21;
486: End If;
487: If (p_rec.xfi_attribute22 = hr_api.g_varchar2) then
488: p_rec.xfi_attribute22 :=
489: ben_xfi_shd.g_old_rec.xfi_attribute22;
490: End If;
491: If (p_rec.xfi_attribute23 = hr_api.g_varchar2) then

Line 491: If (p_rec.xfi_attribute23 = hr_api.g_varchar2) then

487: If (p_rec.xfi_attribute22 = hr_api.g_varchar2) then
488: p_rec.xfi_attribute22 :=
489: ben_xfi_shd.g_old_rec.xfi_attribute22;
490: End If;
491: If (p_rec.xfi_attribute23 = hr_api.g_varchar2) then
492: p_rec.xfi_attribute23 :=
493: ben_xfi_shd.g_old_rec.xfi_attribute23;
494: End If;
495: If (p_rec.xfi_attribute24 = hr_api.g_varchar2) then

Line 495: If (p_rec.xfi_attribute24 = hr_api.g_varchar2) then

491: If (p_rec.xfi_attribute23 = hr_api.g_varchar2) then
492: p_rec.xfi_attribute23 :=
493: ben_xfi_shd.g_old_rec.xfi_attribute23;
494: End If;
495: If (p_rec.xfi_attribute24 = hr_api.g_varchar2) then
496: p_rec.xfi_attribute24 :=
497: ben_xfi_shd.g_old_rec.xfi_attribute24;
498: End If;
499: If (p_rec.xfi_attribute25 = hr_api.g_varchar2) then

Line 499: If (p_rec.xfi_attribute25 = hr_api.g_varchar2) then

495: If (p_rec.xfi_attribute24 = hr_api.g_varchar2) then
496: p_rec.xfi_attribute24 :=
497: ben_xfi_shd.g_old_rec.xfi_attribute24;
498: End If;
499: If (p_rec.xfi_attribute25 = hr_api.g_varchar2) then
500: p_rec.xfi_attribute25 :=
501: ben_xfi_shd.g_old_rec.xfi_attribute25;
502: End If;
503: If (p_rec.xfi_attribute26 = hr_api.g_varchar2) then

Line 503: If (p_rec.xfi_attribute26 = hr_api.g_varchar2) then

499: If (p_rec.xfi_attribute25 = hr_api.g_varchar2) then
500: p_rec.xfi_attribute25 :=
501: ben_xfi_shd.g_old_rec.xfi_attribute25;
502: End If;
503: If (p_rec.xfi_attribute26 = hr_api.g_varchar2) then
504: p_rec.xfi_attribute26 :=
505: ben_xfi_shd.g_old_rec.xfi_attribute26;
506: End If;
507: If (p_rec.xfi_attribute27 = hr_api.g_varchar2) then

Line 507: If (p_rec.xfi_attribute27 = hr_api.g_varchar2) then

503: If (p_rec.xfi_attribute26 = hr_api.g_varchar2) then
504: p_rec.xfi_attribute26 :=
505: ben_xfi_shd.g_old_rec.xfi_attribute26;
506: End If;
507: If (p_rec.xfi_attribute27 = hr_api.g_varchar2) then
508: p_rec.xfi_attribute27 :=
509: ben_xfi_shd.g_old_rec.xfi_attribute27;
510: End If;
511: If (p_rec.xfi_attribute28 = hr_api.g_varchar2) then

Line 511: If (p_rec.xfi_attribute28 = hr_api.g_varchar2) then

507: If (p_rec.xfi_attribute27 = hr_api.g_varchar2) then
508: p_rec.xfi_attribute27 :=
509: ben_xfi_shd.g_old_rec.xfi_attribute27;
510: End If;
511: If (p_rec.xfi_attribute28 = hr_api.g_varchar2) then
512: p_rec.xfi_attribute28 :=
513: ben_xfi_shd.g_old_rec.xfi_attribute28;
514: End If;
515: If (p_rec.xfi_attribute29 = hr_api.g_varchar2) then

Line 515: If (p_rec.xfi_attribute29 = hr_api.g_varchar2) then

511: If (p_rec.xfi_attribute28 = hr_api.g_varchar2) then
512: p_rec.xfi_attribute28 :=
513: ben_xfi_shd.g_old_rec.xfi_attribute28;
514: End If;
515: If (p_rec.xfi_attribute29 = hr_api.g_varchar2) then
516: p_rec.xfi_attribute29 :=
517: ben_xfi_shd.g_old_rec.xfi_attribute29;
518: End If;
519: If (p_rec.xfi_attribute30 = hr_api.g_varchar2) then

Line 519: If (p_rec.xfi_attribute30 = hr_api.g_varchar2) then

515: If (p_rec.xfi_attribute29 = hr_api.g_varchar2) then
516: p_rec.xfi_attribute29 :=
517: ben_xfi_shd.g_old_rec.xfi_attribute29;
518: End If;
519: If (p_rec.xfi_attribute30 = hr_api.g_varchar2) then
520: p_rec.xfi_attribute30 :=
521: ben_xfi_shd.g_old_rec.xfi_attribute30;
522: End If;
523:

Line 524: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then

520: p_rec.xfi_attribute30 :=
521: ben_xfi_shd.g_old_rec.xfi_attribute30;
522: End If;
523:
524: If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
525: p_rec.ext_rcd_in_file_id :=
526: ben_xfi_shd.g_old_rec.ext_rcd_in_file_id;
527: End If;
528:

Line 529: If (p_rec.ext_data_elmt_in_rcd_id1 = hr_api.g_number) then

525: p_rec.ext_rcd_in_file_id :=
526: ben_xfi_shd.g_old_rec.ext_rcd_in_file_id;
527: End If;
528:
529: If (p_rec.ext_data_elmt_in_rcd_id1 = hr_api.g_number) then
530: p_rec.ext_data_elmt_in_rcd_id1 :=
531: ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1;
532: End If;
533:

Line 534: If (p_rec.ext_data_elmt_in_rcd_id2 = hr_api.g_number) then

530: p_rec.ext_data_elmt_in_rcd_id1 :=
531: ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id1;
532: End If;
533:
534: If (p_rec.ext_data_elmt_in_rcd_id2 = hr_api.g_number) then
535: p_rec.ext_data_elmt_in_rcd_id2 :=
536: ben_xfi_shd.g_old_rec.ext_data_elmt_in_rcd_id2;
537: End If;
538: --

Line 596: p_name in varchar2 default hr_api.g_varchar2,

592: -- ----------------------------------------------------------------------------
593: Procedure upd
594: (
595: p_ext_file_id in number,
596: p_name in varchar2 default hr_api.g_varchar2,
597: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_legislation_code in varchar2 default hr_api.g_varchar2,
600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,

Line 597: p_xml_tag_name in varchar2 default hr_api.g_varchar2,

593: Procedure upd
594: (
595: p_ext_file_id in number,
596: p_name in varchar2 default hr_api.g_varchar2,
597: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_legislation_code in varchar2 default hr_api.g_varchar2,
600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,
601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,

Line 598: p_business_group_id in number default hr_api.g_number,

594: (
595: p_ext_file_id in number,
596: p_name in varchar2 default hr_api.g_varchar2,
597: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_legislation_code in varchar2 default hr_api.g_varchar2,
600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,
601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,
602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,

Line 599: p_legislation_code in varchar2 default hr_api.g_varchar2,

595: p_ext_file_id in number,
596: p_name in varchar2 default hr_api.g_varchar2,
597: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_legislation_code in varchar2 default hr_api.g_varchar2,
600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,
601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,
602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,
603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,

Line 600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,

596: p_name in varchar2 default hr_api.g_varchar2,
597: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_legislation_code in varchar2 default hr_api.g_varchar2,
600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,
601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,
602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,
603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,
604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,

Line 601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,

597: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
598: p_business_group_id in number default hr_api.g_number,
599: p_legislation_code in varchar2 default hr_api.g_varchar2,
600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,
601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,
602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,
603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,
604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,
605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,

Line 602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,

598: p_business_group_id in number default hr_api.g_number,
599: p_legislation_code in varchar2 default hr_api.g_varchar2,
600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,
601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,
602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,
603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,
604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,
605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,
606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,

Line 603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,

599: p_legislation_code in varchar2 default hr_api.g_varchar2,
600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,
601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,
602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,
603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,
604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,
605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,
606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,
607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,

Line 604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,

600: p_xfi_attribute_category in varchar2 default hr_api.g_varchar2,
601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,
602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,
603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,
604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,
605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,
606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,
607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,
608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,

Line 605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,

601: p_xfi_attribute1 in varchar2 default hr_api.g_varchar2,
602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,
603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,
604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,
605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,
606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,
607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,
608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,
609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,

Line 606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,

602: p_xfi_attribute2 in varchar2 default hr_api.g_varchar2,
603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,
604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,
605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,
606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,
607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,
608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,
609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,
610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,

Line 607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,

603: p_xfi_attribute3 in varchar2 default hr_api.g_varchar2,
604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,
605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,
606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,
607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,
608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,
609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,
610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,
611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,

Line 608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,

604: p_xfi_attribute4 in varchar2 default hr_api.g_varchar2,
605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,
606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,
607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,
608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,
609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,
610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,
611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,
612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,

Line 609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,

605: p_xfi_attribute5 in varchar2 default hr_api.g_varchar2,
606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,
607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,
608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,
609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,
610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,
611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,
612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,
613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,

Line 610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,

606: p_xfi_attribute6 in varchar2 default hr_api.g_varchar2,
607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,
608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,
609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,
610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,
611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,
612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,
613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,
614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,

Line 611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,

607: p_xfi_attribute7 in varchar2 default hr_api.g_varchar2,
608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,
609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,
610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,
611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,
612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,
613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,
614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,
615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,

Line 612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,

608: p_xfi_attribute8 in varchar2 default hr_api.g_varchar2,
609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,
610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,
611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,
612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,
613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,
614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,
615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,
616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,

Line 613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,

609: p_xfi_attribute9 in varchar2 default hr_api.g_varchar2,
610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,
611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,
612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,
613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,
614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,
615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,
616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,
617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,

Line 614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,

610: p_xfi_attribute10 in varchar2 default hr_api.g_varchar2,
611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,
612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,
613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,
614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,
615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,
616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,
617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,
618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,

Line 615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,

611: p_xfi_attribute11 in varchar2 default hr_api.g_varchar2,
612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,
613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,
614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,
615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,
616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,
617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,
618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,
619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,

Line 616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,

612: p_xfi_attribute12 in varchar2 default hr_api.g_varchar2,
613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,
614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,
615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,
616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,
617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,
618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,
619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,
620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,

Line 617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,

613: p_xfi_attribute13 in varchar2 default hr_api.g_varchar2,
614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,
615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,
616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,
617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,
618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,
619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,
620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,
621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,

Line 618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,

614: p_xfi_attribute14 in varchar2 default hr_api.g_varchar2,
615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,
616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,
617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,
618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,
619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,
620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,
621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,
622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,

Line 619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,

615: p_xfi_attribute15 in varchar2 default hr_api.g_varchar2,
616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,
617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,
618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,
619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,
620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,
621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,
622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,
623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,

Line 620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,

616: p_xfi_attribute16 in varchar2 default hr_api.g_varchar2,
617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,
618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,
619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,
620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,
621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,
622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,
623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,
624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,

Line 621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,

617: p_xfi_attribute17 in varchar2 default hr_api.g_varchar2,
618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,
619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,
620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,
621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,
622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,
623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,
624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,
625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,

Line 622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,

618: p_xfi_attribute18 in varchar2 default hr_api.g_varchar2,
619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,
620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,
621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,
622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,
623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,
624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,
625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,
626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,

Line 623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,

619: p_xfi_attribute19 in varchar2 default hr_api.g_varchar2,
620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,
621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,
622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,
623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,
624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,
625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,
626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,
627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,

Line 624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,

620: p_xfi_attribute20 in varchar2 default hr_api.g_varchar2,
621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,
622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,
623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,
624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,
625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,
626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,
627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,
628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,

Line 625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,

621: p_xfi_attribute21 in varchar2 default hr_api.g_varchar2,
622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,
623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,
624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,
625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,
626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,
627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,
628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,
629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,

Line 626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,

622: p_xfi_attribute22 in varchar2 default hr_api.g_varchar2,
623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,
624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,
625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,
626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,
627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,
628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,
629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,
630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,

Line 627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,

623: p_xfi_attribute23 in varchar2 default hr_api.g_varchar2,
624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,
625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,
626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,
627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,
628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,
629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,
630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,
631: p_ext_rcd_in_file_id in number default hr_api.g_number,

Line 628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,

624: p_xfi_attribute24 in varchar2 default hr_api.g_varchar2,
625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,
626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,
627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,
628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,
629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,
630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,
631: p_ext_rcd_in_file_id in number default hr_api.g_number,
632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,

Line 629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,

625: p_xfi_attribute25 in varchar2 default hr_api.g_varchar2,
626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,
627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,
628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,
629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,
630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,
631: p_ext_rcd_in_file_id in number default hr_api.g_number,
632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,
633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,

Line 630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,

626: p_xfi_attribute26 in varchar2 default hr_api.g_varchar2,
627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,
628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,
629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,
630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,
631: p_ext_rcd_in_file_id in number default hr_api.g_number,
632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,
633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,
634: p_last_update_date in date default hr_api.g_date,

Line 631: p_ext_rcd_in_file_id in number default hr_api.g_number,

627: p_xfi_attribute27 in varchar2 default hr_api.g_varchar2,
628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,
629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,
630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,
631: p_ext_rcd_in_file_id in number default hr_api.g_number,
632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,
633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,
634: p_last_update_date in date default hr_api.g_date,
635: p_creation_date in date default hr_api.g_date,

Line 632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,

628: p_xfi_attribute28 in varchar2 default hr_api.g_varchar2,
629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,
630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,
631: p_ext_rcd_in_file_id in number default hr_api.g_number,
632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,
633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,
634: p_last_update_date in date default hr_api.g_date,
635: p_creation_date in date default hr_api.g_date,
636: p_last_updated_by in number default hr_api.g_number,

Line 633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,

629: p_xfi_attribute29 in varchar2 default hr_api.g_varchar2,
630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,
631: p_ext_rcd_in_file_id in number default hr_api.g_number,
632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,
633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,
634: p_last_update_date in date default hr_api.g_date,
635: p_creation_date in date default hr_api.g_date,
636: p_last_updated_by in number default hr_api.g_number,
637: p_last_update_login in number default hr_api.g_number,

Line 634: p_last_update_date in date default hr_api.g_date,

630: p_xfi_attribute30 in varchar2 default hr_api.g_varchar2,
631: p_ext_rcd_in_file_id in number default hr_api.g_number,
632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,
633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,
634: p_last_update_date in date default hr_api.g_date,
635: p_creation_date in date default hr_api.g_date,
636: p_last_updated_by in number default hr_api.g_number,
637: p_last_update_login in number default hr_api.g_number,
638: p_created_by in number default hr_api.g_number,

Line 635: p_creation_date in date default hr_api.g_date,

631: p_ext_rcd_in_file_id in number default hr_api.g_number,
632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,
633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,
634: p_last_update_date in date default hr_api.g_date,
635: p_creation_date in date default hr_api.g_date,
636: p_last_updated_by in number default hr_api.g_number,
637: p_last_update_login in number default hr_api.g_number,
638: p_created_by in number default hr_api.g_number,
639: p_object_version_number in out nocopy number

Line 636: p_last_updated_by in number default hr_api.g_number,

632: p_ext_data_elmt_in_rcd_id1 in number default hr_api.g_number ,
633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,
634: p_last_update_date in date default hr_api.g_date,
635: p_creation_date in date default hr_api.g_date,
636: p_last_updated_by in number default hr_api.g_number,
637: p_last_update_login in number default hr_api.g_number,
638: p_created_by in number default hr_api.g_number,
639: p_object_version_number in out nocopy number
640: ) is

Line 637: p_last_update_login in number default hr_api.g_number,

633: p_ext_data_elmt_in_rcd_id2 in number default hr_api.g_number ,
634: p_last_update_date in date default hr_api.g_date,
635: p_creation_date in date default hr_api.g_date,
636: p_last_updated_by in number default hr_api.g_number,
637: p_last_update_login in number default hr_api.g_number,
638: p_created_by in number default hr_api.g_number,
639: p_object_version_number in out nocopy number
640: ) is
641: --

Line 638: p_created_by in number default hr_api.g_number,

634: p_last_update_date in date default hr_api.g_date,
635: p_creation_date in date default hr_api.g_date,
636: p_last_updated_by in number default hr_api.g_number,
637: p_last_update_login in number default hr_api.g_number,
638: p_created_by in number default hr_api.g_number,
639: p_object_version_number in out nocopy number
640: ) is
641: --
642: l_rec ben_xfi_shd.g_rec_type;