APPS.PQH_CRD_UPD dependencies on HR_API

Line 128: When hr_api.check_integrity_violated Then

124: --
125: hr_utility.set_location(' Leaving:'||l_proc, 10);
126: --
127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: --
131: pqh_crd_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: --
131: pqh_crd_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: --
136: pqh_crd_shd.constraint_error

Line 133: When hr_api.parent_integrity_violated Then

129: -- A check constraint has been violated
130: --
131: pqh_crd_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: --
136: pqh_crd_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: --
136: pqh_crd_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: --
141: pqh_crd_shd.constraint_error

Line 138: When hr_api.unique_integrity_violated Then

134: -- Parent integrity has been violated
135: --
136: pqh_crd_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: --
141: pqh_crd_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: --
141: pqh_crd_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When Others Then
144: --
145: Raise;
146: End update_dml;

Line 435: when hr_api.cannot_find_prog_unit then

431: );
432: --
433: exception
434: --
435: when hr_api.cannot_find_prog_unit then
436: --
437: hr_api.cannot_find_prog_unit_error
438: (p_module_name => 'PQH_CRITERIA_RATE_DEFN'
439: ,p_hook_type => 'AU');

Line 437: hr_api.cannot_find_prog_unit_error

433: exception
434: --
435: when hr_api.cannot_find_prog_unit then
436: --
437: hr_api.cannot_find_prog_unit_error
438: (p_module_name => 'PQH_CRITERIA_RATE_DEFN'
439: ,p_hook_type => 'AU');
440: --
441: end;

Line 500: If (p_rec.short_name = hr_api.g_varchar2) then

496: -- p_rec plsql record structure
497: -- to see if a system default is being used. If a system default
498: -- is being used then we must set to the 'current' argument value.
499: --
500: If (p_rec.short_name = hr_api.g_varchar2) then
501: p_rec.short_name :=
502: pqh_crd_shd.g_old_rec.short_name;
503: End If;
504: If (p_rec.uom = hr_api.g_varchar2) then

Line 504: If (p_rec.uom = hr_api.g_varchar2) then

500: If (p_rec.short_name = hr_api.g_varchar2) then
501: p_rec.short_name :=
502: pqh_crd_shd.g_old_rec.short_name;
503: End If;
504: If (p_rec.uom = hr_api.g_varchar2) then
505: p_rec.uom :=
506: pqh_crd_shd.g_old_rec.uom;
507: End If;
508: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 508: If (p_rec.currency_code = hr_api.g_varchar2) then

504: If (p_rec.uom = hr_api.g_varchar2) then
505: p_rec.uom :=
506: pqh_crd_shd.g_old_rec.uom;
507: End If;
508: If (p_rec.currency_code = hr_api.g_varchar2) then
509: p_rec.currency_code :=
510: pqh_crd_shd.g_old_rec.currency_code;
511: End If;
512: If (p_rec.reference_period_cd = hr_api.g_varchar2) then

Line 512: If (p_rec.reference_period_cd = hr_api.g_varchar2) then

508: If (p_rec.currency_code = hr_api.g_varchar2) then
509: p_rec.currency_code :=
510: pqh_crd_shd.g_old_rec.currency_code;
511: End If;
512: If (p_rec.reference_period_cd = hr_api.g_varchar2) then
513: p_rec.reference_period_cd :=
514: pqh_crd_shd.g_old_rec.reference_period_cd;
515: End If;
516: If (p_rec.define_max_rate_flag = hr_api.g_varchar2) then

Line 516: If (p_rec.define_max_rate_flag = hr_api.g_varchar2) then

512: If (p_rec.reference_period_cd = hr_api.g_varchar2) then
513: p_rec.reference_period_cd :=
514: pqh_crd_shd.g_old_rec.reference_period_cd;
515: End If;
516: If (p_rec.define_max_rate_flag = hr_api.g_varchar2) then
517: p_rec.define_max_rate_flag :=
518: pqh_crd_shd.g_old_rec.define_max_rate_flag;
519: End If;
520: If (p_rec.define_min_rate_flag = hr_api.g_varchar2) then

Line 520: If (p_rec.define_min_rate_flag = hr_api.g_varchar2) then

