eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CSO_UPD dependencies on HR_API

Line 136: When hr_api.check_integrity_violated Then

132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 10);
134: --
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: --
139: ben_cso_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
138: --
139: ben_cso_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: --
144: ben_cso_shd.constraint_error

Line 141: When hr_api.parent_integrity_violated Then

137: -- A check constraint has been violated
138: --
139: ben_cso_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: --
144: ben_cso_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

141: When hr_api.parent_integrity_violated Then
142: -- Parent integrity has been violated
143: --
144: ben_cso_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
149: ben_cso_shd.constraint_error

Line 146: When hr_api.unique_integrity_violated Then

142: -- Parent integrity has been violated
143: --
144: ben_cso_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
149: ben_cso_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
149: ben_cso_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: --
153: Raise;
154: End update_dml;

Line 475: when hr_api.cannot_find_prog_unit then

471: );
472: --
473: exception
474: --
475: when hr_api.cannot_find_prog_unit then
476: --
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'BEN_CWB_STOCK_OPTN_DTLS'
479: ,p_hook_type => 'AU');

Line 477: hr_api.cannot_find_prog_unit_error

473: exception
474: --
475: when hr_api.cannot_find_prog_unit then
476: --
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'BEN_CWB_STOCK_OPTN_DTLS'
479: ,p_hook_type => 'AU');
480: --
481: end;

Line 540: If (p_rec.grant_id = hr_api.g_number) then

536: -- p_rec plsql record structure
537: -- to see if a system default is being used. If a system default
538: -- is being used then we must set to the 'current' argument value.
539: --
540: If (p_rec.grant_id = hr_api.g_number) then
541: p_rec.grant_id :=
542: ben_cso_shd.g_old_rec.grant_id;
543: End If;
544: If (p_rec.grant_number = hr_api.g_varchar2) then

Line 544: If (p_rec.grant_number = hr_api.g_varchar2) then

540: If (p_rec.grant_id = hr_api.g_number) then
541: p_rec.grant_id :=
542: ben_cso_shd.g_old_rec.grant_id;
543: End If;
544: If (p_rec.grant_number = hr_api.g_varchar2) then
545: p_rec.grant_number :=
546: ben_cso_shd.g_old_rec.grant_number;
547: End If;
548: If (p_rec.grant_name = hr_api.g_varchar2) then

Line 548: If (p_rec.grant_name = hr_api.g_varchar2) then

544: If (p_rec.grant_number = hr_api.g_varchar2) then
545: p_rec.grant_number :=
546: ben_cso_shd.g_old_rec.grant_number;
547: End If;
548: If (p_rec.grant_name = hr_api.g_varchar2) then
549: p_rec.grant_name :=
550: ben_cso_shd.g_old_rec.grant_name;
551: End If;
552: If (p_rec.grant_type = hr_api.g_varchar2) then

Line 552: If (p_rec.grant_type = hr_api.g_varchar2) then

548: If (p_rec.grant_name = hr_api.g_varchar2) then
549: p_rec.grant_name :=
550: ben_cso_shd.g_old_rec.grant_name;
551: End If;
552: If (p_rec.grant_type = hr_api.g_varchar2) then
553: p_rec.grant_type :=
554: ben_cso_shd.g_old_rec.grant_type;
555: End If;
556: If (p_rec.grant_date = hr_api.g_date) then

Line 556: If (p_rec.grant_date = hr_api.g_date) then

552: If (p_rec.grant_type = hr_api.g_varchar2) then
553: p_rec.grant_type :=
554: ben_cso_shd.g_old_rec.grant_type;
555: End If;
556: If (p_rec.grant_date = hr_api.g_date) then
557: p_rec.grant_date :=
558: ben_cso_shd.g_old_rec.grant_date;
559: End If;
560: If (p_rec.grant_shares = hr_api.g_number) then

Line 560: If (p_rec.grant_shares = hr_api.g_number) then

556: If (p_rec.grant_date = hr_api.g_date) then
557: p_rec.grant_date :=
558: ben_cso_shd.g_old_rec.grant_date;
559: End If;
560: If (p_rec.grant_shares = hr_api.g_number) then
561: p_rec.grant_shares :=
562: ben_cso_shd.g_old_rec.grant_shares;
563: End If;
564: If (p_rec.grant_price = hr_api.g_number) then

Line 564: If (p_rec.grant_price = hr_api.g_number) then

560: If (p_rec.grant_shares = hr_api.g_number) then
561: p_rec.grant_shares :=
562: ben_cso_shd.g_old_rec.grant_shares;
563: End If;
564: If (p_rec.grant_price = hr_api.g_number) then
565: p_rec.grant_price :=
566: ben_cso_shd.g_old_rec.grant_price;
567: End If;
568: If (p_rec.value_at_grant = hr_api.g_number) then

Line 568: If (p_rec.value_at_grant = hr_api.g_number) then

564: If (p_rec.grant_price = hr_api.g_number) then
565: p_rec.grant_price :=
566: ben_cso_shd.g_old_rec.grant_price;
567: End If;
568: If (p_rec.value_at_grant = hr_api.g_number) then
569: p_rec.value_at_grant :=
570: ben_cso_shd.g_old_rec.value_at_grant;
571: End If;
572: If (p_rec.current_share_price = hr_api.g_number) then

Line 572: If (p_rec.current_share_price = hr_api.g_number) then

568: If (p_rec.value_at_grant = hr_api.g_number) then
569: p_rec.value_at_grant :=
570: ben_cso_shd.g_old_rec.value_at_grant;
571: End If;
572: If (p_rec.current_share_price = hr_api.g_number) then
573: p_rec.current_share_price :=
574: ben_cso_shd.g_old_rec.current_share_price;
575: End If;
576: If (p_rec.current_shares_outstanding = hr_api.g_number) then

Line 576: If (p_rec.current_shares_outstanding = hr_api.g_number) then

572: If (p_rec.current_share_price = hr_api.g_number) then
573: p_rec.current_share_price :=
574: ben_cso_shd.g_old_rec.current_share_price;
575: End If;
576: If (p_rec.current_shares_outstanding = hr_api.g_number) then
577: p_rec.current_shares_outstanding :=
578: ben_cso_shd.g_old_rec.current_shares_outstanding;
579: End If;
580: If (p_rec.vested_shares = hr_api.g_number) then

