DBA Data[Home] [Help]

APPS.PAY_AIF_UPD dependencies on HR_API

Line 111: When hr_api.check_integrity_violated Then

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

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

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

Line 116: When hr_api.parent_integrity_violated Then

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

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

116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: pay_aif_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: pay_aif_shd.constraint_error

Line 121: When hr_api.unique_integrity_violated Then

117: -- Parent integrity has been violated
118: --
119: pay_aif_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: pay_aif_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: pay_aif_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: --
128: Raise;
129: End update_dml;

Line 368: when hr_api.cannot_find_prog_unit then

364: );
365: --
366: exception
367: --
368: when hr_api.cannot_find_prog_unit then
369: --
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'PAY_ACTION_INFORMATION'
372: ,p_hook_type => 'AU');

Line 370: hr_api.cannot_find_prog_unit_error

366: exception
367: --
368: when hr_api.cannot_find_prog_unit then
369: --
370: hr_api.cannot_find_prog_unit_error
371: (p_module_name => 'PAY_ACTION_INFORMATION'
372: ,p_hook_type => 'AU');
373: --
374: end;

Line 433: If (p_rec.action_context_id = hr_api.g_number) then

429: -- p_rec plsql record structure
430: -- to see if a system default is being used. If a system default
431: -- is being used then we must set to the 'current' argument value.
432: --
433: If (p_rec.action_context_id = hr_api.g_number) then
434: p_rec.action_context_id :=
435: pay_aif_shd.g_old_rec.action_context_id;
436: End If;
437: If (p_rec.action_context_type = hr_api.g_varchar2) then

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

433: If (p_rec.action_context_id = hr_api.g_number) then
434: p_rec.action_context_id :=
435: pay_aif_shd.g_old_rec.action_context_id;
436: End If;
437: If (p_rec.action_context_type = hr_api.g_varchar2) then
438: p_rec.action_context_type :=
439: pay_aif_shd.g_old_rec.action_context_type;
440: End If;
441: If (p_rec.tax_unit_id = hr_api.g_number) then

Line 441: If (p_rec.tax_unit_id = hr_api.g_number) then

437: If (p_rec.action_context_type = hr_api.g_varchar2) then
438: p_rec.action_context_type :=
439: pay_aif_shd.g_old_rec.action_context_type;
440: End If;
441: If (p_rec.tax_unit_id = hr_api.g_number) then
442: p_rec.tax_unit_id :=
443: pay_aif_shd.g_old_rec.tax_unit_id;
444: End If;
445: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then

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

441: If (p_rec.tax_unit_id = hr_api.g_number) then
442: p_rec.tax_unit_id :=
443: pay_aif_shd.g_old_rec.tax_unit_id;
444: End If;
445: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
446: p_rec.jurisdiction_code :=
447: pay_aif_shd.g_old_rec.jurisdiction_code;
448: End If;
449: If (p_rec.source_id = hr_api.g_number) then

Line 449: If (p_rec.source_id = hr_api.g_number) then

445: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
446: p_rec.jurisdiction_code :=
447: pay_aif_shd.g_old_rec.jurisdiction_code;
448: End If;
449: If (p_rec.source_id = hr_api.g_number) then
450: p_rec.source_id :=
451: pay_aif_shd.g_old_rec.source_id;
452: End If;
453: If (p_rec.source_text = hr_api.g_varchar2) then

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

449: If (p_rec.source_id = hr_api.g_number) then
450: p_rec.source_id :=
451: pay_aif_shd.g_old_rec.source_id;
452: End If;
453: If (p_rec.source_text = hr_api.g_varchar2) then
454: p_rec.source_text :=
455: pay_aif_shd.g_old_rec.source_text;
456: End If;
457: If (p_rec.tax_group = hr_api.g_varchar2) then

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

453: If (p_rec.source_text = hr_api.g_varchar2) then
454: p_rec.source_text :=
455: pay_aif_shd.g_old_rec.source_text;
456: End If;
457: If (p_rec.tax_group = hr_api.g_varchar2) then
458: p_rec.tax_group :=
459: pay_aif_shd.g_old_rec.tax_group;
460: End If;
461: If (p_rec.effective_date = hr_api.g_date) then

Line 461: If (p_rec.effective_date = hr_api.g_date) then

457: If (p_rec.tax_group = hr_api.g_varchar2) then
458: p_rec.tax_group :=
459: pay_aif_shd.g_old_rec.tax_group;
460: End If;
461: If (p_rec.effective_date = hr_api.g_date) then
462: p_rec.effective_date :=
463: pay_aif_shd.g_old_rec.effective_date;
464: End If;
465: If (p_rec.assignment_id = hr_api.g_number) then

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

461: If (p_rec.effective_date = hr_api.g_date) then
462: p_rec.effective_date :=
463: pay_aif_shd.g_old_rec.effective_date;
464: End If;
465: If (p_rec.assignment_id = hr_api.g_number) then
466: p_rec.assignment_id :=
467: pay_aif_shd.g_old_rec.assignment_id;
468: End If;
469: If (p_rec.action_information_category = hr_api.g_varchar2) then

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

465: If (p_rec.assignment_id = hr_api.g_number) then
466: p_rec.assignment_id :=
467: pay_aif_shd.g_old_rec.assignment_id;
468: End If;
469: If (p_rec.action_information_category = hr_api.g_varchar2) then
470: p_rec.action_information_category :=
471: pay_aif_shd.g_old_rec.action_information_category;
472: End If;
473: If (p_rec.action_information1 = hr_api.g_varchar2) then

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

