APPS.PAY_GRR_BUS dependencies on PAY_GRR_SHD

Line 397: pay_grr_shd.constraint_error(

393: --
394: -- Check rate type in 'G' or 'SP'
395: --
396: if p_rate_type not in ('G','SP') then
397: pay_grr_shd.constraint_error(
398: p_constraint_name => 'PAY_GRL_RATE_TYPE_CHK');
399: end if;
400: --
401: hr_utility.set_location(l_proc, 3);

Line 516: l_api_updating := pay_grr_shd.api_updating

512: -- Only proceed with validation if :
513: -- a) The current g_old_rec is current and
514: -- b) The value for address type has changed
515: --
516: l_api_updating := pay_grr_shd.api_updating
517: (p_grade_rule_id => p_grade_rule_id
518: ,p_effective_date => p_effective_date
519: ,p_object_version_number => p_object_version_number);
520: --

Line 522: nvl(pay_grr_shd.g_old_rec.maximum, hr_api.g_varchar2) <>

518: ,p_effective_date => p_effective_date
519: ,p_object_version_number => p_object_version_number);
520: --
521: if ((l_api_updating and
522: nvl(pay_grr_shd.g_old_rec.maximum, hr_api.g_varchar2) <>
523: nvl(l_maximum, hr_api.g_varchar2)) or
524: (NOT l_api_updating)) then
525: hr_utility.set_location(l_proc, 2);
526: --

Line 688: l_api_updating := pay_grr_shd.api_updating

684: -- Only proceed with validation if :
685: -- a) The current g_old_rec is current and
686: -- b) The value for address type has changed
687: --
688: l_api_updating := pay_grr_shd.api_updating
689: (p_grade_rule_id => p_grade_rule_id
690: ,p_effective_date => p_effective_date
691: ,p_object_version_number => p_object_version_number);
692: --

Line 694: nvl(pay_grr_shd.g_old_rec.mid_value, hr_api.g_varchar2) <>

690: ,p_effective_date => p_effective_date
691: ,p_object_version_number => p_object_version_number);
692: --
693: if ((l_api_updating and
694: nvl(pay_grr_shd.g_old_rec.mid_value, hr_api.g_varchar2) <>
695: nvl(l_mid_value, hr_api.g_varchar2)) or
696: (NOT l_api_updating)) then
697: hr_utility.set_location(l_proc, 2);
698: --

Line 855: l_api_updating := pay_grr_shd.api_updating

851: -- Only proceed with validation if :
852: -- a) The current g_old_rec is current and
853: -- b) The value for address type has changed
854: --
855: l_api_updating := pay_grr_shd.api_updating
856: (p_grade_rule_id => p_grade_rule_id
857: ,p_effective_date => p_effective_date
858: ,p_object_version_number => p_object_version_number);
859: --

Line 861: nvl(pay_grr_shd.g_old_rec.minimum, hr_api.g_varchar2) <>

857: ,p_effective_date => p_effective_date
858: ,p_object_version_number => p_object_version_number);
859: --
860: if ((l_api_updating and
861: nvl(pay_grr_shd.g_old_rec.minimum, hr_api.g_varchar2) <>
862: nvl(l_minimum, hr_api.g_varchar2)) or
863: (NOT l_api_updating)) then
864: hr_utility.set_location(l_proc, 2);
865: --

Line 1157: l_api_updating := pay_grr_shd.api_updating

1153: -- Only proceed with validation if :
1154: -- a) The current g_old_rec is current and
1155: -- b) The value for address type has changed
1156: --
1157: l_api_updating := pay_grr_shd.api_updating
1158: (p_grade_rule_id => p_grade_rule_id
1159: ,p_effective_date => p_effective_date
1160: ,p_object_version_number => p_object_version_number);
1161: --

Line 1163: nvl(pay_grr_shd.g_old_rec.value, hr_api.g_varchar2) <>

1159: ,p_effective_date => p_effective_date
1160: ,p_object_version_number => p_object_version_number);
1161: --
1162: if ((l_api_updating and
1163: nvl(pay_grr_shd.g_old_rec.value, hr_api.g_varchar2) <>
1164: nvl(l_value, hr_api.g_varchar2)) or
1165: (NOT l_api_updating)) then
1166: hr_utility.set_location(l_proc, 2);
1167: --