Line 580: If (p_rec.vested_shares = hr_api.g_number) then

576: If (p_rec.current_shares_outstanding = hr_api.g_number) then
577: p_rec.current_shares_outstanding :=
578: ben_cso_shd.g_old_rec.current_shares_outstanding;
579: End If;
580: If (p_rec.vested_shares = hr_api.g_number) then
581: p_rec.vested_shares :=
582: ben_cso_shd.g_old_rec.vested_shares;
583: End If;
584: If (p_rec.unvested_shares = hr_api.g_number) then

Line 584: If (p_rec.unvested_shares = hr_api.g_number) then

580: If (p_rec.vested_shares = hr_api.g_number) then
581: p_rec.vested_shares :=
582: ben_cso_shd.g_old_rec.vested_shares;
583: End If;
584: If (p_rec.unvested_shares = hr_api.g_number) then
585: p_rec.unvested_shares :=
586: ben_cso_shd.g_old_rec.unvested_shares;
587: End If;
588: If (p_rec.exercisable_shares = hr_api.g_number) then

Line 588: If (p_rec.exercisable_shares = hr_api.g_number) then

584: If (p_rec.unvested_shares = hr_api.g_number) then
585: p_rec.unvested_shares :=
586: ben_cso_shd.g_old_rec.unvested_shares;
587: End If;
588: If (p_rec.exercisable_shares = hr_api.g_number) then
589: p_rec.exercisable_shares :=
590: ben_cso_shd.g_old_rec.exercisable_shares;
591: End If;
592: If (p_rec.exercised_shares = hr_api.g_number) then

Line 592: If (p_rec.exercised_shares = hr_api.g_number) then

588: If (p_rec.exercisable_shares = hr_api.g_number) then
589: p_rec.exercisable_shares :=
590: ben_cso_shd.g_old_rec.exercisable_shares;
591: End If;
592: If (p_rec.exercised_shares = hr_api.g_number) then
593: p_rec.exercised_shares :=
594: ben_cso_shd.g_old_rec.exercised_shares;
595: End If;
596: If (p_rec.cancelled_shares = hr_api.g_number) then

Line 596: If (p_rec.cancelled_shares = hr_api.g_number) then

592: If (p_rec.exercised_shares = hr_api.g_number) then
593: p_rec.exercised_shares :=
594: ben_cso_shd.g_old_rec.exercised_shares;
595: End If;
596: If (p_rec.cancelled_shares = hr_api.g_number) then
597: p_rec.cancelled_shares :=
598: ben_cso_shd.g_old_rec.cancelled_shares;
599: End If;
600: If (p_rec.trading_symbol = hr_api.g_varchar2) then

Line 600: If (p_rec.trading_symbol = hr_api.g_varchar2) then

596: If (p_rec.cancelled_shares = hr_api.g_number) then
597: p_rec.cancelled_shares :=
598: ben_cso_shd.g_old_rec.cancelled_shares;
599: End If;
600: If (p_rec.trading_symbol = hr_api.g_varchar2) then
601: p_rec.trading_symbol :=
602: ben_cso_shd.g_old_rec.trading_symbol;
603: End If;
604: If (p_rec.expiration_date = hr_api.g_date) then

Line 604: If (p_rec.expiration_date = hr_api.g_date) then

600: If (p_rec.trading_symbol = hr_api.g_varchar2) then
601: p_rec.trading_symbol :=
602: ben_cso_shd.g_old_rec.trading_symbol;
603: End If;
604: If (p_rec.expiration_date = hr_api.g_date) then
605: p_rec.expiration_date :=
606: ben_cso_shd.g_old_rec.expiration_date;
607: End If;
608: If (p_rec.reason_code = hr_api.g_varchar2) then

Line 608: If (p_rec.reason_code = hr_api.g_varchar2) then

604: If (p_rec.expiration_date = hr_api.g_date) then
605: p_rec.expiration_date :=
606: ben_cso_shd.g_old_rec.expiration_date;
607: End If;
608: If (p_rec.reason_code = hr_api.g_varchar2) then
609: p_rec.reason_code :=
610: ben_cso_shd.g_old_rec.reason_code;
611: End If;
612: If (p_rec.class = hr_api.g_varchar2) then

Line 612: If (p_rec.class = hr_api.g_varchar2) then

608: If (p_rec.reason_code = hr_api.g_varchar2) then
609: p_rec.reason_code :=
610: ben_cso_shd.g_old_rec.reason_code;
611: End If;
612: If (p_rec.class = hr_api.g_varchar2) then
613: p_rec.class :=
614: ben_cso_shd.g_old_rec.class;
615: End If;
616: If (p_rec.misc = hr_api.g_varchar2) then

Line 616: If (p_rec.misc = hr_api.g_varchar2) then

612: If (p_rec.class = hr_api.g_varchar2) then
613: p_rec.class :=
614: ben_cso_shd.g_old_rec.class;
615: End If;
616: If (p_rec.misc = hr_api.g_varchar2) then
617: p_rec.misc :=
618: ben_cso_shd.g_old_rec.misc;
619: End If;
620: If (p_rec.employee_number = hr_api.g_varchar2) then

Line 620: If (p_rec.employee_number = hr_api.g_varchar2) then

616: If (p_rec.misc = hr_api.g_varchar2) then
617: p_rec.misc :=
618: ben_cso_shd.g_old_rec.misc;
619: End If;
620: If (p_rec.employee_number = hr_api.g_varchar2) then
621: p_rec.employee_number :=
622: ben_cso_shd.g_old_rec.employee_number;
623: End If;
624: If (p_rec.person_id = hr_api.g_number) then

Line 624: If (p_rec.person_id = hr_api.g_number) then

620: If (p_rec.employee_number = hr_api.g_varchar2) then
621: p_rec.employee_number :=
622: ben_cso_shd.g_old_rec.employee_number;
623: End If;
624: If (p_rec.person_id = hr_api.g_number) then
625: p_rec.person_id :=
626: ben_cso_shd.g_old_rec.person_id;
627: End If;
628: If (p_rec.business_group_id = hr_api.g_number) then

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