469: If (p_rec.action_information_category = hr_api.g_varchar2) then
470: p_rec.action_information_category :=
471: pay_aif_shd.g_old_rec.action_information_category;
472: End If;
473: If (p_rec.action_information1 = hr_api.g_varchar2) then
474: p_rec.action_information1 :=
475: pay_aif_shd.g_old_rec.action_information1;
476: End If;
477: If (p_rec.action_information2 = hr_api.g_varchar2) then

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

473: If (p_rec.action_information1 = hr_api.g_varchar2) then
474: p_rec.action_information1 :=
475: pay_aif_shd.g_old_rec.action_information1;
476: End If;
477: If (p_rec.action_information2 = hr_api.g_varchar2) then
478: p_rec.action_information2 :=
479: pay_aif_shd.g_old_rec.action_information2;
480: End If;
481: If (p_rec.action_information3 = hr_api.g_varchar2) then

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

477: If (p_rec.action_information2 = hr_api.g_varchar2) then
478: p_rec.action_information2 :=
479: pay_aif_shd.g_old_rec.action_information2;
480: End If;
481: If (p_rec.action_information3 = hr_api.g_varchar2) then
482: p_rec.action_information3 :=
483: pay_aif_shd.g_old_rec.action_information3;
484: End If;
485: If (p_rec.action_information4 = hr_api.g_varchar2) then

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

481: If (p_rec.action_information3 = hr_api.g_varchar2) then
482: p_rec.action_information3 :=
483: pay_aif_shd.g_old_rec.action_information3;
484: End If;
485: If (p_rec.action_information4 = hr_api.g_varchar2) then
486: p_rec.action_information4 :=
487: pay_aif_shd.g_old_rec.action_information4;
488: End If;
489: If (p_rec.action_information5 = hr_api.g_varchar2) then

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

485: If (p_rec.action_information4 = hr_api.g_varchar2) then
486: p_rec.action_information4 :=
487: pay_aif_shd.g_old_rec.action_information4;
488: End If;
489: If (p_rec.action_information5 = hr_api.g_varchar2) then
490: p_rec.action_information5 :=
491: pay_aif_shd.g_old_rec.action_information5;
492: End If;
493: If (p_rec.action_information6 = hr_api.g_varchar2) then

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

489: If (p_rec.action_information5 = hr_api.g_varchar2) then
490: p_rec.action_information5 :=
491: pay_aif_shd.g_old_rec.action_information5;
492: End If;
493: If (p_rec.action_information6 = hr_api.g_varchar2) then
494: p_rec.action_information6 :=
495: pay_aif_shd.g_old_rec.action_information6;
496: End If;
497: If (p_rec.action_information7 = hr_api.g_varchar2) then

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

493: If (p_rec.action_information6 = hr_api.g_varchar2) then
494: p_rec.action_information6 :=
495: pay_aif_shd.g_old_rec.action_information6;
496: End If;
497: If (p_rec.action_information7 = hr_api.g_varchar2) then
498: p_rec.action_information7 :=
499: pay_aif_shd.g_old_rec.action_information7;
500: End If;
501: If (p_rec.action_information8 = hr_api.g_varchar2) then

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

497: If (p_rec.action_information7 = hr_api.g_varchar2) then
498: p_rec.action_information7 :=
499: pay_aif_shd.g_old_rec.action_information7;
500: End If;
501: If (p_rec.action_information8 = hr_api.g_varchar2) then
502: p_rec.action_information8 :=
503: pay_aif_shd.g_old_rec.action_information8;
504: End If;
505: If (p_rec.action_information9 = hr_api.g_varchar2) then

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

501: If (p_rec.action_information8 = hr_api.g_varchar2) then
502: p_rec.action_information8 :=
503: pay_aif_shd.g_old_rec.action_information8;
504: End If;
505: If (p_rec.action_information9 = hr_api.g_varchar2) then
506: p_rec.action_information9 :=
507: pay_aif_shd.g_old_rec.action_information9;
508: End If;
509: If (p_rec.action_information10 = hr_api.g_varchar2) then

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

505: If (p_rec.action_information9 = hr_api.g_varchar2) then
506: p_rec.action_information9 :=
507: pay_aif_shd.g_old_rec.action_information9;
508: End If;
509: If (p_rec.action_information10 = hr_api.g_varchar2) then
510: p_rec.action_information10 :=
511: pay_aif_shd.g_old_rec.action_information10;
512: End If;
513: If (p_rec.action_information11 = hr_api.g_varchar2) then

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

509: If (p_rec.action_information10 = hr_api.g_varchar2) then
510: p_rec.action_information10 :=
511: pay_aif_shd.g_old_rec.action_information10;
512: End If;
513: If (p_rec.action_information11 = hr_api.g_varchar2) then
514: p_rec.action_information11 :=
515: pay_aif_shd.g_old_rec.action_information11;
516: End If;
517: If (p_rec.action_information12 = hr_api.g_varchar2) then

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

513: If (p_rec.action_information11 = hr_api.g_varchar2) then
514: p_rec.action_information11 :=
515: pay_aif_shd.g_old_rec.action_information11;
516: End If;
517: If (p_rec.action_information12 = hr_api.g_varchar2) then
518: p_rec.action_information12 :=
519: pay_aif_shd.g_old_rec.action_information12;
520: End If;
521: If (p_rec.action_information13 = hr_api.g_varchar2) then

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

