APPS.BEN_XEL_UPD dependencies on HR_API

Line 132: When hr_api.check_integrity_violated Then

128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: --
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
135: ben_xel_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 137: When hr_api.parent_integrity_violated Then

133: -- A check constraint has been violated
134: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
135: ben_xel_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
140: ben_xel_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
140: ben_xel_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
145: ben_xel_shd.constraint_error

Line 142: When hr_api.unique_integrity_violated Then

138: -- Parent integrity has been violated
139: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
140: ben_xel_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
145: ben_xel_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
145: ben_xel_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: ben_xel_shd.g_api_dml := false; -- Unset the api dml status
149: Raise;
150: End update_dml;

Line 347: when hr_api.cannot_find_prog_unit then

343: );
344: --
345: exception
346: --
347: when hr_api.cannot_find_prog_unit then
348: --
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'ben_ext_data_elmt'
351: ,p_hook_type => 'AU');

Line 349: hr_api.cannot_find_prog_unit_error

345: exception
346: --
347: when hr_api.cannot_find_prog_unit then
348: --
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'ben_ext_data_elmt'
351: ,p_hook_type => 'AU');
352: --
353: end;

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

413: -- p_rec plsql record structure
414: -- to see if a system default is being used. If a system default
415: -- is being used then we must set to the 'current' argument value.
416: --
417: If (p_rec.name = hr_api.g_varchar2) then
418: p_rec.name :=
419: ben_xel_shd.g_old_rec.name;
420: End If;
421: If (p_rec.xml_tag_name = hr_api.g_varchar2) then

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

417: If (p_rec.name = hr_api.g_varchar2) then
418: p_rec.name :=
419: ben_xel_shd.g_old_rec.name;
420: End If;
421: If (p_rec.xml_tag_name = hr_api.g_varchar2) then
422: p_rec.xml_tag_name :=
423: ben_xel_shd.g_old_rec.xml_tag_name;
424: End If;
425: If (p_rec.data_elmt_typ_cd = hr_api.g_varchar2) then

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

421: If (p_rec.xml_tag_name = hr_api.g_varchar2) then
422: p_rec.xml_tag_name :=
423: ben_xel_shd.g_old_rec.xml_tag_name;
424: End If;
425: If (p_rec.data_elmt_typ_cd = hr_api.g_varchar2) then
426: p_rec.data_elmt_typ_cd :=
427: ben_xel_shd.g_old_rec.data_elmt_typ_cd;
428: End If;
429: If (p_rec.data_elmt_rl = hr_api.g_number) then

Line 429: If (p_rec.data_elmt_rl = hr_api.g_number) then

425: If (p_rec.data_elmt_typ_cd = hr_api.g_varchar2) then
426: p_rec.data_elmt_typ_cd :=
427: ben_xel_shd.g_old_rec.data_elmt_typ_cd;
428: End If;
429: If (p_rec.data_elmt_rl = hr_api.g_number) then
430: p_rec.data_elmt_rl :=
431: ben_xel_shd.g_old_rec.data_elmt_rl;
432: End If;
433: If (p_rec.frmt_mask_cd = hr_api.g_varchar2) then

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

429: If (p_rec.data_elmt_rl = hr_api.g_number) then
430: p_rec.data_elmt_rl :=
431: ben_xel_shd.g_old_rec.data_elmt_rl;
432: End If;
433: If (p_rec.frmt_mask_cd = hr_api.g_varchar2) then
434: p_rec.frmt_mask_cd :=
435: ben_xel_shd.g_old_rec.frmt_mask_cd;
436: End If;
437: If (p_rec.string_val = hr_api.g_varchar2) then

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

433: If (p_rec.frmt_mask_cd = hr_api.g_varchar2) then
434: p_rec.frmt_mask_cd :=
435: ben_xel_shd.g_old_rec.frmt_mask_cd;
436: End If;
437: If (p_rec.string_val = hr_api.g_varchar2) then
438: p_rec.string_val :=
439: ben_xel_shd.g_old_rec.string_val;
440: End If;
441: If (p_rec.dflt_val = hr_api.g_varchar2) then

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

437: If (p_rec.string_val = hr_api.g_varchar2) then
438: p_rec.string_val :=
439: ben_xel_shd.g_old_rec.string_val;
440: End If;
441: If (p_rec.dflt_val = hr_api.g_varchar2) then
442: p_rec.dflt_val :=
443: ben_xel_shd.g_old_rec.dflt_val;
444: End If;
445: If (p_rec.max_length_num = hr_api.g_number) then

Line 445: If (p_rec.max_length_num = hr_api.g_number) then

441: If (p_rec.dflt_val = hr_api.g_varchar2) then
442: p_rec.dflt_val :=
443: ben_xel_shd.g_old_rec.dflt_val;
444: End If;
445: If (p_rec.max_length_num = hr_api.g_number) then
446: p_rec.max_length_num :=
447: ben_xel_shd.g_old_rec.max_length_num;
448: End If;
449: if (p_rec.just_cd = hr_api.g_varchar2) then

Line 449: if (p_rec.just_cd = hr_api.g_varchar2) then

445: If (p_rec.max_length_num = hr_api.g_number) then
446: p_rec.max_length_num :=
447: ben_xel_shd.g_old_rec.max_length_num;
448: End If;
449: if (p_rec.just_cd = hr_api.g_varchar2) then
450: p_rec.just_cd :=
451: ben_xel_shd.g_old_rec.just_cd;
452: End If;
453: if (p_rec.ttl_fnctn_cd = hr_api.g_varchar2) then