624: If (p_rec.person_id = hr_api.g_number) then
625: p_rec.person_id :=
626: ben_cso_shd.g_old_rec.person_id;
627: End If;
628: If (p_rec.business_group_id = hr_api.g_number) then
629: p_rec.business_group_id :=
630: ben_cso_shd.g_old_rec.business_group_id;
631: End If;
632: If (p_rec.prtt_rt_val_id = hr_api.g_number) then

Line 632: If (p_rec.prtt_rt_val_id = hr_api.g_number) then

628: If (p_rec.business_group_id = hr_api.g_number) then
629: p_rec.business_group_id :=
630: ben_cso_shd.g_old_rec.business_group_id;
631: End If;
632: If (p_rec.prtt_rt_val_id = hr_api.g_number) then
633: p_rec.prtt_rt_val_id :=
634: ben_cso_shd.g_old_rec.prtt_rt_val_id;
635: End If;
636: If (p_rec.cso_attribute_category = hr_api.g_varchar2) then

Line 636: If (p_rec.cso_attribute_category = hr_api.g_varchar2) then

632: If (p_rec.prtt_rt_val_id = hr_api.g_number) then
633: p_rec.prtt_rt_val_id :=
634: ben_cso_shd.g_old_rec.prtt_rt_val_id;
635: End If;
636: If (p_rec.cso_attribute_category = hr_api.g_varchar2) then
637: p_rec.cso_attribute_category :=
638: ben_cso_shd.g_old_rec.cso_attribute_category;
639: End If;
640: If (p_rec.cso_attribute1 = hr_api.g_varchar2) then

Line 640: If (p_rec.cso_attribute1 = hr_api.g_varchar2) then

636: If (p_rec.cso_attribute_category = hr_api.g_varchar2) then
637: p_rec.cso_attribute_category :=
638: ben_cso_shd.g_old_rec.cso_attribute_category;
639: End If;
640: If (p_rec.cso_attribute1 = hr_api.g_varchar2) then
641: p_rec.cso_attribute1 :=
642: ben_cso_shd.g_old_rec.cso_attribute1;
643: End If;
644: If (p_rec.cso_attribute2 = hr_api.g_varchar2) then

Line 644: If (p_rec.cso_attribute2 = hr_api.g_varchar2) then

640: If (p_rec.cso_attribute1 = hr_api.g_varchar2) then
641: p_rec.cso_attribute1 :=
642: ben_cso_shd.g_old_rec.cso_attribute1;
643: End If;
644: If (p_rec.cso_attribute2 = hr_api.g_varchar2) then
645: p_rec.cso_attribute2 :=
646: ben_cso_shd.g_old_rec.cso_attribute2;
647: End If;
648: If (p_rec.cso_attribute3 = hr_api.g_varchar2) then

Line 648: If (p_rec.cso_attribute3 = hr_api.g_varchar2) then

644: If (p_rec.cso_attribute2 = hr_api.g_varchar2) then
645: p_rec.cso_attribute2 :=
646: ben_cso_shd.g_old_rec.cso_attribute2;
647: End If;
648: If (p_rec.cso_attribute3 = hr_api.g_varchar2) then
649: p_rec.cso_attribute3 :=
650: ben_cso_shd.g_old_rec.cso_attribute3;
651: End If;
652: If (p_rec.cso_attribute4 = hr_api.g_varchar2) then

Line 652: If (p_rec.cso_attribute4 = hr_api.g_varchar2) then

648: If (p_rec.cso_attribute3 = hr_api.g_varchar2) then
649: p_rec.cso_attribute3 :=
650: ben_cso_shd.g_old_rec.cso_attribute3;
651: End If;
652: If (p_rec.cso_attribute4 = hr_api.g_varchar2) then
653: p_rec.cso_attribute4 :=
654: ben_cso_shd.g_old_rec.cso_attribute4;
655: End If;
656: If (p_rec.cso_attribute5 = hr_api.g_varchar2) then

Line 656: If (p_rec.cso_attribute5 = hr_api.g_varchar2) then

652: If (p_rec.cso_attribute4 = hr_api.g_varchar2) then
653: p_rec.cso_attribute4 :=
654: ben_cso_shd.g_old_rec.cso_attribute4;
655: End If;
656: If (p_rec.cso_attribute5 = hr_api.g_varchar2) then
657: p_rec.cso_attribute5 :=
658: ben_cso_shd.g_old_rec.cso_attribute5;
659: End If;
660: If (p_rec.cso_attribute6 = hr_api.g_varchar2) then

Line 660: If (p_rec.cso_attribute6 = hr_api.g_varchar2) then

656: If (p_rec.cso_attribute5 = hr_api.g_varchar2) then
657: p_rec.cso_attribute5 :=
658: ben_cso_shd.g_old_rec.cso_attribute5;
659: End If;
660: If (p_rec.cso_attribute6 = hr_api.g_varchar2) then
661: p_rec.cso_attribute6 :=
662: ben_cso_shd.g_old_rec.cso_attribute6;
663: End If;
664: If (p_rec.cso_attribute7 = hr_api.g_varchar2) then

Line 664: If (p_rec.cso_attribute7 = hr_api.g_varchar2) then

660: If (p_rec.cso_attribute6 = hr_api.g_varchar2) then
661: p_rec.cso_attribute6 :=
662: ben_cso_shd.g_old_rec.cso_attribute6;
663: End If;
664: If (p_rec.cso_attribute7 = hr_api.g_varchar2) then
665: p_rec.cso_attribute7 :=
666: ben_cso_shd.g_old_rec.cso_attribute7;
667: End If;
668: If (p_rec.cso_attribute8 = hr_api.g_varchar2) then

Line 668: If (p_rec.cso_attribute8 = hr_api.g_varchar2) then

664: If (p_rec.cso_attribute7 = hr_api.g_varchar2) then
665: p_rec.cso_attribute7 :=
666: ben_cso_shd.g_old_rec.cso_attribute7;
667: End If;
668: If (p_rec.cso_attribute8 = hr_api.g_varchar2) then
669: p_rec.cso_attribute8 :=
670: ben_cso_shd.g_old_rec.cso_attribute8;
671: End If;
672: If (p_rec.cso_attribute9 = hr_api.g_varchar2) then

Line 672: If (p_rec.cso_attribute9 = hr_api.g_varchar2) then

