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_PPM_BUS dependencies on HR_API

Line 65: hr_api.mandatory_arg_error

61: begin
62: --
63: -- Check mandatory parameters have been set
64: --
65: hr_api.mandatory_arg_error
66: (p_api_name => l_proc
67: ,p_argument => 'org payment method id'
68: ,p_argument_value => p_org_payment_method_id
69: );

Line 71: hr_api.mandatory_arg_error

67: ,p_argument => 'org payment method id'
68: ,p_argument_value => p_org_payment_method_id
69: );
70: --
71: hr_api.mandatory_arg_error
72: (p_api_name => l_proc
73: ,p_argument => 'effective date'
74: ,p_argument_value => p_effective_date
75: );

Line 292: l_payee_date date := hr_api.g_eot;

288: and pp2.effective_start_date >= p_effective_date)
289: for update nowait;
290: --
291: l_proc varchar2(72) := g_package||'return_payee_date';
292: l_payee_date date := hr_api.g_eot;
293: --
294: begin
295: --
296: hr_utility.set_location('Entering:'||l_proc, 5);

Line 373: l_priority_date date := hr_api.g_eot;

369: ))
370: for update nowait;
371: --
372: l_proc varchar2(72) := g_package||'return_priority_date';
373: l_priority_date date := hr_api.g_eot;
374: --
375: begin
376: --
377: hr_utility.set_location('Entering:'||l_proc, 5);

Line 436: hr_api.mandatory_arg_error

432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- check mandatory arguments
435: --
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc,
438: p_argument => 'assignment_id',
439: p_argument_value => p_assignment_id);
440: hr_api.mandatory_arg_error

Line 440: hr_api.mandatory_arg_error

436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc,
438: p_argument => 'assignment_id',
439: p_argument_value => p_assignment_id);
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc,
442: p_argument => 'business_group_id',
443: p_argument_value => p_business_group_id);
444: hr_api.mandatory_arg_error

Line 444: hr_api.mandatory_arg_error

440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc,
442: p_argument => 'business_group_id',
443: p_argument_value => p_business_group_id);
444: hr_api.mandatory_arg_error
445: (p_api_name => l_proc,
446: p_argument => 'org_payment_method_id',
447: p_argument_value => p_org_payment_method_id);
448: hr_api.mandatory_arg_error

Line 448: hr_api.mandatory_arg_error

444: hr_api.mandatory_arg_error
445: (p_api_name => l_proc,
446: p_argument => 'org_payment_method_id',
447: p_argument_value => p_org_payment_method_id);
448: hr_api.mandatory_arg_error
449: (p_api_name => l_proc,
450: p_argument => 'datetrack_mode',
451: p_argument_value => p_datetrack_mode);
452: hr_api.mandatory_arg_error

Line 452: hr_api.mandatory_arg_error

448: hr_api.mandatory_arg_error
449: (p_api_name => l_proc,
450: p_argument => 'datetrack_mode',
451: p_argument_value => p_datetrack_mode);
452: hr_api.mandatory_arg_error
453: (p_api_name => l_proc,
454: p_argument => 'effective_date',
455: p_argument_value => p_effective_date);
456: hr_api.mandatory_arg_error

Line 456: hr_api.mandatory_arg_error

452: hr_api.mandatory_arg_error
453: (p_api_name => l_proc,
454: p_argument => 'effective_date',
455: p_argument_value => p_effective_date);
456: hr_api.mandatory_arg_error
457: (p_api_name => l_proc,
458: p_argument => 'validation_start_date',
459: p_argument_value => p_validation_start_date);
460: hr_api.mandatory_arg_error

Line 460: hr_api.mandatory_arg_error

456: hr_api.mandatory_arg_error
457: (p_api_name => l_proc,
458: p_argument => 'validation_start_date',
459: p_argument_value => p_validation_start_date);
460: hr_api.mandatory_arg_error
461: (p_api_name => l_proc,
462: p_argument => 'validation_end_date',
463: p_argument_value => p_validation_end_date);
464: --