517: If (p_rec.action_information12 = hr_api.g_varchar2) then
518: p_rec.action_information12 :=
519: pay_aif_shd.g_old_rec.action_information12;
520: End If;
521: If (p_rec.action_information13 = hr_api.g_varchar2) then
522: p_rec.action_information13 :=
523: pay_aif_shd.g_old_rec.action_information13;
524: End If;
525: If (p_rec.action_information14 = hr_api.g_varchar2) then

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

521: If (p_rec.action_information13 = hr_api.g_varchar2) then
522: p_rec.action_information13 :=
523: pay_aif_shd.g_old_rec.action_information13;
524: End If;
525: If (p_rec.action_information14 = hr_api.g_varchar2) then
526: p_rec.action_information14 :=
527: pay_aif_shd.g_old_rec.action_information14;
528: End If;
529: If (p_rec.action_information15 = hr_api.g_varchar2) then

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

525: If (p_rec.action_information14 = hr_api.g_varchar2) then
526: p_rec.action_information14 :=
527: pay_aif_shd.g_old_rec.action_information14;
528: End If;
529: If (p_rec.action_information15 = hr_api.g_varchar2) then
530: p_rec.action_information15 :=
531: pay_aif_shd.g_old_rec.action_information15;
532: End If;
533: If (p_rec.action_information16 = hr_api.g_varchar2) then

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

529: If (p_rec.action_information15 = hr_api.g_varchar2) then
530: p_rec.action_information15 :=
531: pay_aif_shd.g_old_rec.action_information15;
532: End If;
533: If (p_rec.action_information16 = hr_api.g_varchar2) then
534: p_rec.action_information16 :=
535: pay_aif_shd.g_old_rec.action_information16;
536: End If;
537: If (p_rec.action_information17 = hr_api.g_varchar2) then

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

533: If (p_rec.action_information16 = hr_api.g_varchar2) then
534: p_rec.action_information16 :=
535: pay_aif_shd.g_old_rec.action_information16;
536: End If;
537: If (p_rec.action_information17 = hr_api.g_varchar2) then
538: p_rec.action_information17 :=
539: pay_aif_shd.g_old_rec.action_information17;
540: End If;
541: If (p_rec.action_information18 = hr_api.g_varchar2) then

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

537: If (p_rec.action_information17 = hr_api.g_varchar2) then
538: p_rec.action_information17 :=
539: pay_aif_shd.g_old_rec.action_information17;
540: End If;
541: If (p_rec.action_information18 = hr_api.g_varchar2) then
542: p_rec.action_information18 :=
543: pay_aif_shd.g_old_rec.action_information18;
544: End If;
545: If (p_rec.action_information19 = hr_api.g_varchar2) then

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

541: If (p_rec.action_information18 = hr_api.g_varchar2) then
542: p_rec.action_information18 :=
543: pay_aif_shd.g_old_rec.action_information18;
544: End If;
545: If (p_rec.action_information19 = hr_api.g_varchar2) then
546: p_rec.action_information19 :=
547: pay_aif_shd.g_old_rec.action_information19;
548: End If;
549: If (p_rec.action_information20 = hr_api.g_varchar2) then

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

545: If (p_rec.action_information19 = hr_api.g_varchar2) then
546: p_rec.action_information19 :=
547: pay_aif_shd.g_old_rec.action_information19;
548: End If;
549: If (p_rec.action_information20 = hr_api.g_varchar2) then
550: p_rec.action_information20 :=
551: pay_aif_shd.g_old_rec.action_information20;
552: End If;
553: If (p_rec.action_information21 = hr_api.g_varchar2) then

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

549: If (p_rec.action_information20 = hr_api.g_varchar2) then
550: p_rec.action_information20 :=
551: pay_aif_shd.g_old_rec.action_information20;
552: End If;
553: If (p_rec.action_information21 = hr_api.g_varchar2) then
554: p_rec.action_information21 :=
555: pay_aif_shd.g_old_rec.action_information21;
556: End If;
557: If (p_rec.action_information22 = hr_api.g_varchar2) then

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

553: If (p_rec.action_information21 = hr_api.g_varchar2) then
554: p_rec.action_information21 :=
555: pay_aif_shd.g_old_rec.action_information21;
556: End If;
557: If (p_rec.action_information22 = hr_api.g_varchar2) then
558: p_rec.action_information22 :=
559: pay_aif_shd.g_old_rec.action_information22;
560: End If;
561: If (p_rec.action_information23 = hr_api.g_varchar2) then

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

557: If (p_rec.action_information22 = hr_api.g_varchar2) then
558: p_rec.action_information22 :=
559: pay_aif_shd.g_old_rec.action_information22;
560: End If;
561: If (p_rec.action_information23 = hr_api.g_varchar2) then
562: p_rec.action_information23 :=
563: pay_aif_shd.g_old_rec.action_information23;
564: End If;
565: If (p_rec.action_information24 = hr_api.g_varchar2) then

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

561: If (p_rec.action_information23 = hr_api.g_varchar2) then
562: p_rec.action_information23 :=
563: pay_aif_shd.g_old_rec.action_information23;
564: End If;
565: If (p_rec.action_information24 = hr_api.g_varchar2) then
566: p_rec.action_information24 :=
567: pay_aif_shd.g_old_rec.action_information24;
568: End If;
569: If (p_rec.action_information25 = hr_api.g_varchar2) then

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

565: If (p_rec.action_information24 = hr_api.g_varchar2) then
566: p_rec.action_information24 :=
567: pay_aif_shd.g_old_rec.action_information24;
568: End If;
569: If (p_rec.action_information25 = hr_api.g_varchar2) then
570: p_rec.action_information25 :=
571: pay_aif_shd.g_old_rec.action_information25;
572: End If;
573: If (p_rec.action_information26 = hr_api.g_varchar2) then

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