Line 453: if (p_rec.ttl_fnctn_cd = hr_api.g_varchar2) then

449: if (p_rec.just_cd = hr_api.g_varchar2) then
450: p_rec.just_cd :=
451: ben_xel_shd.g_old_rec.just_cd;
452: End If;
453: if (p_rec.ttl_fnctn_cd = hr_api.g_varchar2) then
454: p_rec.ttl_fnctn_cd :=
455: ben_xel_shd.g_old_rec.ttl_fnctn_cd;
456: End If;
457: if (p_rec.ttl_cond_oper_cd = hr_api.g_varchar2) then

Line 457: if (p_rec.ttl_cond_oper_cd = hr_api.g_varchar2) then

453: if (p_rec.ttl_fnctn_cd = hr_api.g_varchar2) then
454: p_rec.ttl_fnctn_cd :=
455: ben_xel_shd.g_old_rec.ttl_fnctn_cd;
456: End If;
457: if (p_rec.ttl_cond_oper_cd = hr_api.g_varchar2) then
458: p_rec.ttl_cond_oper_cd :=
459: ben_xel_shd.g_old_rec.ttl_cond_oper_cd;
460: End If;
461: if (p_rec.ttl_cond_val = hr_api.g_varchar2) then

Line 461: if (p_rec.ttl_cond_val = hr_api.g_varchar2) then

457: if (p_rec.ttl_cond_oper_cd = hr_api.g_varchar2) then
458: p_rec.ttl_cond_oper_cd :=
459: ben_xel_shd.g_old_rec.ttl_cond_oper_cd;
460: End If;
461: if (p_rec.ttl_cond_val = hr_api.g_varchar2) then
462: p_rec.ttl_cond_val :=
463: ben_xel_shd.g_old_rec.ttl_cond_val;
464: End If;
465: If (p_rec.ttl_sum_ext_data_elmt_id = hr_api.g_number) then

Line 465: If (p_rec.ttl_sum_ext_data_elmt_id = hr_api.g_number) then

461: if (p_rec.ttl_cond_val = hr_api.g_varchar2) then
462: p_rec.ttl_cond_val :=
463: ben_xel_shd.g_old_rec.ttl_cond_val;
464: End If;
465: If (p_rec.ttl_sum_ext_data_elmt_id = hr_api.g_number) then
466: p_rec.ttl_sum_ext_data_elmt_id :=
467: ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id;
468: End If;
469: If (p_rec.ttl_cond_ext_data_elmt_id = hr_api.g_number) then

Line 469: If (p_rec.ttl_cond_ext_data_elmt_id = hr_api.g_number) then

465: If (p_rec.ttl_sum_ext_data_elmt_id = hr_api.g_number) then
466: p_rec.ttl_sum_ext_data_elmt_id :=
467: ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id;
468: End If;
469: If (p_rec.ttl_cond_ext_data_elmt_id = hr_api.g_number) then
470: p_rec.ttl_cond_ext_data_elmt_id :=
471: ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id;
472: End If;
473: If (p_rec.ext_fld_id = hr_api.g_number) then

Line 473: If (p_rec.ext_fld_id = hr_api.g_number) then

469: If (p_rec.ttl_cond_ext_data_elmt_id = hr_api.g_number) then
470: p_rec.ttl_cond_ext_data_elmt_id :=
471: ben_xel_shd.g_old_rec.ttl_cond_ext_data_elmt_id;
472: End If;
473: If (p_rec.ext_fld_id = hr_api.g_number) then
474: p_rec.ext_fld_id :=
475: ben_xel_shd.g_old_rec.ext_fld_id;
476: End If;
477: If (p_rec.business_group_id = hr_api.g_number) then

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

473: If (p_rec.ext_fld_id = hr_api.g_number) then
474: p_rec.ext_fld_id :=
475: ben_xel_shd.g_old_rec.ext_fld_id;
476: End If;
477: If (p_rec.business_group_id = hr_api.g_number) then
478: p_rec.business_group_id :=
479: ben_xel_shd.g_old_rec.business_group_id;
480: End If;
481: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

477: If (p_rec.business_group_id = hr_api.g_number) then
478: p_rec.business_group_id :=
479: ben_xel_shd.g_old_rec.business_group_id;
480: End If;
481: If (p_rec.legislation_code = hr_api.g_varchar2) then
482: p_rec.legislation_code :=
483: ben_xel_shd.g_old_rec.legislation_code;
484: End If;
485: If (p_rec.xel_attribute_category = hr_api.g_varchar2) then

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

481: If (p_rec.legislation_code = hr_api.g_varchar2) then
482: p_rec.legislation_code :=
483: ben_xel_shd.g_old_rec.legislation_code;
484: End If;
485: If (p_rec.xel_attribute_category = hr_api.g_varchar2) then
486: p_rec.xel_attribute_category :=
487: ben_xel_shd.g_old_rec.xel_attribute_category;
488: End If;
489: If (p_rec.xel_attribute1 = hr_api.g_varchar2) then

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

485: If (p_rec.xel_attribute_category = hr_api.g_varchar2) then
486: p_rec.xel_attribute_category :=
487: ben_xel_shd.g_old_rec.xel_attribute_category;
488: End If;
489: If (p_rec.xel_attribute1 = hr_api.g_varchar2) then
490: p_rec.xel_attribute1 :=
491: ben_xel_shd.g_old_rec.xel_attribute1;
492: End If;
493: If (p_rec.xel_attribute2 = hr_api.g_varchar2) then

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

