DBA Data[Home] [Help]

APPS.PER_PDP_BUS dependencies on STANDARD

Line 202: -- a) Must be <= LAST_STANDARD_PROCESS_DATE (U)

198: -- ---------------------------------------------------------------------------
199: --
200: -- Description:
201: -- Validates that the following business rules are met:
202: -- a) Must be <= LAST_STANDARD_PROCESS_DATE (U)
203: -- b) Must be >= DATE_START (U)
204: -- c) Must be null (I)
205: -- d) Cannot be changed from one not null value to another (U)
206: -- e) Must be after initial insert date of last assignment (U)

Line 210: -- person_id, date_start, last_standard_process_date and period_of_placement_id

206: -- e) Must be after initial insert date of last assignment (U)
207: -- f) Must be after effective start date of last future change(s) (U)
208: --
209: -- Pre-conditions:
210: -- person_id, date_start, last_standard_process_date and period_of_placement_id
211: -- have been successfully validated separately.
212: --
213: -- In Arguments:
214: -- p_actual_termination_date

Line 216: -- p_last_standard_process_date

212: --
213: -- In Arguments:
214: -- p_actual_termination_date
215: -- p_date_start
216: -- p_last_standard_process_date
217: -- p_object_version_number
218: -- p_period_of_placement_id
219: -- p_person_id
220: --

Line 238: ,p_last_standard_process_date in date

234: procedure chk_actual_termination_date
235: --
236: (p_actual_termination_date in date
237: ,p_date_start in date
238: ,p_last_standard_process_date in date
239: ,p_object_version_number in number
240: ,p_period_of_placement_id in number
241: ,p_person_id in number
242: ) is

Line 276: '.LAST_STANDARD_PROCESS_DATE'

272: --
273:
274: if hr_multi_message.no_exclusive_error
275: (p_check_column1 => per_pdp_shd.g_tab_nam||
276: '.LAST_STANDARD_PROCESS_DATE'
277: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
278: '.LAST_STANDARD_PROCESS_DATE'
279: ) then
280:

Line 278: '.LAST_STANDARD_PROCESS_DATE'

274: if hr_multi_message.no_exclusive_error
275: (p_check_column1 => per_pdp_shd.g_tab_nam||
276: '.LAST_STANDARD_PROCESS_DATE'
277: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
278: '.LAST_STANDARD_PROCESS_DATE'
279: ) then
280:
281: --
282: hr_utility.set_location(l_proc, 20);

Line 312: if p_actual_termination_date > p_last_standard_process_date and

308: hr_utility.raise_error;
309: end if;
310: hr_utility.set_location(l_proc, 60);
311: --
312: if p_actual_termination_date > p_last_standard_process_date and
313: p_last_standard_process_date is not null then
314: --
315: -- CHK_ACTUAL_TERMINATION_DATE / a
316: --

Line 313: p_last_standard_process_date is not null then

309: end if;
310: hr_utility.set_location(l_proc, 60);
311: --
312: if p_actual_termination_date > p_last_standard_process_date and
313: p_last_standard_process_date is not null then
314: --
315: -- CHK_ACTUAL_TERMINATION_DATE / a
316: --
317: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');

Line 556: -- c) Must be >= LAST_STANDARD_PROCESS_DATE (U)

552: -- must be equal to ACTUAL_TERMINATION_DATE (U)
553: -- b) If the person is assigned to a payroll then
554: -- must equal the maximum period end date of all Assignments
555: -- for the current Period of Placement (U)
556: -- c) Must be >= LAST_STANDARD_PROCESS_DATE (U)
557: -- d) If ACTUAL_TERMINATION_DATE is null then must be null (U)
558: -- e) Must be null (I)
559: --
560: -- Pre-conditions:

Line 561: -- p_date_start, actual_termination_date, last_standard_process_date and

557: -- d) If ACTUAL_TERMINATION_DATE is null then must be null (U)
558: -- e) Must be null (I)
559: --
560: -- Pre-conditions:
561: -- p_date_start, actual_termination_date, last_standard_process_date and
562: -- period_of_placement_id have been successfully validated separately.
563: --
564: -- In Arguments:
565: -- p_actual_termination_date

Line 568: -- p_last_standard_process_date

564: -- In Arguments:
565: -- p_actual_termination_date
566: -- p_date_start
567: -- p_final_process_date
568: -- p_last_standard_process_date
569: -- p_object_version_number
570: -- p_period_of_placement_id
571: --
572: -- Post Success:

Line 589: p_last_standard_process_date in date,

585: procedure chk_final_process_date
586: (p_actual_termination_date in date,
587: p_date_start in date,
588: p_final_process_date in date,
589: p_last_standard_process_date in date,
590: p_object_version_number in number,
591: p_period_of_placement_id in number) is
592: --
593: l_assigned_payroll boolean;

Line 608: '.LAST_STANDARD_PROCESS_DATE'

604: -- below columns.
605: --
606: if hr_multi_message.no_exclusive_error
607: (p_check_column1 => per_pdp_shd.g_tab_nam||
608: '.LAST_STANDARD_PROCESS_DATE'
609: ,p_check_column2 => per_pdp_shd.g_tab_nam||
610: '.ACTUAL_TERMINATION_DATE'
611: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
612: '.LAST_STANDARD_PROCESS_DATE'

Line 612: '.LAST_STANDARD_PROCESS_DATE'

608: '.LAST_STANDARD_PROCESS_DATE'
609: ,p_check_column2 => per_pdp_shd.g_tab_nam||
610: '.ACTUAL_TERMINATION_DATE'
611: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
612: '.LAST_STANDARD_PROCESS_DATE'
613: ,p_associated_column2 => per_pdp_shd.g_tab_nam||
614: '.ACTUAL_TERMINATION_DATE'
615: ) then
616:

Line 661: if p_last_standard_process_date is null

657: end if;
658: --
659: hr_utility.set_location(l_proc, 7);
660: --
661: if p_last_standard_process_date is null
662: then
663: --
664: hr_utility.set_location(l_proc, 8);
665: --

Line 677: p_last_standard_process_date)

673: end if;
674: else
675: --
676: if not (nvl(p_final_process_date, hr_api.g_eot) >=
677: p_last_standard_process_date)
678: --
679: then
680: -- CHK_FINAL_PROCESS_DATE / c
681: --

Line 714: -- |-------------------< chk_last_standard_process_date >--------------------|

710:
711: end chk_final_process_date;
712: --
713: -- ---------------------------------------------------------------------------
714: -- |-------------------< chk_last_standard_process_date >--------------------|
715: -- ---------------------------------------------------------------------------
716: --
717: -- Description:
718: -- Validates that the following business rules are met:

Line 734: -- p_last_standard_process_date

730: --
731: -- In Arguments:
732: -- p_actual_termination_date
733: -- p_date_start
734: -- p_last_standard_process_date
735: -- p_object_version_number
736: -- p_period_of_placement_id
737: --
738: -- Post Success:

Line 751: procedure chk_last_standard_process_date