516: If (p_rec.define_max_rate_flag = hr_api.g_varchar2) then
517: p_rec.define_max_rate_flag :=
518: pqh_crd_shd.g_old_rec.define_max_rate_flag;
519: End If;
520: If (p_rec.define_min_rate_flag = hr_api.g_varchar2) then
521: p_rec.define_min_rate_flag :=
522: pqh_crd_shd.g_old_rec.define_min_rate_flag;
523: End If;
524: If (p_rec.define_mid_rate_flag = hr_api.g_varchar2) then

Line 524: If (p_rec.define_mid_rate_flag = hr_api.g_varchar2) then

520: If (p_rec.define_min_rate_flag = hr_api.g_varchar2) then
521: p_rec.define_min_rate_flag :=
522: pqh_crd_shd.g_old_rec.define_min_rate_flag;
523: End If;
524: If (p_rec.define_mid_rate_flag = hr_api.g_varchar2) then
525: p_rec.define_mid_rate_flag :=
526: pqh_crd_shd.g_old_rec.define_mid_rate_flag;
527: End If;
528: If (p_rec.define_std_rate_flag = hr_api.g_varchar2) then

Line 528: If (p_rec.define_std_rate_flag = hr_api.g_varchar2) then

524: If (p_rec.define_mid_rate_flag = hr_api.g_varchar2) then
525: p_rec.define_mid_rate_flag :=
526: pqh_crd_shd.g_old_rec.define_mid_rate_flag;
527: End If;
528: If (p_rec.define_std_rate_flag = hr_api.g_varchar2) then
529: p_rec.define_std_rate_flag :=
530: pqh_crd_shd.g_old_rec.define_std_rate_flag;
531: End If;
532: If (p_rec.rate_calc_cd = hr_api.g_varchar2) then

Line 532: If (p_rec.rate_calc_cd = hr_api.g_varchar2) then

528: If (p_rec.define_std_rate_flag = hr_api.g_varchar2) then
529: p_rec.define_std_rate_flag :=
530: pqh_crd_shd.g_old_rec.define_std_rate_flag;
531: End If;
532: If (p_rec.rate_calc_cd = hr_api.g_varchar2) then
533: p_rec.rate_calc_cd :=
534: pqh_crd_shd.g_old_rec.rate_calc_cd;
535: End If;
536: If (p_rec.rate_calc_rule = hr_api.g_number) then

Line 536: If (p_rec.rate_calc_rule = hr_api.g_number) then

532: If (p_rec.rate_calc_cd = hr_api.g_varchar2) then
533: p_rec.rate_calc_cd :=
534: pqh_crd_shd.g_old_rec.rate_calc_cd;
535: End If;
536: If (p_rec.rate_calc_rule = hr_api.g_number) then
537: p_rec.rate_calc_rule :=
538: pqh_crd_shd.g_old_rec.rate_calc_rule;
539: End If;
540: If (p_rec.preferential_rate_cd = hr_api.g_varchar2) then

Line 540: If (p_rec.preferential_rate_cd = hr_api.g_varchar2) then

536: If (p_rec.rate_calc_rule = hr_api.g_number) then
537: p_rec.rate_calc_rule :=
538: pqh_crd_shd.g_old_rec.rate_calc_rule;
539: End If;
540: If (p_rec.preferential_rate_cd = hr_api.g_varchar2) then
541: p_rec.preferential_rate_cd :=
542: pqh_crd_shd.g_old_rec.preferential_rate_cd;
543: End If;
544: If (p_rec.preferential_rate_rule = hr_api.g_number) then

Line 544: If (p_rec.preferential_rate_rule = hr_api.g_number) then

540: If (p_rec.preferential_rate_cd = hr_api.g_varchar2) then
541: p_rec.preferential_rate_cd :=
542: pqh_crd_shd.g_old_rec.preferential_rate_cd;
543: End If;
544: If (p_rec.preferential_rate_rule = hr_api.g_number) then
545: p_rec.preferential_rate_rule :=
546: pqh_crd_shd.g_old_rec.preferential_rate_rule;
547: End If;
548: If (p_rec.rounding_cd = hr_api.g_varchar2) then

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