489: If (p_rec.xel_attribute1 = hr_api.g_varchar2) then
490: p_rec.xel_attribute1 :=
491: ben_xel_shd.g_old_rec.xel_attribute1;
492: End If;
493: If (p_rec.xel_attribute2 = hr_api.g_varchar2) then
494: p_rec.xel_attribute2 :=
495: ben_xel_shd.g_old_rec.xel_attribute2;
496: End If;
497: If (p_rec.xel_attribute3 = hr_api.g_varchar2) then

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

493: If (p_rec.xel_attribute2 = hr_api.g_varchar2) then
494: p_rec.xel_attribute2 :=
495: ben_xel_shd.g_old_rec.xel_attribute2;
496: End If;
497: If (p_rec.xel_attribute3 = hr_api.g_varchar2) then
498: p_rec.xel_attribute3 :=
499: ben_xel_shd.g_old_rec.xel_attribute3;
500: End If;
501: If (p_rec.xel_attribute4 = hr_api.g_varchar2) then

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

497: If (p_rec.xel_attribute3 = hr_api.g_varchar2) then
498: p_rec.xel_attribute3 :=
499: ben_xel_shd.g_old_rec.xel_attribute3;
500: End If;
501: If (p_rec.xel_attribute4 = hr_api.g_varchar2) then
502: p_rec.xel_attribute4 :=
503: ben_xel_shd.g_old_rec.xel_attribute4;
504: End If;
505: If (p_rec.xel_attribute5 = hr_api.g_varchar2) then

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

501: If (p_rec.xel_attribute4 = hr_api.g_varchar2) then
502: p_rec.xel_attribute4 :=
503: ben_xel_shd.g_old_rec.xel_attribute4;
504: End If;
505: If (p_rec.xel_attribute5 = hr_api.g_varchar2) then
506: p_rec.xel_attribute5 :=
507: ben_xel_shd.g_old_rec.xel_attribute5;
508: End If;
509: If (p_rec.xel_attribute6 = hr_api.g_varchar2) then

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

505: If (p_rec.xel_attribute5 = hr_api.g_varchar2) then
506: p_rec.xel_attribute5 :=
507: ben_xel_shd.g_old_rec.xel_attribute5;
508: End If;
509: If (p_rec.xel_attribute6 = hr_api.g_varchar2) then
510: p_rec.xel_attribute6 :=
511: ben_xel_shd.g_old_rec.xel_attribute6;
512: End If;
513: If (p_rec.xel_attribute7 = hr_api.g_varchar2) then

Line 513: If (p_rec.xel_attribute7 = hr_api.g_varchar2) then

509: If (p_rec.xel_attribute6 = hr_api.g_varchar2) then
510: p_rec.xel_attribute6 :=
511: ben_xel_shd.g_old_rec.xel_attribute6;
512: End If;
513: If (p_rec.xel_attribute7 = hr_api.g_varchar2) then
514: p_rec.xel_attribute7 :=
515: ben_xel_shd.g_old_rec.xel_attribute7;
516: End If;
517: If (p_rec.xel_attribute8 = hr_api.g_varchar2) then

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

513: If (p_rec.xel_attribute7 = hr_api.g_varchar2) then
514: p_rec.xel_attribute7 :=
515: ben_xel_shd.g_old_rec.xel_attribute7;
516: End If;
517: If (p_rec.xel_attribute8 = hr_api.g_varchar2) then
518: p_rec.xel_attribute8 :=
519: ben_xel_shd.g_old_rec.xel_attribute8;
520: End If;
521: If (p_rec.xel_attribute9 = hr_api.g_varchar2) then

Line 521: If (p_rec.xel_attribute9 = hr_api.g_varchar2) then

517: If (p_rec.xel_attribute8 = hr_api.g_varchar2) then
518: p_rec.xel_attribute8 :=
519: ben_xel_shd.g_old_rec.xel_attribute8;
520: End If;
521: If (p_rec.xel_attribute9 = hr_api.g_varchar2) then
522: p_rec.xel_attribute9 :=
523: ben_xel_shd.g_old_rec.xel_attribute9;
524: End If;
525: If (p_rec.xel_attribute10 = hr_api.g_varchar2) then

Line 525: If (p_rec.xel_attribute10 = hr_api.g_varchar2) then

521: If (p_rec.xel_attribute9 = hr_api.g_varchar2) then
522: p_rec.xel_attribute9 :=
523: ben_xel_shd.g_old_rec.xel_attribute9;
524: End If;
525: If (p_rec.xel_attribute10 = hr_api.g_varchar2) then
526: p_rec.xel_attribute10 :=
527: ben_xel_shd.g_old_rec.xel_attribute10;
528: End If;
529: If (p_rec.xel_attribute11 = hr_api.g_varchar2) then

Line 529: If (p_rec.xel_attribute11 = hr_api.g_varchar2) then

525: If (p_rec.xel_attribute10 = hr_api.g_varchar2) then
526: p_rec.xel_attribute10 :=
527: ben_xel_shd.g_old_rec.xel_attribute10;
528: End If;
529: If (p_rec.xel_attribute11 = hr_api.g_varchar2) then
530: p_rec.xel_attribute11 :=
531: ben_xel_shd.g_old_rec.xel_attribute11;
532: End If;
533: If (p_rec.xel_attribute12 = hr_api.g_varchar2) then

Line 533: If (p_rec.xel_attribute12 = hr_api.g_varchar2) then