668: If (p_rec.cso_attribute8 = hr_api.g_varchar2) then
669: p_rec.cso_attribute8 :=
670: ben_cso_shd.g_old_rec.cso_attribute8;
671: End If;
672: If (p_rec.cso_attribute9 = hr_api.g_varchar2) then
673: p_rec.cso_attribute9 :=
674: ben_cso_shd.g_old_rec.cso_attribute9;
675: End If;
676: If (p_rec.cso_attribute10 = hr_api.g_varchar2) then

Line 676: If (p_rec.cso_attribute10 = hr_api.g_varchar2) then

672: If (p_rec.cso_attribute9 = hr_api.g_varchar2) then
673: p_rec.cso_attribute9 :=
674: ben_cso_shd.g_old_rec.cso_attribute9;
675: End If;
676: If (p_rec.cso_attribute10 = hr_api.g_varchar2) then
677: p_rec.cso_attribute10 :=
678: ben_cso_shd.g_old_rec.cso_attribute10;
679: End If;
680: If (p_rec.cso_attribute11 = hr_api.g_varchar2) then

Line 680: If (p_rec.cso_attribute11 = hr_api.g_varchar2) then

676: If (p_rec.cso_attribute10 = hr_api.g_varchar2) then
677: p_rec.cso_attribute10 :=
678: ben_cso_shd.g_old_rec.cso_attribute10;
679: End If;
680: If (p_rec.cso_attribute11 = hr_api.g_varchar2) then
681: p_rec.cso_attribute11 :=
682: ben_cso_shd.g_old_rec.cso_attribute11;
683: End If;
684: If (p_rec.cso_attribute12 = hr_api.g_varchar2) then

Line 684: If (p_rec.cso_attribute12 = hr_api.g_varchar2) then

680: If (p_rec.cso_attribute11 = hr_api.g_varchar2) then
681: p_rec.cso_attribute11 :=
682: ben_cso_shd.g_old_rec.cso_attribute11;
683: End If;
684: If (p_rec.cso_attribute12 = hr_api.g_varchar2) then
685: p_rec.cso_attribute12 :=
686: ben_cso_shd.g_old_rec.cso_attribute12;
687: End If;
688: If (p_rec.cso_attribute13 = hr_api.g_varchar2) then

Line 688: If (p_rec.cso_attribute13 = hr_api.g_varchar2) then

684: If (p_rec.cso_attribute12 = hr_api.g_varchar2) then
685: p_rec.cso_attribute12 :=
686: ben_cso_shd.g_old_rec.cso_attribute12;
687: End If;
688: If (p_rec.cso_attribute13 = hr_api.g_varchar2) then
689: p_rec.cso_attribute13 :=
690: ben_cso_shd.g_old_rec.cso_attribute13;
691: End If;
692: If (p_rec.cso_attribute14 = hr_api.g_varchar2) then

Line 692: If (p_rec.cso_attribute14 = hr_api.g_varchar2) then

688: If (p_rec.cso_attribute13 = hr_api.g_varchar2) then
689: p_rec.cso_attribute13 :=
690: ben_cso_shd.g_old_rec.cso_attribute13;
691: End If;
692: If (p_rec.cso_attribute14 = hr_api.g_varchar2) then
693: p_rec.cso_attribute14 :=
694: ben_cso_shd.g_old_rec.cso_attribute14;
695: End If;
696: If (p_rec.cso_attribute15 = hr_api.g_varchar2) then

Line 696: If (p_rec.cso_attribute15 = hr_api.g_varchar2) then

692: If (p_rec.cso_attribute14 = hr_api.g_varchar2) then
693: p_rec.cso_attribute14 :=
694: ben_cso_shd.g_old_rec.cso_attribute14;
695: End If;
696: If (p_rec.cso_attribute15 = hr_api.g_varchar2) then
697: p_rec.cso_attribute15 :=
698: ben_cso_shd.g_old_rec.cso_attribute15;
699: End If;
700: If (p_rec.cso_attribute16 = hr_api.g_varchar2) then

Line 700: If (p_rec.cso_attribute16 = hr_api.g_varchar2) then

696: If (p_rec.cso_attribute15 = hr_api.g_varchar2) then
697: p_rec.cso_attribute15 :=
698: ben_cso_shd.g_old_rec.cso_attribute15;
699: End If;
700: If (p_rec.cso_attribute16 = hr_api.g_varchar2) then
701: p_rec.cso_attribute16 :=
702: ben_cso_shd.g_old_rec.cso_attribute16;
703: End If;
704: If (p_rec.cso_attribute17 = hr_api.g_varchar2) then

Line 704: If (p_rec.cso_attribute17 = hr_api.g_varchar2) then

700: If (p_rec.cso_attribute16 = hr_api.g_varchar2) then
701: p_rec.cso_attribute16 :=
702: ben_cso_shd.g_old_rec.cso_attribute16;
703: End If;
704: If (p_rec.cso_attribute17 = hr_api.g_varchar2) then
705: p_rec.cso_attribute17 :=
706: ben_cso_shd.g_old_rec.cso_attribute17;
707: End If;
708: If (p_rec.cso_attribute18 = hr_api.g_varchar2) then

Line 708: If (p_rec.cso_attribute18 = hr_api.g_varchar2) then

704: If (p_rec.cso_attribute17 = hr_api.g_varchar2) then
705: p_rec.cso_attribute17 :=
706: ben_cso_shd.g_old_rec.cso_attribute17;
707: End If;
708: If (p_rec.cso_attribute18 = hr_api.g_varchar2) then
709: p_rec.cso_attribute18 :=
710: ben_cso_shd.g_old_rec.cso_attribute18;
711: End If;
712: If (p_rec.cso_attribute19 = hr_api.g_varchar2) then

Line 712: If (p_rec.cso_attribute19 = hr_api.g_varchar2) then

708: If (p_rec.cso_attribute18 = hr_api.g_varchar2) then
709: p_rec.cso_attribute18 :=
710: ben_cso_shd.g_old_rec.cso_attribute18;
711: End If;
712: If (p_rec.cso_attribute19 = hr_api.g_varchar2) then
713: p_rec.cso_attribute19 :=
714: ben_cso_shd.g_old_rec.cso_attribute19;
715: End If;
716: If (p_rec.cso_attribute20 = hr_api.g_varchar2) then