544: If (p_rec.preferential_rate_rule = hr_api.g_number) then
545: p_rec.preferential_rate_rule :=
546: pqh_crd_shd.g_old_rec.preferential_rate_rule;
547: End If;
548: If (p_rec.rounding_cd = hr_api.g_varchar2) then
549: p_rec.rounding_cd :=
550: pqh_crd_shd.g_old_rec.rounding_cd;
551: End If;
552: If (p_rec.rounding_rule = hr_api.g_number) then

Line 552: If (p_rec.rounding_rule = hr_api.g_number) then

548: If (p_rec.rounding_cd = hr_api.g_varchar2) then
549: p_rec.rounding_cd :=
550: pqh_crd_shd.g_old_rec.rounding_cd;
551: End If;
552: If (p_rec.rounding_rule = hr_api.g_number) then
553: p_rec.rounding_rule :=
554: pqh_crd_shd.g_old_rec.rounding_rule;
555: End If;
556: If (p_rec.business_group_id = hr_api.g_number) then

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

552: If (p_rec.rounding_rule = hr_api.g_number) then
553: p_rec.rounding_rule :=
554: pqh_crd_shd.g_old_rec.rounding_rule;
555: End If;
556: If (p_rec.business_group_id = hr_api.g_number) then
557: p_rec.business_group_id :=
558: pqh_crd_shd.g_old_rec.business_group_id;
559: End If;
560: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

556: If (p_rec.business_group_id = hr_api.g_number) then
557: p_rec.business_group_id :=
558: pqh_crd_shd.g_old_rec.business_group_id;
559: End If;
560: If (p_rec.legislation_code = hr_api.g_varchar2) then
561: p_rec.legislation_code :=
562: pqh_crd_shd.g_old_rec.legislation_code;
563: End If;
564: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 564: If (p_rec.attribute_category = hr_api.g_varchar2) then

560: If (p_rec.legislation_code = hr_api.g_varchar2) then
561: p_rec.legislation_code :=
562: pqh_crd_shd.g_old_rec.legislation_code;
563: End If;
564: If (p_rec.attribute_category = hr_api.g_varchar2) then
565: p_rec.attribute_category :=
566: pqh_crd_shd.g_old_rec.attribute_category;
567: End If;
568: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 568: If (p_rec.attribute1 = hr_api.g_varchar2) then

564: If (p_rec.attribute_category = hr_api.g_varchar2) then
565: p_rec.attribute_category :=
566: pqh_crd_shd.g_old_rec.attribute_category;
567: End If;
568: If (p_rec.attribute1 = hr_api.g_varchar2) then
569: p_rec.attribute1 :=
570: pqh_crd_shd.g_old_rec.attribute1;
571: End If;
572: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 572: If (p_rec.attribute2 = hr_api.g_varchar2) then

568: If (p_rec.attribute1 = hr_api.g_varchar2) then
569: p_rec.attribute1 :=
570: pqh_crd_shd.g_old_rec.attribute1;
571: End If;
572: If (p_rec.attribute2 = hr_api.g_varchar2) then
573: p_rec.attribute2 :=
574: pqh_crd_shd.g_old_rec.attribute2;
575: End If;
576: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 576: If (p_rec.attribute3 = hr_api.g_varchar2) then

572: If (p_rec.attribute2 = hr_api.g_varchar2) then
573: p_rec.attribute2 :=
574: pqh_crd_shd.g_old_rec.attribute2;
575: End If;
576: If (p_rec.attribute3 = hr_api.g_varchar2) then
577: p_rec.attribute3 :=
578: pqh_crd_shd.g_old_rec.attribute3;
579: End If;
580: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 580: If (p_rec.attribute4 = hr_api.g_varchar2) then

576: If (p_rec.attribute3 = hr_api.g_varchar2) then
577: p_rec.attribute3 :=
578: pqh_crd_shd.g_old_rec.attribute3;
579: End If;
580: If (p_rec.attribute4 = hr_api.g_varchar2) then
581: p_rec.attribute4 :=
582: pqh_crd_shd.g_old_rec.attribute4;
583: End If;
584: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 584: If (p_rec.attribute5 = hr_api.g_varchar2) then

