DBA Data[Home] [Help]

APPS.PAY_PPM_BUS dependencies on PAY_PPM_SHD

Line 831: l_api_updating := pay_ppm_shd.api_updating

827: -- If the personal payment method is not a garnishment (i.e. if the cursor
828: -- returns zero rows) then ensure that PAYEE_ID and PAYEE_TYPE are both
829: -- null.
830: --
831: l_api_updating := pay_ppm_shd.api_updating
832: (p_personal_payment_method_id => p_personal_payment_method_id
833: ,p_effective_date => p_effective_date
834: ,p_object_version_number => p_object_version_number);
835: --

Line 837: nvl(pay_ppm_shd.g_old_rec.payee_id, hr_api.g_number) <>

833: ,p_effective_date => p_effective_date
834: ,p_object_version_number => p_object_version_number);
835: --
836: if (l_api_updating and
837: nvl(pay_ppm_shd.g_old_rec.payee_id, hr_api.g_number) <>
838: nvl(p_payee_id, hr_api.g_number)) or
839: (l_api_updating and
840: nvl(pay_ppm_shd.g_old_rec.payee_type, hr_api.g_varchar2) <>
841: nvl(p_payee_type, hr_api.g_varchar2)) or

Line 840: nvl(pay_ppm_shd.g_old_rec.payee_type, hr_api.g_varchar2) <>

836: if (l_api_updating and
837: nvl(pay_ppm_shd.g_old_rec.payee_id, hr_api.g_number) <>
838: nvl(p_payee_id, hr_api.g_number)) or
839: (l_api_updating and
840: nvl(pay_ppm_shd.g_old_rec.payee_type, hr_api.g_varchar2) <>
841: nvl(p_payee_type, hr_api.g_varchar2)) or
842: (not l_api_updating) then
843: open csr_chk_garnishment;
844: fetch csr_chk_garnishment into l_exists;

Line 938: l_api_updating := pay_ppm_shd.api_updating

934: -- Only proceed with validation if:
935: -- a) The current g_old_rec is current and
936: -- b) The amount or percentage values have changed
937: --
938: l_api_updating := pay_ppm_shd.api_updating
939: (p_personal_payment_method_id => p_personal_payment_method_id
940: ,p_effective_date => p_effective_date
941: ,p_object_version_number => p_object_version_number);
942: --

Line 943: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.amount,hr_api.g_number)

939: (p_personal_payment_method_id => p_personal_payment_method_id
940: ,p_effective_date => p_effective_date
941: ,p_object_version_number => p_object_version_number);
942: --
943: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.amount,hr_api.g_number)
944: <> nvl(p_amount,hr_api.g_number)) or
945: (l_api_updating and nvl(pay_ppm_shd.g_old_rec.percentage,hr_api.g_number)
946: <> nvl(p_percentage,hr_api.g_number)) or
947: (NOT l_api_updating)) then

Line 945: (l_api_updating and nvl(pay_ppm_shd.g_old_rec.percentage,hr_api.g_number)

941: ,p_object_version_number => p_object_version_number);
942: --
943: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.amount,hr_api.g_number)
944: <> nvl(p_amount,hr_api.g_number)) or
945: (l_api_updating and nvl(pay_ppm_shd.g_old_rec.percentage,hr_api.g_number)
946: <> nvl(p_percentage,hr_api.g_number)) or
947: (NOT l_api_updating)) then
948: hr_utility.set_location(l_proc, 2);
949: --

Line 1119: l_api_updating := pay_ppm_shd.api_updating

1115: -- Only proceed with validation if:
1116: -- a) The current g_old_rec is current and
1117: -- b) The external account id value has changed
1118: --
1119: l_api_updating := pay_ppm_shd.api_updating
1120: (p_personal_payment_method_id => p_personal_payment_method_id
1121: ,p_effective_date => p_effective_date
1122: ,p_object_version_number => p_object_version_number);
1123: --

Line 1124: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.external_account_id,

1120: (p_personal_payment_method_id => p_personal_payment_method_id
1121: ,p_effective_date => p_effective_date
1122: ,p_object_version_number => p_object_version_number);
1123: --
1124: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.external_account_id,
1125: hr_api.g_number)
1126: <> nvl(p_external_account_id,hr_api.g_number)) or
1127: (NOT l_api_updating)) then
1128: hr_utility.set_location(l_proc, 2);

Line 1166: pay_ppm_shd.constraint_error

