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.PAY_GRR_BUS dependencies on PAY_GRADE_RULES

Line 62: -- rate_id and rate_type is unique on pay_grade_rules_f between the start

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.

Line 90: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE

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

Line 91: ,p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_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

Line 94: ,p_business_group_id in pay_grade_rules_f.business_group_id%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

Line 95: ,p_rate_type in pay_grade_rules_f.rate_type%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
99: --

Line 96: ,p_rate_id in pay_grade_rules_f.rate_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: --
100: l_exists varchar2(1);

Line 102: l_business_group_id pay_grade_rules_f.business_group_id%type;

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

Line 119: from pay_grade_rules_f pgr

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

Line 271: (p_rate_id in pay_grade_rules_f.rate_id%TYPE,

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: --

Line 272: p_business_group_id pay_grade_rules_f.business_group_id%TYPE

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);

Line 278: l_business_group_id pay_grade_rules_f.business_group_id%TYPE;

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

Line 362: (p_rate_id in pay_grade_rules.rate_id%TYPE

358: --
359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: procedure chk_rate_type
362: (p_rate_id in pay_grade_rules.rate_id%TYPE
363: ,p_rate_type in pay_grade_rules.rate_type%TYPE)
364: is
365: --
366: l_exists varchar2(1);

Line 363: ,p_rate_type in pay_grade_rules.rate_type%TYPE)

359: -- {End Of Comments}
360: -- ----------------------------------------------------------------------------
361: procedure chk_rate_type
362: (p_rate_id in pay_grade_rules.rate_id%TYPE
363: ,p_rate_type in pay_grade_rules.rate_type%TYPE)
364: is
365: --
366: l_exists varchar2(1);
367: l_proc varchar2(72) := g_package||'chk_rate_type';

Line 455: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE

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

Line 456: ,p_rate_id in pay_grade_rules_f.rate_id%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

Line 457: ,p_rate_type in pay_grade_rules_f.rate_type%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

Line 458: ,p_maximum in pay_grade_rules_f.maximum%TYPE

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)

Line 459: ,p_minimum in pay_grade_rules_f.minimum%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

Line 460: ,p_value in pay_grade_rules_f.value%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
464: --

Line 462: ,p_object_version_number in pay_grade_rules_f.object_version_number%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: --
465: l_proc varchar2(72) := g_package||'chk_maximum';
466: l_api_updating boolean;

Line 467: l_value pay_grade_rules_f.value%TYPE;

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;

Line 468: l_maximum pay_grade_rules_f.maximum%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;

Line 469: l_dummy_return_value pay_grade_rules_f.value%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: --

Line 630: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE

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

Line 631: ,p_rate_type in pay_grade_rules_f.rate_type%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

Line 632: ,p_rate_id in pay_grade_rules_f.rate_id%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

Line 633: ,p_mid_value in pay_grade_rules_f.mid_value%TYPE

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)

Line 634: ,p_maximum in pay_grade_rules_f.maximum%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

Line 635: ,p_minimum in pay_grade_rules_f.minimum%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
639: --

Line 637: ,p_object_version_number in pay_grade_rules_f.object_version_number%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: --
640: l_proc varchar2(72) := g_package||'chk_mid_value';
641: l_api_updating boolean;

Line 642: l_mid_value pay_grade_rules_f.mid_value%TYPE;

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;

Line 643: l_dummy_return_value pay_grade_rules_f.value%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: --

Line 794: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE

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

Line 795: ,p_rate_type in pay_grade_rules_f.rate_type%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

Line 796: ,p_rate_id in pay_grade_rules_f.rate_id%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

Line 797: ,p_maximum in pay_grade_rules_f.maximum%TYPE

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)

Line 798: ,p_minimum in pay_grade_rules_f.minimum%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

Line 799: ,p_value in pay_grade_rules_f.value%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
803: --

Line 801: ,p_object_version_number in pay_grade_rules_f.object_version_number%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: --
804: l_proc varchar2(72) := g_package||'chk_minimum';
805: l_api_updating boolean;

Line 806: l_minimum pay_grade_rules_f.minimum%TYPE;

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;

Line 807: l_value pay_grade_rules_f.value%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;

Line 808: l_dummy_return_value pay_grade_rules_f.value%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: --

Line 966: (p_grade_or_spinal_point_id in pay_grade_rules_f.grade_or_spinal_point_id%TYPE

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

Line 967: ,p_sequence in pay_grade_rules_f.sequence%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

Line 968: ,p_business_group_id in pay_grade_rules_f.business_group_id%TYPE

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)

Line 969: ,p_rate_id in pay_grade_rules_f.rate_id%TYPE

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

Line 970: ,p_rate_type in pay_grade_rules_f.rate_type%TYPE

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: --

Line 1031: -- Rate ID and Rate Type is unique on pay_grade_rules_f

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

Line 1099: (p_grade_rule_id in pay_grade_rules_f.grade_rule_id%TYPE

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

Line 1100: ,p_rate_type in pay_grade_rules_f.rate_type%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

Line 1101: ,p_rate_id in pay_grade_rules_f.rate_id%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

Line 1102: ,p_maximum in pay_grade_rules_f.maximum%TYPE

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)

Line 1103: ,p_minimum in pay_grade_rules_f.minimum%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

Line 1104: ,p_value in pay_grade_rules_f.value%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
1108: --

Line 1106: ,p_object_version_number in pay_grade_rules_f.object_version_number%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: --
1109: l_proc varchar2(72) := g_package||'chk_value';
1110: l_api_updating boolean;

Line 1111: l_value pay_grade_rules_f.value%TYPE;

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;

Line 1112: l_dummy_return_value pay_grade_rules_f.value%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: --

Line 1849: , pay_grade_rules_f pgr

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: --