118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: --
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: pay_con_shd.g_api_dml := false; -- Unset the api dml status
125: pay_con_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: pay_con_shd.g_api_dml := false; -- Unset the api dml status
125: pay_con_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: pay_con_shd.g_api_dml := false; -- Unset the api dml status
130: pay_con_shd.constraint_error
123: -- A check constraint has been violated
124: pay_con_shd.g_api_dml := false; -- Unset the api dml status
125: pay_con_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: pay_con_shd.g_api_dml := false; -- Unset the api dml status
130: pay_con_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: pay_con_shd.g_api_dml := false; -- Unset the api dml status
130: pay_con_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: pay_con_shd.g_api_dml := false; -- Unset the api dml status
135: pay_con_shd.constraint_error
128: -- Parent integrity has been violated
129: pay_con_shd.g_api_dml := false; -- Unset the api dml status
130: pay_con_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: pay_con_shd.g_api_dml := false; -- Unset the api dml status
135: pay_con_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: pay_con_shd.g_api_dml := false; -- Unset the api dml status
135: pay_con_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: pay_con_shd.g_api_dml := false; -- Unset the api dml status
139: Raise;
140: End update_dml;
317: );
318: --
319: exception
320: --
321: when hr_api.cannot_find_prog_unit then
322: --
323: hr_api.cannot_find_prog_unit_error
324: (p_module_name => 'pay_contribution_history'
325: ,p_hook_type => 'AU');
319: exception
320: --
321: when hr_api.cannot_find_prog_unit then
322: --
323: hr_api.cannot_find_prog_unit_error
324: (p_module_name => 'pay_contribution_history'
325: ,p_hook_type => 'AU');
326: --
327: end;
387: -- p_rec plsql record structure
388: -- to see if a system default is being used. If a system default
389: -- is being used then we must set to the 'current' argument value.
390: --
391: If (p_rec.person_id = hr_api.g_number) then
392: p_rec.person_id :=
393: pay_con_shd.g_old_rec.person_id;
394: End If;
395: If (p_rec.date_from = hr_api.g_date) then
391: If (p_rec.person_id = hr_api.g_number) then
392: p_rec.person_id :=
393: pay_con_shd.g_old_rec.person_id;
394: End If;
395: If (p_rec.date_from = hr_api.g_date) then
396: p_rec.date_from :=
397: pay_con_shd.g_old_rec.date_from;
398: End If;
399: If (p_rec.date_to = hr_api.g_date) then
395: If (p_rec.date_from = hr_api.g_date) then
396: p_rec.date_from :=
397: pay_con_shd.g_old_rec.date_from;
398: End If;
399: If (p_rec.date_to = hr_api.g_date) then
400: p_rec.date_to :=
401: pay_con_shd.g_old_rec.date_to;
402: End If;
403: If (p_rec.contr_type = hr_api.g_varchar2) then
399: If (p_rec.date_to = hr_api.g_date) then
400: p_rec.date_to :=
401: pay_con_shd.g_old_rec.date_to;
402: End If;
403: If (p_rec.contr_type = hr_api.g_varchar2) then
404: p_rec.contr_type :=
405: pay_con_shd.g_old_rec.contr_type;
406: End If;
407: If (p_rec.business_group_id = hr_api.g_number) then
403: If (p_rec.contr_type = hr_api.g_varchar2) then
404: p_rec.contr_type :=
405: pay_con_shd.g_old_rec.contr_type;
406: End If;
407: If (p_rec.business_group_id = hr_api.g_number) then
408: p_rec.business_group_id :=
409: pay_con_shd.g_old_rec.business_group_id;
410: End If;
411: If (p_rec.legislation_code = hr_api.g_varchar2) then
407: If (p_rec.business_group_id = hr_api.g_number) then
408: p_rec.business_group_id :=
409: pay_con_shd.g_old_rec.business_group_id;
410: End If;
411: If (p_rec.legislation_code = hr_api.g_varchar2) then
412: p_rec.legislation_code :=
413: pay_con_shd.g_old_rec.legislation_code;
414: End If;
415: If (p_rec.amt_contr = hr_api.g_number) then
411: If (p_rec.legislation_code = hr_api.g_varchar2) then
412: p_rec.legislation_code :=
413: pay_con_shd.g_old_rec.legislation_code;
414: End If;
415: If (p_rec.amt_contr = hr_api.g_number) then
416: p_rec.amt_contr :=
417: pay_con_shd.g_old_rec.amt_contr;
418: End If;
419: If (p_rec.max_contr_allowed = hr_api.g_number) then
415: If (p_rec.amt_contr = hr_api.g_number) then
416: p_rec.amt_contr :=
417: pay_con_shd.g_old_rec.amt_contr;
418: End If;
419: If (p_rec.max_contr_allowed = hr_api.g_number) then
420: p_rec.max_contr_allowed :=
421: pay_con_shd.g_old_rec.max_contr_allowed;
422: End If;
423: If (p_rec.includable_comp = hr_api.g_number) then
419: If (p_rec.max_contr_allowed = hr_api.g_number) then
420: p_rec.max_contr_allowed :=
421: pay_con_shd.g_old_rec.max_contr_allowed;
422: End If;
423: If (p_rec.includable_comp = hr_api.g_number) then
424: p_rec.includable_comp :=
425: pay_con_shd.g_old_rec.includable_comp;
426: End If;
427: If (p_rec.tax_unit_id = hr_api.g_number) then
423: If (p_rec.includable_comp = hr_api.g_number) then
424: p_rec.includable_comp :=
425: pay_con_shd.g_old_rec.includable_comp;
426: End If;
427: If (p_rec.tax_unit_id = hr_api.g_number) then
428: p_rec.tax_unit_id :=
429: pay_con_shd.g_old_rec.tax_unit_id;
430: End If;
431: If (p_rec.source_system = hr_api.g_varchar2) then
427: If (p_rec.tax_unit_id = hr_api.g_number) then
428: p_rec.tax_unit_id :=
429: pay_con_shd.g_old_rec.tax_unit_id;
430: End If;
431: If (p_rec.source_system = hr_api.g_varchar2) then
432: p_rec.source_system :=
433: pay_con_shd.g_old_rec.source_system;
434: End If;
435: If (p_rec.contr_information_category = hr_api.g_varchar2) then
431: If (p_rec.source_system = hr_api.g_varchar2) then
432: p_rec.source_system :=
433: pay_con_shd.g_old_rec.source_system;
434: End If;
435: If (p_rec.contr_information_category = hr_api.g_varchar2) then
436: p_rec.contr_information_category :=
437: pay_con_shd.g_old_rec.contr_information_category;
438: End If;
439: If (p_rec.contr_information1 = hr_api.g_varchar2) then
435: If (p_rec.contr_information_category = hr_api.g_varchar2) then
436: p_rec.contr_information_category :=
437: pay_con_shd.g_old_rec.contr_information_category;
438: End If;
439: If (p_rec.contr_information1 = hr_api.g_varchar2) then
440: p_rec.contr_information1 :=
441: pay_con_shd.g_old_rec.contr_information1;
442: End If;
443: If (p_rec.contr_information2 = hr_api.g_varchar2) then
439: If (p_rec.contr_information1 = hr_api.g_varchar2) then
440: p_rec.contr_information1 :=
441: pay_con_shd.g_old_rec.contr_information1;
442: End If;
443: If (p_rec.contr_information2 = hr_api.g_varchar2) then
444: p_rec.contr_information2 :=
445: pay_con_shd.g_old_rec.contr_information2;
446: End If;
447: If (p_rec.contr_information3 = hr_api.g_varchar2) then
443: If (p_rec.contr_information2 = hr_api.g_varchar2) then
444: p_rec.contr_information2 :=
445: pay_con_shd.g_old_rec.contr_information2;
446: End If;
447: If (p_rec.contr_information3 = hr_api.g_varchar2) then
448: p_rec.contr_information3 :=
449: pay_con_shd.g_old_rec.contr_information3;
450: End If;
451: If (p_rec.contr_information4 = hr_api.g_varchar2) then
447: If (p_rec.contr_information3 = hr_api.g_varchar2) then
448: p_rec.contr_information3 :=
449: pay_con_shd.g_old_rec.contr_information3;
450: End If;
451: If (p_rec.contr_information4 = hr_api.g_varchar2) then
452: p_rec.contr_information4 :=
453: pay_con_shd.g_old_rec.contr_information4;
454: End If;
455: If (p_rec.contr_information5 = hr_api.g_varchar2) then
451: If (p_rec.contr_information4 = hr_api.g_varchar2) then
452: p_rec.contr_information4 :=
453: pay_con_shd.g_old_rec.contr_information4;
454: End If;
455: If (p_rec.contr_information5 = hr_api.g_varchar2) then
456: p_rec.contr_information5 :=
457: pay_con_shd.g_old_rec.contr_information5;
458: End If;
459: If (p_rec.contr_information6 = hr_api.g_varchar2) then
455: If (p_rec.contr_information5 = hr_api.g_varchar2) then
456: p_rec.contr_information5 :=
457: pay_con_shd.g_old_rec.contr_information5;
458: End If;
459: If (p_rec.contr_information6 = hr_api.g_varchar2) then
460: p_rec.contr_information6 :=
461: pay_con_shd.g_old_rec.contr_information6;
462: End If;
463: If (p_rec.contr_information7 = hr_api.g_varchar2) then
459: If (p_rec.contr_information6 = hr_api.g_varchar2) then
460: p_rec.contr_information6 :=
461: pay_con_shd.g_old_rec.contr_information6;
462: End If;
463: If (p_rec.contr_information7 = hr_api.g_varchar2) then
464: p_rec.contr_information7 :=
465: pay_con_shd.g_old_rec.contr_information7;
466: End If;
467: If (p_rec.contr_information8 = hr_api.g_varchar2) then
463: If (p_rec.contr_information7 = hr_api.g_varchar2) then
464: p_rec.contr_information7 :=
465: pay_con_shd.g_old_rec.contr_information7;
466: End If;
467: If (p_rec.contr_information8 = hr_api.g_varchar2) then
468: p_rec.contr_information8 :=
469: pay_con_shd.g_old_rec.contr_information8;
470: End If;
471: If (p_rec.contr_information9 = hr_api.g_varchar2) then
467: If (p_rec.contr_information8 = hr_api.g_varchar2) then
468: p_rec.contr_information8 :=
469: pay_con_shd.g_old_rec.contr_information8;
470: End If;
471: If (p_rec.contr_information9 = hr_api.g_varchar2) then
472: p_rec.contr_information9 :=
473: pay_con_shd.g_old_rec.contr_information9;
474: End If;
475: If (p_rec.contr_information10 = hr_api.g_varchar2) then
471: If (p_rec.contr_information9 = hr_api.g_varchar2) then
472: p_rec.contr_information9 :=
473: pay_con_shd.g_old_rec.contr_information9;
474: End If;
475: If (p_rec.contr_information10 = hr_api.g_varchar2) then
476: p_rec.contr_information10 :=
477: pay_con_shd.g_old_rec.contr_information10;
478: End If;
479: If (p_rec.contr_information11 = hr_api.g_varchar2) then
475: If (p_rec.contr_information10 = hr_api.g_varchar2) then
476: p_rec.contr_information10 :=
477: pay_con_shd.g_old_rec.contr_information10;
478: End If;
479: If (p_rec.contr_information11 = hr_api.g_varchar2) then
480: p_rec.contr_information11 :=
481: pay_con_shd.g_old_rec.contr_information11;
482: End If;
483: If (p_rec.contr_information12 = hr_api.g_varchar2) then
479: If (p_rec.contr_information11 = hr_api.g_varchar2) then
480: p_rec.contr_information11 :=
481: pay_con_shd.g_old_rec.contr_information11;
482: End If;
483: If (p_rec.contr_information12 = hr_api.g_varchar2) then
484: p_rec.contr_information12 :=
485: pay_con_shd.g_old_rec.contr_information12;
486: End If;
487: If (p_rec.contr_information13 = hr_api.g_varchar2) then
483: If (p_rec.contr_information12 = hr_api.g_varchar2) then
484: p_rec.contr_information12 :=
485: pay_con_shd.g_old_rec.contr_information12;
486: End If;
487: If (p_rec.contr_information13 = hr_api.g_varchar2) then
488: p_rec.contr_information13 :=
489: pay_con_shd.g_old_rec.contr_information13;
490: End If;
491: If (p_rec.contr_information14 = hr_api.g_varchar2) then
487: If (p_rec.contr_information13 = hr_api.g_varchar2) then
488: p_rec.contr_information13 :=
489: pay_con_shd.g_old_rec.contr_information13;
490: End If;
491: If (p_rec.contr_information14 = hr_api.g_varchar2) then
492: p_rec.contr_information14 :=
493: pay_con_shd.g_old_rec.contr_information14;
494: End If;
495: If (p_rec.contr_information15 = hr_api.g_varchar2) then
491: If (p_rec.contr_information14 = hr_api.g_varchar2) then
492: p_rec.contr_information14 :=
493: pay_con_shd.g_old_rec.contr_information14;
494: End If;
495: If (p_rec.contr_information15 = hr_api.g_varchar2) then
496: p_rec.contr_information15 :=
497: pay_con_shd.g_old_rec.contr_information15;
498: End If;
499: If (p_rec.contr_information16 = hr_api.g_varchar2) then
495: If (p_rec.contr_information15 = hr_api.g_varchar2) then
496: p_rec.contr_information15 :=
497: pay_con_shd.g_old_rec.contr_information15;
498: End If;
499: If (p_rec.contr_information16 = hr_api.g_varchar2) then
500: p_rec.contr_information16 :=
501: pay_con_shd.g_old_rec.contr_information16;
502: End If;
503: If (p_rec.contr_information17 = hr_api.g_varchar2) then
499: If (p_rec.contr_information16 = hr_api.g_varchar2) then
500: p_rec.contr_information16 :=
501: pay_con_shd.g_old_rec.contr_information16;
502: End If;
503: If (p_rec.contr_information17 = hr_api.g_varchar2) then
504: p_rec.contr_information17 :=
505: pay_con_shd.g_old_rec.contr_information17;
506: End If;
507: If (p_rec.contr_information18 = hr_api.g_varchar2) then
503: If (p_rec.contr_information17 = hr_api.g_varchar2) then
504: p_rec.contr_information17 :=
505: pay_con_shd.g_old_rec.contr_information17;
506: End If;
507: If (p_rec.contr_information18 = hr_api.g_varchar2) then
508: p_rec.contr_information18 :=
509: pay_con_shd.g_old_rec.contr_information18;
510: End If;
511: If (p_rec.contr_information19 = hr_api.g_varchar2) then
507: If (p_rec.contr_information18 = hr_api.g_varchar2) then
508: p_rec.contr_information18 :=
509: pay_con_shd.g_old_rec.contr_information18;
510: End If;
511: If (p_rec.contr_information19 = hr_api.g_varchar2) then
512: p_rec.contr_information19 :=
513: pay_con_shd.g_old_rec.contr_information19;
514: End If;
515: If (p_rec.contr_information20 = hr_api.g_varchar2) then
511: If (p_rec.contr_information19 = hr_api.g_varchar2) then
512: p_rec.contr_information19 :=
513: pay_con_shd.g_old_rec.contr_information19;
514: End If;
515: If (p_rec.contr_information20 = hr_api.g_varchar2) then
516: p_rec.contr_information20 :=
517: pay_con_shd.g_old_rec.contr_information20;
518: End If;
519: If (p_rec.contr_information21 = hr_api.g_varchar2) then
515: If (p_rec.contr_information20 = hr_api.g_varchar2) then
516: p_rec.contr_information20 :=
517: pay_con_shd.g_old_rec.contr_information20;
518: End If;
519: If (p_rec.contr_information21 = hr_api.g_varchar2) then
520: p_rec.contr_information21 :=
521: pay_con_shd.g_old_rec.contr_information21;
522: End If;
523: If (p_rec.contr_information22 = hr_api.g_varchar2) then
519: If (p_rec.contr_information21 = hr_api.g_varchar2) then
520: p_rec.contr_information21 :=
521: pay_con_shd.g_old_rec.contr_information21;
522: End If;
523: If (p_rec.contr_information22 = hr_api.g_varchar2) then
524: p_rec.contr_information22 :=
525: pay_con_shd.g_old_rec.contr_information22;
526: End If;
527: If (p_rec.contr_information23 = hr_api.g_varchar2) then
523: If (p_rec.contr_information22 = hr_api.g_varchar2) then
524: p_rec.contr_information22 :=
525: pay_con_shd.g_old_rec.contr_information22;
526: End If;
527: If (p_rec.contr_information23 = hr_api.g_varchar2) then
528: p_rec.contr_information23 :=
529: pay_con_shd.g_old_rec.contr_information23;
530: End If;
531: If (p_rec.contr_information24 = hr_api.g_varchar2) then
527: If (p_rec.contr_information23 = hr_api.g_varchar2) then
528: p_rec.contr_information23 :=
529: pay_con_shd.g_old_rec.contr_information23;
530: End If;
531: If (p_rec.contr_information24 = hr_api.g_varchar2) then
532: p_rec.contr_information24 :=
533: pay_con_shd.g_old_rec.contr_information24;
534: End If;
535: If (p_rec.contr_information25 = hr_api.g_varchar2) then
531: If (p_rec.contr_information24 = hr_api.g_varchar2) then
532: p_rec.contr_information24 :=
533: pay_con_shd.g_old_rec.contr_information24;
534: End If;
535: If (p_rec.contr_information25 = hr_api.g_varchar2) then
536: p_rec.contr_information25 :=
537: pay_con_shd.g_old_rec.contr_information25;
538: End If;
539: If (p_rec.contr_information26 = hr_api.g_varchar2) then
535: If (p_rec.contr_information25 = hr_api.g_varchar2) then
536: p_rec.contr_information25 :=
537: pay_con_shd.g_old_rec.contr_information25;
538: End If;
539: If (p_rec.contr_information26 = hr_api.g_varchar2) then
540: p_rec.contr_information26 :=
541: pay_con_shd.g_old_rec.contr_information26;
542: End If;
543: If (p_rec.contr_information27 = hr_api.g_varchar2) then
539: If (p_rec.contr_information26 = hr_api.g_varchar2) then
540: p_rec.contr_information26 :=
541: pay_con_shd.g_old_rec.contr_information26;
542: End If;
543: If (p_rec.contr_information27 = hr_api.g_varchar2) then
544: p_rec.contr_information27 :=
545: pay_con_shd.g_old_rec.contr_information27;
546: End If;
547: If (p_rec.contr_information28 = hr_api.g_varchar2) then
543: If (p_rec.contr_information27 = hr_api.g_varchar2) then
544: p_rec.contr_information27 :=
545: pay_con_shd.g_old_rec.contr_information27;
546: End If;
547: If (p_rec.contr_information28 = hr_api.g_varchar2) then
548: p_rec.contr_information28 :=
549: pay_con_shd.g_old_rec.contr_information28;
550: End If;
551: If (p_rec.contr_information29 = hr_api.g_varchar2) then
547: If (p_rec.contr_information28 = hr_api.g_varchar2) then
548: p_rec.contr_information28 :=
549: pay_con_shd.g_old_rec.contr_information28;
550: End If;
551: If (p_rec.contr_information29 = hr_api.g_varchar2) then
552: p_rec.contr_information29 :=
553: pay_con_shd.g_old_rec.contr_information29;
554: End If;
555: If (p_rec.contr_information30 = hr_api.g_varchar2) then
551: If (p_rec.contr_information29 = hr_api.g_varchar2) then
552: p_rec.contr_information29 :=
553: pay_con_shd.g_old_rec.contr_information29;
554: End If;
555: If (p_rec.contr_information30 = hr_api.g_varchar2) then
556: p_rec.contr_information30 :=
557: pay_con_shd.g_old_rec.contr_information30;
558: End If;
559:
610: -- ----------------------------------------------------------------------------
611: Procedure upd
612: (
613: p_contr_history_id in number,
614: p_person_id in number default hr_api.g_number,
615: p_date_from in date default hr_api.g_date,
616: p_date_to in date default hr_api.g_date,
617: p_contr_type in varchar2 default hr_api.g_varchar2,
618: p_business_group_id in number default hr_api.g_number,
611: Procedure upd
612: (
613: p_contr_history_id in number,
614: p_person_id in number default hr_api.g_number,
615: p_date_from in date default hr_api.g_date,
616: p_date_to in date default hr_api.g_date,
617: p_contr_type in varchar2 default hr_api.g_varchar2,
618: p_business_group_id in number default hr_api.g_number,
619: p_legislation_code in varchar2 default hr_api.g_varchar2,
612: (
613: p_contr_history_id in number,
614: p_person_id in number default hr_api.g_number,
615: p_date_from in date default hr_api.g_date,
616: p_date_to in date default hr_api.g_date,
617: p_contr_type in varchar2 default hr_api.g_varchar2,
618: p_business_group_id in number default hr_api.g_number,
619: p_legislation_code in varchar2 default hr_api.g_varchar2,
620: p_amt_contr in number default hr_api.g_number,
613: p_contr_history_id in number,
614: p_person_id in number default hr_api.g_number,
615: p_date_from in date default hr_api.g_date,
616: p_date_to in date default hr_api.g_date,
617: p_contr_type in varchar2 default hr_api.g_varchar2,
618: p_business_group_id in number default hr_api.g_number,
619: p_legislation_code in varchar2 default hr_api.g_varchar2,
620: p_amt_contr in number default hr_api.g_number,
621: p_max_contr_allowed in number default hr_api.g_number,
614: p_person_id in number default hr_api.g_number,
615: p_date_from in date default hr_api.g_date,
616: p_date_to in date default hr_api.g_date,
617: p_contr_type in varchar2 default hr_api.g_varchar2,
618: p_business_group_id in number default hr_api.g_number,
619: p_legislation_code in varchar2 default hr_api.g_varchar2,
620: p_amt_contr in number default hr_api.g_number,
621: p_max_contr_allowed in number default hr_api.g_number,
622: p_includable_comp in number default hr_api.g_number,
615: p_date_from in date default hr_api.g_date,
616: p_date_to in date default hr_api.g_date,
617: p_contr_type in varchar2 default hr_api.g_varchar2,
618: p_business_group_id in number default hr_api.g_number,
619: p_legislation_code in varchar2 default hr_api.g_varchar2,
620: p_amt_contr in number default hr_api.g_number,
621: p_max_contr_allowed in number default hr_api.g_number,
622: p_includable_comp in number default hr_api.g_number,
623: p_tax_unit_id in number default hr_api.g_number,
616: p_date_to in date default hr_api.g_date,
617: p_contr_type in varchar2 default hr_api.g_varchar2,
618: p_business_group_id in number default hr_api.g_number,
619: p_legislation_code in varchar2 default hr_api.g_varchar2,
620: p_amt_contr in number default hr_api.g_number,
621: p_max_contr_allowed in number default hr_api.g_number,
622: p_includable_comp in number default hr_api.g_number,
623: p_tax_unit_id in number default hr_api.g_number,
624: p_source_system in varchar2 default hr_api.g_varchar2,
617: p_contr_type in varchar2 default hr_api.g_varchar2,
618: p_business_group_id in number default hr_api.g_number,
619: p_legislation_code in varchar2 default hr_api.g_varchar2,
620: p_amt_contr in number default hr_api.g_number,
621: p_max_contr_allowed in number default hr_api.g_number,
622: p_includable_comp in number default hr_api.g_number,
623: p_tax_unit_id in number default hr_api.g_number,
624: p_source_system in varchar2 default hr_api.g_varchar2,
625: p_contr_information_category in varchar2 default hr_api.g_varchar2,
618: p_business_group_id in number default hr_api.g_number,
619: p_legislation_code in varchar2 default hr_api.g_varchar2,
620: p_amt_contr in number default hr_api.g_number,
621: p_max_contr_allowed in number default hr_api.g_number,
622: p_includable_comp in number default hr_api.g_number,
623: p_tax_unit_id in number default hr_api.g_number,
624: p_source_system in varchar2 default hr_api.g_varchar2,
625: p_contr_information_category in varchar2 default hr_api.g_varchar2,
626: p_contr_information1 in varchar2 default hr_api.g_varchar2,
619: p_legislation_code in varchar2 default hr_api.g_varchar2,
620: p_amt_contr in number default hr_api.g_number,
621: p_max_contr_allowed in number default hr_api.g_number,
622: p_includable_comp in number default hr_api.g_number,
623: p_tax_unit_id in number default hr_api.g_number,
624: p_source_system in varchar2 default hr_api.g_varchar2,
625: p_contr_information_category in varchar2 default hr_api.g_varchar2,
626: p_contr_information1 in varchar2 default hr_api.g_varchar2,
627: p_contr_information2 in varchar2 default hr_api.g_varchar2,
620: p_amt_contr in number default hr_api.g_number,
621: p_max_contr_allowed in number default hr_api.g_number,
622: p_includable_comp in number default hr_api.g_number,
623: p_tax_unit_id in number default hr_api.g_number,
624: p_source_system in varchar2 default hr_api.g_varchar2,
625: p_contr_information_category in varchar2 default hr_api.g_varchar2,
626: p_contr_information1 in varchar2 default hr_api.g_varchar2,
627: p_contr_information2 in varchar2 default hr_api.g_varchar2,
628: p_contr_information3 in varchar2 default hr_api.g_varchar2,
621: p_max_contr_allowed in number default hr_api.g_number,
622: p_includable_comp in number default hr_api.g_number,
623: p_tax_unit_id in number default hr_api.g_number,
624: p_source_system in varchar2 default hr_api.g_varchar2,
625: p_contr_information_category in varchar2 default hr_api.g_varchar2,
626: p_contr_information1 in varchar2 default hr_api.g_varchar2,
627: p_contr_information2 in varchar2 default hr_api.g_varchar2,
628: p_contr_information3 in varchar2 default hr_api.g_varchar2,
629: p_contr_information4 in varchar2 default hr_api.g_varchar2,
622: p_includable_comp in number default hr_api.g_number,
623: p_tax_unit_id in number default hr_api.g_number,
624: p_source_system in varchar2 default hr_api.g_varchar2,
625: p_contr_information_category in varchar2 default hr_api.g_varchar2,
626: p_contr_information1 in varchar2 default hr_api.g_varchar2,
627: p_contr_information2 in varchar2 default hr_api.g_varchar2,
628: p_contr_information3 in varchar2 default hr_api.g_varchar2,
629: p_contr_information4 in varchar2 default hr_api.g_varchar2,
630: p_contr_information5 in varchar2 default hr_api.g_varchar2,
623: p_tax_unit_id in number default hr_api.g_number,
624: p_source_system in varchar2 default hr_api.g_varchar2,
625: p_contr_information_category in varchar2 default hr_api.g_varchar2,
626: p_contr_information1 in varchar2 default hr_api.g_varchar2,
627: p_contr_information2 in varchar2 default hr_api.g_varchar2,
628: p_contr_information3 in varchar2 default hr_api.g_varchar2,
629: p_contr_information4 in varchar2 default hr_api.g_varchar2,
630: p_contr_information5 in varchar2 default hr_api.g_varchar2,
631: p_contr_information6 in varchar2 default hr_api.g_varchar2,
624: p_source_system in varchar2 default hr_api.g_varchar2,
625: p_contr_information_category in varchar2 default hr_api.g_varchar2,
626: p_contr_information1 in varchar2 default hr_api.g_varchar2,
627: p_contr_information2 in varchar2 default hr_api.g_varchar2,
628: p_contr_information3 in varchar2 default hr_api.g_varchar2,
629: p_contr_information4 in varchar2 default hr_api.g_varchar2,
630: p_contr_information5 in varchar2 default hr_api.g_varchar2,
631: p_contr_information6 in varchar2 default hr_api.g_varchar2,
632: p_contr_information7 in varchar2 default hr_api.g_varchar2,
625: p_contr_information_category in varchar2 default hr_api.g_varchar2,
626: p_contr_information1 in varchar2 default hr_api.g_varchar2,
627: p_contr_information2 in varchar2 default hr_api.g_varchar2,
628: p_contr_information3 in varchar2 default hr_api.g_varchar2,
629: p_contr_information4 in varchar2 default hr_api.g_varchar2,
630: p_contr_information5 in varchar2 default hr_api.g_varchar2,
631: p_contr_information6 in varchar2 default hr_api.g_varchar2,
632: p_contr_information7 in varchar2 default hr_api.g_varchar2,
633: p_contr_information8 in varchar2 default hr_api.g_varchar2,
626: p_contr_information1 in varchar2 default hr_api.g_varchar2,
627: p_contr_information2 in varchar2 default hr_api.g_varchar2,
628: p_contr_information3 in varchar2 default hr_api.g_varchar2,
629: p_contr_information4 in varchar2 default hr_api.g_varchar2,
630: p_contr_information5 in varchar2 default hr_api.g_varchar2,
631: p_contr_information6 in varchar2 default hr_api.g_varchar2,
632: p_contr_information7 in varchar2 default hr_api.g_varchar2,
633: p_contr_information8 in varchar2 default hr_api.g_varchar2,
634: p_contr_information9 in varchar2 default hr_api.g_varchar2,
627: p_contr_information2 in varchar2 default hr_api.g_varchar2,
628: p_contr_information3 in varchar2 default hr_api.g_varchar2,
629: p_contr_information4 in varchar2 default hr_api.g_varchar2,
630: p_contr_information5 in varchar2 default hr_api.g_varchar2,
631: p_contr_information6 in varchar2 default hr_api.g_varchar2,
632: p_contr_information7 in varchar2 default hr_api.g_varchar2,
633: p_contr_information8 in varchar2 default hr_api.g_varchar2,
634: p_contr_information9 in varchar2 default hr_api.g_varchar2,
635: p_contr_information10 in varchar2 default hr_api.g_varchar2,
628: p_contr_information3 in varchar2 default hr_api.g_varchar2,
629: p_contr_information4 in varchar2 default hr_api.g_varchar2,
630: p_contr_information5 in varchar2 default hr_api.g_varchar2,
631: p_contr_information6 in varchar2 default hr_api.g_varchar2,
632: p_contr_information7 in varchar2 default hr_api.g_varchar2,
633: p_contr_information8 in varchar2 default hr_api.g_varchar2,
634: p_contr_information9 in varchar2 default hr_api.g_varchar2,
635: p_contr_information10 in varchar2 default hr_api.g_varchar2,
636: p_contr_information11 in varchar2 default hr_api.g_varchar2,
629: p_contr_information4 in varchar2 default hr_api.g_varchar2,
630: p_contr_information5 in varchar2 default hr_api.g_varchar2,
631: p_contr_information6 in varchar2 default hr_api.g_varchar2,
632: p_contr_information7 in varchar2 default hr_api.g_varchar2,
633: p_contr_information8 in varchar2 default hr_api.g_varchar2,
634: p_contr_information9 in varchar2 default hr_api.g_varchar2,
635: p_contr_information10 in varchar2 default hr_api.g_varchar2,
636: p_contr_information11 in varchar2 default hr_api.g_varchar2,
637: p_contr_information12 in varchar2 default hr_api.g_varchar2,
630: p_contr_information5 in varchar2 default hr_api.g_varchar2,
631: p_contr_information6 in varchar2 default hr_api.g_varchar2,
632: p_contr_information7 in varchar2 default hr_api.g_varchar2,
633: p_contr_information8 in varchar2 default hr_api.g_varchar2,
634: p_contr_information9 in varchar2 default hr_api.g_varchar2,
635: p_contr_information10 in varchar2 default hr_api.g_varchar2,
636: p_contr_information11 in varchar2 default hr_api.g_varchar2,
637: p_contr_information12 in varchar2 default hr_api.g_varchar2,
638: p_contr_information13 in varchar2 default hr_api.g_varchar2,
631: p_contr_information6 in varchar2 default hr_api.g_varchar2,
632: p_contr_information7 in varchar2 default hr_api.g_varchar2,
633: p_contr_information8 in varchar2 default hr_api.g_varchar2,
634: p_contr_information9 in varchar2 default hr_api.g_varchar2,
635: p_contr_information10 in varchar2 default hr_api.g_varchar2,
636: p_contr_information11 in varchar2 default hr_api.g_varchar2,
637: p_contr_information12 in varchar2 default hr_api.g_varchar2,
638: p_contr_information13 in varchar2 default hr_api.g_varchar2,
639: p_contr_information14 in varchar2 default hr_api.g_varchar2,
632: p_contr_information7 in varchar2 default hr_api.g_varchar2,
633: p_contr_information8 in varchar2 default hr_api.g_varchar2,
634: p_contr_information9 in varchar2 default hr_api.g_varchar2,
635: p_contr_information10 in varchar2 default hr_api.g_varchar2,
636: p_contr_information11 in varchar2 default hr_api.g_varchar2,
637: p_contr_information12 in varchar2 default hr_api.g_varchar2,
638: p_contr_information13 in varchar2 default hr_api.g_varchar2,
639: p_contr_information14 in varchar2 default hr_api.g_varchar2,
640: p_contr_information15 in varchar2 default hr_api.g_varchar2,
633: p_contr_information8 in varchar2 default hr_api.g_varchar2,
634: p_contr_information9 in varchar2 default hr_api.g_varchar2,
635: p_contr_information10 in varchar2 default hr_api.g_varchar2,
636: p_contr_information11 in varchar2 default hr_api.g_varchar2,
637: p_contr_information12 in varchar2 default hr_api.g_varchar2,
638: p_contr_information13 in varchar2 default hr_api.g_varchar2,
639: p_contr_information14 in varchar2 default hr_api.g_varchar2,
640: p_contr_information15 in varchar2 default hr_api.g_varchar2,
641: p_contr_information16 in varchar2 default hr_api.g_varchar2,
634: p_contr_information9 in varchar2 default hr_api.g_varchar2,
635: p_contr_information10 in varchar2 default hr_api.g_varchar2,
636: p_contr_information11 in varchar2 default hr_api.g_varchar2,
637: p_contr_information12 in varchar2 default hr_api.g_varchar2,
638: p_contr_information13 in varchar2 default hr_api.g_varchar2,
639: p_contr_information14 in varchar2 default hr_api.g_varchar2,
640: p_contr_information15 in varchar2 default hr_api.g_varchar2,
641: p_contr_information16 in varchar2 default hr_api.g_varchar2,
642: p_contr_information17 in varchar2 default hr_api.g_varchar2,
635: p_contr_information10 in varchar2 default hr_api.g_varchar2,
636: p_contr_information11 in varchar2 default hr_api.g_varchar2,
637: p_contr_information12 in varchar2 default hr_api.g_varchar2,
638: p_contr_information13 in varchar2 default hr_api.g_varchar2,
639: p_contr_information14 in varchar2 default hr_api.g_varchar2,
640: p_contr_information15 in varchar2 default hr_api.g_varchar2,
641: p_contr_information16 in varchar2 default hr_api.g_varchar2,
642: p_contr_information17 in varchar2 default hr_api.g_varchar2,
643: p_contr_information18 in varchar2 default hr_api.g_varchar2,
636: p_contr_information11 in varchar2 default hr_api.g_varchar2,
637: p_contr_information12 in varchar2 default hr_api.g_varchar2,
638: p_contr_information13 in varchar2 default hr_api.g_varchar2,
639: p_contr_information14 in varchar2 default hr_api.g_varchar2,
640: p_contr_information15 in varchar2 default hr_api.g_varchar2,
641: p_contr_information16 in varchar2 default hr_api.g_varchar2,
642: p_contr_information17 in varchar2 default hr_api.g_varchar2,
643: p_contr_information18 in varchar2 default hr_api.g_varchar2,
644: p_contr_information19 in varchar2 default hr_api.g_varchar2,
637: p_contr_information12 in varchar2 default hr_api.g_varchar2,
638: p_contr_information13 in varchar2 default hr_api.g_varchar2,
639: p_contr_information14 in varchar2 default hr_api.g_varchar2,
640: p_contr_information15 in varchar2 default hr_api.g_varchar2,
641: p_contr_information16 in varchar2 default hr_api.g_varchar2,
642: p_contr_information17 in varchar2 default hr_api.g_varchar2,
643: p_contr_information18 in varchar2 default hr_api.g_varchar2,
644: p_contr_information19 in varchar2 default hr_api.g_varchar2,
645: p_contr_information20 in varchar2 default hr_api.g_varchar2,
638: p_contr_information13 in varchar2 default hr_api.g_varchar2,
639: p_contr_information14 in varchar2 default hr_api.g_varchar2,
640: p_contr_information15 in varchar2 default hr_api.g_varchar2,
641: p_contr_information16 in varchar2 default hr_api.g_varchar2,
642: p_contr_information17 in varchar2 default hr_api.g_varchar2,
643: p_contr_information18 in varchar2 default hr_api.g_varchar2,
644: p_contr_information19 in varchar2 default hr_api.g_varchar2,
645: p_contr_information20 in varchar2 default hr_api.g_varchar2,
646: p_contr_information21 in varchar2 default hr_api.g_varchar2,
639: p_contr_information14 in varchar2 default hr_api.g_varchar2,
640: p_contr_information15 in varchar2 default hr_api.g_varchar2,
641: p_contr_information16 in varchar2 default hr_api.g_varchar2,
642: p_contr_information17 in varchar2 default hr_api.g_varchar2,
643: p_contr_information18 in varchar2 default hr_api.g_varchar2,
644: p_contr_information19 in varchar2 default hr_api.g_varchar2,
645: p_contr_information20 in varchar2 default hr_api.g_varchar2,
646: p_contr_information21 in varchar2 default hr_api.g_varchar2,
647: p_contr_information22 in varchar2 default hr_api.g_varchar2,
640: p_contr_information15 in varchar2 default hr_api.g_varchar2,
641: p_contr_information16 in varchar2 default hr_api.g_varchar2,
642: p_contr_information17 in varchar2 default hr_api.g_varchar2,
643: p_contr_information18 in varchar2 default hr_api.g_varchar2,
644: p_contr_information19 in varchar2 default hr_api.g_varchar2,
645: p_contr_information20 in varchar2 default hr_api.g_varchar2,
646: p_contr_information21 in varchar2 default hr_api.g_varchar2,
647: p_contr_information22 in varchar2 default hr_api.g_varchar2,
648: p_contr_information23 in varchar2 default hr_api.g_varchar2,
641: p_contr_information16 in varchar2 default hr_api.g_varchar2,
642: p_contr_information17 in varchar2 default hr_api.g_varchar2,
643: p_contr_information18 in varchar2 default hr_api.g_varchar2,
644: p_contr_information19 in varchar2 default hr_api.g_varchar2,
645: p_contr_information20 in varchar2 default hr_api.g_varchar2,
646: p_contr_information21 in varchar2 default hr_api.g_varchar2,
647: p_contr_information22 in varchar2 default hr_api.g_varchar2,
648: p_contr_information23 in varchar2 default hr_api.g_varchar2,
649: p_contr_information24 in varchar2 default hr_api.g_varchar2,
642: p_contr_information17 in varchar2 default hr_api.g_varchar2,
643: p_contr_information18 in varchar2 default hr_api.g_varchar2,
644: p_contr_information19 in varchar2 default hr_api.g_varchar2,
645: p_contr_information20 in varchar2 default hr_api.g_varchar2,
646: p_contr_information21 in varchar2 default hr_api.g_varchar2,
647: p_contr_information22 in varchar2 default hr_api.g_varchar2,
648: p_contr_information23 in varchar2 default hr_api.g_varchar2,
649: p_contr_information24 in varchar2 default hr_api.g_varchar2,
650: p_contr_information25 in varchar2 default hr_api.g_varchar2,
643: p_contr_information18 in varchar2 default hr_api.g_varchar2,
644: p_contr_information19 in varchar2 default hr_api.g_varchar2,
645: p_contr_information20 in varchar2 default hr_api.g_varchar2,
646: p_contr_information21 in varchar2 default hr_api.g_varchar2,
647: p_contr_information22 in varchar2 default hr_api.g_varchar2,
648: p_contr_information23 in varchar2 default hr_api.g_varchar2,
649: p_contr_information24 in varchar2 default hr_api.g_varchar2,
650: p_contr_information25 in varchar2 default hr_api.g_varchar2,
651: p_contr_information26 in varchar2 default hr_api.g_varchar2,
644: p_contr_information19 in varchar2 default hr_api.g_varchar2,
645: p_contr_information20 in varchar2 default hr_api.g_varchar2,
646: p_contr_information21 in varchar2 default hr_api.g_varchar2,
647: p_contr_information22 in varchar2 default hr_api.g_varchar2,
648: p_contr_information23 in varchar2 default hr_api.g_varchar2,
649: p_contr_information24 in varchar2 default hr_api.g_varchar2,
650: p_contr_information25 in varchar2 default hr_api.g_varchar2,
651: p_contr_information26 in varchar2 default hr_api.g_varchar2,
652: p_contr_information27 in varchar2 default hr_api.g_varchar2,
645: p_contr_information20 in varchar2 default hr_api.g_varchar2,
646: p_contr_information21 in varchar2 default hr_api.g_varchar2,
647: p_contr_information22 in varchar2 default hr_api.g_varchar2,
648: p_contr_information23 in varchar2 default hr_api.g_varchar2,
649: p_contr_information24 in varchar2 default hr_api.g_varchar2,
650: p_contr_information25 in varchar2 default hr_api.g_varchar2,
651: p_contr_information26 in varchar2 default hr_api.g_varchar2,
652: p_contr_information27 in varchar2 default hr_api.g_varchar2,
653: p_contr_information28 in varchar2 default hr_api.g_varchar2,
646: p_contr_information21 in varchar2 default hr_api.g_varchar2,
647: p_contr_information22 in varchar2 default hr_api.g_varchar2,
648: p_contr_information23 in varchar2 default hr_api.g_varchar2,
649: p_contr_information24 in varchar2 default hr_api.g_varchar2,
650: p_contr_information25 in varchar2 default hr_api.g_varchar2,
651: p_contr_information26 in varchar2 default hr_api.g_varchar2,
652: p_contr_information27 in varchar2 default hr_api.g_varchar2,
653: p_contr_information28 in varchar2 default hr_api.g_varchar2,
654: p_contr_information29 in varchar2 default hr_api.g_varchar2,
647: p_contr_information22 in varchar2 default hr_api.g_varchar2,
648: p_contr_information23 in varchar2 default hr_api.g_varchar2,
649: p_contr_information24 in varchar2 default hr_api.g_varchar2,
650: p_contr_information25 in varchar2 default hr_api.g_varchar2,
651: p_contr_information26 in varchar2 default hr_api.g_varchar2,
652: p_contr_information27 in varchar2 default hr_api.g_varchar2,
653: p_contr_information28 in varchar2 default hr_api.g_varchar2,
654: p_contr_information29 in varchar2 default hr_api.g_varchar2,
655: p_contr_information30 in varchar2 default hr_api.g_varchar2,
648: p_contr_information23 in varchar2 default hr_api.g_varchar2,
649: p_contr_information24 in varchar2 default hr_api.g_varchar2,
650: p_contr_information25 in varchar2 default hr_api.g_varchar2,
651: p_contr_information26 in varchar2 default hr_api.g_varchar2,
652: p_contr_information27 in varchar2 default hr_api.g_varchar2,
653: p_contr_information28 in varchar2 default hr_api.g_varchar2,
654: p_contr_information29 in varchar2 default hr_api.g_varchar2,
655: p_contr_information30 in varchar2 default hr_api.g_varchar2,
656: p_object_version_number in out number
649: p_contr_information24 in varchar2 default hr_api.g_varchar2,
650: p_contr_information25 in varchar2 default hr_api.g_varchar2,
651: p_contr_information26 in varchar2 default hr_api.g_varchar2,
652: p_contr_information27 in varchar2 default hr_api.g_varchar2,
653: p_contr_information28 in varchar2 default hr_api.g_varchar2,
654: p_contr_information29 in varchar2 default hr_api.g_varchar2,
655: p_contr_information30 in varchar2 default hr_api.g_varchar2,
656: p_object_version_number in out number
657: ) is
650: p_contr_information25 in varchar2 default hr_api.g_varchar2,
651: p_contr_information26 in varchar2 default hr_api.g_varchar2,
652: p_contr_information27 in varchar2 default hr_api.g_varchar2,
653: p_contr_information28 in varchar2 default hr_api.g_varchar2,
654: p_contr_information29 in varchar2 default hr_api.g_varchar2,
655: p_contr_information30 in varchar2 default hr_api.g_varchar2,
656: p_object_version_number in out number
657: ) is
658: --
651: p_contr_information26 in varchar2 default hr_api.g_varchar2,
652: p_contr_information27 in varchar2 default hr_api.g_varchar2,
653: p_contr_information28 in varchar2 default hr_api.g_varchar2,
654: p_contr_information29 in varchar2 default hr_api.g_varchar2,
655: p_contr_information30 in varchar2 default hr_api.g_varchar2,
656: p_object_version_number in out number
657: ) is
658: --
659: l_rec pay_con_shd.g_rec_type;