569: If (p_rec.action_information25 = hr_api.g_varchar2) then
570: p_rec.action_information25 :=
571: pay_aif_shd.g_old_rec.action_information25;
572: End If;
573: If (p_rec.action_information26 = hr_api.g_varchar2) then
574: p_rec.action_information26 :=
575: pay_aif_shd.g_old_rec.action_information26;
576: End If;
577: If (p_rec.action_information27 = hr_api.g_varchar2) then

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

573: If (p_rec.action_information26 = hr_api.g_varchar2) then
574: p_rec.action_information26 :=
575: pay_aif_shd.g_old_rec.action_information26;
576: End If;
577: If (p_rec.action_information27 = hr_api.g_varchar2) then
578: p_rec.action_information27 :=
579: pay_aif_shd.g_old_rec.action_information27;
580: End If;
581: If (p_rec.action_information28 = hr_api.g_varchar2) then

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

577: If (p_rec.action_information27 = hr_api.g_varchar2) then
578: p_rec.action_information27 :=
579: pay_aif_shd.g_old_rec.action_information27;
580: End If;
581: If (p_rec.action_information28 = hr_api.g_varchar2) then
582: p_rec.action_information28 :=
583: pay_aif_shd.g_old_rec.action_information28;
584: End If;
585: If (p_rec.action_information29 = hr_api.g_varchar2) then

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

581: If (p_rec.action_information28 = hr_api.g_varchar2) then
582: p_rec.action_information28 :=
583: pay_aif_shd.g_old_rec.action_information28;
584: End If;
585: If (p_rec.action_information29 = hr_api.g_varchar2) then
586: p_rec.action_information29 :=
587: pay_aif_shd.g_old_rec.action_information29;
588: End If;
589: If (p_rec.action_information30 = hr_api.g_varchar2) then

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

585: If (p_rec.action_information29 = hr_api.g_varchar2) then
586: p_rec.action_information29 :=
587: pay_aif_shd.g_old_rec.action_information29;
588: End If;
589: If (p_rec.action_information30 = hr_api.g_varchar2) then
590: p_rec.action_information30 :=
591: pay_aif_shd.g_old_rec.action_information30;
592: End If;
593: --

Line 655: ,p_action_information1 in varchar2 default hr_api.g_varchar2