580: If (p_rec.attribute4 = hr_api.g_varchar2) then
581: p_rec.attribute4 :=
582: pqh_crd_shd.g_old_rec.attribute4;
583: End If;
584: If (p_rec.attribute5 = hr_api.g_varchar2) then
585: p_rec.attribute5 :=
586: pqh_crd_shd.g_old_rec.attribute5;
587: End If;
588: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 588: If (p_rec.attribute6 = hr_api.g_varchar2) then

584: If (p_rec.attribute5 = hr_api.g_varchar2) then
585: p_rec.attribute5 :=
586: pqh_crd_shd.g_old_rec.attribute5;
587: End If;
588: If (p_rec.attribute6 = hr_api.g_varchar2) then
589: p_rec.attribute6 :=
590: pqh_crd_shd.g_old_rec.attribute6;
591: End If;
592: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 592: If (p_rec.attribute7 = hr_api.g_varchar2) then

588: If (p_rec.attribute6 = hr_api.g_varchar2) then
589: p_rec.attribute6 :=
590: pqh_crd_shd.g_old_rec.attribute6;
591: End If;
592: If (p_rec.attribute7 = hr_api.g_varchar2) then
593: p_rec.attribute7 :=
594: pqh_crd_shd.g_old_rec.attribute7;
595: End If;
596: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 596: If (p_rec.attribute8 = hr_api.g_varchar2) then

592: If (p_rec.attribute7 = hr_api.g_varchar2) then
593: p_rec.attribute7 :=
594: pqh_crd_shd.g_old_rec.attribute7;
595: End If;
596: If (p_rec.attribute8 = hr_api.g_varchar2) then
597: p_rec.attribute8 :=
598: pqh_crd_shd.g_old_rec.attribute8;
599: End If;
600: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

596: If (p_rec.attribute8 = hr_api.g_varchar2) then
597: p_rec.attribute8 :=
598: pqh_crd_shd.g_old_rec.attribute8;
599: End If;
600: If (p_rec.attribute9 = hr_api.g_varchar2) then
601: p_rec.attribute9 :=
602: pqh_crd_shd.g_old_rec.attribute9;
603: End If;
604: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 604: If (p_rec.attribute10 = hr_api.g_varchar2) then

600: If (p_rec.attribute9 = hr_api.g_varchar2) then
601: p_rec.attribute9 :=
602: pqh_crd_shd.g_old_rec.attribute9;
603: End If;
604: If (p_rec.attribute10 = hr_api.g_varchar2) then
605: p_rec.attribute10 :=
606: pqh_crd_shd.g_old_rec.attribute10;
607: End If;
608: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

604: If (p_rec.attribute10 = hr_api.g_varchar2) then
605: p_rec.attribute10 :=
606: pqh_crd_shd.g_old_rec.attribute10;
607: End If;
608: If (p_rec.attribute11 = hr_api.g_varchar2) then
609: p_rec.attribute11 :=
610: pqh_crd_shd.g_old_rec.attribute11;
611: End If;
612: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

608: If (p_rec.attribute11 = hr_api.g_varchar2) then
609: p_rec.attribute11 :=
610: pqh_crd_shd.g_old_rec.attribute11;
611: End If;
612: If (p_rec.attribute12 = hr_api.g_varchar2) then
613: p_rec.attribute12 :=
614: pqh_crd_shd.g_old_rec.attribute12;
615: End If;
616: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

612: If (p_rec.attribute12 = hr_api.g_varchar2) then
613: p_rec.attribute12 :=
614: pqh_crd_shd.g_old_rec.attribute12;
615: End If;
616: If (p_rec.attribute13 = hr_api.g_varchar2) then
617: p_rec.attribute13 :=
618: pqh_crd_shd.g_old_rec.attribute13;
619: End If;
620: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

616: If (p_rec.attribute13 = hr_api.g_varchar2) then
617: p_rec.attribute13 :=
618: pqh_crd_shd.g_old_rec.attribute13;
619: End If;
620: If (p_rec.attribute14 = hr_api.g_varchar2) then
621: p_rec.attribute14 :=
622: pqh_crd_shd.g_old_rec.attribute14;
623: End If;
624: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 624: If (p_rec.attribute15 = hr_api.g_varchar2) then

