DBA Data[Home] [Help]

APPS.PAY_PGR_BUS dependencies on PAY_PGR_BUS

Line 1: Package Body pay_pgr_bus as

1: Package Body pay_pgr_bus as
2: /* $Header: pypgrrhi.pkb 120.6.12020000.2 2013/01/17 09:39:34 sclakkar ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pay_pgr_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_pgr_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 1011: if ( nvl(pay_pgr_bus.g_grade_rule_id, hr_api.g_number)

1007: ,p_argument => 'grade_rule_id'
1008: ,p_argument_value => p_grade_rule_id
1009: );
1010: --
1011: if ( nvl(pay_pgr_bus.g_grade_rule_id, hr_api.g_number)
1012: = p_grade_rule_id) then
1013: --
1014: -- The legislation code has already been found with a previous
1015: -- call to this function. Just return the value in the global

Line 1018: l_legislation_code := pay_pgr_bus.g_legislation_code;

1014: -- The legislation code has already been found with a previous
1015: -- call to this function. Just return the value in the global
1016: -- variable.
1017: --
1018: l_legislation_code := pay_pgr_bus.g_legislation_code;
1019: hr_utility.set_location(l_proc, 20);
1020: else
1021: --
1022: -- The ID is different to the last call to this function

Line 1042: pay_pgr_bus.g_grade_rule_id := p_grade_rule_id;

1038: -- Set the global variables so the values are
1039: -- available for the next call to this function.
1040: --
1041: close csr_leg_code;
1042: pay_pgr_bus.g_grade_rule_id := p_grade_rule_id;
1043: pay_pgr_bus.g_legislation_code := l_legislation_code;
1044: end if;
1045: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1046: return l_legislation_code;

Line 1043: pay_pgr_bus.g_legislation_code := l_legislation_code;

1039: -- available for the next call to this function.
1040: --
1041: close csr_leg_code;
1042: pay_pgr_bus.g_grade_rule_id := p_grade_rule_id;
1043: pay_pgr_bus.g_legislation_code := l_legislation_code;
1044: end if;
1045: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1046: return l_legislation_code;
1047: end return_legislation_code;

Line 1318: pay_pgr_bus.chk_rate_type

1314: --
1315: --
1316: -- Validate Dependent Attributes
1317: --
1318: pay_pgr_bus.chk_rate_type
1319: (p_rate_type => p_rec.rate_type
1320: ,p_effective_date => p_effective_date
1321: ,p_grade_rule_id => p_rec.grade_rule_id
1322: ,p_object_version_number => p_rec.object_version_number

Line 1328: pay_pgr_bus.chk_grade_or_spinal_point_id

1324: ,p_validation_end_date => p_validation_end_date);
1325: --
1326: hr_utility.set_location(l_proc, 40);
1327: --
1328: pay_pgr_bus.chk_grade_or_spinal_point_id
1329: (p_grade_rule_id => p_rec.grade_rule_id
1330: ,p_business_group_id => p_rec.business_group_id
1331: ,p_effective_date => p_effective_date
1332: ,p_grade_or_spinal_point_id => p_rec.grade_or_spinal_point_id

Line 1338: pay_pgr_bus.chk_currency_code

1334: ,p_object_version_number => p_rec.object_version_number);
1335: --
1336: hr_utility.set_location(l_proc, 50);
1337: --
1338: pay_pgr_bus.chk_currency_code
1339: (p_rate_type => p_rec.rate_type
1340: ,p_currency_code => p_rec.currency_code
1341: ,p_grade_rule_id => p_rec.grade_rule_id
1342: ,p_rate_id => p_rec.rate_id

Line 1348: pay_pgr_bus.chk_value

1344: ,p_object_version_number => p_rec.object_version_number);
1345: --
1346: hr_utility.set_location(l_proc, 60);
1347: --
1348: pay_pgr_bus.chk_value
1349: (p_rate_type => p_rec.rate_type
1350: ,p_value => p_rec.value
1351: ,p_grade_rule_id => p_rec.grade_rule_id
1352: ,p_currency_code => p_rec.currency_code

Line 1360: pay_pgr_bus.chk_value_min_max_comb

1356: hr_utility.set_location(l_proc, 70);
1357: --
1358: -- Fix for bug 3049789 starts here.
1359: --
1360: pay_pgr_bus.chk_value_min_max_comb
1361: (p_rate_type => p_rec.rate_type
1362: ,p_grade_rule_id => p_rec.grade_rule_id
1363: ,p_value => p_rec.value
1364: ,p_minimum => p_rec.minimum

Line 1371: pay_pgr_bus.chk_rate_id

1367: hr_utility.set_location(l_proc, 80);
1368: --
1369: -- Fix for bug 3049789 ends here.
1370: --
1371: pay_pgr_bus.chk_rate_id
1372: (p_rate_id => p_rec.rate_id
1373: ,p_rate_type => p_rec.rate_type
1374: ,p_business_group_id => p_rec.business_group_id
1375: ,p_grade_or_spinal_point_id => p_rec.grade_or_spinal_point_id

Line 1382: pay_pgr_bus.chk_values_format

1378: ,p_object_version_number => p_rec.object_version_number);
1379: --
1380: hr_utility.set_location(l_proc, 90);
1381: --
1382: pay_pgr_bus.chk_values_format
1383: (p_rate_id => p_rec.rate_id
1384: ,p_rate_type => p_rec.rate_type
1385: ,p_value => p_rec.value
1386: ,p_minimum => p_rec.minimum

Line 1450: pay_pgr_bus.chk_rate_type

1446: hr_utility.set_location(l_proc, 50);
1447: --
1448: -- Validate Dependent Attributes
1449: --
1450: pay_pgr_bus.chk_rate_type
1451: (p_rate_type => p_rec.rate_type
1452: ,p_effective_date => p_effective_date
1453: ,p_grade_rule_id => p_rec.grade_rule_id
1454: ,p_object_version_number => p_rec.object_version_number

Line 1460: pay_pgr_bus.chk_grade_or_spinal_point_id

1456: ,p_validation_end_date => p_validation_end_date);
1457: --
1458: hr_utility.set_location(l_proc, 60);
1459: --
1460: pay_pgr_bus.chk_grade_or_spinal_point_id
1461: (p_grade_rule_id => p_rec.grade_rule_id
1462: ,p_business_group_id => p_rec.business_group_id
1463: ,p_effective_date => p_effective_date
1464: ,p_grade_or_spinal_point_id => p_rec.grade_or_spinal_point_id

Line 1470: pay_pgr_bus.chk_currency_code

1466: ,p_object_version_number => p_rec.object_version_number);
1467: --
1468: hr_utility.set_location(l_proc, 70);
1469: --
1470: pay_pgr_bus.chk_currency_code
1471: (p_rate_type => p_rec.rate_type
1472: ,p_currency_code => p_rec.currency_code
1473: ,p_grade_rule_id => p_rec.grade_rule_id
1474: ,p_rate_id => p_rec.rate_id

Line 1480: pay_pgr_bus.chk_value

1476: ,p_object_version_number => p_rec.object_version_number);
1477: --
1478: hr_utility.set_location(l_proc, 80);
1479: --
1480: pay_pgr_bus.chk_value
1481: (p_rate_type => p_rec.rate_type
1482: ,p_value => p_rec.value
1483: ,p_grade_rule_id => p_rec.grade_rule_id
1484: ,p_currency_code => p_rec.currency_code

Line 1492: pay_pgr_bus.chk_value_min_max_comb

1488: hr_utility.set_location(l_proc,90);
1489: --
1490: -- Fix for bug 3049789 starts here.
1491: --
1492: pay_pgr_bus.chk_value_min_max_comb
1493: (p_rate_type => p_rec.rate_type
1494: ,p_grade_rule_id => p_rec.grade_rule_id
1495: ,p_value => p_rec.value
1496: ,p_minimum => p_rec.minimum

Line 1503: pay_pgr_bus.chk_rate_id

1499: hr_utility.set_location(l_proc, 100);
1500: --
1501: -- Fix for bug 3049789 ends here.
1502: --
1503: pay_pgr_bus.chk_rate_id
1504: (p_rate_id => p_rec.rate_id
1505: ,p_rate_type => p_rec.rate_type
1506: ,p_business_group_id => p_rec.business_group_id
1507: ,p_grade_or_spinal_point_id => p_rec.grade_or_spinal_point_id

Line 1514: pay_pgr_bus.chk_values_format

1510: ,p_object_version_number => p_rec.object_version_number);
1511: --
1512: hr_utility.set_location(l_proc, 110);
1513: --
1514: pay_pgr_bus.chk_values_format
1515: (p_rate_id => p_rec.rate_id
1516: ,p_rate_type => p_rec.rate_type
1517: ,p_value => p_rec.value
1518: ,p_minimum => p_rec.minimum

Line 1557: end pay_pgr_bus;

1553: hr_utility.set_location(' Leaving:'||l_proc, 20);
1554:
1555: End delete_validate;
1556: --
1557: end pay_pgr_bus;