Line 716: If (p_rec.cso_attribute20 = hr_api.g_varchar2) then

712: If (p_rec.cso_attribute19 = hr_api.g_varchar2) then
713: p_rec.cso_attribute19 :=
714: ben_cso_shd.g_old_rec.cso_attribute19;
715: End If;
716: If (p_rec.cso_attribute20 = hr_api.g_varchar2) then
717: p_rec.cso_attribute20 :=
718: ben_cso_shd.g_old_rec.cso_attribute20;
719: End If;
720: If (p_rec.cso_attribute21 = hr_api.g_varchar2) then

Line 720: If (p_rec.cso_attribute21 = hr_api.g_varchar2) then

716: If (p_rec.cso_attribute20 = hr_api.g_varchar2) then
717: p_rec.cso_attribute20 :=
718: ben_cso_shd.g_old_rec.cso_attribute20;
719: End If;
720: If (p_rec.cso_attribute21 = hr_api.g_varchar2) then
721: p_rec.cso_attribute21 :=
722: ben_cso_shd.g_old_rec.cso_attribute21;
723: End If;
724: If (p_rec.cso_attribute22 = hr_api.g_varchar2) then

Line 724: If (p_rec.cso_attribute22 = hr_api.g_varchar2) then

720: If (p_rec.cso_attribute21 = hr_api.g_varchar2) then
721: p_rec.cso_attribute21 :=
722: ben_cso_shd.g_old_rec.cso_attribute21;
723: End If;
724: If (p_rec.cso_attribute22 = hr_api.g_varchar2) then
725: p_rec.cso_attribute22 :=
726: ben_cso_shd.g_old_rec.cso_attribute22;
727: End If;
728: If (p_rec.cso_attribute23 = hr_api.g_varchar2) then

Line 728: If (p_rec.cso_attribute23 = hr_api.g_varchar2) then

724: If (p_rec.cso_attribute22 = hr_api.g_varchar2) then
725: p_rec.cso_attribute22 :=
726: ben_cso_shd.g_old_rec.cso_attribute22;
727: End If;
728: If (p_rec.cso_attribute23 = hr_api.g_varchar2) then
729: p_rec.cso_attribute23 :=
730: ben_cso_shd.g_old_rec.cso_attribute23;
731: End If;
732: If (p_rec.cso_attribute24 = hr_api.g_varchar2) then

Line 732: If (p_rec.cso_attribute24 = hr_api.g_varchar2) then

728: If (p_rec.cso_attribute23 = hr_api.g_varchar2) then
729: p_rec.cso_attribute23 :=
730: ben_cso_shd.g_old_rec.cso_attribute23;
731: End If;
732: If (p_rec.cso_attribute24 = hr_api.g_varchar2) then
733: p_rec.cso_attribute24 :=
734: ben_cso_shd.g_old_rec.cso_attribute24;
735: End If;
736: If (p_rec.cso_attribute25 = hr_api.g_varchar2) then

Line 736: If (p_rec.cso_attribute25 = hr_api.g_varchar2) then

732: If (p_rec.cso_attribute24 = hr_api.g_varchar2) then
733: p_rec.cso_attribute24 :=
734: ben_cso_shd.g_old_rec.cso_attribute24;
735: End If;
736: If (p_rec.cso_attribute25 = hr_api.g_varchar2) then
737: p_rec.cso_attribute25 :=
738: ben_cso_shd.g_old_rec.cso_attribute25;
739: End If;
740: If (p_rec.cso_attribute26 = hr_api.g_varchar2) then

Line 740: If (p_rec.cso_attribute26 = hr_api.g_varchar2) then

736: If (p_rec.cso_attribute25 = hr_api.g_varchar2) then
737: p_rec.cso_attribute25 :=
738: ben_cso_shd.g_old_rec.cso_attribute25;
739: End If;
740: If (p_rec.cso_attribute26 = hr_api.g_varchar2) then
741: p_rec.cso_attribute26 :=
742: ben_cso_shd.g_old_rec.cso_attribute26;
743: End If;
744: If (p_rec.cso_attribute27 = hr_api.g_varchar2) then

Line 744: If (p_rec.cso_attribute27 = hr_api.g_varchar2) then

740: If (p_rec.cso_attribute26 = hr_api.g_varchar2) then
741: p_rec.cso_attribute26 :=
742: ben_cso_shd.g_old_rec.cso_attribute26;
743: End If;
744: If (p_rec.cso_attribute27 = hr_api.g_varchar2) then
745: p_rec.cso_attribute27 :=
746: ben_cso_shd.g_old_rec.cso_attribute27;
747: End If;
748: If (p_rec.cso_attribute28 = hr_api.g_varchar2) then

Line 748: If (p_rec.cso_attribute28 = hr_api.g_varchar2) then

744: If (p_rec.cso_attribute27 = hr_api.g_varchar2) then
745: p_rec.cso_attribute27 :=
746: ben_cso_shd.g_old_rec.cso_attribute27;
747: End If;
748: If (p_rec.cso_attribute28 = hr_api.g_varchar2) then
749: p_rec.cso_attribute28 :=
750: ben_cso_shd.g_old_rec.cso_attribute28;
751: End If;
752: If (p_rec.cso_attribute29 = hr_api.g_varchar2) then

Line 752: If (p_rec.cso_attribute29 = hr_api.g_varchar2) then

748: If (p_rec.cso_attribute28 = hr_api.g_varchar2) then
749: p_rec.cso_attribute28 :=
750: ben_cso_shd.g_old_rec.cso_attribute28;
751: End If;
752: If (p_rec.cso_attribute29 = hr_api.g_varchar2) then
753: p_rec.cso_attribute29 :=
754: ben_cso_shd.g_old_rec.cso_attribute29;
755: End If;
756: If (p_rec.cso_attribute30 = hr_api.g_varchar2) then

Line 756: If (p_rec.cso_attribute30 = hr_api.g_varchar2) then