Line 560: hr_api.mandatory_arg_error

556: hr_utility.set_location('Entering:'|| l_proc, 1);
557: --
558: -- Check mandatory parameters have been set
559: --
560: hr_api.mandatory_arg_error
561: (p_api_name => l_proc
562: ,p_argument => 'org_payment_method_id'
563: ,p_argument_value => p_org_payment_method_id);
564: --

Line 565: hr_api.mandatory_arg_error

561: (p_api_name => l_proc
562: ,p_argument => 'org_payment_method_id'
563: ,p_argument_value => p_org_payment_method_id);
564: --
565: hr_api.mandatory_arg_error
566: (p_api_name => l_proc
567: ,p_argument => 'effective_date'
568: ,p_argument_value => p_effective_date);
569: --

Line 687: nvl(oru.date_to, hr_api.g_eot);

683: select oru.business_group_id
684: from hr_all_organization_units oru
685: where oru.organization_id = p_payee_id
686: and p_effective_date between oru.date_from and
687: nvl(oru.date_to, hr_api.g_eot);
688: --
689: -- Check that the organization is active and of type 'HR_PAYEE'
690: --
691: cursor csr_chk_organization_active is

Line 727: hr_api.mandatory_arg_error

723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: -- Ensure that all mandatory arguments are not null.
726: --
727: hr_api.mandatory_arg_error
728: (p_api_name => l_proc
729: ,p_argument => 'business_group_id'
730: ,p_argument_value => p_business_group_id
731: );

Line 733: hr_api.mandatory_arg_error

729: ,p_argument => 'business_group_id'
730: ,p_argument_value => p_business_group_id
731: );
732: --
733: hr_api.mandatory_arg_error
734: (p_api_name => l_proc
735: ,p_argument => 'assignment_id'
736: ,p_argument_value => p_assignment_id
737: );

Line 813: hr_api.mandatory_arg_error

809: hr_utility.set_location('Entering:'||l_proc, 5);
810: --
811: -- Ensure that all mandatory arguments are not null.
812: --
813: hr_api.mandatory_arg_error
814: (p_api_name => l_proc
815: ,p_argument => 'org_payment_method_id'
816: ,p_argument_value => p_org_payment_method_id
817: );

Line 819: hr_api.mandatory_arg_error

815: ,p_argument => 'org_payment_method_id'
816: ,p_argument_value => p_org_payment_method_id
817: );
818: --
819: hr_api.mandatory_arg_error
820: (p_api_name => l_proc
821: ,p_argument => 'effective_date'
822: ,p_argument_value => p_effective_date
823: );

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 838: nvl(p_payee_id, hr_api.g_number)) or

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
842: (not l_api_updating) then

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 841: nvl(p_payee_type, hr_api.g_varchar2)) or

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;
845: if csr_chk_garnishment%notfound then

Line 922: hr_api.mandatory_arg_error

918: hr_utility.set_location('Entering:'|| l_proc, 1);
919: --
920: -- Check mandatory parameters have been set
921: --
922: hr_api.mandatory_arg_error
923: (p_api_name => l_proc
924: ,p_argument => 'org payment method id'
925: ,p_argument_value => p_org_payment_method_id
926: );

Line 928: hr_api.mandatory_arg_error

924: ,p_argument => 'org payment method id'
925: ,p_argument_value => p_org_payment_method_id
926: );
927: --
928: hr_api.mandatory_arg_error
929: (p_api_name => l_proc
930: ,p_argument => 'effective date'
931: ,p_argument_value => p_effective_date
932: );

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 944: <> nvl(p_amount,hr_api.g_number)) or

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
948: hr_utility.set_location(l_proc, 2);

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 946: <> nvl(p_percentage,hr_api.g_number)) or

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: --
950: -- Check the related balance type

Line 1103: hr_api.mandatory_arg_error