651: -- ----------------------------------------------------------------------------
652: Procedure upd
653: (p_action_information_id in number
654: ,p_object_version_number in out nocopy number
655: ,p_action_information1 in varchar2 default hr_api.g_varchar2
656: ,p_action_information2 in varchar2 default hr_api.g_varchar2
657: ,p_action_information3 in varchar2 default hr_api.g_varchar2
658: ,p_action_information4 in varchar2 default hr_api.g_varchar2
659: ,p_action_information5 in varchar2 default hr_api.g_varchar2

Line 656: ,p_action_information2 in varchar2 default hr_api.g_varchar2

652: Procedure upd
653: (p_action_information_id in number
654: ,p_object_version_number in out nocopy number
655: ,p_action_information1 in varchar2 default hr_api.g_varchar2
656: ,p_action_information2 in varchar2 default hr_api.g_varchar2
657: ,p_action_information3 in varchar2 default hr_api.g_varchar2
658: ,p_action_information4 in varchar2 default hr_api.g_varchar2
659: ,p_action_information5 in varchar2 default hr_api.g_varchar2
660: ,p_action_information6 in varchar2 default hr_api.g_varchar2

Line 657: ,p_action_information3 in varchar2 default hr_api.g_varchar2

653: (p_action_information_id in number
654: ,p_object_version_number in out nocopy number
655: ,p_action_information1 in varchar2 default hr_api.g_varchar2
656: ,p_action_information2 in varchar2 default hr_api.g_varchar2
657: ,p_action_information3 in varchar2 default hr_api.g_varchar2
658: ,p_action_information4 in varchar2 default hr_api.g_varchar2
659: ,p_action_information5 in varchar2 default hr_api.g_varchar2
660: ,p_action_information6 in varchar2 default hr_api.g_varchar2
661: ,p_action_information7 in varchar2 default hr_api.g_varchar2

Line 658: ,p_action_information4 in varchar2 default hr_api.g_varchar2

654: ,p_object_version_number in out nocopy number
655: ,p_action_information1 in varchar2 default hr_api.g_varchar2
656: ,p_action_information2 in varchar2 default hr_api.g_varchar2
657: ,p_action_information3 in varchar2 default hr_api.g_varchar2
658: ,p_action_information4 in varchar2 default hr_api.g_varchar2
659: ,p_action_information5 in varchar2 default hr_api.g_varchar2
660: ,p_action_information6 in varchar2 default hr_api.g_varchar2
661: ,p_action_information7 in varchar2 default hr_api.g_varchar2
662: ,p_action_information8 in varchar2 default hr_api.g_varchar2

Line 659: ,p_action_information5 in varchar2 default hr_api.g_varchar2

655: ,p_action_information1 in varchar2 default hr_api.g_varchar2
656: ,p_action_information2 in varchar2 default hr_api.g_varchar2
657: ,p_action_information3 in varchar2 default hr_api.g_varchar2
658: ,p_action_information4 in varchar2 default hr_api.g_varchar2
659: ,p_action_information5 in varchar2 default hr_api.g_varchar2
660: ,p_action_information6 in varchar2 default hr_api.g_varchar2
661: ,p_action_information7 in varchar2 default hr_api.g_varchar2
662: ,p_action_information8 in varchar2 default hr_api.g_varchar2
663: ,p_action_information9 in varchar2 default hr_api.g_varchar2

Line 660: ,p_action_information6 in varchar2 default hr_api.g_varchar2

656: ,p_action_information2 in varchar2 default hr_api.g_varchar2
657: ,p_action_information3 in varchar2 default hr_api.g_varchar2
658: ,p_action_information4 in varchar2 default hr_api.g_varchar2
659: ,p_action_information5 in varchar2 default hr_api.g_varchar2
660: ,p_action_information6 in varchar2 default hr_api.g_varchar2
661: ,p_action_information7 in varchar2 default hr_api.g_varchar2
662: ,p_action_information8 in varchar2 default hr_api.g_varchar2
663: ,p_action_information9 in varchar2 default hr_api.g_varchar2
664: ,p_action_information10 in varchar2 default hr_api.g_varchar2

Line 661: ,p_action_information7 in varchar2 default hr_api.g_varchar2

657: ,p_action_information3 in varchar2 default hr_api.g_varchar2
658: ,p_action_information4 in varchar2 default hr_api.g_varchar2
659: ,p_action_information5 in varchar2 default hr_api.g_varchar2
660: ,p_action_information6 in varchar2 default hr_api.g_varchar2
661: ,p_action_information7 in varchar2 default hr_api.g_varchar2
662: ,p_action_information8 in varchar2 default hr_api.g_varchar2
663: ,p_action_information9 in varchar2 default hr_api.g_varchar2
664: ,p_action_information10 in varchar2 default hr_api.g_varchar2
665: ,p_action_information11 in varchar2 default hr_api.g_varchar2

Line 662: ,p_action_information8 in varchar2 default hr_api.g_varchar2

658: ,p_action_information4 in varchar2 default hr_api.g_varchar2
659: ,p_action_information5 in varchar2 default hr_api.g_varchar2
660: ,p_action_information6 in varchar2 default hr_api.g_varchar2
661: ,p_action_information7 in varchar2 default hr_api.g_varchar2
662: ,p_action_information8 in varchar2 default hr_api.g_varchar2
663: ,p_action_information9 in varchar2 default hr_api.g_varchar2
664: ,p_action_information10 in varchar2 default hr_api.g_varchar2
665: ,p_action_information11 in varchar2 default hr_api.g_varchar2
666: ,p_action_information12 in varchar2 default hr_api.g_varchar2

Line 663: ,p_action_information9 in varchar2 default hr_api.g_varchar2

659: ,p_action_information5 in varchar2 default hr_api.g_varchar2
660: ,p_action_information6 in varchar2 default hr_api.g_varchar2
661: ,p_action_information7 in varchar2 default hr_api.g_varchar2
662: ,p_action_information8 in varchar2 default hr_api.g_varchar2
663: ,p_action_information9 in varchar2 default hr_api.g_varchar2
664: ,p_action_information10 in varchar2 default hr_api.g_varchar2
665: ,p_action_information11 in varchar2 default hr_api.g_varchar2
666: ,p_action_information12 in varchar2 default hr_api.g_varchar2
667: ,p_action_information13 in varchar2 default hr_api.g_varchar2

Line 664: ,p_action_information10 in varchar2 default hr_api.g_varchar2

660: ,p_action_information6 in varchar2 default hr_api.g_varchar2
661: ,p_action_information7 in varchar2 default hr_api.g_varchar2
662: ,p_action_information8 in varchar2 default hr_api.g_varchar2
663: ,p_action_information9 in varchar2 default hr_api.g_varchar2
664: ,p_action_information10 in varchar2 default hr_api.g_varchar2
665: ,p_action_information11 in varchar2 default hr_api.g_varchar2
666: ,p_action_information12 in varchar2 default hr_api.g_varchar2
667: ,p_action_information13 in varchar2 default hr_api.g_varchar2
668: ,p_action_information14 in varchar2 default hr_api.g_varchar2

Line 665: ,p_action_information11 in varchar2 default hr_api.g_varchar2

661: ,p_action_information7 in varchar2 default hr_api.g_varchar2
662: ,p_action_information8 in varchar2 default hr_api.g_varchar2
663: ,p_action_information9 in varchar2 default hr_api.g_varchar2
664: ,p_action_information10 in varchar2 default hr_api.g_varchar2
665: ,p_action_information11 in varchar2 default hr_api.g_varchar2
666: ,p_action_information12 in varchar2 default hr_api.g_varchar2
667: ,p_action_information13 in varchar2 default hr_api.g_varchar2
668: ,p_action_information14 in varchar2 default hr_api.g_varchar2
669: ,p_action_information15 in varchar2 default hr_api.g_varchar2

Line 666: ,p_action_information12 in varchar2 default hr_api.g_varchar2

662: ,p_action_information8 in varchar2 default hr_api.g_varchar2
663: ,p_action_information9 in varchar2 default hr_api.g_varchar2
664: ,p_action_information10 in varchar2 default hr_api.g_varchar2
665: ,p_action_information11 in varchar2 default hr_api.g_varchar2
666: ,p_action_information12 in varchar2 default hr_api.g_varchar2
667: ,p_action_information13 in varchar2 default hr_api.g_varchar2
668: ,p_action_information14 in varchar2 default hr_api.g_varchar2
669: ,p_action_information15 in varchar2 default hr_api.g_varchar2
670: ,p_action_information16 in varchar2 default hr_api.g_varchar2

Line 667: ,p_action_information13 in varchar2 default hr_api.g_varchar2

663: ,p_action_information9 in varchar2 default hr_api.g_varchar2
664: ,p_action_information10 in varchar2 default hr_api.g_varchar2
665: ,p_action_information11 in varchar2 default hr_api.g_varchar2
666: ,p_action_information12 in varchar2 default hr_api.g_varchar2
667: ,p_action_information13 in varchar2 default hr_api.g_varchar2
668: ,p_action_information14 in varchar2 default hr_api.g_varchar2
669: ,p_action_information15 in varchar2 default hr_api.g_varchar2
670: ,p_action_information16 in varchar2 default hr_api.g_varchar2
671: ,p_action_information17 in varchar2 default hr_api.g_varchar2

Line 668: ,p_action_information14 in varchar2 default hr_api.g_varchar2

664: ,p_action_information10 in varchar2 default hr_api.g_varchar2
665: ,p_action_information11 in varchar2 default hr_api.g_varchar2
666: ,p_action_information12 in varchar2 default hr_api.g_varchar2
667: ,p_action_information13 in varchar2 default hr_api.g_varchar2
668: ,p_action_information14 in varchar2 default hr_api.g_varchar2
669: ,p_action_information15 in varchar2 default hr_api.g_varchar2
670: ,p_action_information16 in varchar2 default hr_api.g_varchar2
671: ,p_action_information17 in varchar2 default hr_api.g_varchar2
672: ,p_action_information18 in varchar2 default hr_api.g_varchar2

Line 669: ,p_action_information15 in varchar2 default hr_api.g_varchar2

665: ,p_action_information11 in varchar2 default hr_api.g_varchar2
666: ,p_action_information12 in varchar2 default hr_api.g_varchar2
667: ,p_action_information13 in varchar2 default hr_api.g_varchar2
668: ,p_action_information14 in varchar2 default hr_api.g_varchar2
669: ,p_action_information15 in varchar2 default hr_api.g_varchar2
670: ,p_action_information16 in varchar2 default hr_api.g_varchar2
671: ,p_action_information17 in varchar2 default hr_api.g_varchar2
672: ,p_action_information18 in varchar2 default hr_api.g_varchar2
673: ,p_action_information19 in varchar2 default hr_api.g_varchar2

Line 670: ,p_action_information16 in varchar2 default hr_api.g_varchar2

666: ,p_action_information12 in varchar2 default hr_api.g_varchar2
667: ,p_action_information13 in varchar2 default hr_api.g_varchar2
668: ,p_action_information14 in varchar2 default hr_api.g_varchar2
669: ,p_action_information15 in varchar2 default hr_api.g_varchar2
670: ,p_action_information16 in varchar2 default hr_api.g_varchar2
671: ,p_action_information17 in varchar2 default hr_api.g_varchar2
672: ,p_action_information18 in varchar2 default hr_api.g_varchar2
673: ,p_action_information19 in varchar2 default hr_api.g_varchar2
674: ,p_action_information20 in varchar2 default hr_api.g_varchar2

Line 671: ,p_action_information17 in varchar2 default hr_api.g_varchar2

667: ,p_action_information13 in varchar2 default hr_api.g_varchar2
668: ,p_action_information14 in varchar2 default hr_api.g_varchar2
669: ,p_action_information15 in varchar2 default hr_api.g_varchar2
670: ,p_action_information16 in varchar2 default hr_api.g_varchar2
671: ,p_action_information17 in varchar2 default hr_api.g_varchar2
672: ,p_action_information18 in varchar2 default hr_api.g_varchar2
673: ,p_action_information19 in varchar2 default hr_api.g_varchar2
674: ,p_action_information20 in varchar2 default hr_api.g_varchar2
675: ,p_action_information21 in varchar2 default hr_api.g_varchar2

Line 672: ,p_action_information18 in varchar2 default hr_api.g_varchar2

668: ,p_action_information14 in varchar2 default hr_api.g_varchar2
669: ,p_action_information15 in varchar2 default hr_api.g_varchar2
670: ,p_action_information16 in varchar2 default hr_api.g_varchar2
671: ,p_action_information17 in varchar2 default hr_api.g_varchar2
672: ,p_action_information18 in varchar2 default hr_api.g_varchar2
673: ,p_action_information19 in varchar2 default hr_api.g_varchar2
674: ,p_action_information20 in varchar2 default hr_api.g_varchar2
675: ,p_action_information21 in varchar2 default hr_api.g_varchar2
676: ,p_action_information22 in varchar2 default hr_api.g_varchar2

Line 673: ,p_action_information19 in varchar2 default hr_api.g_varchar2

669: ,p_action_information15 in varchar2 default hr_api.g_varchar2
670: ,p_action_information16 in varchar2 default hr_api.g_varchar2
671: ,p_action_information17 in varchar2 default hr_api.g_varchar2
672: ,p_action_information18 in varchar2 default hr_api.g_varchar2
673: ,p_action_information19 in varchar2 default hr_api.g_varchar2
674: ,p_action_information20 in varchar2 default hr_api.g_varchar2
675: ,p_action_information21 in varchar2 default hr_api.g_varchar2
676: ,p_action_information22 in varchar2 default hr_api.g_varchar2
677: ,p_action_information23 in varchar2 default hr_api.g_varchar2

Line 674: ,p_action_information20 in varchar2 default hr_api.g_varchar2

670: ,p_action_information16 in varchar2 default hr_api.g_varchar2
671: ,p_action_information17 in varchar2 default hr_api.g_varchar2
672: ,p_action_information18 in varchar2 default hr_api.g_varchar2
673: ,p_action_information19 in varchar2 default hr_api.g_varchar2
674: ,p_action_information20 in varchar2 default hr_api.g_varchar2
675: ,p_action_information21 in varchar2 default hr_api.g_varchar2
676: ,p_action_information22 in varchar2 default hr_api.g_varchar2
677: ,p_action_information23 in varchar2 default hr_api.g_varchar2
678: ,p_action_information24 in varchar2 default hr_api.g_varchar2

Line 675: ,p_action_information21 in varchar2 default hr_api.g_varchar2

671: ,p_action_information17 in varchar2 default hr_api.g_varchar2
672: ,p_action_information18 in varchar2 default hr_api.g_varchar2
673: ,p_action_information19 in varchar2 default hr_api.g_varchar2
674: ,p_action_information20 in varchar2 default hr_api.g_varchar2
675: ,p_action_information21 in varchar2 default hr_api.g_varchar2
676: ,p_action_information22 in varchar2 default hr_api.g_varchar2
677: ,p_action_information23 in varchar2 default hr_api.g_varchar2
678: ,p_action_information24 in varchar2 default hr_api.g_varchar2
679: ,p_action_information25 in varchar2 default hr_api.g_varchar2

Line 676: ,p_action_information22 in varchar2 default hr_api.g_varchar2

672: ,p_action_information18 in varchar2 default hr_api.g_varchar2
673: ,p_action_information19 in varchar2 default hr_api.g_varchar2
674: ,p_action_information20 in varchar2 default hr_api.g_varchar2
675: ,p_action_information21 in varchar2 default hr_api.g_varchar2
676: ,p_action_information22 in varchar2 default hr_api.g_varchar2
677: ,p_action_information23 in varchar2 default hr_api.g_varchar2
678: ,p_action_information24 in varchar2 default hr_api.g_varchar2
679: ,p_action_information25 in varchar2 default hr_api.g_varchar2
680: ,p_action_information26 in varchar2 default hr_api.g_varchar2

Line 677: ,p_action_information23 in varchar2 default hr_api.g_varchar2

673: ,p_action_information19 in varchar2 default hr_api.g_varchar2
674: ,p_action_information20 in varchar2 default hr_api.g_varchar2
675: ,p_action_information21 in varchar2 default hr_api.g_varchar2
676: ,p_action_information22 in varchar2 default hr_api.g_varchar2
677: ,p_action_information23 in varchar2 default hr_api.g_varchar2
678: ,p_action_information24 in varchar2 default hr_api.g_varchar2
679: ,p_action_information25 in varchar2 default hr_api.g_varchar2
680: ,p_action_information26 in varchar2 default hr_api.g_varchar2
681: ,p_action_information27 in varchar2 default hr_api.g_varchar2

Line 678: ,p_action_information24 in varchar2 default hr_api.g_varchar2

674: ,p_action_information20 in varchar2 default hr_api.g_varchar2
675: ,p_action_information21 in varchar2 default hr_api.g_varchar2
676: ,p_action_information22 in varchar2 default hr_api.g_varchar2
677: ,p_action_information23 in varchar2 default hr_api.g_varchar2
678: ,p_action_information24 in varchar2 default hr_api.g_varchar2
679: ,p_action_information25 in varchar2 default hr_api.g_varchar2
680: ,p_action_information26 in varchar2 default hr_api.g_varchar2
681: ,p_action_information27 in varchar2 default hr_api.g_varchar2
682: ,p_action_information28 in varchar2 default hr_api.g_varchar2

Line 679: ,p_action_information25 in varchar2 default hr_api.g_varchar2

675: ,p_action_information21 in varchar2 default hr_api.g_varchar2
676: ,p_action_information22 in varchar2 default hr_api.g_varchar2
677: ,p_action_information23 in varchar2 default hr_api.g_varchar2
678: ,p_action_information24 in varchar2 default hr_api.g_varchar2
679: ,p_action_information25 in varchar2 default hr_api.g_varchar2
680: ,p_action_information26 in varchar2 default hr_api.g_varchar2
681: ,p_action_information27 in varchar2 default hr_api.g_varchar2
682: ,p_action_information28 in varchar2 default hr_api.g_varchar2
683: ,p_action_information29 in varchar2 default hr_api.g_varchar2

Line 680: ,p_action_information26 in varchar2 default hr_api.g_varchar2

676: ,p_action_information22 in varchar2 default hr_api.g_varchar2
677: ,p_action_information23 in varchar2 default hr_api.g_varchar2
678: ,p_action_information24 in varchar2 default hr_api.g_varchar2
679: ,p_action_information25 in varchar2 default hr_api.g_varchar2
680: ,p_action_information26 in varchar2 default hr_api.g_varchar2
681: ,p_action_information27 in varchar2 default hr_api.g_varchar2
682: ,p_action_information28 in varchar2 default hr_api.g_varchar2
683: ,p_action_information29 in varchar2 default hr_api.g_varchar2
684: ,p_action_information30 in varchar2 default hr_api.g_varchar2

Line 681: ,p_action_information27 in varchar2 default hr_api.g_varchar2

677: ,p_action_information23 in varchar2 default hr_api.g_varchar2
678: ,p_action_information24 in varchar2 default hr_api.g_varchar2
679: ,p_action_information25 in varchar2 default hr_api.g_varchar2
680: ,p_action_information26 in varchar2 default hr_api.g_varchar2
681: ,p_action_information27 in varchar2 default hr_api.g_varchar2
682: ,p_action_information28 in varchar2 default hr_api.g_varchar2
683: ,p_action_information29 in varchar2 default hr_api.g_varchar2
684: ,p_action_information30 in varchar2 default hr_api.g_varchar2
685: ) is

Line 682: ,p_action_information28 in varchar2 default hr_api.g_varchar2

678: ,p_action_information24 in varchar2 default hr_api.g_varchar2
679: ,p_action_information25 in varchar2 default hr_api.g_varchar2
680: ,p_action_information26 in varchar2 default hr_api.g_varchar2
681: ,p_action_information27 in varchar2 default hr_api.g_varchar2
682: ,p_action_information28 in varchar2 default hr_api.g_varchar2
683: ,p_action_information29 in varchar2 default hr_api.g_varchar2
684: ,p_action_information30 in varchar2 default hr_api.g_varchar2
685: ) is
686: --

Line 683: ,p_action_information29 in varchar2 default hr_api.g_varchar2

679: ,p_action_information25 in varchar2 default hr_api.g_varchar2
680: ,p_action_information26 in varchar2 default hr_api.g_varchar2
681: ,p_action_information27 in varchar2 default hr_api.g_varchar2
682: ,p_action_information28 in varchar2 default hr_api.g_varchar2
683: ,p_action_information29 in varchar2 default hr_api.g_varchar2
684: ,p_action_information30 in varchar2 default hr_api.g_varchar2
685: ) is
686: --
687: l_rec pay_aif_shd.g_rec_type;