620: If (p_rec.attribute14 = hr_api.g_varchar2) then
621: p_rec.attribute14 :=
622: pqh_crd_shd.g_old_rec.attribute14;
623: End If;
624: If (p_rec.attribute15 = hr_api.g_varchar2) then
625: p_rec.attribute15 :=
626: pqh_crd_shd.g_old_rec.attribute15;
627: End If;
628: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 628: If (p_rec.attribute16 = hr_api.g_varchar2) then

624: If (p_rec.attribute15 = hr_api.g_varchar2) then
625: p_rec.attribute15 :=
626: pqh_crd_shd.g_old_rec.attribute15;
627: End If;
628: If (p_rec.attribute16 = hr_api.g_varchar2) then
629: p_rec.attribute16 :=
630: pqh_crd_shd.g_old_rec.attribute16;
631: End If;
632: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 632: If (p_rec.attribute17 = hr_api.g_varchar2) then

628: If (p_rec.attribute16 = hr_api.g_varchar2) then
629: p_rec.attribute16 :=
630: pqh_crd_shd.g_old_rec.attribute16;
631: End If;
632: If (p_rec.attribute17 = hr_api.g_varchar2) then
633: p_rec.attribute17 :=
634: pqh_crd_shd.g_old_rec.attribute17;
635: End If;
636: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

632: If (p_rec.attribute17 = hr_api.g_varchar2) then
633: p_rec.attribute17 :=
634: pqh_crd_shd.g_old_rec.attribute17;
635: End If;
636: If (p_rec.attribute18 = hr_api.g_varchar2) then
637: p_rec.attribute18 :=
638: pqh_crd_shd.g_old_rec.attribute18;
639: End If;
640: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

636: If (p_rec.attribute18 = hr_api.g_varchar2) then
637: p_rec.attribute18 :=
638: pqh_crd_shd.g_old_rec.attribute18;
639: End If;
640: If (p_rec.attribute19 = hr_api.g_varchar2) then
641: p_rec.attribute19 :=
642: pqh_crd_shd.g_old_rec.attribute19;
643: End If;
644: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

640: If (p_rec.attribute19 = hr_api.g_varchar2) then
641: p_rec.attribute19 :=
642: pqh_crd_shd.g_old_rec.attribute19;
643: End If;
644: If (p_rec.attribute20 = hr_api.g_varchar2) then
645: p_rec.attribute20 :=
646: pqh_crd_shd.g_old_rec.attribute20;
647: End If;
648: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

644: If (p_rec.attribute20 = hr_api.g_varchar2) then
645: p_rec.attribute20 :=
646: pqh_crd_shd.g_old_rec.attribute20;
647: End If;
648: If (p_rec.attribute21 = hr_api.g_varchar2) then
649: p_rec.attribute21 :=
650: pqh_crd_shd.g_old_rec.attribute21;
651: End If;
652: If (p_rec.attribute22 = hr_api.g_varchar2) then

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

648: If (p_rec.attribute21 = hr_api.g_varchar2) then
649: p_rec.attribute21 :=
650: pqh_crd_shd.g_old_rec.attribute21;
651: End If;
652: If (p_rec.attribute22 = hr_api.g_varchar2) then
653: p_rec.attribute22 :=
654: pqh_crd_shd.g_old_rec.attribute22;
655: End If;
656: If (p_rec.attribute23 = hr_api.g_varchar2) then

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

652: If (p_rec.attribute22 = hr_api.g_varchar2) then
653: p_rec.attribute22 :=
654: pqh_crd_shd.g_old_rec.attribute22;
655: End If;
656: If (p_rec.attribute23 = hr_api.g_varchar2) then
657: p_rec.attribute23 :=
658: pqh_crd_shd.g_old_rec.attribute23;
659: End If;
660: If (p_rec.attribute24 = hr_api.g_varchar2) then

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

656: If (p_rec.attribute23 = hr_api.g_varchar2) then
657: p_rec.attribute23 :=
658: pqh_crd_shd.g_old_rec.attribute23;
659: End If;
660: If (p_rec.attribute24 = hr_api.g_varchar2) then
661: p_rec.attribute24 :=
662: pqh_crd_shd.g_old_rec.attribute24;
663: End If;
664: If (p_rec.attribute25 = hr_api.g_varchar2) then

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