1099: hr_utility.set_location('Entering:'|| l_proc, 1);
1100: --
1101: -- Check mandatory parameters have been set
1102: --
1103: hr_api.mandatory_arg_error
1104: (p_api_name => l_proc
1105: ,p_argument => 'org payment method id'
1106: ,p_argument_value => p_org_payment_method_id
1107: );

Line 1109: hr_api.mandatory_arg_error

1105: ,p_argument => 'org payment method id'
1106: ,p_argument_value => p_org_payment_method_id
1107: );
1108: --
1109: hr_api.mandatory_arg_error
1110: (p_api_name => l_proc
1111: ,p_argument => 'effective date'
1112: ,p_argument_value => p_effective_date
1113: );

Line 1125: hr_api.g_number)

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

Line 1126: <> nvl(p_external_account_id,hr_api.g_number)) or

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);
1129: --
1130: -- Check if related payment type is Magnetic Tape

Line 1255: hr_api.mandatory_arg_error

1251: hr_utility.set_location('Entering:'|| l_proc, 1);
1252: --
1253: -- Check mandatory parameters have been set
1254: --
1255: hr_api.mandatory_arg_error
1256: (p_api_name => l_proc
1257: ,p_argument => 'org_payment_method_id'
1258: ,p_argument_value => p_org_payment_method_id
1259: );

Line 1261: hr_api.mandatory_arg_error

1257: ,p_argument => 'org_payment_method_id'
1258: ,p_argument_value => p_org_payment_method_id
1259: );
1260: --
1261: hr_api.mandatory_arg_error
1262: (p_api_name => l_proc
1263: ,p_argument => 'assignment_id'
1264: ,p_argument_value => p_assignment_id
1265: );

Line 1267: hr_api.mandatory_arg_error

1263: ,p_argument => 'assignment_id'
1264: ,p_argument_value => p_assignment_id
1265: );
1266: --
1267: hr_api.mandatory_arg_error
1268: (p_api_name => l_proc
1269: ,p_argument => 'effective_date'
1270: ,p_argument_value => p_effective_date
1271: );

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 1283: <> nvl(p_priority,hr_api.g_number)) or

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: --
1287: -- Check if priority is null

Line 1454: hr_api.mandatory_arg_error

1450: hr_utility.set_location('Entering:'|| l_proc, 1);
1451: --
1452: -- Check mandatory parameters have been set
1453: --
1454: hr_api.mandatory_arg_error
1455: (p_api_name => l_proc
1456: ,p_argument => 'effective_date'
1457: ,p_argument_value => p_effective_date
1458: );

Line 1460: hr_api.mandatory_arg_error

1456: ,p_argument => 'effective_date'
1457: ,p_argument_value => p_effective_date
1458: );
1459: --
1460: hr_api.mandatory_arg_error
1461: (p_api_name => l_proc
1462: ,p_argument => 'datetrack_mode'
1463: ,p_argument_value => p_datetrack_mode
1464: );

Line 1536: if nvl(p_rec.business_group_id, hr_api.g_number) <>

1532: end if;
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;

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 1549: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>

1545: raise l_error;
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;

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 1558: hr_api.argument_changed_error

1554: hr_utility.set_location(l_proc, 9);
1555: --
1556: exception
1557: when l_error then
1558: hr_api.argument_changed_error
1559: (p_api_name => l_proc
1560: ,p_argument => l_argument);
1561: when others then
1562: raise;