529: If (p_rec.xel_attribute11 = hr_api.g_varchar2) then
530: p_rec.xel_attribute11 :=
531: ben_xel_shd.g_old_rec.xel_attribute11;
532: End If;
533: If (p_rec.xel_attribute12 = hr_api.g_varchar2) then
534: p_rec.xel_attribute12 :=
535: ben_xel_shd.g_old_rec.xel_attribute12;
536: End If;
537: If (p_rec.xel_attribute13 = hr_api.g_varchar2) then

Line 537: If (p_rec.xel_attribute13 = hr_api.g_varchar2) then

533: If (p_rec.xel_attribute12 = hr_api.g_varchar2) then
534: p_rec.xel_attribute12 :=
535: ben_xel_shd.g_old_rec.xel_attribute12;
536: End If;
537: If (p_rec.xel_attribute13 = hr_api.g_varchar2) then
538: p_rec.xel_attribute13 :=
539: ben_xel_shd.g_old_rec.xel_attribute13;
540: End If;
541: If (p_rec.xel_attribute14 = hr_api.g_varchar2) then

Line 541: If (p_rec.xel_attribute14 = hr_api.g_varchar2) then

537: If (p_rec.xel_attribute13 = hr_api.g_varchar2) then
538: p_rec.xel_attribute13 :=
539: ben_xel_shd.g_old_rec.xel_attribute13;
540: End If;
541: If (p_rec.xel_attribute14 = hr_api.g_varchar2) then
542: p_rec.xel_attribute14 :=
543: ben_xel_shd.g_old_rec.xel_attribute14;
544: End If;
545: If (p_rec.xel_attribute15 = hr_api.g_varchar2) then

Line 545: If (p_rec.xel_attribute15 = hr_api.g_varchar2) then

541: If (p_rec.xel_attribute14 = hr_api.g_varchar2) then
542: p_rec.xel_attribute14 :=
543: ben_xel_shd.g_old_rec.xel_attribute14;
544: End If;
545: If (p_rec.xel_attribute15 = hr_api.g_varchar2) then
546: p_rec.xel_attribute15 :=
547: ben_xel_shd.g_old_rec.xel_attribute15;
548: End If;
549: If (p_rec.xel_attribute16 = hr_api.g_varchar2) then

Line 549: If (p_rec.xel_attribute16 = hr_api.g_varchar2) then

545: If (p_rec.xel_attribute15 = hr_api.g_varchar2) then
546: p_rec.xel_attribute15 :=
547: ben_xel_shd.g_old_rec.xel_attribute15;
548: End If;
549: If (p_rec.xel_attribute16 = hr_api.g_varchar2) then
550: p_rec.xel_attribute16 :=
551: ben_xel_shd.g_old_rec.xel_attribute16;
552: End If;
553: If (p_rec.xel_attribute17 = hr_api.g_varchar2) then

Line 553: If (p_rec.xel_attribute17 = hr_api.g_varchar2) then

549: If (p_rec.xel_attribute16 = hr_api.g_varchar2) then
550: p_rec.xel_attribute16 :=
551: ben_xel_shd.g_old_rec.xel_attribute16;
552: End If;
553: If (p_rec.xel_attribute17 = hr_api.g_varchar2) then
554: p_rec.xel_attribute17 :=
555: ben_xel_shd.g_old_rec.xel_attribute17;
556: End If;
557: If (p_rec.xel_attribute18 = hr_api.g_varchar2) then

Line 557: If (p_rec.xel_attribute18 = hr_api.g_varchar2) then

553: If (p_rec.xel_attribute17 = hr_api.g_varchar2) then
554: p_rec.xel_attribute17 :=
555: ben_xel_shd.g_old_rec.xel_attribute17;
556: End If;
557: If (p_rec.xel_attribute18 = hr_api.g_varchar2) then
558: p_rec.xel_attribute18 :=
559: ben_xel_shd.g_old_rec.xel_attribute18;
560: End If;
561: If (p_rec.xel_attribute19 = hr_api.g_varchar2) then

Line 561: If (p_rec.xel_attribute19 = hr_api.g_varchar2) then

557: If (p_rec.xel_attribute18 = hr_api.g_varchar2) then
558: p_rec.xel_attribute18 :=
559: ben_xel_shd.g_old_rec.xel_attribute18;
560: End If;
561: If (p_rec.xel_attribute19 = hr_api.g_varchar2) then
562: p_rec.xel_attribute19 :=
563: ben_xel_shd.g_old_rec.xel_attribute19;
564: End If;
565: If (p_rec.xel_attribute20 = hr_api.g_varchar2) then

Line 565: If (p_rec.xel_attribute20 = hr_api.g_varchar2) then

561: If (p_rec.xel_attribute19 = hr_api.g_varchar2) then
562: p_rec.xel_attribute19 :=
563: ben_xel_shd.g_old_rec.xel_attribute19;
564: End If;
565: If (p_rec.xel_attribute20 = hr_api.g_varchar2) then
566: p_rec.xel_attribute20 :=
567: ben_xel_shd.g_old_rec.xel_attribute20;
568: End If;
569: If (p_rec.xel_attribute21 = hr_api.g_varchar2) then

Line 569: If (p_rec.xel_attribute21 = hr_api.g_varchar2) then

565: If (p_rec.xel_attribute20 = hr_api.g_varchar2) then
566: p_rec.xel_attribute20 :=
567: ben_xel_shd.g_old_rec.xel_attribute20;
568: End If;
569: If (p_rec.xel_attribute21 = hr_api.g_varchar2) then
570: p_rec.xel_attribute21 :=
571: ben_xel_shd.g_old_rec.xel_attribute21;
572: End If;
573: If (p_rec.xel_attribute22 = hr_api.g_varchar2) then