660: If (p_rec.attribute24 = hr_api.g_varchar2) then
661: p_rec.attribute24 :=
662: pqh_crd_shd.g_old_rec.attribute24;
663: End If;
664: If (p_rec.attribute25 = hr_api.g_varchar2) then
665: p_rec.attribute25 :=
666: pqh_crd_shd.g_old_rec.attribute25;
667: End If;
668: If (p_rec.attribute26 = hr_api.g_varchar2) then

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

664: If (p_rec.attribute25 = hr_api.g_varchar2) then
665: p_rec.attribute25 :=
666: pqh_crd_shd.g_old_rec.attribute25;
667: End If;
668: If (p_rec.attribute26 = hr_api.g_varchar2) then
669: p_rec.attribute26 :=
670: pqh_crd_shd.g_old_rec.attribute26;
671: End If;
672: If (p_rec.attribute27 = hr_api.g_varchar2) then

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

668: If (p_rec.attribute26 = hr_api.g_varchar2) then
669: p_rec.attribute26 :=
670: pqh_crd_shd.g_old_rec.attribute26;
671: End If;
672: If (p_rec.attribute27 = hr_api.g_varchar2) then
673: p_rec.attribute27 :=
674: pqh_crd_shd.g_old_rec.attribute27;
675: End If;
676: If (p_rec.attribute28 = hr_api.g_varchar2) then

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

672: If (p_rec.attribute27 = hr_api.g_varchar2) then
673: p_rec.attribute27 :=
674: pqh_crd_shd.g_old_rec.attribute27;
675: End If;
676: If (p_rec.attribute28 = hr_api.g_varchar2) then
677: p_rec.attribute28 :=
678: pqh_crd_shd.g_old_rec.attribute28;
679: End If;
680: If (p_rec.attribute29 = hr_api.g_varchar2) then

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

676: If (p_rec.attribute28 = hr_api.g_varchar2) then
677: p_rec.attribute28 :=
678: pqh_crd_shd.g_old_rec.attribute28;
679: End If;
680: If (p_rec.attribute29 = hr_api.g_varchar2) then
681: p_rec.attribute29 :=
682: pqh_crd_shd.g_old_rec.attribute29;
683: End If;
684: If (p_rec.attribute30 = hr_api.g_varchar2) then

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

680: If (p_rec.attribute29 = hr_api.g_varchar2) then
681: p_rec.attribute29 :=
682: pqh_crd_shd.g_old_rec.attribute29;
683: End If;
684: If (p_rec.attribute30 = hr_api.g_varchar2) then
685: p_rec.attribute30 :=
686: pqh_crd_shd.g_old_rec.attribute30;
687: End If;
688: --

Line 752: ,p_uom in varchar2 default hr_api.g_varchar2