Line 1596: (p_org_payment_method_id in number default hr_api.g_number,

1592: --
1593: -- {End Of Comments}
1594: -- ----------------------------------------------------------------------------
1595: Procedure dt_update_validate
1596: (p_org_payment_method_id in number default hr_api.g_number,
1597: p_assignment_id in number default hr_api.g_number,
1598: p_datetrack_mode in varchar2,
1599: p_validation_start_date in date,
1600: p_validation_end_date in date) Is

Line 1597: p_assignment_id in number default hr_api.g_number,

1593: -- {End Of Comments}
1594: -- ----------------------------------------------------------------------------
1595: Procedure dt_update_validate
1596: (p_org_payment_method_id in number default hr_api.g_number,
1597: p_assignment_id in number default hr_api.g_number,
1598: p_datetrack_mode in varchar2,
1599: p_validation_start_date in date,
1600: p_validation_end_date in date) Is
1601: --

Line 1611: hr_api.mandatory_arg_error

1607: hr_utility.set_location('Entering:'||l_proc, 5);
1608: --
1609: -- Ensure that the p_datetrack_mode argument is not null
1610: --
1611: hr_api.mandatory_arg_error
1612: (p_api_name => l_proc,
1613: p_argument => 'datetrack_mode',
1614: p_argument_value => p_datetrack_mode);
1615: --

Line 1623: hr_api.mandatory_arg_error

1619: --
1620: --
1621: -- Ensure the arguments are not null
1622: --
1623: hr_api.mandatory_arg_error
1624: (p_api_name => l_proc,
1625: p_argument => 'validation_start_date',
1626: p_argument_value => p_validation_start_date);
1627: --

Line 1628: hr_api.mandatory_arg_error

1624: (p_api_name => l_proc,
1625: p_argument => 'validation_start_date',
1626: p_argument_value => p_validation_start_date);
1627: --
1628: hr_api.mandatory_arg_error
1629: (p_api_name => l_proc,
1630: p_argument => 'validation_end_date',
1631: p_argument_value => p_validation_end_date);
1632: --

Line 1633: If ((nvl(p_org_payment_method_id, hr_api.g_number) <> hr_api.g_number) and

1629: (p_api_name => l_proc,
1630: p_argument => 'validation_end_date',
1631: p_argument_value => p_validation_end_date);
1632: --
1633: If ((nvl(p_org_payment_method_id, hr_api.g_number) <> hr_api.g_number) and
1634: NOT (dt_api.check_min_max_dates
1635: (p_base_table_name => 'pay_org_payment_methods_f',
1636: p_base_key_column => 'org_payment_method_id',
1637: p_base_key_value => p_org_payment_method_id,

Line 1643: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and

1639: p_to_date => p_validation_end_date))) Then
1640: l_table_name := 'org payment methods';
1641: Raise l_integrity_error;
1642: End If;
1643: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
1644: NOT (dt_api.check_min_max_dates
1645: (p_base_table_name => 'per_all_assignments_f',
1646: p_base_key_column => 'assignment_id',
1647: p_base_key_value => p_assignment_id,

Line 1728: hr_api.mandatory_arg_error

1724: hr_utility.set_location('Entering:'||l_proc, 5);
1725: --
1726: -- Ensure that the p_datetrack_mode argument is not null
1727: --
1728: hr_api.mandatory_arg_error
1729: (p_api_name => l_proc,
1730: p_argument => 'datetrack_mode',
1731: p_argument_value => p_datetrack_mode);
1732: --

Line 1750: hr_api.mandatory_arg_error

1746: --
1747: --
1748: -- Ensure the arguments are not null
1749: --
1750: hr_api.mandatory_arg_error
1751: (p_api_name => l_proc,
1752: p_argument => 'validation_start_date',
1753: p_argument_value => p_validation_start_date);
1754: --

Line 1755: hr_api.mandatory_arg_error

1751: (p_api_name => l_proc,
1752: p_argument => 'validation_start_date',
1753: p_argument_value => p_validation_start_date);
1754: --
1755: hr_api.mandatory_arg_error
1756: (p_api_name => l_proc,
1757: p_argument => 'validation_end_date',
1758: p_argument_value => p_validation_end_date);
1759: --

Line 1760: hr_api.mandatory_arg_error

1756: (p_api_name => l_proc,
1757: p_argument => 'validation_end_date',
1758: p_argument_value => p_validation_end_date);
1759: --
1760: hr_api.mandatory_arg_error
1761: (p_api_name => l_proc,
1762: p_argument => 'personal_payment_method_id',
1763: p_argument_value => p_personal_payment_method_id);
1764: --

Line 1811: hr_api.validate_bus_grp_id(p_rec.business_group_id);

1807: -- Business Rules in payppm.bru is provided.
1808: --
1809: -- Validate Business Group ID
1810: --
1811: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1812: --
1813: -- Validate Org Payment Method ID
1814: --
1815: chk_org_payment_method_id

Line 2036: hr_api.mandatory_arg_error(p_api_name => l_proc,

2032: hr_utility.set_location('Entering:'|| l_proc, 10);
2033: --
2034: -- Ensure that all the mandatory parameter are not null
2035: --
2036: hr_api.mandatory_arg_error(p_api_name => l_proc,
2037: p_argument => 'personal_payment_method_id',
2038: p_argument_value => p_personal_payment_method_id);
2039: --
2040: open csr_leg_code;

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 2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or

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) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or

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 2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or

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) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or

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 2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or

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) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or

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 2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or

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) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or

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 2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or

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) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or

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 2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or

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) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or

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 2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or

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) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or

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 2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or

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) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or

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 2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or

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) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or

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 2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or

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) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or

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 2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or

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) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or

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 2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or

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) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or

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 2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or

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) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or

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 2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or

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) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or

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 2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or

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) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or

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 2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or

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) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or

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 2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or

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) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or

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 2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or

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) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or

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 2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or

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) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or

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 2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or

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) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or

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 2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or

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) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or

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 2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or

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) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or

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 2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or

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) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or

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 2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or

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) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or

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 2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or

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) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or

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 2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or

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) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or

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 2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or

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) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or

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 2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or

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) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or

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 2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or

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) <>
2131: nvl(p_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 2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or

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

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 2131: nvl(p_rec.ppm_information30, 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:
2135: -- a) During update, the structure column value or any

Line 2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>

2221: -- Only do the validation if inserting or if values have changed on
2222: -- update.
2223: --
2224: if (p_rec.personal_payment_method_id is not null and (
2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>

Line 2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or

2222: -- update.
2223: --
2224: if (p_rec.personal_payment_method_id is not null and (
2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or

Line 2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>

2223: --
2224: if (p_rec.personal_payment_method_id is not null and (
2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>

Line 2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or

2224: if (p_rec.personal_payment_method_id is not null and (
2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or

Line 2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>

2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>

Line 2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or

2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or

Line 2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>

2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>

Line 2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or

2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or

Line 2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>

2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>

Line 2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or

2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or

Line 2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>

2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>

Line 2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or

2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or

Line 2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>

2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>

Line 2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or

2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or

Line 2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>

2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>

Line 2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or

2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or

Line 2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>

2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>

Line 2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or

2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or

Line 2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>

2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>

Line 2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or

2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or

Line 2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>

2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>

Line 2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or

2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or

Line 2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>

2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>

Line 2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or

2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or

Line 2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>

2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>

Line 2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or

2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or

Line 2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>

2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>

Line 2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or

2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or

Line 2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>

2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>

Line 2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or

2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or

Line 2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>

2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>

Line 2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or

2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or

Line 2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>

2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>

Line 2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or

2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or

Line 2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>

2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>

Line 2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or

2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or

Line 2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>

2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>

Line 2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or

2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or

Line 2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>

2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or
2267: p_rec.personal_payment_method_id is null

Line 2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or

2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or
2267: p_rec.personal_payment_method_id is null
2268: then

Line 2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>

2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or
2267: p_rec.personal_payment_method_id is null
2268: then
2269: hr_utility.set_location(l_proc, 20);

Line 2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or

2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or
2267: p_rec.personal_payment_method_id is null
2268: then
2269: hr_utility.set_location(l_proc, 20);
2270: hr_dflex_utility.ins_or_upd_descflex_attribs