Line 573: If (p_rec.xel_attribute22 = hr_api.g_varchar2) then

569: If (p_rec.xel_attribute21 = hr_api.g_varchar2) then
570: p_rec.xel_attribute21 :=
571: ben_xel_shd.g_old_rec.xel_attribute21;
572: End If;
573: If (p_rec.xel_attribute22 = hr_api.g_varchar2) then
574: p_rec.xel_attribute22 :=
575: ben_xel_shd.g_old_rec.xel_attribute22;
576: End If;
577: If (p_rec.xel_attribute23 = hr_api.g_varchar2) then

Line 577: If (p_rec.xel_attribute23 = hr_api.g_varchar2) then

573: If (p_rec.xel_attribute22 = hr_api.g_varchar2) then
574: p_rec.xel_attribute22 :=
575: ben_xel_shd.g_old_rec.xel_attribute22;
576: End If;
577: If (p_rec.xel_attribute23 = hr_api.g_varchar2) then
578: p_rec.xel_attribute23 :=
579: ben_xel_shd.g_old_rec.xel_attribute23;
580: End If;
581: If (p_rec.xel_attribute24 = hr_api.g_varchar2) then

Line 581: If (p_rec.xel_attribute24 = hr_api.g_varchar2) then

577: If (p_rec.xel_attribute23 = hr_api.g_varchar2) then
578: p_rec.xel_attribute23 :=
579: ben_xel_shd.g_old_rec.xel_attribute23;
580: End If;
581: If (p_rec.xel_attribute24 = hr_api.g_varchar2) then
582: p_rec.xel_attribute24 :=
583: ben_xel_shd.g_old_rec.xel_attribute24;
584: End If;
585: If (p_rec.xel_attribute25 = hr_api.g_varchar2) then

Line 585: If (p_rec.xel_attribute25 = hr_api.g_varchar2) then

581: If (p_rec.xel_attribute24 = hr_api.g_varchar2) then
582: p_rec.xel_attribute24 :=
583: ben_xel_shd.g_old_rec.xel_attribute24;
584: End If;
585: If (p_rec.xel_attribute25 = hr_api.g_varchar2) then
586: p_rec.xel_attribute25 :=
587: ben_xel_shd.g_old_rec.xel_attribute25;
588: End If;
589: If (p_rec.xel_attribute26 = hr_api.g_varchar2) then

Line 589: If (p_rec.xel_attribute26 = hr_api.g_varchar2) then

585: If (p_rec.xel_attribute25 = hr_api.g_varchar2) then
586: p_rec.xel_attribute25 :=
587: ben_xel_shd.g_old_rec.xel_attribute25;
588: End If;
589: If (p_rec.xel_attribute26 = hr_api.g_varchar2) then
590: p_rec.xel_attribute26 :=
591: ben_xel_shd.g_old_rec.xel_attribute26;
592: End If;
593: If (p_rec.xel_attribute27 = hr_api.g_varchar2) then

Line 593: If (p_rec.xel_attribute27 = hr_api.g_varchar2) then

589: If (p_rec.xel_attribute26 = hr_api.g_varchar2) then
590: p_rec.xel_attribute26 :=
591: ben_xel_shd.g_old_rec.xel_attribute26;
592: End If;
593: If (p_rec.xel_attribute27 = hr_api.g_varchar2) then
594: p_rec.xel_attribute27 :=
595: ben_xel_shd.g_old_rec.xel_attribute27;
596: End If;
597: If (p_rec.xel_attribute28 = hr_api.g_varchar2) then

Line 597: If (p_rec.xel_attribute28 = hr_api.g_varchar2) then

593: If (p_rec.xel_attribute27 = hr_api.g_varchar2) then
594: p_rec.xel_attribute27 :=
595: ben_xel_shd.g_old_rec.xel_attribute27;
596: End If;
597: If (p_rec.xel_attribute28 = hr_api.g_varchar2) then
598: p_rec.xel_attribute28 :=
599: ben_xel_shd.g_old_rec.xel_attribute28;
600: End If;
601: If (p_rec.xel_attribute29 = hr_api.g_varchar2) then

Line 601: If (p_rec.xel_attribute29 = hr_api.g_varchar2) then

597: If (p_rec.xel_attribute28 = hr_api.g_varchar2) then
598: p_rec.xel_attribute28 :=
599: ben_xel_shd.g_old_rec.xel_attribute28;
600: End If;
601: If (p_rec.xel_attribute29 = hr_api.g_varchar2) then
602: p_rec.xel_attribute29 :=
603: ben_xel_shd.g_old_rec.xel_attribute29;
604: End If;
605: If (p_rec.xel_attribute30 = hr_api.g_varchar2) then

Line 605: If (p_rec.xel_attribute30 = hr_api.g_varchar2) then

601: If (p_rec.xel_attribute29 = hr_api.g_varchar2) then
602: p_rec.xel_attribute29 :=
603: ben_xel_shd.g_old_rec.xel_attribute29;
604: End If;
605: If (p_rec.xel_attribute30 = hr_api.g_varchar2) then
606: p_rec.xel_attribute30 :=
607: ben_xel_shd.g_old_rec.xel_attribute30;
608: End If;
609:

Line 611: If (p_rec.defined_balance_id = hr_api.g_number) then

607: ben_xel_shd.g_old_rec.xel_attribute30;
608: End If;
609:
610:
611: If (p_rec.defined_balance_id = hr_api.g_number) then
612: p_rec.defined_balance_id :=
613: ben_xel_shd.g_old_rec.defined_balance_id;
614: End If;
615:

Line 678: p_name in varchar2 default hr_api.g_varchar2,

674: Procedure upd
675: (
676: p_effective_date in date,
677: p_ext_data_elmt_id in number,
678: p_name in varchar2 default hr_api.g_varchar2,
679: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
680: p_data_elmt_typ_cd in varchar2 default hr_api.g_varchar2,
681: p_data_elmt_rl in number default hr_api.g_number,
682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,

Line 679: p_xml_tag_name in varchar2 default hr_api.g_varchar2,

675: (
676: p_effective_date in date,
677: p_ext_data_elmt_id in number,
678: p_name in varchar2 default hr_api.g_varchar2,
679: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
680: p_data_elmt_typ_cd in varchar2 default hr_api.g_varchar2,
681: p_data_elmt_rl in number default hr_api.g_number,
682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,
683: p_string_val in varchar2 default hr_api.g_varchar2,

Line 680: p_data_elmt_typ_cd in varchar2 default hr_api.g_varchar2,

676: p_effective_date in date,
677: p_ext_data_elmt_id in number,
678: p_name in varchar2 default hr_api.g_varchar2,
679: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
680: p_data_elmt_typ_cd in varchar2 default hr_api.g_varchar2,
681: p_data_elmt_rl in number default hr_api.g_number,
682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,
683: p_string_val in varchar2 default hr_api.g_varchar2,
684: p_dflt_val in varchar2 default hr_api.g_varchar2,

Line 681: p_data_elmt_rl in number default hr_api.g_number,

677: p_ext_data_elmt_id in number,
678: p_name in varchar2 default hr_api.g_varchar2,
679: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
680: p_data_elmt_typ_cd in varchar2 default hr_api.g_varchar2,
681: p_data_elmt_rl in number default hr_api.g_number,
682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,
683: p_string_val in varchar2 default hr_api.g_varchar2,
684: p_dflt_val in varchar2 default hr_api.g_varchar2,
685: p_max_length_num in number default hr_api.g_number,

Line 682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,

678: p_name in varchar2 default hr_api.g_varchar2,
679: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
680: p_data_elmt_typ_cd in varchar2 default hr_api.g_varchar2,
681: p_data_elmt_rl in number default hr_api.g_number,
682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,
683: p_string_val in varchar2 default hr_api.g_varchar2,
684: p_dflt_val in varchar2 default hr_api.g_varchar2,
685: p_max_length_num in number default hr_api.g_number,
686: p_just_cd in varchar2 default hr_api.g_varchar2,

Line 683: p_string_val in varchar2 default hr_api.g_varchar2,

679: p_xml_tag_name in varchar2 default hr_api.g_varchar2,
680: p_data_elmt_typ_cd in varchar2 default hr_api.g_varchar2,
681: p_data_elmt_rl in number default hr_api.g_number,
682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,
683: p_string_val in varchar2 default hr_api.g_varchar2,
684: p_dflt_val in varchar2 default hr_api.g_varchar2,
685: p_max_length_num in number default hr_api.g_number,
686: p_just_cd in varchar2 default hr_api.g_varchar2,
687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2

Line 684: p_dflt_val in varchar2 default hr_api.g_varchar2,

680: p_data_elmt_typ_cd in varchar2 default hr_api.g_varchar2,
681: p_data_elmt_rl in number default hr_api.g_number,
682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,
683: p_string_val in varchar2 default hr_api.g_varchar2,
684: p_dflt_val in varchar2 default hr_api.g_varchar2,
685: p_max_length_num in number default hr_api.g_number,
686: p_just_cd in varchar2 default hr_api.g_varchar2,
687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2
688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2

Line 685: p_max_length_num in number default hr_api.g_number,

681: p_data_elmt_rl in number default hr_api.g_number,
682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,
683: p_string_val in varchar2 default hr_api.g_varchar2,
684: p_dflt_val in varchar2 default hr_api.g_varchar2,
685: p_max_length_num in number default hr_api.g_number,
686: p_just_cd in varchar2 default hr_api.g_varchar2,
687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2
688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2
689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2

Line 686: p_just_cd in varchar2 default hr_api.g_varchar2,

682: p_frmt_mask_cd in varchar2 default hr_api.g_varchar2,
683: p_string_val in varchar2 default hr_api.g_varchar2,
684: p_dflt_val in varchar2 default hr_api.g_varchar2,
685: p_max_length_num in number default hr_api.g_number,
686: p_just_cd in varchar2 default hr_api.g_varchar2,
687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2
688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2
689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2
690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number

Line 687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2

683: p_string_val in varchar2 default hr_api.g_varchar2,
684: p_dflt_val in varchar2 default hr_api.g_varchar2,
685: p_max_length_num in number default hr_api.g_number,
686: p_just_cd in varchar2 default hr_api.g_varchar2,
687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2
688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2
689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2
690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number
691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number

Line 688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2

684: p_dflt_val in varchar2 default hr_api.g_varchar2,
685: p_max_length_num in number default hr_api.g_number,
686: p_just_cd in varchar2 default hr_api.g_varchar2,
687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2
688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2
689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2
690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number
691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number
692: ,p_ext_fld_id in number default hr_api.g_number,

Line 689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2

685: p_max_length_num in number default hr_api.g_number,
686: p_just_cd in varchar2 default hr_api.g_varchar2,
687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2
688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2
689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2
690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number
691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number
692: ,p_ext_fld_id in number default hr_api.g_number,
693: p_business_group_id in number default hr_api.g_number,

Line 690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number

686: p_just_cd in varchar2 default hr_api.g_varchar2,
687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2
688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2
689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2
690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number
691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number
692: ,p_ext_fld_id in number default hr_api.g_number,
693: p_business_group_id in number default hr_api.g_number,
694: p_legislation_code in varchar2 default hr_api.g_varchar2,

Line 691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number

687: p_ttl_fnctn_cd in varchar2 default hr_api.g_varchar2
688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2
689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2
690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number
691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number
692: ,p_ext_fld_id in number default hr_api.g_number,
693: p_business_group_id in number default hr_api.g_number,
694: p_legislation_code in varchar2 default hr_api.g_varchar2,
695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,

Line 692: ,p_ext_fld_id in number default hr_api.g_number,

688: ,p_ttl_cond_oper_cd in varchar2 default hr_api.g_varchar2
689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2
690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number
691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number
692: ,p_ext_fld_id in number default hr_api.g_number,
693: p_business_group_id in number default hr_api.g_number,
694: p_legislation_code in varchar2 default hr_api.g_varchar2,
695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,
696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,

Line 693: p_business_group_id in number default hr_api.g_number,

689: ,p_ttl_cond_val in varchar2 default hr_api.g_varchar2
690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number
691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number
692: ,p_ext_fld_id in number default hr_api.g_number,
693: p_business_group_id in number default hr_api.g_number,
694: p_legislation_code in varchar2 default hr_api.g_varchar2,
695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,
696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,
697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,

Line 694: p_legislation_code in varchar2 default hr_api.g_varchar2,

690: ,p_ttl_sum_ext_data_elmt_id in number default hr_api.g_number
691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number
692: ,p_ext_fld_id in number default hr_api.g_number,
693: p_business_group_id in number default hr_api.g_number,
694: p_legislation_code in varchar2 default hr_api.g_varchar2,
695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,
696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,
697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,
698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,

Line 695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,

691: ,p_ttl_cond_ext_data_elmt_id in number default hr_api.g_number
692: ,p_ext_fld_id in number default hr_api.g_number,
693: p_business_group_id in number default hr_api.g_number,
694: p_legislation_code in varchar2 default hr_api.g_varchar2,
695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,
696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,
697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,
698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,
699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,

Line 696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,

692: ,p_ext_fld_id in number default hr_api.g_number,
693: p_business_group_id in number default hr_api.g_number,
694: p_legislation_code in varchar2 default hr_api.g_varchar2,
695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,
696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,
697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,
698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,
699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,
700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,

Line 697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,

693: p_business_group_id in number default hr_api.g_number,
694: p_legislation_code in varchar2 default hr_api.g_varchar2,
695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,
696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,
697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,
698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,
699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,
700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,
701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,

Line 698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,

694: p_legislation_code in varchar2 default hr_api.g_varchar2,
695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,
696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,
697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,
698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,
699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,
700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,
701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,
702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,

Line 699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,

695: p_xel_attribute_category in varchar2 default hr_api.g_varchar2,
696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,
697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,
698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,
699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,
700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,
701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,
702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,
703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,

Line 700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,

696: p_xel_attribute1 in varchar2 default hr_api.g_varchar2,
697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,
698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,
699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,
700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,
701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,
702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,
703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,
704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,

Line 701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,

697: p_xel_attribute2 in varchar2 default hr_api.g_varchar2,
698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,
699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,
700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,
701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,
702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,
703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,
704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,
705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,

Line 702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,

698: p_xel_attribute3 in varchar2 default hr_api.g_varchar2,
699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,
700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,
701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,
702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,
703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,
704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,
705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,
706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,

Line 703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,

699: p_xel_attribute4 in varchar2 default hr_api.g_varchar2,
700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,
701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,
702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,
703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,
704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,
705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,
706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,
707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,

Line 704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,

700: p_xel_attribute5 in varchar2 default hr_api.g_varchar2,
701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,
702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,
703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,
704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,
705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,
706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,
707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,
708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,

Line 705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,

701: p_xel_attribute6 in varchar2 default hr_api.g_varchar2,
702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,
703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,
704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,
705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,
706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,
707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,
708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,
709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,

Line 706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,

702: p_xel_attribute7 in varchar2 default hr_api.g_varchar2,
703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,
704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,
705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,
706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,
707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,
708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,
709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,
710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,

Line 707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,

703: p_xel_attribute8 in varchar2 default hr_api.g_varchar2,
704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,
705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,
706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,
707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,
708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,
709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,
710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,
711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,

Line 708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,

704: p_xel_attribute9 in varchar2 default hr_api.g_varchar2,
705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,
706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,
707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,
708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,
709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,
710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,
711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,
712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,

Line 709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,

705: p_xel_attribute10 in varchar2 default hr_api.g_varchar2,
706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,
707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,
708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,
709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,
710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,
711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,
712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,
713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,

Line 710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,

706: p_xel_attribute11 in varchar2 default hr_api.g_varchar2,
707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,
708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,
709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,
710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,
711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,
712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,
713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,
714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,

Line 711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,

707: p_xel_attribute12 in varchar2 default hr_api.g_varchar2,
708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,
709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,
710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,
711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,
712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,
713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,
714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,
715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,

Line 712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,

708: p_xel_attribute13 in varchar2 default hr_api.g_varchar2,
709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,
710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,
711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,
712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,
713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,
714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,
715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,
716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,

Line 713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,

709: p_xel_attribute14 in varchar2 default hr_api.g_varchar2,
710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,
711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,
712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,
713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,
714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,
715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,
716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,
717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,

Line 714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,

710: p_xel_attribute15 in varchar2 default hr_api.g_varchar2,
711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,
712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,
713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,
714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,
715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,
716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,
717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,
718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,

Line 715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,

711: p_xel_attribute16 in varchar2 default hr_api.g_varchar2,
712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,
713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,
714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,
715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,
716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,
717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,
718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,
719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,

Line 716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,

712: p_xel_attribute17 in varchar2 default hr_api.g_varchar2,
713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,
714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,
715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,
716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,
717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,
718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,
719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,
720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,

Line 717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,

713: p_xel_attribute18 in varchar2 default hr_api.g_varchar2,
714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,
715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,
716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,
717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,
718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,
719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,
720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,
721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,

Line 718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,

714: p_xel_attribute19 in varchar2 default hr_api.g_varchar2,
715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,
716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,
717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,
718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,
719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,
720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,
721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,
722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,

Line 719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,

715: p_xel_attribute20 in varchar2 default hr_api.g_varchar2,
716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,
717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,
718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,
719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,
720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,
721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,
722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,
723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,

Line 720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,

716: p_xel_attribute21 in varchar2 default hr_api.g_varchar2,
717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,
718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,
719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,
720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,
721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,
722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,
723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,
724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,

Line 721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,

717: p_xel_attribute22 in varchar2 default hr_api.g_varchar2,
718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,
719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,
720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,
721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,
722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,
723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,
724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,
725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,

Line 722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,

718: p_xel_attribute23 in varchar2 default hr_api.g_varchar2,
719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,
720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,
721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,
722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,
723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,
724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,
725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,
726: p_defined_balance_id in number default hr_api.g_number,

Line 723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,

719: p_xel_attribute24 in varchar2 default hr_api.g_varchar2,
720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,
721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,
722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,
723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,
724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,
725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,
726: p_defined_balance_id in number default hr_api.g_number,
727: p_last_update_date in date default hr_api.g_date,

Line 724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,

720: p_xel_attribute25 in varchar2 default hr_api.g_varchar2,
721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,
722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,
723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,
724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,
725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,
726: p_defined_balance_id in number default hr_api.g_number,
727: p_last_update_date in date default hr_api.g_date,
728: p_creation_date in date default hr_api.g_date,

Line 725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,

721: p_xel_attribute26 in varchar2 default hr_api.g_varchar2,
722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,
723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,
724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,
725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,
726: p_defined_balance_id in number default hr_api.g_number,
727: p_last_update_date in date default hr_api.g_date,
728: p_creation_date in date default hr_api.g_date,
729: p_last_updated_by in number default hr_api.g_number,

Line 726: p_defined_balance_id in number default hr_api.g_number,

722: p_xel_attribute27 in varchar2 default hr_api.g_varchar2,
723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,
724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,
725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,
726: p_defined_balance_id in number default hr_api.g_number,
727: p_last_update_date in date default hr_api.g_date,
728: p_creation_date in date default hr_api.g_date,
729: p_last_updated_by in number default hr_api.g_number,
730: p_last_update_login in number default hr_api.g_number,

Line 727: p_last_update_date in date default hr_api.g_date,

723: p_xel_attribute28 in varchar2 default hr_api.g_varchar2,
724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,
725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,
726: p_defined_balance_id in number default hr_api.g_number,
727: p_last_update_date in date default hr_api.g_date,
728: p_creation_date in date default hr_api.g_date,
729: p_last_updated_by in number default hr_api.g_number,
730: p_last_update_login in number default hr_api.g_number,
731: p_created_by in number default hr_api.g_number,

Line 728: p_creation_date in date default hr_api.g_date,

724: p_xel_attribute29 in varchar2 default hr_api.g_varchar2,
725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,
726: p_defined_balance_id in number default hr_api.g_number,
727: p_last_update_date in date default hr_api.g_date,
728: p_creation_date in date default hr_api.g_date,
729: p_last_updated_by in number default hr_api.g_number,
730: p_last_update_login in number default hr_api.g_number,
731: p_created_by in number default hr_api.g_number,
732: p_object_version_number in out nocopy number

Line 729: p_last_updated_by in number default hr_api.g_number,

725: p_xel_attribute30 in varchar2 default hr_api.g_varchar2,
726: p_defined_balance_id in number default hr_api.g_number,
727: p_last_update_date in date default hr_api.g_date,
728: p_creation_date in date default hr_api.g_date,
729: p_last_updated_by in number default hr_api.g_number,
730: p_last_update_login in number default hr_api.g_number,
731: p_created_by in number default hr_api.g_number,
732: p_object_version_number in out nocopy number
733: ) is

Line 730: p_last_update_login in number default hr_api.g_number,

726: p_defined_balance_id in number default hr_api.g_number,
727: p_last_update_date in date default hr_api.g_date,
728: p_creation_date in date default hr_api.g_date,
729: p_last_updated_by in number default hr_api.g_number,
730: p_last_update_login in number default hr_api.g_number,
731: p_created_by in number default hr_api.g_number,
732: p_object_version_number in out nocopy number
733: ) is
734: --

Line 731: p_created_by in number default hr_api.g_number,

727: p_last_update_date in date default hr_api.g_date,
728: p_creation_date in date default hr_api.g_date,
729: p_last_updated_by in number default hr_api.g_number,
730: p_last_update_login in number default hr_api.g_number,
731: p_created_by in number default hr_api.g_number,
732: p_object_version_number in out nocopy number
733: ) is
734: --
735: l_rec ben_xel_shd.g_rec_type;