752: If (p_rec.cso_attribute29 = hr_api.g_varchar2) then
753: p_rec.cso_attribute29 :=
754: ben_cso_shd.g_old_rec.cso_attribute29;
755: End If;
756: If (p_rec.cso_attribute30 = hr_api.g_varchar2) then
757: p_rec.cso_attribute30 :=
758: ben_cso_shd.g_old_rec.cso_attribute30;
759: End If;
760: --

Line 824: ,p_grant_id in number default hr_api.g_number

820: Procedure upd
821: (p_effective_date in date
822: ,p_cwb_stock_optn_dtls_id in number
823: ,p_object_version_number in out nocopy number
824: ,p_grant_id in number default hr_api.g_number
825: ,p_grant_number in varchar2 default hr_api.g_varchar2
826: ,p_grant_name in varchar2 default hr_api.g_varchar2
827: ,p_grant_type in varchar2 default hr_api.g_varchar2
828: ,p_grant_date in date default hr_api.g_date

Line 825: ,p_grant_number in varchar2 default hr_api.g_varchar2

821: (p_effective_date in date
822: ,p_cwb_stock_optn_dtls_id in number
823: ,p_object_version_number in out nocopy number
824: ,p_grant_id in number default hr_api.g_number
825: ,p_grant_number in varchar2 default hr_api.g_varchar2
826: ,p_grant_name in varchar2 default hr_api.g_varchar2
827: ,p_grant_type in varchar2 default hr_api.g_varchar2
828: ,p_grant_date in date default hr_api.g_date
829: ,p_grant_shares in number default hr_api.g_number

Line 826: ,p_grant_name in varchar2 default hr_api.g_varchar2

822: ,p_cwb_stock_optn_dtls_id in number
823: ,p_object_version_number in out nocopy number
824: ,p_grant_id in number default hr_api.g_number
825: ,p_grant_number in varchar2 default hr_api.g_varchar2
826: ,p_grant_name in varchar2 default hr_api.g_varchar2
827: ,p_grant_type in varchar2 default hr_api.g_varchar2
828: ,p_grant_date in date default hr_api.g_date
829: ,p_grant_shares in number default hr_api.g_number
830: ,p_grant_price in number default hr_api.g_number

Line 827: ,p_grant_type in varchar2 default hr_api.g_varchar2

823: ,p_object_version_number in out nocopy number
824: ,p_grant_id in number default hr_api.g_number
825: ,p_grant_number in varchar2 default hr_api.g_varchar2
826: ,p_grant_name in varchar2 default hr_api.g_varchar2
827: ,p_grant_type in varchar2 default hr_api.g_varchar2
828: ,p_grant_date in date default hr_api.g_date
829: ,p_grant_shares in number default hr_api.g_number
830: ,p_grant_price in number default hr_api.g_number
831: ,p_value_at_grant in number default hr_api.g_number

Line 828: ,p_grant_date in date default hr_api.g_date

824: ,p_grant_id in number default hr_api.g_number
825: ,p_grant_number in varchar2 default hr_api.g_varchar2
826: ,p_grant_name in varchar2 default hr_api.g_varchar2
827: ,p_grant_type in varchar2 default hr_api.g_varchar2
828: ,p_grant_date in date default hr_api.g_date
829: ,p_grant_shares in number default hr_api.g_number
830: ,p_grant_price in number default hr_api.g_number
831: ,p_value_at_grant in number default hr_api.g_number
832: ,p_current_share_price in number default hr_api.g_number

Line 829: ,p_grant_shares in number default hr_api.g_number

825: ,p_grant_number in varchar2 default hr_api.g_varchar2
826: ,p_grant_name in varchar2 default hr_api.g_varchar2
827: ,p_grant_type in varchar2 default hr_api.g_varchar2
828: ,p_grant_date in date default hr_api.g_date
829: ,p_grant_shares in number default hr_api.g_number
830: ,p_grant_price in number default hr_api.g_number
831: ,p_value_at_grant in number default hr_api.g_number
832: ,p_current_share_price in number default hr_api.g_number
833: ,p_current_shares_outstanding in number default hr_api.g_number

Line 830: ,p_grant_price in number default hr_api.g_number

826: ,p_grant_name in varchar2 default hr_api.g_varchar2
827: ,p_grant_type in varchar2 default hr_api.g_varchar2
828: ,p_grant_date in date default hr_api.g_date
829: ,p_grant_shares in number default hr_api.g_number
830: ,p_grant_price in number default hr_api.g_number
831: ,p_value_at_grant in number default hr_api.g_number
832: ,p_current_share_price in number default hr_api.g_number
833: ,p_current_shares_outstanding in number default hr_api.g_number
834: ,p_vested_shares in number default hr_api.g_number

Line 831: ,p_value_at_grant in number default hr_api.g_number

827: ,p_grant_type in varchar2 default hr_api.g_varchar2
828: ,p_grant_date in date default hr_api.g_date
829: ,p_grant_shares in number default hr_api.g_number
830: ,p_grant_price in number default hr_api.g_number
831: ,p_value_at_grant in number default hr_api.g_number
832: ,p_current_share_price in number default hr_api.g_number
833: ,p_current_shares_outstanding in number default hr_api.g_number
834: ,p_vested_shares in number default hr_api.g_number
835: ,p_unvested_shares in number default hr_api.g_number

Line 832: ,p_current_share_price in number default hr_api.g_number

828: ,p_grant_date in date default hr_api.g_date
829: ,p_grant_shares in number default hr_api.g_number
830: ,p_grant_price in number default hr_api.g_number
831: ,p_value_at_grant in number default hr_api.g_number
832: ,p_current_share_price in number default hr_api.g_number
833: ,p_current_shares_outstanding in number default hr_api.g_number
834: ,p_vested_shares in number default hr_api.g_number
835: ,p_unvested_shares in number default hr_api.g_number
836: ,p_exercisable_shares in number default hr_api.g_number

Line 833: ,p_current_shares_outstanding in number default hr_api.g_number

829: ,p_grant_shares in number default hr_api.g_number
830: ,p_grant_price in number default hr_api.g_number
831: ,p_value_at_grant in number default hr_api.g_number
832: ,p_current_share_price in number default hr_api.g_number
833: ,p_current_shares_outstanding in number default hr_api.g_number
834: ,p_vested_shares in number default hr_api.g_number
835: ,p_unvested_shares in number default hr_api.g_number
836: ,p_exercisable_shares in number default hr_api.g_number
837: ,p_exercised_shares in number default hr_api.g_number

Line 834: ,p_vested_shares in number default hr_api.g_number

830: ,p_grant_price in number default hr_api.g_number
831: ,p_value_at_grant in number default hr_api.g_number
832: ,p_current_share_price in number default hr_api.g_number
833: ,p_current_shares_outstanding in number default hr_api.g_number
834: ,p_vested_shares in number default hr_api.g_number
835: ,p_unvested_shares in number default hr_api.g_number
836: ,p_exercisable_shares in number default hr_api.g_number
837: ,p_exercised_shares in number default hr_api.g_number
838: ,p_cancelled_shares in number default hr_api.g_number

Line 835: ,p_unvested_shares in number default hr_api.g_number

831: ,p_value_at_grant in number default hr_api.g_number
832: ,p_current_share_price in number default hr_api.g_number
833: ,p_current_shares_outstanding in number default hr_api.g_number
834: ,p_vested_shares in number default hr_api.g_number
835: ,p_unvested_shares in number default hr_api.g_number
836: ,p_exercisable_shares in number default hr_api.g_number
837: ,p_exercised_shares in number default hr_api.g_number
838: ,p_cancelled_shares in number default hr_api.g_number
839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2

Line 836: ,p_exercisable_shares in number default hr_api.g_number

832: ,p_current_share_price in number default hr_api.g_number
833: ,p_current_shares_outstanding in number default hr_api.g_number
834: ,p_vested_shares in number default hr_api.g_number
835: ,p_unvested_shares in number default hr_api.g_number
836: ,p_exercisable_shares in number default hr_api.g_number
837: ,p_exercised_shares in number default hr_api.g_number
838: ,p_cancelled_shares in number default hr_api.g_number
839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
840: ,p_expiration_date in date default hr_api.g_date

Line 837: ,p_exercised_shares in number default hr_api.g_number

833: ,p_current_shares_outstanding in number default hr_api.g_number
834: ,p_vested_shares in number default hr_api.g_number
835: ,p_unvested_shares in number default hr_api.g_number
836: ,p_exercisable_shares in number default hr_api.g_number
837: ,p_exercised_shares in number default hr_api.g_number
838: ,p_cancelled_shares in number default hr_api.g_number
839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
840: ,p_expiration_date in date default hr_api.g_date
841: ,p_reason_code in varchar2 default hr_api.g_varchar2

Line 838: ,p_cancelled_shares in number default hr_api.g_number

834: ,p_vested_shares in number default hr_api.g_number
835: ,p_unvested_shares in number default hr_api.g_number
836: ,p_exercisable_shares in number default hr_api.g_number
837: ,p_exercised_shares in number default hr_api.g_number
838: ,p_cancelled_shares in number default hr_api.g_number
839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
840: ,p_expiration_date in date default hr_api.g_date
841: ,p_reason_code in varchar2 default hr_api.g_varchar2
842: ,p_class in varchar2 default hr_api.g_varchar2

Line 839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2

835: ,p_unvested_shares in number default hr_api.g_number
836: ,p_exercisable_shares in number default hr_api.g_number
837: ,p_exercised_shares in number default hr_api.g_number
838: ,p_cancelled_shares in number default hr_api.g_number
839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
840: ,p_expiration_date in date default hr_api.g_date
841: ,p_reason_code in varchar2 default hr_api.g_varchar2
842: ,p_class in varchar2 default hr_api.g_varchar2
843: ,p_misc in varchar2 default hr_api.g_varchar2

Line 840: ,p_expiration_date in date default hr_api.g_date

836: ,p_exercisable_shares in number default hr_api.g_number
837: ,p_exercised_shares in number default hr_api.g_number
838: ,p_cancelled_shares in number default hr_api.g_number
839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
840: ,p_expiration_date in date default hr_api.g_date
841: ,p_reason_code in varchar2 default hr_api.g_varchar2
842: ,p_class in varchar2 default hr_api.g_varchar2
843: ,p_misc in varchar2 default hr_api.g_varchar2
844: ,p_employee_number in varchar2 default hr_api.g_varchar2

Line 841: ,p_reason_code in varchar2 default hr_api.g_varchar2

837: ,p_exercised_shares in number default hr_api.g_number
838: ,p_cancelled_shares in number default hr_api.g_number
839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
840: ,p_expiration_date in date default hr_api.g_date
841: ,p_reason_code in varchar2 default hr_api.g_varchar2
842: ,p_class in varchar2 default hr_api.g_varchar2
843: ,p_misc in varchar2 default hr_api.g_varchar2
844: ,p_employee_number in varchar2 default hr_api.g_varchar2
845: ,p_person_id in number default hr_api.g_number

Line 842: ,p_class in varchar2 default hr_api.g_varchar2

838: ,p_cancelled_shares in number default hr_api.g_number
839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
840: ,p_expiration_date in date default hr_api.g_date
841: ,p_reason_code in varchar2 default hr_api.g_varchar2
842: ,p_class in varchar2 default hr_api.g_varchar2
843: ,p_misc in varchar2 default hr_api.g_varchar2
844: ,p_employee_number in varchar2 default hr_api.g_varchar2
845: ,p_person_id in number default hr_api.g_number
846: ,p_business_group_id in number default hr_api.g_number

Line 843: ,p_misc in varchar2 default hr_api.g_varchar2

839: ,p_trading_symbol in varchar2 default hr_api.g_varchar2
840: ,p_expiration_date in date default hr_api.g_date
841: ,p_reason_code in varchar2 default hr_api.g_varchar2
842: ,p_class in varchar2 default hr_api.g_varchar2
843: ,p_misc in varchar2 default hr_api.g_varchar2
844: ,p_employee_number in varchar2 default hr_api.g_varchar2
845: ,p_person_id in number default hr_api.g_number
846: ,p_business_group_id in number default hr_api.g_number
847: ,p_prtt_rt_val_id in number default hr_api.g_number

Line 844: ,p_employee_number in varchar2 default hr_api.g_varchar2

840: ,p_expiration_date in date default hr_api.g_date
841: ,p_reason_code in varchar2 default hr_api.g_varchar2
842: ,p_class in varchar2 default hr_api.g_varchar2
843: ,p_misc in varchar2 default hr_api.g_varchar2
844: ,p_employee_number in varchar2 default hr_api.g_varchar2
845: ,p_person_id in number default hr_api.g_number
846: ,p_business_group_id in number default hr_api.g_number
847: ,p_prtt_rt_val_id in number default hr_api.g_number
848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2

Line 845: ,p_person_id in number default hr_api.g_number

841: ,p_reason_code in varchar2 default hr_api.g_varchar2
842: ,p_class in varchar2 default hr_api.g_varchar2
843: ,p_misc in varchar2 default hr_api.g_varchar2
844: ,p_employee_number in varchar2 default hr_api.g_varchar2
845: ,p_person_id in number default hr_api.g_number
846: ,p_business_group_id in number default hr_api.g_number
847: ,p_prtt_rt_val_id in number default hr_api.g_number
848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2

Line 846: ,p_business_group_id in number default hr_api.g_number

842: ,p_class in varchar2 default hr_api.g_varchar2
843: ,p_misc in varchar2 default hr_api.g_varchar2
844: ,p_employee_number in varchar2 default hr_api.g_varchar2
845: ,p_person_id in number default hr_api.g_number
846: ,p_business_group_id in number default hr_api.g_number
847: ,p_prtt_rt_val_id in number default hr_api.g_number
848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2

Line 847: ,p_prtt_rt_val_id in number default hr_api.g_number

843: ,p_misc in varchar2 default hr_api.g_varchar2
844: ,p_employee_number in varchar2 default hr_api.g_varchar2
845: ,p_person_id in number default hr_api.g_number
846: ,p_business_group_id in number default hr_api.g_number
847: ,p_prtt_rt_val_id in number default hr_api.g_number
848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2

Line 848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2

844: ,p_employee_number in varchar2 default hr_api.g_varchar2
845: ,p_person_id in number default hr_api.g_number
846: ,p_business_group_id in number default hr_api.g_number
847: ,p_prtt_rt_val_id in number default hr_api.g_number
848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2

Line 849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2

845: ,p_person_id in number default hr_api.g_number
846: ,p_business_group_id in number default hr_api.g_number
847: ,p_prtt_rt_val_id in number default hr_api.g_number
848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2

Line 850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2

846: ,p_business_group_id in number default hr_api.g_number
847: ,p_prtt_rt_val_id in number default hr_api.g_number
848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2

Line 851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2

847: ,p_prtt_rt_val_id in number default hr_api.g_number
848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2

Line 852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2

848: ,p_cso_attribute_category in varchar2 default hr_api.g_varchar2
849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2

Line 853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2

849: ,p_cso_attribute1 in varchar2 default hr_api.g_varchar2
850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2

Line 854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2

850: ,p_cso_attribute2 in varchar2 default hr_api.g_varchar2
851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2

Line 855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2

851: ,p_cso_attribute3 in varchar2 default hr_api.g_varchar2
852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2

Line 856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2

852: ,p_cso_attribute4 in varchar2 default hr_api.g_varchar2
853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2

Line 857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2

853: ,p_cso_attribute5 in varchar2 default hr_api.g_varchar2
854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2

Line 858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2

854: ,p_cso_attribute6 in varchar2 default hr_api.g_varchar2
855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2

Line 859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2

855: ,p_cso_attribute7 in varchar2 default hr_api.g_varchar2
856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2

Line 860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2

856: ,p_cso_attribute8 in varchar2 default hr_api.g_varchar2
857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2

Line 861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2

857: ,p_cso_attribute9 in varchar2 default hr_api.g_varchar2
858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2

Line 862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2

858: ,p_cso_attribute10 in varchar2 default hr_api.g_varchar2
859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2

Line 863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2

859: ,p_cso_attribute11 in varchar2 default hr_api.g_varchar2
860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2

Line 864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2

860: ,p_cso_attribute12 in varchar2 default hr_api.g_varchar2
861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2

Line 865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2

861: ,p_cso_attribute13 in varchar2 default hr_api.g_varchar2
862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2

Line 866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2

862: ,p_cso_attribute14 in varchar2 default hr_api.g_varchar2
863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2

Line 867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2

863: ,p_cso_attribute15 in varchar2 default hr_api.g_varchar2
864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2

Line 868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2

864: ,p_cso_attribute16 in varchar2 default hr_api.g_varchar2
865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2

Line 869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2

865: ,p_cso_attribute17 in varchar2 default hr_api.g_varchar2
866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2

Line 870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2

866: ,p_cso_attribute18 in varchar2 default hr_api.g_varchar2
867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2

Line 871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2

867: ,p_cso_attribute19 in varchar2 default hr_api.g_varchar2
868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
875: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2

Line 872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2

868: ,p_cso_attribute20 in varchar2 default hr_api.g_varchar2
869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
875: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
876: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2

Line 873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2

869: ,p_cso_attribute21 in varchar2 default hr_api.g_varchar2
870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
875: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
876: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
877: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2

Line 874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2

870: ,p_cso_attribute22 in varchar2 default hr_api.g_varchar2
871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
875: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
876: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
877: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
878: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2

Line 875: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2

871: ,p_cso_attribute23 in varchar2 default hr_api.g_varchar2
872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
875: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
876: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
877: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
878: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
879: ) is

Line 876: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2

872: ,p_cso_attribute24 in varchar2 default hr_api.g_varchar2
873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
875: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
876: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
877: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
878: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
879: ) is
880: --

Line 877: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2

873: ,p_cso_attribute25 in varchar2 default hr_api.g_varchar2
874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
875: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
876: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
877: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
878: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
879: ) is
880: --
881: l_rec ben_cso_shd.g_rec_type;

Line 878: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2

874: ,p_cso_attribute26 in varchar2 default hr_api.g_varchar2
875: ,p_cso_attribute27 in varchar2 default hr_api.g_varchar2
876: ,p_cso_attribute28 in varchar2 default hr_api.g_varchar2
877: ,p_cso_attribute29 in varchar2 default hr_api.g_varchar2
878: ,p_cso_attribute30 in varchar2 default hr_api.g_varchar2
879: ) is
880: --
881: l_rec ben_cso_shd.g_rec_type;
882: l_proc varchar2(72) := g_package||'upd';