58: -- If the grade_or_spinal_point_id refers to spinal point and the spinal
59: -- point exists on per_spinal_points then processing continues
60: --
61: -- If the combination of grade_or_spinal_point_id, business_group_id,
62: -- rate_id and rate_type is unique on pay_grade_rules_f between the start
63: -- and end effective dates then processing continues
64: --
65: -- If the business group of the grade rule is the same as the
66: -- business group of the spinal point.
86: --
87: -- {End Of Comments}
88: -- ----------------------------------------------------------------------------
89: procedure chk_grade_or_spinal_point_id
90: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
91: ,p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE
92: ,p_effective_start_date in date
93: ,p_effective_end_date in date
94: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
87: -- {End Of Comments}
88: -- ----------------------------------------------------------------------------
89: procedure chk_grade_or_spinal_point_id
90: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
91: ,p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE
92: ,p_effective_start_date in date
93: ,p_effective_end_date in date
94: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
95: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
90: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
91: ,p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE
92: ,p_effective_start_date in date
93: ,p_effective_end_date in date
94: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
95: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
96: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
97: ,p_effective_date in date
98: ) is
91: ,p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE
92: ,p_effective_start_date in date
93: ,p_effective_end_date in date
94: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
95: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
96: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
97: ,p_effective_date in date
98: ) is
99: --
92: ,p_effective_start_date in date
93: ,p_effective_end_date in date
94: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
95: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
96: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
97: ,p_effective_date in date
98: ) is
99: --
100: l_exists varchar2(1);
98: ) is
99: --
100: l_exists varchar2(1);
101: l_proc varchar2(72) := g_package||'chk_grade_or_spinal_point_id';
102: l_business_group_id pay_grade_rules_f.business_group_id%type;
103: --
104: cursor csr_valid_grade_id is
105: select business_group_id
106: from per_grades pg
115: where psp.spinal_point_id = p_grade_or_spinal_point_id;
116: --
117: cursor csr_unique_rate is
118: select null
119: from pay_grade_rules_f pgr
120: where pgr.rate_id = p_rate_id
121: and pgr.business_group_id = p_business_group_id
122: and pgr.rate_type = p_rate_type
123: and pgr.grade_or_spinal_point_id = p_grade_or_spinal_point_id
267: --
268: -- {End Of Comments}
269: -- ----------------------------------------------------------------------------
270: procedure chk_rate_id
271: (p_rate_id in pay_grade_rules_f.rate_id%TYPE,
272: p_business_group_id pay_grade_rules_f.business_group_id%TYPE
273: )
274: is
275: --
268: -- {End Of Comments}
269: -- ----------------------------------------------------------------------------
270: procedure chk_rate_id
271: (p_rate_id in pay_grade_rules_f.rate_id%TYPE,
272: p_business_group_id pay_grade_rules_f.business_group_id%TYPE
273: )
274: is
275: --
276: l_exists varchar2(1);
274: is
275: --
276: l_exists varchar2(1);
277: l_proc varchar2(72) := g_package||'chk_rate_id';
278: l_business_group_id pay_grade_rules_f.business_group_id%TYPE;
279: --
280: cursor csr_rate_exists is
281: select business_group_id
282: from pay_rates pr
451: --
452: -- {End Of Comments}
453: -- ----------------------------------------------------------------------------
454: procedure chk_maximum
455: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
456: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
457: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
458: ,p_maximum in pay_grade_rules_f.maximum%TYPE
459: ,p_minimum in pay_grade_rules_f.minimum%TYPE
452: -- {End Of Comments}
453: -- ----------------------------------------------------------------------------
454: procedure chk_maximum
455: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
456: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
457: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
458: ,p_maximum in pay_grade_rules_f.maximum%TYPE
459: ,p_minimum in pay_grade_rules_f.minimum%TYPE
460: ,p_value in pay_grade_rules_f.value%TYPE
453: -- ----------------------------------------------------------------------------
454: procedure chk_maximum
455: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
456: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
457: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
458: ,p_maximum in pay_grade_rules_f.maximum%TYPE
459: ,p_minimum in pay_grade_rules_f.minimum%TYPE
460: ,p_value in pay_grade_rules_f.value%TYPE
461: ,p_effective_date in date
454: procedure chk_maximum
455: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
456: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
457: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
458: ,p_maximum in pay_grade_rules_f.maximum%TYPE
459: ,p_minimum in pay_grade_rules_f.minimum%TYPE
460: ,p_value in pay_grade_rules_f.value%TYPE
461: ,p_effective_date in date
462: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
455: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
456: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
457: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
458: ,p_maximum in pay_grade_rules_f.maximum%TYPE
459: ,p_minimum in pay_grade_rules_f.minimum%TYPE
460: ,p_value in pay_grade_rules_f.value%TYPE
461: ,p_effective_date in date
462: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
463: is
456: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
457: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
458: ,p_maximum in pay_grade_rules_f.maximum%TYPE
459: ,p_minimum in pay_grade_rules_f.minimum%TYPE
460: ,p_value in pay_grade_rules_f.value%TYPE
461: ,p_effective_date in date
462: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
463: is
464: --
458: ,p_maximum in pay_grade_rules_f.maximum%TYPE
459: ,p_minimum in pay_grade_rules_f.minimum%TYPE
460: ,p_value in pay_grade_rules_f.value%TYPE
461: ,p_effective_date in date
462: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
463: is
464: --
465: l_proc varchar2(72) := g_package||'chk_maximum';
466: l_api_updating boolean;
463: is
464: --
465: l_proc varchar2(72) := g_package||'chk_maximum';
466: l_api_updating boolean;
467: l_value pay_grade_rules_f.value%TYPE;
468: l_maximum pay_grade_rules_f.maximum%TYPE;
469: l_dummy_return_value pay_grade_rules_f.value%TYPE;
470: l_min_max_status varchar2(30);
471: l_uom pay_rates.rate_uom%TYPE;
464: --
465: l_proc varchar2(72) := g_package||'chk_maximum';
466: l_api_updating boolean;
467: l_value pay_grade_rules_f.value%TYPE;
468: l_maximum pay_grade_rules_f.maximum%TYPE;
469: l_dummy_return_value pay_grade_rules_f.value%TYPE;
470: l_min_max_status varchar2(30);
471: l_uom pay_rates.rate_uom%TYPE;
472: l_currency_code per_business_groups.currency_code%TYPE;
465: l_proc varchar2(72) := g_package||'chk_maximum';
466: l_api_updating boolean;
467: l_value pay_grade_rules_f.value%TYPE;
468: l_maximum pay_grade_rules_f.maximum%TYPE;
469: l_dummy_return_value pay_grade_rules_f.value%TYPE;
470: l_min_max_status varchar2(30);
471: l_uom pay_rates.rate_uom%TYPE;
472: l_currency_code per_business_groups.currency_code%TYPE;
473: --
626: --
627: -- {End Of Comments}
628: -- ----------------------------------------------------------------------------
629: procedure chk_mid_value
630: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
631: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
632: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
633: ,p_mid_value in pay_grade_rules_f.mid_value%TYPE
634: ,p_maximum in pay_grade_rules_f.maximum%TYPE
627: -- {End Of Comments}
628: -- ----------------------------------------------------------------------------
629: procedure chk_mid_value
630: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
631: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
632: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
633: ,p_mid_value in pay_grade_rules_f.mid_value%TYPE
634: ,p_maximum in pay_grade_rules_f.maximum%TYPE
635: ,p_minimum in pay_grade_rules_f.minimum%TYPE
628: -- ----------------------------------------------------------------------------
629: procedure chk_mid_value
630: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
631: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
632: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
633: ,p_mid_value in pay_grade_rules_f.mid_value%TYPE
634: ,p_maximum in pay_grade_rules_f.maximum%TYPE
635: ,p_minimum in pay_grade_rules_f.minimum%TYPE
636: ,p_effective_date in date
629: procedure chk_mid_value
630: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
631: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
632: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
633: ,p_mid_value in pay_grade_rules_f.mid_value%TYPE
634: ,p_maximum in pay_grade_rules_f.maximum%TYPE
635: ,p_minimum in pay_grade_rules_f.minimum%TYPE
636: ,p_effective_date in date
637: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
630: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
631: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
632: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
633: ,p_mid_value in pay_grade_rules_f.mid_value%TYPE
634: ,p_maximum in pay_grade_rules_f.maximum%TYPE
635: ,p_minimum in pay_grade_rules_f.minimum%TYPE
636: ,p_effective_date in date
637: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
638: is
631: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
632: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
633: ,p_mid_value in pay_grade_rules_f.mid_value%TYPE
634: ,p_maximum in pay_grade_rules_f.maximum%TYPE
635: ,p_minimum in pay_grade_rules_f.minimum%TYPE
636: ,p_effective_date in date
637: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
638: is
639: --
633: ,p_mid_value in pay_grade_rules_f.mid_value%TYPE
634: ,p_maximum in pay_grade_rules_f.maximum%TYPE
635: ,p_minimum in pay_grade_rules_f.minimum%TYPE
636: ,p_effective_date in date
637: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
638: is
639: --
640: l_proc varchar2(72) := g_package||'chk_mid_value';
641: l_api_updating boolean;
638: is
639: --
640: l_proc varchar2(72) := g_package||'chk_mid_value';
641: l_api_updating boolean;
642: l_mid_value pay_grade_rules_f.mid_value%TYPE;
643: l_dummy_return_value pay_grade_rules_f.value%TYPE;
644: l_min_max_status varchar2(30);
645: l_uom pay_rates.rate_uom%TYPE;
646: l_currency_code per_business_groups.currency_code%TYPE;
639: --
640: l_proc varchar2(72) := g_package||'chk_mid_value';
641: l_api_updating boolean;
642: l_mid_value pay_grade_rules_f.mid_value%TYPE;
643: l_dummy_return_value pay_grade_rules_f.value%TYPE;
644: l_min_max_status varchar2(30);
645: l_uom pay_rates.rate_uom%TYPE;
646: l_currency_code per_business_groups.currency_code%TYPE;
647: --
790: --
791: -- {End Of Comments}
792: -- ----------------------------------------------------------------------------
793: procedure chk_minimum
794: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
795: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
796: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
797: ,p_maximum in pay_grade_rules_f.maximum%TYPE
798: ,p_minimum in pay_grade_rules_f.minimum%TYPE
791: -- {End Of Comments}
792: -- ----------------------------------------------------------------------------
793: procedure chk_minimum
794: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
795: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
796: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
797: ,p_maximum in pay_grade_rules_f.maximum%TYPE
798: ,p_minimum in pay_grade_rules_f.minimum%TYPE
799: ,p_value in pay_grade_rules_f.value%TYPE
792: -- ----------------------------------------------------------------------------
793: procedure chk_minimum
794: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
795: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
796: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
797: ,p_maximum in pay_grade_rules_f.maximum%TYPE
798: ,p_minimum in pay_grade_rules_f.minimum%TYPE
799: ,p_value in pay_grade_rules_f.value%TYPE
800: ,p_effective_date in date
793: procedure chk_minimum
794: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
795: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
796: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
797: ,p_maximum in pay_grade_rules_f.maximum%TYPE
798: ,p_minimum in pay_grade_rules_f.minimum%TYPE
799: ,p_value in pay_grade_rules_f.value%TYPE
800: ,p_effective_date in date
801: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
794: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
795: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
796: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
797: ,p_maximum in pay_grade_rules_f.maximum%TYPE
798: ,p_minimum in pay_grade_rules_f.minimum%TYPE
799: ,p_value in pay_grade_rules_f.value%TYPE
800: ,p_effective_date in date
801: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
802: is
795: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
796: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
797: ,p_maximum in pay_grade_rules_f.maximum%TYPE
798: ,p_minimum in pay_grade_rules_f.minimum%TYPE
799: ,p_value in pay_grade_rules_f.value%TYPE
800: ,p_effective_date in date
801: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
802: is
803: --
797: ,p_maximum in pay_grade_rules_f.maximum%TYPE
798: ,p_minimum in pay_grade_rules_f.minimum%TYPE
799: ,p_value in pay_grade_rules_f.value%TYPE
800: ,p_effective_date in date
801: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
802: is
803: --
804: l_proc varchar2(72) := g_package||'chk_minimum';
805: l_api_updating boolean;
802: is
803: --
804: l_proc varchar2(72) := g_package||'chk_minimum';
805: l_api_updating boolean;
806: l_minimum pay_grade_rules_f.minimum%TYPE;
807: l_value pay_grade_rules_f.value%TYPE;
808: l_dummy_return_value pay_grade_rules_f.value%TYPE;
809: l_min_max_status varchar2(30);
810: l_uom pay_rates.rate_uom%TYPE;
803: --
804: l_proc varchar2(72) := g_package||'chk_minimum';
805: l_api_updating boolean;
806: l_minimum pay_grade_rules_f.minimum%TYPE;
807: l_value pay_grade_rules_f.value%TYPE;
808: l_dummy_return_value pay_grade_rules_f.value%TYPE;
809: l_min_max_status varchar2(30);
810: l_uom pay_rates.rate_uom%TYPE;
811: l_currency_code per_business_groups.currency_code%TYPE;
804: l_proc varchar2(72) := g_package||'chk_minimum';
805: l_api_updating boolean;
806: l_minimum pay_grade_rules_f.minimum%TYPE;
807: l_value pay_grade_rules_f.value%TYPE;
808: l_dummy_return_value pay_grade_rules_f.value%TYPE;
809: l_min_max_status varchar2(30);
810: l_uom pay_rates.rate_uom%TYPE;
811: l_currency_code per_business_groups.currency_code%TYPE;
812: --
962: --
963: -- {End Of Comments}
964: -- ----------------------------------------------------------------------------
965: procedure chk_sequence
966: (p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE
967: ,p_sequence in pay_grade_rules_f.sequence%TYPE
968: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
969: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
970: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
963: -- {End Of Comments}
964: -- ----------------------------------------------------------------------------
965: procedure chk_sequence
966: (p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE
967: ,p_sequence in pay_grade_rules_f.sequence%TYPE
968: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
969: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
970: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
971: ,p_effective_start_date in date
964: -- ----------------------------------------------------------------------------
965: procedure chk_sequence
966: (p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE
967: ,p_sequence in pay_grade_rules_f.sequence%TYPE
968: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
969: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
970: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
971: ,p_effective_start_date in date
972: ,p_effective_end_date in date)
965: procedure chk_sequence
966: (p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE
967: ,p_sequence in pay_grade_rules_f.sequence%TYPE
968: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
969: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
970: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
971: ,p_effective_start_date in date
972: ,p_effective_end_date in date)
973: is
966: (p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE
967: ,p_sequence in pay_grade_rules_f.sequence%TYPE
968: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE
969: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
970: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
971: ,p_effective_start_date in date
972: ,p_effective_end_date in date)
973: is
974: --
1027: --
1028: hr_utility.set_location(l_proc, 2);
1029: --
1030: -- Check that combination of Sequence, Business Group,
1031: -- Rate ID and Rate Type is unique on pay_grade_rules_f
1032: --
1033: if p_sequence is not null then
1034: --
1035: -- Check that value for Sequence is valid for the grade
1095: --
1096: -- {End Of Comments}
1097: -- ----------------------------------------------------------------------------
1098: procedure chk_value
1099: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
1100: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
1101: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
1102: ,p_maximum in pay_grade_rules_f.maximum%TYPE
1103: ,p_minimum in pay_grade_rules_f.minimum%TYPE
1096: -- {End Of Comments}
1097: -- ----------------------------------------------------------------------------
1098: procedure chk_value
1099: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
1100: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
1101: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
1102: ,p_maximum in pay_grade_rules_f.maximum%TYPE
1103: ,p_minimum in pay_grade_rules_f.minimum%TYPE
1104: ,p_value in pay_grade_rules_f.value%TYPE
1097: -- ----------------------------------------------------------------------------
1098: procedure chk_value
1099: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
1100: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
1101: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
1102: ,p_maximum in pay_grade_rules_f.maximum%TYPE
1103: ,p_minimum in pay_grade_rules_f.minimum%TYPE
1104: ,p_value in pay_grade_rules_f.value%TYPE
1105: ,p_effective_date in date
1098: procedure chk_value
1099: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
1100: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
1101: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
1102: ,p_maximum in pay_grade_rules_f.maximum%TYPE
1103: ,p_minimum in pay_grade_rules_f.minimum%TYPE
1104: ,p_value in pay_grade_rules_f.value%TYPE
1105: ,p_effective_date in date
1106: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
1099: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE
1100: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
1101: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
1102: ,p_maximum in pay_grade_rules_f.maximum%TYPE
1103: ,p_minimum in pay_grade_rules_f.minimum%TYPE
1104: ,p_value in pay_grade_rules_f.value%TYPE
1105: ,p_effective_date in date
1106: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
1107: is
1100: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE
1101: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE
1102: ,p_maximum in pay_grade_rules_f.maximum%TYPE
1103: ,p_minimum in pay_grade_rules_f.minimum%TYPE
1104: ,p_value in pay_grade_rules_f.value%TYPE
1105: ,p_effective_date in date
1106: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
1107: is
1108: --
1102: ,p_maximum in pay_grade_rules_f.maximum%TYPE
1103: ,p_minimum in pay_grade_rules_f.minimum%TYPE
1104: ,p_value in pay_grade_rules_f.value%TYPE
1105: ,p_effective_date in date
1106: ,p_object_version_number in pay_grade_rules_f.object_version_number%TYPE)
1107: is
1108: --
1109: l_proc varchar2(72) := g_package||'chk_value';
1110: l_api_updating boolean;
1107: is
1108: --
1109: l_proc varchar2(72) := g_package||'chk_value';
1110: l_api_updating boolean;
1111: l_value pay_grade_rules_f.value%TYPE;
1112: l_dummy_return_value pay_grade_rules_f.value%TYPE;
1113: l_min_max_status varchar2(30);
1114: l_uom pay_rates.rate_uom%TYPE;
1115: l_currency_code per_business_groups.currency_code%TYPE;
1108: --
1109: l_proc varchar2(72) := g_package||'chk_value';
1110: l_api_updating boolean;
1111: l_value pay_grade_rules_f.value%TYPE;
1112: l_dummy_return_value pay_grade_rules_f.value%TYPE;
1113: l_min_max_status varchar2(30);
1114: l_uom pay_rates.rate_uom%TYPE;
1115: l_currency_code per_business_groups.currency_code%TYPE;
1116: --
1845: --
1846: cursor csr_leg_code is
1847: select pbg.legislation_code
1848: from per_business_groups pbg
1849: , pay_grade_rules_f pgr
1850: where pgr.grade_rule_id = p_grade_rule_id
1851: and pbg.business_group_id = pgr.business_group_id
1852: order by pgr.effective_start_date;
1853: --