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.PER_PDS_BUS dependencies on PER_PDS_SHD

Line 162: l_api_updating := per_pds_shd.api_updating

158: hr_utility.set_location(l_proc, 20);
159: --
160: -- Check to see if record updated.
161: --
162: l_api_updating := per_pds_shd.api_updating
163: (p_period_of_service_id => p_period_of_service_id
164: ,p_object_version_number => p_object_version_number);
165: --
166: hr_utility.set_location(l_proc, 30);

Line 171: if nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>

167: --
168: if l_api_updating
169: then
170: --
171: if nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
172: nvl(p_actual_termination_date, hr_api.g_date)
173: and p_actual_termination_date is not null
174: then
175: hr_utility.set_location(l_proc, 40);

Line 177: if per_pds_shd.g_old_rec.actual_termination_date is not null

173: and p_actual_termination_date is not null
174: then
175: hr_utility.set_location(l_proc, 40);
176: --
177: if per_pds_shd.g_old_rec.actual_termination_date is not null
178: then
179: --
180: -- Cannot be changed from one not null value to another not null value.
181: -- CHK_ACTUAL_TERMINATION_DATE / d

Line 450: l_api_updating := per_pds_shd.api_updating

446: hr_utility.set_location(l_proc, 2);
447: --
448: -- Check to see if record updated.
449: --
450: l_api_updating := per_pds_shd.api_updating
451: (p_period_of_service_id => p_period_of_service_id
452: ,p_object_version_number => p_object_version_number);
453: --
454: hr_utility.set_location(l_proc, 5);

Line 459: if nvl(per_pds_shd.g_old_rec.final_process_date, hr_api.g_date) <>

455: --
456: if l_api_updating
457: then
458: --
459: if nvl(per_pds_shd.g_old_rec.final_process_date, hr_api.g_date) <>
460: nvl(p_final_process_date, hr_api.g_date)
461: then
462: --
463: hr_utility.set_location(l_proc, 6);

Line 471: --if per_pds_shd.g_old_rec.final_process_date is not null

467: --
468: --
469: -- 115.30 (START)
470: --
471: --if per_pds_shd.g_old_rec.final_process_date is not null
472: --and p_final_process_date is not null
473: --then
474: -- -- CHK_FINAL_PROCESS_DATE / g
475: -- --

Line 484: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL

480: -- if FPD is changing and old FPD < new FPD then raise an error if new FPD
481: -- >= start date of next-latest PDS and old FPD < start date of next-latest
482: -- PDS. In effect, check that a PDS gap is not being updated to an overlap.
483: --
484: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
485: AND p_final_process_date IS NOT NULL
486: AND (p_final_process_date > per_pds_shd.g_old_rec.final_process_date)
487: THEN
488: --

Line 486: AND (p_final_process_date > per_pds_shd.g_old_rec.final_process_date)

482: -- PDS. In effect, check that a PDS gap is not being updated to an overlap.
483: --
484: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
485: AND p_final_process_date IS NOT NULL
486: AND (p_final_process_date > per_pds_shd.g_old_rec.final_process_date)
487: THEN
488: --
489: hr_utility.set_location(l_proc, 10);
490: -- Get the next latest PDS is one exists