748: Procedure upd
749: (p_effective_date in date
750: ,p_criteria_rate_defn_id in number
751: ,p_object_version_number in out nocopy number
752: ,p_uom in varchar2 default hr_api.g_varchar2
753: ,p_rate_calc_cd in varchar2 default hr_api.g_varchar2
754: ,p_preferential_rate_cd in varchar2 default hr_api.g_varchar2
755: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
756: ,p_short_name in varchar2 default hr_api.g_varchar2

Line 753: ,p_rate_calc_cd in varchar2 default hr_api.g_varchar2

749: (p_effective_date in date
750: ,p_criteria_rate_defn_id in number
751: ,p_object_version_number in out nocopy number
752: ,p_uom in varchar2 default hr_api.g_varchar2
753: ,p_rate_calc_cd in varchar2 default hr_api.g_varchar2
754: ,p_preferential_rate_cd in varchar2 default hr_api.g_varchar2
755: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
756: ,p_short_name in varchar2 default hr_api.g_varchar2
757: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 754: ,p_preferential_rate_cd in varchar2 default hr_api.g_varchar2

750: ,p_criteria_rate_defn_id in number
751: ,p_object_version_number in out nocopy number
752: ,p_uom in varchar2 default hr_api.g_varchar2
753: ,p_rate_calc_cd in varchar2 default hr_api.g_varchar2
754: ,p_preferential_rate_cd in varchar2 default hr_api.g_varchar2
755: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
756: ,p_short_name in varchar2 default hr_api.g_varchar2
757: ,p_currency_code in varchar2 default hr_api.g_varchar2
758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2

Line 755: ,p_rounding_cd in varchar2 default hr_api.g_varchar2

751: ,p_object_version_number in out nocopy number
752: ,p_uom in varchar2 default hr_api.g_varchar2
753: ,p_rate_calc_cd in varchar2 default hr_api.g_varchar2
754: ,p_preferential_rate_cd in varchar2 default hr_api.g_varchar2
755: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
756: ,p_short_name in varchar2 default hr_api.g_varchar2
757: ,p_currency_code in varchar2 default hr_api.g_varchar2
758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2

Line 756: ,p_short_name in varchar2 default hr_api.g_varchar2

752: ,p_uom in varchar2 default hr_api.g_varchar2
753: ,p_rate_calc_cd in varchar2 default hr_api.g_varchar2
754: ,p_preferential_rate_cd in varchar2 default hr_api.g_varchar2
755: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
756: ,p_short_name in varchar2 default hr_api.g_varchar2
757: ,p_currency_code in varchar2 default hr_api.g_varchar2
758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2

Line 757: ,p_currency_code in varchar2 default hr_api.g_varchar2

753: ,p_rate_calc_cd in varchar2 default hr_api.g_varchar2
754: ,p_preferential_rate_cd in varchar2 default hr_api.g_varchar2
755: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
756: ,p_short_name in varchar2 default hr_api.g_varchar2
757: ,p_currency_code in varchar2 default hr_api.g_varchar2
758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2

Line 758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2

754: ,p_preferential_rate_cd in varchar2 default hr_api.g_varchar2
755: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
756: ,p_short_name in varchar2 default hr_api.g_varchar2
757: ,p_currency_code in varchar2 default hr_api.g_varchar2
758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2

Line 759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2

755: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
756: ,p_short_name in varchar2 default hr_api.g_varchar2
757: ,p_currency_code in varchar2 default hr_api.g_varchar2
758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
763: ,p_rate_calc_rule in number default hr_api.g_number

Line 760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2

756: ,p_short_name in varchar2 default hr_api.g_varchar2
757: ,p_currency_code in varchar2 default hr_api.g_varchar2
758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
763: ,p_rate_calc_rule in number default hr_api.g_number
764: ,p_preferential_rate_rule in number default hr_api.g_number

Line 761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2

757: ,p_currency_code in varchar2 default hr_api.g_varchar2
758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
763: ,p_rate_calc_rule in number default hr_api.g_number
764: ,p_preferential_rate_rule in number default hr_api.g_number
765: ,p_rounding_rule in number default hr_api.g_number

Line 762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2

758: ,p_reference_period_cd in varchar2 default hr_api.g_varchar2
759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
763: ,p_rate_calc_rule in number default hr_api.g_number
764: ,p_preferential_rate_rule in number default hr_api.g_number
765: ,p_rounding_rule in number default hr_api.g_number
766: ,p_business_group_id in number default hr_api.g_number

Line 763: ,p_rate_calc_rule in number default hr_api.g_number

759: ,p_define_max_rate_flag in varchar2 default hr_api.g_varchar2
760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
763: ,p_rate_calc_rule in number default hr_api.g_number
764: ,p_preferential_rate_rule in number default hr_api.g_number
765: ,p_rounding_rule in number default hr_api.g_number
766: ,p_business_group_id in number default hr_api.g_number
767: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 764: ,p_preferential_rate_rule in number default hr_api.g_number

760: ,p_define_min_rate_flag in varchar2 default hr_api.g_varchar2
761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
763: ,p_rate_calc_rule in number default hr_api.g_number
764: ,p_preferential_rate_rule in number default hr_api.g_number
765: ,p_rounding_rule in number default hr_api.g_number
766: ,p_business_group_id in number default hr_api.g_number
767: ,p_legislation_code in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 765: ,p_rounding_rule in number default hr_api.g_number

761: ,p_define_mid_rate_flag in varchar2 default hr_api.g_varchar2
762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
763: ,p_rate_calc_rule in number default hr_api.g_number
764: ,p_preferential_rate_rule in number default hr_api.g_number
765: ,p_rounding_rule in number default hr_api.g_number
766: ,p_business_group_id in number default hr_api.g_number
767: ,p_legislation_code in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 766: ,p_business_group_id in number default hr_api.g_number

762: ,p_define_std_rate_flag in varchar2 default hr_api.g_varchar2
763: ,p_rate_calc_rule in number default hr_api.g_number
764: ,p_preferential_rate_rule in number default hr_api.g_number
765: ,p_rounding_rule in number default hr_api.g_number
766: ,p_business_group_id in number default hr_api.g_number
767: ,p_legislation_code in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 767: ,p_legislation_code in varchar2 default hr_api.g_varchar2

763: ,p_rate_calc_rule in number default hr_api.g_number
764: ,p_preferential_rate_rule in number default hr_api.g_number
765: ,p_rounding_rule in number default hr_api.g_number
766: ,p_business_group_id in number default hr_api.g_number
767: ,p_legislation_code in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 768: ,p_attribute_category in varchar2 default hr_api.g_varchar2

764: ,p_preferential_rate_rule in number default hr_api.g_number
765: ,p_rounding_rule in number default hr_api.g_number
766: ,p_business_group_id in number default hr_api.g_number
767: ,p_legislation_code in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 769: ,p_attribute1 in varchar2 default hr_api.g_varchar2

765: ,p_rounding_rule in number default hr_api.g_number
766: ,p_business_group_id in number default hr_api.g_number
767: ,p_legislation_code in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 770: ,p_attribute2 in varchar2 default hr_api.g_varchar2

766: ,p_business_group_id in number default hr_api.g_number
767: ,p_legislation_code in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 771: ,p_attribute3 in varchar2 default hr_api.g_varchar2

767: ,p_legislation_code in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 772: ,p_attribute4 in varchar2 default hr_api.g_varchar2

768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 773: ,p_attribute5 in varchar2 default hr_api.g_varchar2

769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 774: ,p_attribute6 in varchar2 default hr_api.g_varchar2

770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 775: ,p_attribute7 in varchar2 default hr_api.g_varchar2

771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 776: ,p_attribute8 in varchar2 default hr_api.g_varchar2

772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 777: ,p_attribute9 in varchar2 default hr_api.g_varchar2

773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 778: ,p_attribute10 in varchar2 default hr_api.g_varchar2

774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 779: ,p_attribute11 in varchar2 default hr_api.g_varchar2

775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 780: ,p_attribute12 in varchar2 default hr_api.g_varchar2

776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 781: ,p_attribute13 in varchar2 default hr_api.g_varchar2

777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 782: ,p_attribute14 in varchar2 default hr_api.g_varchar2

778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 783: ,p_attribute15 in varchar2 default hr_api.g_varchar2

779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 784: ,p_attribute16 in varchar2 default hr_api.g_varchar2

780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 785: ,p_attribute17 in varchar2 default hr_api.g_varchar2

781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 786: ,p_attribute18 in varchar2 default hr_api.g_varchar2

782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 787: ,p_attribute19 in varchar2 default hr_api.g_varchar2

783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 788: ,p_attribute20 in varchar2 default hr_api.g_varchar2

784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 789: ,p_attribute21 in varchar2 default hr_api.g_varchar2

785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 790: ,p_attribute22 in varchar2 default hr_api.g_varchar2

786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 791: ,p_attribute23 in varchar2 default hr_api.g_varchar2

787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 792: ,p_attribute24 in varchar2 default hr_api.g_varchar2

788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 793: ,p_attribute25 in varchar2 default hr_api.g_varchar2

789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 794: ,p_attribute26 in varchar2 default hr_api.g_varchar2

790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 795: ,p_attribute27 in varchar2 default hr_api.g_varchar2

791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ) is

Line 796: ,p_attribute28 in varchar2 default hr_api.g_varchar2

792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ) is
800: --

Line 797: ,p_attribute29 in varchar2 default hr_api.g_varchar2

793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ) is
800: --
801: l_rec pqh_crd_shd.g_rec_type;

Line 798: ,p_attribute30 in varchar2 default hr_api.g_varchar2

794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ) is
800: --
801: l_rec pqh_crd_shd.g_rec_type;
802: l_proc varchar2(72) := g_package||'upd';