Line 1255: Procedure check_non_updateable_args(p_rec in pay_grr_shd.g_rec_type

1251: -- Internal Table Handler Use Only.
1252: --
1253: -- {End Of Comments}
1254: -- ----------------------------------------------------------------------------
1255: Procedure check_non_updateable_args(p_rec in pay_grr_shd.g_rec_type
1256: ,p_effective_date in date) is
1257: --
1258: l_proc varchar2(72) := g_package||'check_non_updateable_args';
1259: l_error exception;

Line 1268: if not pay_grr_shd.api_updating

1264: --
1265: -- Only proceed with validation if a row exists for
1266: -- the current record in the HR Schema
1267: --
1268: if not pay_grr_shd.api_updating
1269: (p_grade_rule_id => p_rec.grade_rule_id
1270: ,p_object_version_number => p_rec.object_version_number
1271: ,p_effective_date => p_effective_date
1272: ) then

Line 1281: nvl(pay_grr_shd.g_old_rec.business_group_id, hr_api.g_number) then

1277: --
1278: hr_utility.set_location(l_proc, 6);
1279: --
1280: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1281: nvl(pay_grr_shd.g_old_rec.business_group_id, hr_api.g_number) then
1282: l_argument := 'business_group_id';
1283: raise l_error;
1284: end if;
1285: hr_utility.set_location(l_proc, 7);

Line 1287: if p_rec.grade_rule_id <> pay_grr_shd.g_old_rec.grade_rule_id then

1283: raise l_error;
1284: end if;
1285: hr_utility.set_location(l_proc, 7);
1286: --
1287: if p_rec.grade_rule_id <> pay_grr_shd.g_old_rec.grade_rule_id then
1288: l_argument := 'grade_rule_id';
1289: raise l_error;
1290: end if;
1291: hr_utility.set_location(l_proc, 8);

Line 1294: nvl(pay_grr_shd.g_old_rec.grade_or_spinal_point_id, hr_api.g_number) then

1290: end if;
1291: hr_utility.set_location(l_proc, 8);
1292: --
1293: if nvl(p_rec.grade_or_spinal_point_id, hr_api.g_number) <>
1294: nvl(pay_grr_shd.g_old_rec.grade_or_spinal_point_id, hr_api.g_number) then
1295: l_argument := 'grade_or_spinal_point_id';
1296: raise l_error;
1297: end if;
1298: hr_utility.set_location(l_proc, 9);

Line 1301: nvl(pay_grr_shd.g_old_rec.rate_id, hr_api.g_number) then

1297: end if;
1298: hr_utility.set_location(l_proc, 9);
1299: --
1300: if nvl(p_rec.rate_id, hr_api.g_number) <>
1301: nvl(pay_grr_shd.g_old_rec.rate_id, hr_api.g_number) then
1302: l_argument := 'rate_id';
1303: raise l_error;
1304: end if;
1305: hr_utility.set_location(l_proc, 10);

Line 1308: nvl(pay_grr_shd.g_old_rec.sequence, hr_api.g_number) then

1304: end if;
1305: hr_utility.set_location(l_proc, 10);
1306: --
1307: if nvl(p_rec.sequence, hr_api.g_number) <>
1308: nvl(pay_grr_shd.g_old_rec.sequence, hr_api.g_number) then
1309: l_argument := 'sequence';
1310: raise l_error;
1311: end if;
1312: hr_utility.set_location(l_proc, 11);

Line 1315: nvl(pay_grr_shd.g_old_rec.rate_type, hr_api.g_varchar2) then

1311: end if;
1312: hr_utility.set_location(l_proc, 11);
1313: --
1314: if nvl(p_rec.rate_type, hr_api.g_varchar2) <>
1315: nvl(pay_grr_shd.g_old_rec.rate_type, hr_api.g_varchar2) then
1316: l_argument := 'rate_type';
1317: raise l_error;
1318: end if;
1319: hr_utility.set_location(l_proc, 12);

Line 1529: (p_rec in pay_grr_shd.g_rec_type,

1525: -- ----------------------------------------------------------------------------
1526: -- |---------------------------< insert_validate >----------------------------|
1527: -- ----------------------------------------------------------------------------
1528: Procedure insert_validate
1529: (p_rec in pay_grr_shd.g_rec_type,
1530: p_effective_date in date,
1531: p_datetrack_mode in varchar2,
1532: p_validation_start_date in date,
1533: p_validation_end_date in date) is

Line 1693: (p_rec in pay_grr_shd.g_rec_type,

1689: -- ----------------------------------------------------------------------------
1690: -- |---------------------------< update_validate >----------------------------|
1691: -- ----------------------------------------------------------------------------
1692: Procedure update_validate
1693: (p_rec in pay_grr_shd.g_rec_type,
1694: p_effective_date in date,
1695: p_datetrack_mode in varchar2,
1696: p_validation_start_date in date,
1697: p_validation_end_date in date) is

Line 1813: (p_rec in pay_grr_shd.g_rec_type,

1809: -- ----------------------------------------------------------------------------
1810: -- |---------------------------< delete_validate >----------------------------|
1811: -- ----------------------------------------------------------------------------
1812: Procedure delete_validate
1813: (p_rec in pay_grr_shd.g_rec_type,
1814: p_effective_date in date,
1815: p_datetrack_mode in varchar2,
1816: p_validation_start_date in date,
1817: p_validation_end_date in date) is