Line 497: IF ((per_pds_shd.g_old_rec.final_process_date < lr_next_pds.date_start)

493: IF csr_next_pds%FOUND THEN
494: -- Check if PDS gap is being updated to a overlap
495: hr_utility.set_location(l_proc, 15);
496: --
497: IF ((per_pds_shd.g_old_rec.final_process_date < lr_next_pds.date_start)
498: AND p_final_process_date >= lr_next_pds.date_start)
499: THEN
500: CLOSE csr_next_pds;
501: hr_utility.set_message(800,'HR_449744_EMP_FPD_PDS');

Line 533: /* IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL

529: --
530: -- if FPD is changing and old FPD < new FPD then raise an error if old FPD
531: -- = LSPD/ATD but new FPD > LSPD/ATD.
532: --
533: /* IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
534: AND p_final_process_date IS NOT NULL
535: AND (p_final_process_date > per_pds_shd.g_old_rec.final_process_date)
536: THEN
537: --

Line 535: AND (p_final_process_date > per_pds_shd.g_old_rec.final_process_date)

531: -- = LSPD/ATD but new FPD > LSPD/ATD.
532: --
533: /* IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
534: AND p_final_process_date IS NOT NULL
535: AND (p_final_process_date > per_pds_shd.g_old_rec.final_process_date)
536: THEN
537: --
538: hr_utility.set_location(l_proc, 22);
539: --

Line 540: IF ((per_pds_shd.g_old_rec.final_process_date = NVL(p_last_standard_process_date, p_actual_termination_date))

536: THEN
537: --
538: hr_utility.set_location(l_proc, 22);
539: --
540: IF ((per_pds_shd.g_old_rec.final_process_date = NVL(p_last_standard_process_date, p_actual_termination_date))
541: AND p_final_process_date > NVL(p_last_standard_process_date, p_actual_termination_date))
542: THEN
543: hr_utility.set_message(800,'HR_449764_FPD_GT_LSPD_ATD');
544: hr_utility.raise_error;

Line 553: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL

549: --
550: --
551: hr_utility.set_location(l_proc, 25);
552: --
553: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
554: AND p_final_process_date IS NULL
555: THEN
556: --
557: hr_utility.set_location(l_proc, 26);

Line 559: IF (per_pds_shd.g_old_rec.final_process_date = per_pds_shd.g_old_rec.actual_termination_date)

555: THEN
556: --
557: hr_utility.set_location(l_proc, 26);
558: --
559: IF (per_pds_shd.g_old_rec.final_process_date = per_pds_shd.g_old_rec.actual_termination_date)
560: THEN
561: hr_utility.set_message(800,'HR_449764_FPD_GT_LSPD_ATD');
562: hr_utility.raise_error;
563: END IF;

Line 575: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL

571: -- if FPD is changing and old FPD > new FPD then raise an error if new FPD
572: -- < start date of next-latest PDS and old FPD >= start date of next-latest
573: -- PDS. In effect, check that a PDS overlap is not being updated to an gap.
574: --
575: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
576: AND p_final_process_date IS NOT NULL
577: AND (p_final_process_date < per_pds_shd.g_old_rec.final_process_date)
578: THEN
579: -- Get the next latest PDS is one exists

Line 577: AND (p_final_process_date < per_pds_shd.g_old_rec.final_process_date)

573: -- PDS. In effect, check that a PDS overlap is not being updated to an gap.
574: --
575: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
576: AND p_final_process_date IS NOT NULL
577: AND (p_final_process_date < per_pds_shd.g_old_rec.final_process_date)
578: THEN
579: -- Get the next latest PDS is one exists
580: hr_utility.set_location(l_proc, 33);
581: --

Line 588: IF ((per_pds_shd.g_old_rec.final_process_date >= lr_next_pds.date_start)

584: IF csr_next_pds%FOUND THEN
585: -- Check if PDS overlap is being updated to a gap
586: hr_utility.set_location(l_proc, 35);
587: --
588: IF ((per_pds_shd.g_old_rec.final_process_date >= lr_next_pds.date_start)
589: AND p_final_process_date < lr_next_pds.date_start)
590: THEN
591: CLOSE csr_next_pds;
592: hr_utility.set_message(800,'HR_449744_EMP_FPD_PDS');

Line 604: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL

600: --
601: -- if FPD is changing and old FPD > new FPD then raise an error if the new
602: -- FPD <= NVL(LSPD,ATD)
603: --
604: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
605: AND p_final_process_date IS NOT NULL
606: AND (p_final_process_date < per_pds_shd.g_old_rec.final_process_date)
607: AND (p_final_process_date < NVL(p_last_standard_process_date, p_actual_termination_date)) -- ER 6981999 .
608: THEN

Line 606: AND (p_final_process_date < per_pds_shd.g_old_rec.final_process_date)

602: -- FPD <= NVL(LSPD,ATD)
603: --
604: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
605: AND p_final_process_date IS NOT NULL
606: AND (p_final_process_date < per_pds_shd.g_old_rec.final_process_date)
607: AND (p_final_process_date < NVL(p_last_standard_process_date, p_actual_termination_date)) -- ER 6981999 .
608: THEN
609: hr_utility.set_message(800,'HR_449741_EMP_FPD_ATD');
610: hr_utility.raise_error;

Line 618: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL

614: --
615: -- if FPD is changing and old FPD > new FPD then raise an error if the new
616: -- FPD <= Prev PDS FPD
617: --
618: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
619: AND p_final_process_date IS NOT NULL
620: AND (p_final_process_date < per_pds_shd.g_old_rec.final_process_date)
621: THEN
622: -- Get the previous PDS FPD

Line 620: AND (p_final_process_date < per_pds_shd.g_old_rec.final_process_date)

616: -- FPD <= Prev PDS FPD
617: --
618: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
619: AND p_final_process_date IS NOT NULL
620: AND (p_final_process_date < per_pds_shd.g_old_rec.final_process_date)
621: THEN
622: -- Get the previous PDS FPD
623: OPEN csr_prev_pds_fpd;
624: FETCH csr_prev_pds_fpd INTO l_prev_pds_fpd;

Line 640: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL

636: --
637: -- if FPD is changing and the new FPD is null, then raise an error is a
638: -- later PDS exists with FPD not null.
639: --
640: IF per_pds_shd.g_old_rec.final_process_date IS NOT NULL
641: AND p_final_process_date IS NULL
642: THEN
643: -- Check for a later PDS with FPD not null
644: hr_utility.set_location(l_proc, 53);

Line 815: l_api_updating := per_pds_shd.api_updating

811: hr_utility.set_location(l_proc, 10);
812: --
813: -- Check to see if record updated.
814: --
815: l_api_updating := per_pds_shd.api_updating
816: (p_period_of_service_id => p_period_of_service_id
817: ,p_object_version_number => p_object_version_number);
818: --
819: hr_utility.set_location(l_proc, 20);

Line 824: if nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>

820: --
821: if l_api_updating
822: then
823: --
824: if nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
825: nvl(p_last_standard_process_date, hr_api.g_date)
826: then
827: --
828: hr_utility.set_location(l_proc, 30);

Line 830: if per_pds_shd.g_old_rec.last_standard_process_date is not null

826: then
827: --
828: hr_utility.set_location(l_proc, 30);
829: --
830: if per_pds_shd.g_old_rec.last_standard_process_date is not null
831: and p_last_standard_process_date is not null
832: then
833: -- CHK_LAST_STANDARD_PROCESS_DATE / i
834: --

Line 912: if (nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>

908: end if;
909: --
910: -- 70.16 change h start.
911: --
912: if (nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
913: nvl(p_actual_termination_date,hr_api.g_date) )
914: and (p_actual_termination_date is not null)
915: and l_legislation_code <> 'US'
916: --

Line 1016: l_api_updating := per_pds_shd.api_updating

1012: hr_utility.set_location(l_proc, 10);
1013: --
1014: -- Check to see if record updated.
1015: --
1016: l_api_updating := per_pds_shd.api_updating
1017: (p_period_of_service_id => p_period_of_service_id
1018: ,p_object_version_number => p_object_version_number);
1019: --
1020: hr_utility.set_location(l_proc, 20);

Line 1028: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)

1024: -- b) The value for actual_termination_date or last_standard_process_date
1025: -- has changed
1026: --
1027: if (l_api_updating
1028: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1029: <> nvl(p_actual_termination_date, hr_api.g_date))
1030: or
1031: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1032: <> nvl(p_last_standard_process_date, hr_api.g_date))))

Line 1031: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)

1027: if (l_api_updating
1028: and ((nvl(per_pds_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1029: <> nvl(p_actual_termination_date, hr_api.g_date))
1030: or
1031: (nvl(per_pds_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1032: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1033: or
1034: NOT l_api_updating then
1035: --

Line 1062: if (per_pds_shd.g_old_rec.actual_termination_date is null

1058: --
1059: -- Check combination when either actual_termination_date or
1060: -- last_standard_process_date are set
1061: --
1062: if (per_pds_shd.g_old_rec.actual_termination_date is null
1063: and p_actual_termination_date is not null)
1064: and p_last_standard_process_date is null
1065: then
1066: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');

Line 1119: l_rec per_pds_shd.g_rec_type;

1115: per_periods_of_service.period_of_service_id%TYPE) is
1116: --
1117: l_api_updating boolean;
1118: l_proc varchar2(72) := g_package||'chk_leaving_reason';
1119: l_rec per_pds_shd.g_rec_type;
1120: --
1121: begin
1122: hr_utility.set_location('Entering:'|| l_proc, 1);
1123: --

Line 1132: l_api_updating := per_pds_shd.api_updating

1128: );
1129: --
1130: -- Check to see if record updated.
1131: --
1132: l_api_updating := per_pds_shd.api_updating
1133: (p_period_of_service_id => p_period_of_service_id
1134: ,p_object_version_number => p_object_version_number);
1135: --
1136: hr_utility.set_location(l_proc, 2);

Line 1142: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <>

1138: if l_api_updating
1139: and p_leaving_reason is not null
1140: then
1141: --
1142: if nvl(per_pds_shd.g_old_rec.leaving_reason, hr_api.g_varchar2) <>
1143: nvl(p_leaving_reason, hr_api.g_varchar2)
1144: then
1145: --
1146: -- Bug 1472162.

Line 1254: l_api_updating := per_pds_shd.api_updating

1250: hr_utility.set_location(l_proc, 5);
1251: --
1252: -- Check to see if record updated.
1253: --
1254: l_api_updating := per_pds_shd.api_updating
1255: (p_period_of_service_id => p_period_of_service_id
1256: ,p_object_version_number => p_object_version_number);
1257: --
1258: if not l_api_updating

Line 1316: l_rec per_pds_shd.g_rec_type;

1312: p_termination_accepted_person in
1313: per_periods_of_service.termination_accepted_person_id%TYPE) is
1314: --
1315: l_proc varchar2(72) := g_package||'chk_person_id';
1316: l_rec per_pds_shd.g_rec_type;
1317: --
1318: begin
1319: hr_utility.set_location('Entering:'|| l_proc, 1);
1320: --

Line 1419: l_api_updating := per_pds_shd.api_updating

1415: hr_utility.set_location(l_proc, 5);
1416: --
1417: -- Check to see if record updated.
1418: --
1419: l_api_updating := per_pds_shd.api_updating
1420: (p_period_of_service_id => p_period_of_service_id
1421: ,p_object_version_number => p_object_version_number);
1422: --
1423: if not l_api_updating

Line 1545: l_api_updating := per_pds_shd.api_updating

1541: hr_utility.set_location(l_proc, 5);
1542: --
1543: -- Check to see if record updated.
1544: --
1545: l_api_updating := per_pds_shd.api_updating
1546: (p_period_of_service_id => p_period_of_service_id
1547: ,p_object_version_number => p_object_version_number);
1548: --
1549: if not l_api_updating

Line 1645: l_api_updating := per_pds_shd.api_updating

1641: hr_utility.set_location(l_proc, 5);
1642: --
1643: -- Check to see if record updated.
1644: --
1645: l_api_updating := per_pds_shd.api_updating
1646: (p_period_of_service_id => p_period_of_service_id
1647: ,p_object_version_number => p_object_version_number);
1648: --
1649: if l_api_updating

Line 1652: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion

1648: --
1649: if l_api_updating
1650: then
1651: --
1652: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1653: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1654: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1655: per_pds_shd.g_old_rec.termination_accepted_person_id,hr_api.g_number))) -- nvl(per_pds_shd.g_old_rec.termination_accepted_person_id,
1656: then -- hr_api.g_number))

Line 1655: per_pds_shd.g_old_rec.termination_accepted_person_id,hr_api.g_number))) -- nvl(per_pds_shd.g_old_rec.termination_accepted_person_id,

1651: --
1652: if (nvl(per_pds_shd.g_old_rec.termination_accepted_person_id, -- Bug # 2282955. This right hand side part of the condtion
1653: hr_api.g_number) <> -- is modified from nvl(p_termination_acceted_person,
1654: nvl(p_termination_accepted_person, nvl( -- hr_api.g_number) to nvl(p_termination_acceted_person,
1655: per_pds_shd.g_old_rec.termination_accepted_person_id,hr_api.g_number))) -- nvl(per_pds_shd.g_old_rec.termination_accepted_person_id,
1656: then -- hr_api.g_number))
1657: --
1658: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1659: --

Line 1661: per_pds_shd.g_old_rec.person_id)

1657: --
1658: -- CHK_TERMINATION_ACCEPTED_PERSON_ID / b
1659: --
1660: if (nvl(p_termination_accepted_person, hr_api.g_number) =
1661: per_pds_shd.g_old_rec.person_id)
1662: then
1663: hr_utility.set_message(801,'HR_7488_PDS_INV_TAP_ID');
1664: hr_utility.raise_error;
1665: end if;

Line 1735: (p_rec in per_pds_shd.g_rec_type) is

1731: --
1732: -- {End Of Comments}
1733: Procedure check_non_updateable_args
1734: --
1735: (p_rec in per_pds_shd.g_rec_type) is
1736: --
1737: l_proc varchar2(72) := g_package||'check_non_updateable_args';
1738: l_error exception;
1739: l_argument varchar2(30);

Line 1747: if not per_pds_shd.api_updating

1743: --
1744: -- Only proceed with validation if a row exists for
1745: -- the current record in the HR Schema
1746: --
1747: if not per_pds_shd.api_updating
1748: (p_period_of_service_id => p_rec.period_of_service_id,
1749: p_object_version_number => p_rec.object_version_number)
1750: then
1751: --

Line 1760: nvl(per_pds_shd.g_old_rec.business_group_id, hr_api.g_number)

1756: --
1757: hr_utility.set_location(l_proc, 6);
1758: --
1759: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1760: nvl(per_pds_shd.g_old_rec.business_group_id, hr_api.g_number)
1761: then
1762: -- CHK_BUSINESS_GROUP_ID / b
1763: --
1764: l_argument := 'business_group_id';

Line 1771: nvl(per_pds_shd.g_old_rec.period_of_service_id, hr_api.g_number)

1767: --
1768: hr_utility.set_location(l_proc, 7);
1769: --
1770: if nvl(p_rec.period_of_service_id, hr_api.g_number) <>
1771: nvl(per_pds_shd.g_old_rec.period_of_service_id, hr_api.g_number)
1772: then
1773: -- CHK_PERIOD_OF_SERVICE_ID / c
1774: --
1775: l_argument := 'period_of_service_id';

Line 1782: nvl(per_pds_shd.g_old_rec.person_id, hr_api.g_number)

1778: --
1779: hr_utility.set_location(l_proc, 8);
1780: --
1781: if nvl(p_rec.person_id, hr_api.g_number) <>
1782: nvl(per_pds_shd.g_old_rec.person_id, hr_api.g_number)
1783: then
1784: -- CHK_PERSON_ID / b
1785: --
1786: l_argument := 'person_id';

Line 1833: (p_rec in per_pds_shd.g_rec_type

1829: -- Access Status:
1830: -- Internal Table Handler Use Only.
1831: -- ---------------------------------------------------------------------------
1832: procedure chk_df
1833: (p_rec in per_pds_shd.g_rec_type
1834: ,p_validate_df_flex in boolean default true) is
1835: --
1836: l_proc varchar2(72) := g_package||'chk_df';
1837: --

Line 1888: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1884: --
1885: --
1886: If ( (p_rec.period_of_service_id is not null)
1887: and
1888: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1886: If ( (p_rec.period_of_service_id is not null)
1887: and
1888: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1888: ( (nvl(per_pds_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1889: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1890: nvl(per_pds_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1891: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1892: nvl(per_pds_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1893: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1894: nvl(per_pds_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1895: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1896: nvl(per_pds_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1897: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1898: nvl(per_pds_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1899: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1900: nvl(per_pds_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1901: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1902: nvl(per_pds_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1903: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1904: nvl(per_pds_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1905: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1906: nvl(per_pds_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1907: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1908: nvl(per_pds_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1909: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1910: nvl(per_pds_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1911: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1912: nvl(per_pds_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1913: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1914: nvl(per_pds_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1915: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1916: nvl(per_pds_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1917: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1918: nvl(per_pds_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1919: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1920: nvl(per_pds_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1921: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1922: nvl(per_pds_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1923: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1929: nvl(p_rec.attribute20, hr_api.g_varchar2)
1930: )

Line 1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1924: nvl(per_pds_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1925: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1926: nvl(per_pds_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1927: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1928: nvl(per_pds_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1929: nvl(p_rec.attribute20, hr_api.g_varchar2)
1930: )
1931: or
1932: (

Line 1935: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =

1931: or
1932: (
1933: -- Added the check for date_start and adjusted_svc_date for fix
1934: -- of #1577252
1935: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1936: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1937: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1938: nvl(p_rec.date_start, hr_api.g_date) ) and
1939: (p_rec.attribute_category is null) and

Line 1937: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =

1933: -- Added the check for date_start and adjusted_svc_date for fix
1934: -- of #1577252
1935: ( nvl(per_pds_shd.g_old_rec.adjusted_svc_date, hr_api.g_date) =
1936: nvl(p_rec.adjusted_svc_date, hr_api.g_date) ) and
1937: ( nvl(per_pds_shd.g_old_rec.date_start, hr_api.g_date) =
1938: nvl(p_rec.date_start, hr_api.g_date) ) and
1939: (p_rec.attribute_category is null) and
1940: (p_rec.attribute1 is null) and
1941: (p_rec.attribute2 is null) and

Line 2055: (p_rec in per_pds_shd.g_rec_type) is

2051: -- {End Of Comments}
2052: -- ----------------------------------------------------------------------------
2053: --
2054: procedure chk_ddf
2055: (p_rec in per_pds_shd.g_rec_type) is
2056: --
2057: l_proc varchar2(72) := g_package||'chk_ddf';
2058: l_error exception;
2059: --

Line 2068: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>

2064: -- value has changed
2065: --
2066: if (p_rec.period_of_service_id is null) or
2067: ((p_rec.period_of_service_id is not null) and
2068: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2069: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>

Line 2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>

2066: if (p_rec.period_of_service_id is null) or
2067: ((p_rec.period_of_service_id is not null) and
2068: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2069: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>

Line 2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>

2068: nvl(per_pds_shd.g_old_rec.pds_information_category, hr_api.g_varchar2) <>
2069: nvl(p_rec.pds_information_category, hr_api.g_varchar2) or
2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>

Line 2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>

2070: nvl(per_pds_shd.g_old_rec.pds_information1, hr_api.g_varchar2) <>
2071: nvl(p_rec.pds_information1, hr_api.g_varchar2) or
2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>

Line 2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>

2072: nvl(per_pds_shd.g_old_rec.pds_information2, hr_api.g_varchar2) <>
2073: nvl(p_rec.pds_information2, hr_api.g_varchar2) or
2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>

Line 2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>

2074: nvl(per_pds_shd.g_old_rec.pds_information3, hr_api.g_varchar2) <>
2075: nvl(p_rec.pds_information3, hr_api.g_varchar2) or
2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>

Line 2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>

2076: nvl(per_pds_shd.g_old_rec.pds_information4, hr_api.g_varchar2) <>
2077: nvl(p_rec.pds_information4, hr_api.g_varchar2) or
2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>

Line 2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>

2078: nvl(per_pds_shd.g_old_rec.pds_information5, hr_api.g_varchar2) <>
2079: nvl(p_rec.pds_information5, hr_api.g_varchar2) or
2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>

Line 2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>

2080: nvl(per_pds_shd.g_old_rec.pds_information6, hr_api.g_varchar2) <>
2081: nvl(p_rec.pds_information6, hr_api.g_varchar2) or
2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>

Line 2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>

2082: nvl(per_pds_shd.g_old_rec.pds_information7, hr_api.g_varchar2) <>
2083: nvl(p_rec.pds_information7, hr_api.g_varchar2) or
2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>

Line 2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>

2084: nvl(per_pds_shd.g_old_rec.pds_information8, hr_api.g_varchar2) <>
2085: nvl(p_rec.pds_information8, hr_api.g_varchar2) or
2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>

Line 2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>

2086: nvl(per_pds_shd.g_old_rec.pds_information9, hr_api.g_varchar2) <>
2087: nvl(p_rec.pds_information9, hr_api.g_varchar2) or
2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>

Line 2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>

2088: nvl(per_pds_shd.g_old_rec.pds_information10, hr_api.g_varchar2) <>
2089: nvl(p_rec.pds_information10, hr_api.g_varchar2) or
2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>

Line 2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>

2090: nvl(per_pds_shd.g_old_rec.pds_information11, hr_api.g_varchar2) <>
2091: nvl(p_rec.pds_information11, hr_api.g_varchar2) or
2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>

Line 2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>

2092: nvl(per_pds_shd.g_old_rec.pds_information12, hr_api.g_varchar2) <>
2093: nvl(p_rec.pds_information12, hr_api.g_varchar2) or
2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>

Line 2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>

2094: nvl(per_pds_shd.g_old_rec.pds_information13, hr_api.g_varchar2) <>
2095: nvl(p_rec.pds_information13, hr_api.g_varchar2) or
2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>

Line 2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>

2096: nvl(per_pds_shd.g_old_rec.pds_information14, hr_api.g_varchar2) <>
2097: nvl(p_rec.pds_information14, hr_api.g_varchar2) or
2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>

Line 2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>

2098: nvl(per_pds_shd.g_old_rec.pds_information15, hr_api.g_varchar2) <>
2099: nvl(p_rec.pds_information15, hr_api.g_varchar2) or
2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>

Line 2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>

2100: nvl(per_pds_shd.g_old_rec.pds_information16, hr_api.g_varchar2) <>
2101: nvl(p_rec.pds_information16, hr_api.g_varchar2) or
2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>

Line 2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>

2102: nvl(per_pds_shd.g_old_rec.pds_information17, hr_api.g_varchar2) <>
2103: nvl(p_rec.pds_information17, hr_api.g_varchar2) or
2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>

Line 2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>

2104: nvl(per_pds_shd.g_old_rec.pds_information18, hr_api.g_varchar2) <>
2105: nvl(p_rec.pds_information18, hr_api.g_varchar2) or
2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>

Line 2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>

2106: nvl(per_pds_shd.g_old_rec.pds_information19, hr_api.g_varchar2) <>
2107: nvl(p_rec.pds_information19, hr_api.g_varchar2) or
2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>

Line 2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>

2108: nvl(per_pds_shd.g_old_rec.pds_information20, hr_api.g_varchar2) <>
2109: nvl(p_rec.pds_information20, hr_api.g_varchar2) or
2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>

Line 2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>

2110: nvl(per_pds_shd.g_old_rec.pds_information21, hr_api.g_varchar2) <>
2111: nvl(p_rec.pds_information21, hr_api.g_varchar2) or
2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>

Line 2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>

2112: nvl(per_pds_shd.g_old_rec.pds_information22, hr_api.g_varchar2) <>
2113: nvl(p_rec.pds_information22, hr_api.g_varchar2) or
2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>

Line 2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>

2114: nvl(per_pds_shd.g_old_rec.pds_information23, hr_api.g_varchar2) <>
2115: nvl(p_rec.pds_information23, hr_api.g_varchar2) or
2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>

Line 2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>

2116: nvl(per_pds_shd.g_old_rec.pds_information24, hr_api.g_varchar2) <>
2117: nvl(p_rec.pds_information24, hr_api.g_varchar2) or
2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>

Line 2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>

2118: nvl(per_pds_shd.g_old_rec.pds_information25, hr_api.g_varchar2) <>
2119: nvl(p_rec.pds_information25, hr_api.g_varchar2) or
2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>

Line 2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>

2120: nvl(per_pds_shd.g_old_rec.pds_information26, hr_api.g_varchar2) <>
2121: nvl(p_rec.pds_information26, hr_api.g_varchar2) or
2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>

Line 2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>

2122: nvl(per_pds_shd.g_old_rec.pds_information27, hr_api.g_varchar2) <>
2123: nvl(p_rec.pds_information27, hr_api.g_varchar2) or
2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2129: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2130: --

Line 2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>

2124: nvl(per_pds_shd.g_old_rec.pds_information28, hr_api.g_varchar2) <>
2125: nvl(p_rec.pds_information28, hr_api.g_varchar2) or
2126: nvl(per_pds_shd.g_old_rec.pds_information29, hr_api.g_varchar2) <>
2127: nvl(p_rec.pds_information29, hr_api.g_varchar2) or
2128: nvl(per_pds_shd.g_old_rec.pds_information30, hr_api.g_varchar2) <>
2129: nvl(p_rec.pds_information30, hr_api.g_varchar2)) then
2130: --
2131: hr_dflex_utility.ins_or_upd_descflex_attribs
2132: (p_appl_short_name => 'PER'

Line 2205: Procedure insert_validate(p_rec in per_pds_shd.g_rec_type

2201: --
2202: -- --------------------------------------------------------------------------- -- ----------------------------------------------------------------------------
2203: -- |---------------------------< insert_validate >----------------------------|
2204: -- ----------------------------------------------------------------------------
2205: Procedure insert_validate(p_rec in per_pds_shd.g_rec_type
2206: ,p_effective_date in date
2207: ,p_validate_df_flex in boolean) is
2208: --
2209: l_proc varchar2(72) := g_package||'insert_validate';

Line 2426: Procedure update_validate(p_rec in per_pds_shd.g_rec_type

2422: --
2423: -- ----------------------------------------------------------------------------
2424: -- |---------------------------< update_validate >----------------------------|
2425: -- ----------------------------------------------------------------------------
2426: Procedure update_validate(p_rec in per_pds_shd.g_rec_type
2427: ,p_effective_date in date) is
2428: --
2429: l_proc varchar2(72) := g_package||'update_validate';
2430: --

Line 2642: Procedure delete_validate(p_rec in per_pds_shd.g_rec_type) is

2638: --
2639: -- ----------------------------------------------------------------------------
2640: -- |---------------------------< delete_validate >----------------------------|
2641: -- ----------------------------------------------------------------------------
2642: Procedure delete_validate(p_rec in per_pds_shd.g_rec_type) is
2643: --
2644: l_proc varchar2(72) := g_package||'delete_validate';
2645: --
2646: Begin