1162: open csr_chk_ext_acct_id;
1163: fetch csr_chk_ext_acct_id into l_exists;
1164: if csr_chk_ext_acct_id%notfound then
1165: close csr_chk_ext_acct_id;
1166: pay_ppm_shd.constraint_error
1167: (p_constraint_name => 'PAY_PERSONAL_PAYMENT_METHO_FK2');
1168: else
1169: close csr_chk_ext_acct_id;
1170: end if;

Line 1277: l_api_updating := pay_ppm_shd.api_updating

1273: -- Only proceed with validation if:
1274: -- a) The current g_old_rec is current and
1275: -- b) The priority value has changed
1276: --
1277: l_api_updating := pay_ppm_shd.api_updating
1278: (p_personal_payment_method_id => p_personal_payment_method_id
1279: ,p_effective_date => p_effective_date
1280: ,p_object_version_number => p_object_version_number);
1281: --

Line 1282: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.priority,hr_api.g_number)

1278: (p_personal_payment_method_id => p_personal_payment_method_id
1279: ,p_effective_date => p_effective_date
1280: ,p_object_version_number => p_object_version_number);
1281: --
1282: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.priority,hr_api.g_number)
1283: <> nvl(p_priority,hr_api.g_number)) or
1284: (NOT l_api_updating)) then
1285: hr_utility.set_location(l_proc, 2);
1286: --