747: --
748: -- {End Of Comments}
749: -- ----------------------------------------------------------------------------
750: --
751: procedure chk_last_standard_process_date
752: (p_actual_termination_date in date
753: ,p_business_group_id in number
754: ,p_date_start in date
755: ,p_last_standard_process_date in date

Line 755: ,p_last_standard_process_date in date

751: procedure chk_last_standard_process_date
752: (p_actual_termination_date in date
753: ,p_business_group_id in number
754: ,p_date_start in date
755: ,p_last_standard_process_date in date
756: ,p_object_version_number in number
757: ,p_period_of_placement_id in number
758: ) is
759: --

Line 765: := g_package||'chk_last_standard_process_date';

761: l_assigned_payroll boolean;
762: l_legislation_code per_business_groups.legislation_code%TYPE;
763: l_max_end_date date;
764: l_proc varchar2(72)
765: := g_package||'chk_last_standard_process_date';
766: --
767: cursor csr_get_legislation_code is
768: select bus.legislation_code
769: from per_business_groups_perf bus

Line 790: if nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>

786: --
787: if l_api_updating
788: then
789: --
790: if nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
791: nvl(p_last_standard_process_date, hr_api.g_date)
792: then
793: --
794: hr_utility.set_location(l_proc, 30);

Line 791: nvl(p_last_standard_process_date, hr_api.g_date)

787: if l_api_updating
788: then
789: --
790: if nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
791: nvl(p_last_standard_process_date, hr_api.g_date)
792: then
793: --
794: hr_utility.set_location(l_proc, 30);
795: --

Line 796: if per_pdp_shd.g_old_rec.last_standard_process_date is not null

792: then
793: --
794: hr_utility.set_location(l_proc, 30);
795: --
796: if per_pdp_shd.g_old_rec.last_standard_process_date is not null
797: and p_last_standard_process_date is not null
798: then
799: -- CHK_LAST_STANDARD_PROCESS_DATE / i
800: --

Line 797: and p_last_standard_process_date is not null

793: --
794: hr_utility.set_location(l_proc, 30);
795: --
796: if per_pdp_shd.g_old_rec.last_standard_process_date is not null
797: and p_last_standard_process_date is not null
798: then
799: -- CHK_LAST_STANDARD_PROCESS_DATE / i
800: --
801: hr_utility.set_message(801,'HR_7960_PDS_INV_LSP_CHANGE');

Line 799: -- CHK_LAST_STANDARD_PROCESS_DATE / i

795: --
796: if per_pdp_shd.g_old_rec.last_standard_process_date is not null
797: and p_last_standard_process_date is not null
798: then
799: -- CHK_LAST_STANDARD_PROCESS_DATE / i
800: --
801: hr_utility.set_message(801,'HR_7960_PDS_INV_LSP_CHANGE');
802: hr_utility.raise_error;
803: end if;

Line 827: -- last_standard_process for US legislature.

823: --
824: hr_utility.set_location(l_proc, 50);
825: --
826: -- Bug 1711085. VS. 27-Mar-2001. Commented out the code that disables
827: -- last_standard_process for US legislature.
828: /* if l_legislation_code = 'US'
829: then
830: --
831: hr_utility.set_location(l_proc, 60);

Line 833: if not (p_last_standard_process_date is null)

829: then
830: --
831: hr_utility.set_location(l_proc, 60);
832: --
833: if not (p_last_standard_process_date is null)
834: then
835: -- CHK_LAST_STANDARD_PROCESS_DATE / g
836: --
837: hr_utility.set_message(801,'HR_7958_PDS_INV_US_LSP_BLANK');

Line 835: -- CHK_LAST_STANDARD_PROCESS_DATE / g

831: hr_utility.set_location(l_proc, 60);
832: --
833: if not (p_last_standard_process_date is null)
834: then
835: -- CHK_LAST_STANDARD_PROCESS_DATE / g
836: --
837: hr_utility.set_message(801,'HR_7958_PDS_INV_US_LSP_BLANK');
838: hr_utility.raise_error;
839: end if;

Line 846: if not (p_last_standard_process_date is null)

842: --
843: if p_actual_termination_date is null
844: then
845: --
846: if not (p_last_standard_process_date is null)
847: then
848: -- CHK_LAST_STANDARD_PROCESS_DATE / f
849: --
850: hr_utility.set_message(801,'HR_7497_PDS_INV_LSP_DT_BLANK');

Line 848: -- CHK_LAST_STANDARD_PROCESS_DATE / f

844: then
845: --
846: if not (p_last_standard_process_date is null)
847: then
848: -- CHK_LAST_STANDARD_PROCESS_DATE / f
849: --
850: hr_utility.set_message(801,'HR_7497_PDS_INV_LSP_DT_BLANK');
851: hr_utility.raise_error;
852: end if;

Line 858: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=

854: end if;
855: --
856: hr_utility.set_location(l_proc, 80);
857: --
858: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
859: nvl(p_actual_termination_date, hr_api.g_eot))
860: --
861: then
862: -- CHK_LAST_STANDARD_PROCESS_DATE / c

Line 862: -- CHK_LAST_STANDARD_PROCESS_DATE / c

858: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
859: nvl(p_actual_termination_date, hr_api.g_eot))
860: --
861: then
862: -- CHK_LAST_STANDARD_PROCESS_DATE / c
863: --
864: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
865: hr_utility.raise_error;
866: end if;

Line 879: if p_last_standard_process_date is null

875: and l_legislation_code <> 'US'
876: then
877: hr_utility.set_location(l_proc, 100);
878: --
879: if p_last_standard_process_date is null
880: --
881: then
882: --
883: -- Must also be set to not null value if actual_termination_date

Line 885: -- CHK_LAST_STANDARD_PROCESS_DATE / h

881: then
882: --
883: -- Must also be set to not null value if actual_termination_date
884: -- updated to not null value.
885: -- CHK_LAST_STANDARD_PROCESS_DATE / h
886: --
887: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');
888: hr_utility.raise_error;
889: end if;

Line 902: '.LAST_STANDARD_PROCESS_DATE'

898: exception
899: when app_exception.application_exception then
900: if hr_multi_message.exception_add
901: (p_associated_column1 => per_pdp_shd.g_tab_nam||
902: '.LAST_STANDARD_PROCESS_DATE'
903: ) then
904: hr_utility.set_location(' Leaving:'|| l_proc, 140);
905: raise;
906: end if;

Line 909: end chk_last_standard_process_date;

905: raise;
906: end if;
907: hr_utility.set_location(' Leaving:'|| l_proc, 150);
908:
909: end chk_last_standard_process_date;
910: --
911: -- ---------------------------------------------------------------------------
912: -- |-------------------------< chk_at_date_lsp_date >------------------------|
913: -- ---------------------------------------------------------------------------

Line 919: -- a NOT NULL value then last_standard_process_date must also

915: -- Description:
916: -- Validates the following business rule :
917: --
918: -- If actual_termination_date is changed from a NULL value to
919: -- a NOT NULL value then last_standard_process_date must also
920: -- be changed to a NOT NULL value.
921: --
922: -- Pre-conditions:
923: -- actual_termination_date, last_standard_process_date have been

Line 923: -- actual_termination_date, last_standard_process_date have been

919: -- a NOT NULL value then last_standard_process_date must also
920: -- be changed to a NOT NULL value.
921: --
922: -- Pre-conditions:
923: -- actual_termination_date, last_standard_process_date have been
924: -- successfully validated separately.
925: --
926: -- In Arguments:
927: -- p_period_of_placement_id

Line 929: -- p_last_standard_process_date

925: --
926: -- In Arguments:
927: -- p_period_of_placement_id
928: -- p_actual_termination_date
929: -- p_last_standard_process_date
930: -- p_object_version_number
931: --
932: -- Post Success:
933: -- If the above business rules are satisfied then processing continues.

Line 948: ,p_last_standard_process_date in date

944: --
945: procedure chk_at_date_lsp_date
946: --
947: (p_actual_termination_date in date
948: ,p_last_standard_process_date in date
949: ,p_object_version_number in number
950: ,p_period_of_placement_id in number
951: ,p_business_group_id in number
952: ) is

Line 975: '.LAST_STANDARD_PROCESS_DATE'

971: -- below columns.
972: --
973: if hr_multi_message.no_exclusive_error
974: (p_check_column1 => per_pdp_shd.g_tab_nam||
975: '.LAST_STANDARD_PROCESS_DATE'
976: ,p_check_column2 => per_pdp_shd.g_tab_nam||
977: '.ACTUAL_TERMINATION_DATE'
978: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
979: '.LAST_STANDARD_PROCESS_DATE'

Line 979: '.LAST_STANDARD_PROCESS_DATE'

975: '.LAST_STANDARD_PROCESS_DATE'
976: ,p_check_column2 => per_pdp_shd.g_tab_nam||
977: '.ACTUAL_TERMINATION_DATE'
978: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
979: '.LAST_STANDARD_PROCESS_DATE'
980: ,p_associated_column2 => per_pdp_shd.g_tab_nam||
981: '.ACTUAL_TERMINATION_DATE'
982: ) then
983:

Line 995: -- b) The value for actual_termination_date or last_standard_process_date

991: hr_utility.set_location(l_proc, 20);
992: --
993: -- Only proceed with validation if :
994: -- a) The current g_old_rec is current and
995: -- b) The value for actual_termination_date or last_standard_process_date
996: -- has changed
997: --
998: if (l_api_updating
999: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)

Line 1002: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)

998: if (l_api_updating
999: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1000: <> nvl(p_actual_termination_date, hr_api.g_date))
1001: or
1002: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1003: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1004: or
1005: NOT l_api_updating then
1006: --

Line 1003: <> nvl(p_last_standard_process_date, hr_api.g_date))))

999: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
1000: <> nvl(p_actual_termination_date, hr_api.g_date))
1001: or
1002: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1003: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1004: or
1005: NOT l_api_updating then
1006: --
1007: hr_utility.set_location(l_proc, 30);

Line 1031: -- last_standard_process_date are set

1027: --
1028: if l_legislation_code <> 'US' then
1029: --
1030: -- Check combination when either actual_termination_date or
1031: -- last_standard_process_date are set
1032: --
1033: if (per_pdp_shd.g_old_rec.actual_termination_date is null
1034: and p_actual_termination_date is not null)
1035: and p_last_standard_process_date is null

Line 1035: and p_last_standard_process_date is null

1031: -- last_standard_process_date are set
1032: --
1033: if (per_pdp_shd.g_old_rec.actual_termination_date is null
1034: and p_actual_termination_date is not null)
1035: and p_last_standard_process_date is null
1036: then
1037: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');
1038: hr_utility.raise_error;
1039: end if;

Line 1882: -- Validate last standard process date

1878:
1879: hr_utility.set_location(l_proc, 40);
1880:
1881: --
1882: -- Validate last standard process date
1883: --
1884: -- Business Rule Mapping
1885: -- =====================
1886: -- CHK_LAST_STANDARD_PROCESS_DATE / e

Line 1886: -- CHK_LAST_STANDARD_PROCESS_DATE / e

1882: -- Validate last standard process date
1883: --
1884: -- Business Rule Mapping
1885: -- =====================
1886: -- CHK_LAST_STANDARD_PROCESS_DATE / e
1887: --
1888: -- 70.3 change c start.
1889: --
1890: per_pdp_bus.chk_last_standard_process_date

Line 1890: per_pdp_bus.chk_last_standard_process_date

1886: -- CHK_LAST_STANDARD_PROCESS_DATE / e
1887: --
1888: -- 70.3 change c start.
1889: --
1890: per_pdp_bus.chk_last_standard_process_date
1891: (p_actual_termination_date => p_rec.actual_termination_date
1892: ,p_business_group_id => p_rec.business_group_id
1893: ,p_date_start => p_rec.date_start
1894: ,p_last_standard_process_date => p_rec.last_standard_process_date

Line 1894: ,p_last_standard_process_date => p_rec.last_standard_process_date

1890: per_pdp_bus.chk_last_standard_process_date
1891: (p_actual_termination_date => p_rec.actual_termination_date
1892: ,p_business_group_id => p_rec.business_group_id
1893: ,p_date_start => p_rec.date_start
1894: ,p_last_standard_process_date => p_rec.last_standard_process_date
1895: ,p_object_version_number => p_rec.object_version_number
1896: ,p_period_of_placement_id => p_rec.period_of_placement_id
1897: );
1898:

Line 1915: ,p_last_standard_process_date => p_rec.last_standard_process_date

1911: --
1912: per_pdp_bus.chk_actual_termination_date
1913: (p_actual_termination_date => p_rec.actual_termination_date
1914: ,p_date_start => p_rec.date_start
1915: ,p_last_standard_process_date => p_rec.last_standard_process_date
1916: ,p_object_version_number => p_rec.object_version_number
1917: ,p_period_of_placement_id => p_rec.period_of_placement_id
1918: ,p_person_id => p_rec.person_id);
1919:

Line 1933: p_last_standard_process_date => p_rec.last_standard_process_date,

1929: per_pdp_bus.chk_final_process_date
1930: (p_actual_termination_date => p_rec.actual_termination_date,
1931: p_date_start => p_rec.date_start,
1932: p_final_process_date => p_rec.final_process_date,
1933: p_last_standard_process_date => p_rec.last_standard_process_date,
1934: p_object_version_number => p_rec.object_version_number,
1935: p_period_of_placement_id => p_rec.period_of_placement_id);
1936:
1937: hr_utility.set_location(l_proc, 70);

Line 1940: -- Validate actual termination date/last standard process date

1936:
1937: hr_utility.set_location(l_proc, 70);
1938:
1939: --
1940: -- Validate actual termination date/last standard process date
1941: --
1942: -- Business Rule Mapping
1943: -- =====================
1944: -- CHK_LAST_STANDARD_PROCESS_DATE / h

Line 1944: -- CHK_LAST_STANDARD_PROCESS_DATE / h

1940: -- Validate actual termination date/last standard process date
1941: --
1942: -- Business Rule Mapping
1943: -- =====================
1944: -- CHK_LAST_STANDARD_PROCESS_DATE / h
1945: --
1946: per_pdp_bus.chk_at_date_lsp_date
1947: (p_actual_termination_date => p_rec.actual_termination_date
1948: ,p_last_standard_process_date => p_rec.last_standard_process_date

Line 1948: ,p_last_standard_process_date => p_rec.last_standard_process_date

1944: -- CHK_LAST_STANDARD_PROCESS_DATE / h
1945: --
1946: per_pdp_bus.chk_at_date_lsp_date
1947: (p_actual_termination_date => p_rec.actual_termination_date
1948: ,p_last_standard_process_date => p_rec.last_standard_process_date
1949: ,p_object_version_number => p_rec.object_version_number
1950: ,p_period_of_placement_id => p_rec.period_of_placement_id
1951: ,p_business_group_id => p_rec.business_group_id
1952: );

Line 2078: -- Validate last standard process date

2074: p_period_of_placement_id => p_rec.period_of_placement_id);
2075:
2076: hr_utility.set_location(l_proc, 40);
2077: --
2078: -- Validate last standard process date
2079: --
2080: -- Business Rule Mapping
2081: -- =====================
2082: -- CHK_LAST_STANDARD_PROCESS_DATE / e

Line 2082: -- CHK_LAST_STANDARD_PROCESS_DATE / e

2078: -- Validate last standard process date
2079: --
2080: -- Business Rule Mapping
2081: -- =====================
2082: -- CHK_LAST_STANDARD_PROCESS_DATE / e
2083: --
2084: -- 70.3 change c start.
2085: --
2086: per_pdp_bus.chk_last_standard_process_date

Line 2086: per_pdp_bus.chk_last_standard_process_date

2082: -- CHK_LAST_STANDARD_PROCESS_DATE / e
2083: --
2084: -- 70.3 change c start.
2085: --
2086: per_pdp_bus.chk_last_standard_process_date
2087: (p_actual_termination_date => p_rec.actual_termination_date
2088: ,p_business_group_id => p_rec.business_group_id
2089: ,p_date_start => p_rec.date_start
2090: ,p_last_standard_process_date => p_rec.last_standard_process_date

Line 2090: ,p_last_standard_process_date => p_rec.last_standard_process_date

2086: per_pdp_bus.chk_last_standard_process_date
2087: (p_actual_termination_date => p_rec.actual_termination_date
2088: ,p_business_group_id => p_rec.business_group_id
2089: ,p_date_start => p_rec.date_start
2090: ,p_last_standard_process_date => p_rec.last_standard_process_date
2091: ,p_object_version_number => p_rec.object_version_number
2092: ,p_period_of_placement_id => p_rec.period_of_placement_id
2093: );
2094:

Line 2111: ,p_last_standard_process_date => p_rec.last_standard_process_date

2107: --
2108: per_pdp_bus.chk_actual_termination_date
2109: (p_actual_termination_date => p_rec.actual_termination_date
2110: ,p_date_start => p_rec.date_start
2111: ,p_last_standard_process_date => p_rec.last_standard_process_date
2112: ,p_object_version_number => p_rec.object_version_number
2113: ,p_period_of_placement_id => p_rec.period_of_placement_id
2114: ,p_person_id => p_rec.person_id);
2115:

Line 2129: p_last_standard_process_date => p_rec.last_standard_process_date,

2125: per_pdp_bus.chk_final_process_date
2126: (p_actual_termination_date => p_rec.actual_termination_date,
2127: p_date_start => p_rec.date_start,
2128: p_final_process_date => p_rec.final_process_date,
2129: p_last_standard_process_date => p_rec.last_standard_process_date,
2130: p_object_version_number => p_rec.object_version_number,
2131: p_period_of_placement_id => p_rec.period_of_placement_id);
2132:
2133: hr_utility.set_location(l_proc, 70);

Line 2136: -- Validate actual termination date/last standard process date

2132:
2133: hr_utility.set_location(l_proc, 70);
2134:
2135: --
2136: -- Validate actual termination date/last standard process date
2137: --
2138: -- Business Rule Mapping
2139: -- =====================
2140: -- CHK_LAST_STANDARD_PROCESS_DATE / h

Line 2140: -- CHK_LAST_STANDARD_PROCESS_DATE / h

2136: -- Validate actual termination date/last standard process date
2137: --
2138: -- Business Rule Mapping
2139: -- =====================
2140: -- CHK_LAST_STANDARD_PROCESS_DATE / h
2141: --
2142: per_pdp_bus.chk_at_date_lsp_date
2143: (p_actual_termination_date => p_rec.actual_termination_date
2144: ,p_last_standard_process_date => p_rec.last_standard_process_date

Line 2144: ,p_last_standard_process_date => p_rec.last_standard_process_date

2140: -- CHK_LAST_STANDARD_PROCESS_DATE / h
2141: --
2142: per_pdp_bus.chk_at_date_lsp_date
2143: (p_actual_termination_date => p_rec.actual_termination_date
2144: ,p_last_standard_process_date => p_rec.last_standard_process_date
2145: ,p_object_version_number => p_rec.object_version_number
2146: ,p_period_of_placement_id => p_rec.period_of_placement_id
2147: ,p_business_group_id => p_rec.business_group_id
2148: );