Line 684: ,p_action_information30 in varchar2 default hr_api.g_varchar2

680: ,p_action_information26 in varchar2 default hr_api.g_varchar2
681: ,p_action_information27 in varchar2 default hr_api.g_varchar2
682: ,p_action_information28 in varchar2 default hr_api.g_varchar2
683: ,p_action_information29 in varchar2 default hr_api.g_varchar2
684: ,p_action_information30 in varchar2 default hr_api.g_varchar2
685: ) is
686: --
687: l_rec pay_aif_shd.g_rec_type;
688: l_proc varchar2(72) := g_package||'upd';

Line 699: ,hr_api.g_number

695: --
696: l_rec :=
697: pay_aif_shd.convert_args
698: (p_action_information_id
699: ,hr_api.g_number
700: ,hr_api.g_varchar2
701: ,hr_api.g_number
702: ,hr_api.g_varchar2
703: ,hr_api.g_number

Line 700: ,hr_api.g_varchar2

696: l_rec :=
697: pay_aif_shd.convert_args
698: (p_action_information_id
699: ,hr_api.g_number
700: ,hr_api.g_varchar2
701: ,hr_api.g_number
702: ,hr_api.g_varchar2
703: ,hr_api.g_number
704: ,hr_api.g_varchar2

Line 701: ,hr_api.g_number

697: pay_aif_shd.convert_args
698: (p_action_information_id
699: ,hr_api.g_number
700: ,hr_api.g_varchar2
701: ,hr_api.g_number
702: ,hr_api.g_varchar2
703: ,hr_api.g_number
704: ,hr_api.g_varchar2
705: ,hr_api.g_varchar2

Line 702: ,hr_api.g_varchar2

698: (p_action_information_id
699: ,hr_api.g_number
700: ,hr_api.g_varchar2
701: ,hr_api.g_number
702: ,hr_api.g_varchar2
703: ,hr_api.g_number
704: ,hr_api.g_varchar2
705: ,hr_api.g_varchar2
706: ,p_object_version_number

Line 703: ,hr_api.g_number

699: ,hr_api.g_number
700: ,hr_api.g_varchar2
701: ,hr_api.g_number
702: ,hr_api.g_varchar2
703: ,hr_api.g_number
704: ,hr_api.g_varchar2
705: ,hr_api.g_varchar2
706: ,p_object_version_number
707: ,hr_api.g_date

Line 704: ,hr_api.g_varchar2

700: ,hr_api.g_varchar2
701: ,hr_api.g_number
702: ,hr_api.g_varchar2
703: ,hr_api.g_number
704: ,hr_api.g_varchar2
705: ,hr_api.g_varchar2
706: ,p_object_version_number
707: ,hr_api.g_date
708: ,hr_api.g_number

Line 705: ,hr_api.g_varchar2

701: ,hr_api.g_number
702: ,hr_api.g_varchar2
703: ,hr_api.g_number
704: ,hr_api.g_varchar2
705: ,hr_api.g_varchar2
706: ,p_object_version_number
707: ,hr_api.g_date
708: ,hr_api.g_number
709: ,hr_api.g_varchar2

Line 707: ,hr_api.g_date

703: ,hr_api.g_number
704: ,hr_api.g_varchar2
705: ,hr_api.g_varchar2
706: ,p_object_version_number
707: ,hr_api.g_date
708: ,hr_api.g_number
709: ,hr_api.g_varchar2
710: ,p_action_information1
711: ,p_action_information2

Line 708: ,hr_api.g_number

704: ,hr_api.g_varchar2
705: ,hr_api.g_varchar2
706: ,p_object_version_number
707: ,hr_api.g_date
708: ,hr_api.g_number
709: ,hr_api.g_varchar2
710: ,p_action_information1
711: ,p_action_information2
712: ,p_action_information3

Line 709: ,hr_api.g_varchar2

705: ,hr_api.g_varchar2
706: ,p_object_version_number
707: ,hr_api.g_date
708: ,hr_api.g_number
709: ,hr_api.g_varchar2
710: ,p_action_information1
711: ,p_action_information2
712: ,p_action_information3
713: ,p_action_information4