DBA Data[Home] [Help]

APPS.PAY_PGR_BUS dependencies on PAY_PGR_SHD

Line 41: (pay_pgr_shd.g_old_rec.rate_type <> p_rate_type))) THEN

37: -- b) The value for rate_type is changing and not null
38: --
39: IF ( (p_grade_rule_id IS NULL) OR
40: ((p_grade_rule_id IS NOT NULL) AND
41: (pay_pgr_shd.g_old_rec.rate_type <> p_rate_type))) THEN
42: --
43: hr_utility.set_location(l_proc, 20);
44: --
45: -- Check that the rate type exists in HR_LOOKUPS

Line 140: (pay_pgr_shd.g_old_rec.rate_id <> p_rate_id))) THEN

136: -- b) The value for rate_type is changing and not null
137: --
138: IF ( (p_grade_rule_id IS NULL) OR
139: ((p_grade_rule_id IS NOT NULL) AND
140: (pay_pgr_shd.g_old_rec.rate_id <> p_rate_id))) THEN
141: --
142: hr_utility.set_location(l_proc, 30);
143: --
144: -- Check that the rate exists.

Line 295: (pay_pgr_shd.g_old_rec.grade_or_spinal_point_id <>

291: -- b) The value for grade_or_spinal_point_id is changing and not null
292: --
293: IF ( (p_grade_rule_id IS NULL) OR
294: ((p_grade_rule_id IS NOT NULL) AND
295: (pay_pgr_shd.g_old_rec.grade_or_spinal_point_id <>
296: p_grade_or_spinal_point_id))) THEN
297: --
298: hr_utility.set_location(l_proc, 30);
299: --

Line 411: (pay_pgr_shd.g_old_rec.currency_code <> p_currency_code))) THEN

407: -- b) The value for currency is changing and not null
408: --
409: IF ( (p_grade_rule_id IS NULL) OR
410: ((p_grade_rule_id IS NOT NULL) AND
411: (pay_pgr_shd.g_old_rec.currency_code <> p_currency_code))) THEN
412: --
413: hr_utility.set_location(l_proc, 30);
414: --
415: -- If the rate is for assignment rates then check

Line 766: (pay_pgr_shd.g_old_rec.value <> p_value))) THEN

762: -- b) The value for value has changed
763: --
764: IF ( (p_grade_rule_id IS NULL) OR
765: ((p_grade_rule_id IS NOT NULL) AND
766: (pay_pgr_shd.g_old_rec.value <> p_value))) THEN
767: --
768: hr_utility.set_location(l_proc, 30);
769: --
770: -- If the rate is for assignment rates and the

Line 867: (nvl(pay_pgr_shd.g_old_rec.value,-1) <> nvl(p_value,-1) OR

863: -- b) The value for value has changed
864: --
865: IF ( (p_grade_rule_id IS NULL) OR
866: ((p_grade_rule_id IS NOT NULL) AND
867: (nvl(pay_pgr_shd.g_old_rec.value,-1) <> nvl(p_value,-1) OR
868: nvl(pay_pgr_shd.g_old_rec.minimum,-1) <> nvl(p_minimum,-1) OR
869: nvl(pay_pgr_shd.g_old_rec.maximum,-1) <> nvl(p_maximum,-1) ))) THEN
870: --
871: hr_utility.set_location(l_proc, 30);

Line 868: nvl(pay_pgr_shd.g_old_rec.minimum,-1) <> nvl(p_minimum,-1) OR

864: --
865: IF ( (p_grade_rule_id IS NULL) OR
866: ((p_grade_rule_id IS NOT NULL) AND
867: (nvl(pay_pgr_shd.g_old_rec.value,-1) <> nvl(p_value,-1) OR
868: nvl(pay_pgr_shd.g_old_rec.minimum,-1) <> nvl(p_minimum,-1) OR
869: nvl(pay_pgr_shd.g_old_rec.maximum,-1) <> nvl(p_maximum,-1) ))) THEN
870: --
871: hr_utility.set_location(l_proc, 30);
872: --