Line 1512: Procedure check_non_updateable_args(p_rec in pay_ppm_shd.g_rec_type

1508: -- ----------------------------------------------------------------------------
1509: -- |----------------------< check_non_updateable_args >-----------------------|
1510: -- ----------------------------------------------------------------------------
1511: --
1512: Procedure check_non_updateable_args(p_rec in pay_ppm_shd.g_rec_type
1513: ,p_effective_date in date) is
1514: --
1515: l_proc varchar2(72) := g_package||'check_non_updateable_args';
1516: l_error exception;

Line 1525: if not pay_ppm_shd.api_updating

1521: --
1522: -- Only proceed with validation if a row exists for
1523: -- the current record in the HR Schema
1524: --
1525: if not pay_ppm_shd.api_updating
1526: (p_personal_payment_method_id => p_rec.personal_payment_method_id
1527: ,p_effective_date => p_effective_date
1528: ,p_object_version_number => p_rec.object_version_number) then
1529: hr_utility.set_message(801, 'HR_51351_PPM_UPD_ROW_NOT_EXIST');

Line 1537: nvl(pay_ppm_shd.g_old_rec.business_group_id, hr_api.g_number) then

1533: --
1534: hr_utility.set_location(l_proc, 6);
1535: --
1536: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1537: nvl(pay_ppm_shd.g_old_rec.business_group_id, hr_api.g_number) then
1538: l_argument := 'business_group_id';
1539: raise l_error;
1540: end if;
1541: hr_utility.set_location(l_proc, 7);

Line 1543: if p_rec.assignment_id <> pay_ppm_shd.g_old_rec.assignment_id then

1539: raise l_error;
1540: end if;
1541: hr_utility.set_location(l_proc, 7);
1542: --
1543: if p_rec.assignment_id <> pay_ppm_shd.g_old_rec.assignment_id then
1544: l_argument := 'assignment_id';
1545: raise l_error;
1546: end if;
1547: hr_utility.set_location(l_proc, 8);

Line 1550: nvl(pay_ppm_shd.g_old_rec.org_payment_method_id, hr_api.g_number) then

1546: end if;
1547: hr_utility.set_location(l_proc, 8);
1548: --
1549: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>
1550: nvl(pay_ppm_shd.g_old_rec.org_payment_method_id, hr_api.g_number) then
1551: l_argument := 'org_payment_method_id';
1552: raise l_error;
1553: end if;
1554: hr_utility.set_location(l_proc, 9);

Line 1795: (p_rec in pay_ppm_shd.g_rec_type,

1791: -- ----------------------------------------------------------------------------
1792: -- |---------------------------< insert_validate >----------------------------|
1793: -- ----------------------------------------------------------------------------
1794: Procedure insert_validate
1795: (p_rec in pay_ppm_shd.g_rec_type,
1796: p_effective_date in date,
1797: p_datetrack_mode in varchar2,
1798: p_validation_start_date in date,
1799: p_validation_end_date in date) is

Line 1885: (p_rec in pay_ppm_shd.g_rec_type,

1881: -- ----------------------------------------------------------------------------
1882: -- |---------------------------< update_validate >----------------------------|
1883: -- ----------------------------------------------------------------------------
1884: Procedure update_validate
1885: (p_rec in pay_ppm_shd.g_rec_type,
1886: p_effective_date in date,
1887: p_datetrack_mode in varchar2,
1888: p_validation_start_date in date,
1889: p_validation_end_date in date) is

Line 1977: (p_rec in pay_ppm_shd.g_rec_type,

1973: -- ----------------------------------------------------------------------------
1974: -- |---------------------------< delete_validate >----------------------------|
1975: -- ----------------------------------------------------------------------------
1976: Procedure delete_validate
1977: (p_rec in pay_ppm_shd.g_rec_type,
1978: p_effective_date in date,
1979: p_datetrack_mode in varchar2,
1980: p_validation_start_date in date,
1981: p_validation_end_date in date) is

Line 2061: (p_rec in pay_ppm_shd.g_rec_type

2057: -- ----------------------------------------------------------------------------
2058: -- |-----------------------------< chk_ddf >----------------------------------|
2059: -- ----------------------------------------------------------------------------
2060: procedure chk_ddf
2061: (p_rec in pay_ppm_shd.g_rec_type
2062: ) is
2063: --
2064: l_proc varchar2(72) := g_package || 'chk_ddf';
2065: --

Line 2070: nvl(pay_ppm_shd.g_old_rec.ppm_information_category, hr_api.g_varchar2) <>

2066: begin
2067: hr_utility.set_location('Entering:'||l_proc,10);
2068: --
2069: if ((p_rec.personal_payment_method_id is not null) and (
2070: nvl(pay_ppm_shd.g_old_rec.ppm_information_category, hr_api.g_varchar2) <>
2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>

Line 2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>

2068: --
2069: if ((p_rec.personal_payment_method_id is not null) and (
2070: nvl(pay_ppm_shd.g_old_rec.ppm_information_category, hr_api.g_varchar2) <>
2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>

Line 2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>

2070: nvl(pay_ppm_shd.g_old_rec.ppm_information_category, hr_api.g_varchar2) <>
2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>

Line 2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>

2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>

Line 2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>

2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>

Line 2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>

2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>

Line 2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>

2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>

Line 2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>

2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>

Line 2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>

2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>

Line 2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>

2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>

Line 2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>

2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>

Line 2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>

2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>

Line 2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>

2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>

Line 2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>

2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>

Line 2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>

2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>

Line 2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>

2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>

Line 2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>

2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>

Line 2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>

2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>

Line 2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>

2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>

Line 2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>

2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>

Line 2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>

2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>

Line 2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>

2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>

Line 2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>

2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>

Line 2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>

2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>

Line 2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>

2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>

Line 2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>

2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>

Line 2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>

2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>

Line 2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>

2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>

Line 2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>

2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>

Line 2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>

2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>
2131: nvl(p_rec.ppm_information30, hr_api.g_varchar2) ))
2132: or (p_rec.personal_payment_method_id is null) then

Line 2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>

2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>
2131: nvl(p_rec.ppm_information30, hr_api.g_varchar2) ))
2132: or (p_rec.personal_payment_method_id is null) then
2133: --
2134: -- Only execute the validation if absolutely necessary:

Line 2213: (p_rec in pay_ppm_shd.g_rec_type

2209: -- -----------------------------------------------------------------------
2210: -- |------------------------------< chk_df >-----------------------------|
2211: -- -----------------------------------------------------------------------
2212: procedure chk_df
2213: (p_rec in pay_ppm_shd.g_rec_type
2214: ) is
2215: l_proc varchar2(2000) := g_package||'chk_df';
2216: l_rec pay_ppm_shd.g_rec_type;
2217: begin

Line 2216: l_rec pay_ppm_shd.g_rec_type;

2212: procedure chk_df
2213: (p_rec in pay_ppm_shd.g_rec_type
2214: ) is
2215: l_proc varchar2(2000) := g_package||'chk_df';
2216: l_rec pay_ppm_shd.g_rec_type;
2217: begin
2218: hr_utility.set_location('Entering:'||l_proc, 10);
2219: l_rec := pay_ppm_shd.g_old_rec;
2220: --

Line 2219: l_rec := pay_ppm_shd.g_old_rec;

2215: l_proc varchar2(2000) := g_package||'chk_df';
2216: l_rec pay_ppm_shd.g_rec_type;
2217: begin
2218: hr_utility.set_location('Entering:'||l_proc, 10);
2219: l_rec := pay_ppm_shd.g_old_rec;
2220: --
2221: -- Only do the validation if inserting or if values have changed on
2222: -- update.
2223: --