Line 869: nvl(pay_pgr_shd.g_old_rec.maximum,-1) <> nvl(p_maximum,-1) ))) THEN

865: IF ( (p_grade_rule_id IS NULL) OR
866: ((p_grade_rule_id IS NOT NULL) AND
867: (nvl(pay_pgr_shd.g_old_rec.value,-1) <> nvl(p_value,-1) OR
868: nvl(pay_pgr_shd.g_old_rec.minimum,-1) <> nvl(p_minimum,-1) OR
869: nvl(pay_pgr_shd.g_old_rec.maximum,-1) <> nvl(p_maximum,-1) ))) THEN
870: --
871: hr_utility.set_location(l_proc, 30);
872: --
873: -- If the rate is for Grade rates, either value OR a minimum and Maximum

Line 1078: ,p_rec in pay_pgr_shd.g_rec_type

1074: -- {End Of Comments}
1075: -- ----------------------------------------------------------------------------
1076: Procedure chk_non_updateable_args
1077: (p_effective_date in date
1078: ,p_rec in pay_pgr_shd.g_rec_type
1079: ) IS
1080: --
1081: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1082: --

Line 1088: IF NOT pay_pgr_shd.api_updating

1084: --
1085: -- Only proceed with the validation if a row exists for the current
1086: -- record in the HR Schema.
1087: --
1088: IF NOT pay_pgr_shd.api_updating
1089: (p_grade_rule_id => p_rec.grade_rule_id
1090: ,p_effective_date => p_effective_date
1091: ,p_object_version_number => p_rec.object_version_number
1092: ) THEN

Line 1285: (p_rec in pay_pgr_shd.g_rec_type

1281: -- ----------------------------------------------------------------------------
1282: -- |---------------------------< insert_validate >----------------------------|
1283: -- ----------------------------------------------------------------------------
1284: Procedure insert_validate
1285: (p_rec in pay_pgr_shd.g_rec_type
1286: ,p_effective_date in date
1287: ,p_datetrack_mode in varchar2
1288: ,p_validation_start_date in date
1289: ,p_validation_end_date in date

Line 1302: ,p_associated_column1 => pay_pgr_shd.g_tab_nam

1298: -- Call all supporting business operations
1299: --
1300: hr_api.validate_bus_grp_id
1301: (p_business_group_id => p_rec.business_group_id
1302: ,p_associated_column1 => pay_pgr_shd.g_tab_nam
1303: || '.BUSINESS_GROUP_ID');
1304: --
1305: hr_utility.set_location(l_proc, 20);
1306: --

Line 1399: (p_rec in pay_pgr_shd.g_rec_type

1395: -- ----------------------------------------------------------------------------
1396: -- |---------------------------< update_validate >----------------------------|
1397: -- ----------------------------------------------------------------------------
1398: Procedure update_validate
1399: (p_rec in pay_pgr_shd.g_rec_type
1400: ,p_effective_date in date
1401: ,p_datetrack_mode in varchar2
1402: ,p_validation_start_date in date
1403: ,p_validation_end_date in date

Line 1415: ,p_associated_column1 => pay_pgr_shd.g_tab_nam

1411: -- Call all supporting business operations
1412: --
1413: hr_api.validate_bus_grp_id
1414: (p_business_group_id => p_rec.business_group_id
1415: ,p_associated_column1 => pay_pgr_shd.g_tab_nam
1416: || '.BUSINESS_GROUP_ID');
1417: --
1418: hr_utility.set_location(l_proc, 20);
1419: --

Line 1531: (p_rec in pay_pgr_shd.g_rec_type

1527: -- ----------------------------------------------------------------------------
1528: -- |---------------------------< delete_validate >----------------------------|
1529: -- ----------------------------------------------------------------------------
1530: Procedure delete_validate
1531: (p_rec in pay_pgr_shd.g_rec_type
1532: ,p_effective_date in date
1533: ,p_datetrack_mode in varchar2
1534: ,p_validation_start_date in date
1535: ,p_validation_end_date in date