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_PDP_BUS dependencies on PER_PDP_SHD

Line 275: (p_check_column1 => per_pdp_shd.g_tab_nam||

271: -- below columns.
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

Line 277: ,p_associated_column1 => per_pdp_shd.g_tab_nam||

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

Line 286: l_api_updating := per_pdp_shd.api_updating

282: hr_utility.set_location(l_proc, 20);
283: --
284: -- Check to see if record updated.
285: --
286: l_api_updating := per_pdp_shd.api_updating
287: (p_period_of_placement_id => p_period_of_placement_id
288: ,p_object_version_number => p_object_version_number);
289: --
290: hr_utility.set_location(l_proc, 30);

Line 295: if nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>

291: --
292: if l_api_updating
293: then
294: --
295: if nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
296: nvl(p_actual_termination_date, hr_api.g_date)
297: and p_actual_termination_date is not null
298: then
299: hr_utility.set_location(l_proc, 40);

Line 301: if per_pdp_shd.g_old_rec.actual_termination_date is not null

297: and p_actual_termination_date is not null
298: then
299: hr_utility.set_location(l_proc, 40);
300: --
301: if per_pdp_shd.g_old_rec.actual_termination_date is not null
302: then
303: --
304: -- Cannot be changed from one not null value to another not null value.
305: -- CHK_ACTUAL_TERMINATION_DATE / d

Line 459: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.DATE_START'

455:
456: exception
457: when app_exception.application_exception then
458: if hr_multi_message.exception_add
459: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.DATE_START'
460: ) then
461: hr_utility.set_location(' Leaving:'|| l_proc, 30);
462: raise;
463: end if;

Line 512: l_api_updating := per_pdp_shd.api_updating

508: hr_utility.set_location('Entering:'|| l_proc, 10);
509: --
510: -- Check to see if record updated.
511: --
512: l_api_updating := per_pdp_shd.api_updating
513: (p_period_of_placement_id => p_period_of_placement_id
514: ,p_object_version_number => p_object_version_number);
515: --
516: hr_utility.set_location('Entering:'|| l_proc, 20);

Line 519: AND (nvl(per_pdp_shd.g_old_rec.projected_termination_date, hr_api.g_date) <>

515: --
516: hr_utility.set_location('Entering:'|| l_proc, 20);
517: --
518: if (l_api_updating
519: AND (nvl(per_pdp_shd.g_old_rec.projected_termination_date, hr_api.g_date) <>
520: nvl(p_projected_termination_date, hr_api.g_date)))
521: OR not l_api_updating
522: then
523: if nvl(p_projected_termination_date,hr_api.g_eot) < p_date_start

Line 537: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PROJECTED_TERMINATION_DATE'

533: hr_utility.set_location(' Leaving:'|| l_proc, 30);
534: exception
535: when app_exception.application_exception then
536: if hr_multi_message.exception_add
537: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PROJECTED_TERMINATION_DATE'
538: ) then
539: hr_utility.set_location(' Leaving:'|| l_proc, 40);
540: raise;
541: end if;

Line 607: (p_check_column1 => per_pdp_shd.g_tab_nam||

603: -- does not already contain an error associated with the
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||

Line 609: ,p_check_column2 => per_pdp_shd.g_tab_nam||

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'
613: ,p_associated_column2 => per_pdp_shd.g_tab_nam||

Line 611: ,p_associated_column1 => per_pdp_shd.g_tab_nam||

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'
613: ,p_associated_column2 => per_pdp_shd.g_tab_nam||
614: '.ACTUAL_TERMINATION_DATE'
615: ) then

Line 613: ,p_associated_column2 => per_pdp_shd.g_tab_nam||

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

Line 620: l_api_updating := per_pdp_shd.api_updating

616:
617: --
618: -- Check to see if record updated.
619: --
620: l_api_updating := per_pdp_shd.api_updating
621: (p_period_of_placement_id => p_period_of_placement_id
622: ,p_object_version_number => p_object_version_number);
623: --
624: hr_utility.set_location(l_proc, 5);

Line 629: if nvl(per_pdp_shd.g_old_rec.final_process_date, hr_api.g_date) <>

625: --
626: if l_api_updating
627: then
628: --
629: if nvl(per_pdp_shd.g_old_rec.final_process_date, hr_api.g_date) <>
630: nvl(p_final_process_date, hr_api.g_date)
631: then
632: --
633: hr_utility.set_location(l_proc, 6);

Line 636: if per_pdp_shd.g_old_rec.final_process_date is not null

632: --
633: hr_utility.set_location(l_proc, 6);
634: --
635: --
636: if per_pdp_shd.g_old_rec.final_process_date is not null
637: and p_final_process_date is not null
638: then
639: -- CHK_FINAL_PROCESS_DATE / g
640: --

Line 781: l_api_updating := per_pdp_shd.api_updating

777: --
778: --
779: -- Check to see if record updated.
780: --
781: l_api_updating := per_pdp_shd.api_updating
782: (p_period_of_placement_id => p_period_of_placement_id
783: ,p_object_version_number => p_object_version_number);
784: --
785: hr_utility.set_location(l_proc, 20);

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 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 872: if (nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>

868: hr_utility.set_location(l_proc, 90);
869: --
870: end if;
871: --
872: if (nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
873: nvl(p_actual_termination_date,hr_api.g_date) )
874: and (p_actual_termination_date is not null)
875: and l_legislation_code <> 'US'
876: then

Line 901: (p_associated_column1 => per_pdp_shd.g_tab_nam||

897:
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;

Line 974: (p_check_column1 => per_pdp_shd.g_tab_nam||

970: -- does not already contain an error associated with the
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||

Line 976: ,p_check_column2 => per_pdp_shd.g_tab_nam||

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'
980: ,p_associated_column2 => per_pdp_shd.g_tab_nam||

Line 978: ,p_associated_column1 => per_pdp_shd.g_tab_nam||

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'
980: ,p_associated_column2 => per_pdp_shd.g_tab_nam||
981: '.ACTUAL_TERMINATION_DATE'
982: ) then

Line 980: ,p_associated_column2 => per_pdp_shd.g_tab_nam||

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

Line 987: l_api_updating := per_pdp_shd.api_updating

983:
984: --
985: -- Check to see if record updated.
986: --
987: l_api_updating := per_pdp_shd.api_updating
988: (p_period_of_placement_id => p_period_of_placement_id
989: ,p_object_version_number => p_object_version_number);
990: --
991: hr_utility.set_location(l_proc, 20);

Line 999: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)

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)
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))))

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 1033: if (per_pdp_shd.g_old_rec.actual_termination_date is null

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
1036: then
1037: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');

Line 1107: l_rec per_pdp_shd.g_rec_type;

1103: p_period_of_placement_id in number) is
1104: --
1105: l_api_updating boolean;
1106: l_proc varchar2(72) := g_package||'chk_termination_reason';
1107: l_rec per_pdp_shd.g_rec_type;
1108: --
1109: begin
1110: hr_utility.set_location('Entering:'|| l_proc, 1);
1111: --

Line 1120: l_api_updating := per_pdp_shd.api_updating

1116: );
1117: --
1118: -- Check to see if record updated.
1119: --
1120: l_api_updating := per_pdp_shd.api_updating
1121: (p_period_of_placement_id => p_period_of_placement_id
1122: ,p_object_version_number => p_object_version_number);
1123: --
1124: hr_utility.set_location(l_proc, 2);

Line 1130: if nvl(per_pdp_shd.g_old_rec.termination_reason, hr_api.g_varchar2) <>

1126: if l_api_updating
1127: and p_termination_reason is not null
1128: then
1129: --
1130: if nvl(per_pdp_shd.g_old_rec.termination_reason, hr_api.g_varchar2) <>
1131: nvl(p_termination_reason, hr_api.g_varchar2)
1132: then
1133: --
1134: -- Bug 1472162.

Line 1157: (p_associated_column1 => per_pdp_shd.g_tab_nam||

1153:
1154: exception
1155: when app_exception.application_exception then
1156: if hr_multi_message.exception_add
1157: (p_associated_column1 => per_pdp_shd.g_tab_nam||
1158: '.TERMINATION_REASON'
1159: ) then
1160: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1161: raise;

Line 1206: l_rec per_pdp_shd.g_rec_type;

1202: ,p_effective_date in date
1203: ,p_business_group_id in number) is
1204: --
1205: l_proc varchar2(72) := g_package||'chk_person_id';
1206: l_rec per_pdp_shd.g_rec_type;
1207: l_person_id number;
1208:
1209: cursor c_get_person is
1210: select p.person_id

Line 1251: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PERSON_ID'

1247:
1248: exception
1249: when app_exception.application_exception then
1250: if hr_multi_message.exception_add
1251: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PERSON_ID'
1252: ) then
1253: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1254: raise;
1255: end if;

Line 1327: l_api_updating := per_pdp_shd.api_updating

1323: hr_utility.set_location(l_proc, 5);
1324: --
1325: -- Check to see if record updated.
1326: --
1327: l_api_updating := per_pdp_shd.api_updating
1328: (p_period_of_placement_id => p_period_of_placement_id
1329: ,p_object_version_number => p_object_version_number);
1330: --
1331: if not l_api_updating

Line 1360: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PERSON_ID'

1356:
1357: exception
1358: when app_exception.application_exception then
1359: if hr_multi_message.exception_add
1360: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PERSON_ID'
1361: ,p_associated_column2 => per_pdp_shd.g_tab_nam||'.DATE_START'
1362: ) then
1363: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1364: raise;

Line 1361: ,p_associated_column2 => per_pdp_shd.g_tab_nam||'.DATE_START'

1357: exception
1358: when app_exception.application_exception then
1359: if hr_multi_message.exception_add
1360: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PERSON_ID'
1361: ,p_associated_column2 => per_pdp_shd.g_tab_nam||'.DATE_START'
1362: ) then
1363: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1364: raise;
1365: end if;

Line 1400: (p_rec in per_pdp_shd.g_rec_type

1396: --
1397: -- ----------------------------------------------------------------------------
1398: --
1399: procedure chk_ddf
1400: (p_rec in per_pdp_shd.g_rec_type
1401: ) is
1402: --
1403: l_proc varchar2(72) := g_package || 'chk_ddf';
1404: --

Line 1409: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

1405: begin
1406: hr_utility.set_location('Entering:'||l_proc,10);
1407: --
1408: if ((p_rec.period_of_placement_id is not null) and (
1409: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1410: nvl(p_rec.information_category, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>

1407: --
1408: if ((p_rec.period_of_placement_id is not null) and (
1409: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1410: nvl(p_rec.information_category, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

1409: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1410: nvl(p_rec.information_category, hr_api.g_varchar2) or
1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

1411: nvl(per_pdp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
1412: nvl(p_rec.information1, hr_api.g_varchar2) or
1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

1413: nvl(per_pdp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
1414: nvl(p_rec.information2, hr_api.g_varchar2) or
1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

1415: nvl(per_pdp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
1416: nvl(p_rec.information3, hr_api.g_varchar2) or
1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

1417: nvl(per_pdp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
1418: nvl(p_rec.information4, hr_api.g_varchar2) or
1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

1419: nvl(per_pdp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
1420: nvl(p_rec.information5, hr_api.g_varchar2) or
1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

1421: nvl(per_pdp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
1422: nvl(p_rec.information6, hr_api.g_varchar2) or
1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

1423: nvl(per_pdp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
1424: nvl(p_rec.information7, hr_api.g_varchar2) or
1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

1425: nvl(per_pdp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
1426: nvl(p_rec.information8, hr_api.g_varchar2) or
1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

1427: nvl(per_pdp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
1428: nvl(p_rec.information9, hr_api.g_varchar2) or
1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

1429: nvl(per_pdp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
1430: nvl(p_rec.information10, hr_api.g_varchar2) or
1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

1431: nvl(per_pdp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
1432: nvl(p_rec.information11, hr_api.g_varchar2) or
1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

1433: nvl(per_pdp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
1434: nvl(p_rec.information12, hr_api.g_varchar2) or
1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

1435: nvl(per_pdp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
1436: nvl(p_rec.information13, hr_api.g_varchar2) or
1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

1437: nvl(per_pdp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
1438: nvl(p_rec.information14, hr_api.g_varchar2) or
1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

1439: nvl(per_pdp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
1440: nvl(p_rec.information15, hr_api.g_varchar2) or
1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

1441: nvl(per_pdp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
1442: nvl(p_rec.information16, hr_api.g_varchar2) or
1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

1443: nvl(per_pdp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
1444: nvl(p_rec.information17, hr_api.g_varchar2) or
1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

1445: nvl(per_pdp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
1446: nvl(p_rec.information18, hr_api.g_varchar2) or
1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

1447: nvl(per_pdp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
1448: nvl(p_rec.information19, hr_api.g_varchar2) or
1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

1449: nvl(per_pdp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
1450: nvl(p_rec.information20, hr_api.g_varchar2) or
1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

1451: nvl(per_pdp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
1452: nvl(p_rec.information21, hr_api.g_varchar2) or
1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

1453: nvl(per_pdp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
1454: nvl(p_rec.information22, hr_api.g_varchar2) or
1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

1455: nvl(per_pdp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
1456: nvl(p_rec.information23, hr_api.g_varchar2) or
1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

1457: nvl(per_pdp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
1458: nvl(p_rec.information24, hr_api.g_varchar2) or
1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

1459: nvl(per_pdp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
1460: nvl(p_rec.information25, hr_api.g_varchar2) or
1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

1461: nvl(per_pdp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
1462: nvl(p_rec.information26, hr_api.g_varchar2) or
1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

1463: nvl(per_pdp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
1464: nvl(p_rec.information27, hr_api.g_varchar2) or
1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1470: nvl(p_rec.information30, hr_api.g_varchar2) ))
1471: or (p_rec.period_of_placement_id is null) then

Line 1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

1465: nvl(per_pdp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
1466: nvl(p_rec.information28, hr_api.g_varchar2) or
1467: nvl(per_pdp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
1468: nvl(p_rec.information29, hr_api.g_varchar2) or
1469: nvl(per_pdp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
1470: nvl(p_rec.information30, hr_api.g_varchar2) ))
1471: or (p_rec.period_of_placement_id is null) then
1472: --
1473: -- Only execute the validation if absolutely necessary:

Line 1578: (p_rec in per_pdp_shd.g_rec_type

1574: --
1575: -- ----------------------------------------------------------------------------
1576: --
1577: procedure chk_df
1578: (p_rec in per_pdp_shd.g_rec_type
1579: ) is
1580: --
1581: l_proc varchar2(72) := g_package || 'chk_df';
1582: --

Line 1587: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

1583: begin
1584: hr_utility.set_location('Entering:'||l_proc,10);
1585: --
1586: if ((p_rec.period_of_placement_id is not null) and (
1587: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1588: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

1585: --
1586: if ((p_rec.period_of_placement_id is not null) and (
1587: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1588: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

1587: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1588: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

1589: nvl(per_pdp_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1590: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

1591: nvl(per_pdp_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1592: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

1593: nvl(per_pdp_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1594: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

1595: nvl(per_pdp_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1596: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

1597: nvl(per_pdp_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1598: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

1599: nvl(per_pdp_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1600: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

1601: nvl(per_pdp_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1602: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

1603: nvl(per_pdp_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1604: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

1605: nvl(per_pdp_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1606: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

1607: nvl(per_pdp_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1608: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

1609: nvl(per_pdp_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1610: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

1611: nvl(per_pdp_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1612: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

1613: nvl(per_pdp_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1614: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

1615: nvl(per_pdp_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1616: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

1617: nvl(per_pdp_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1618: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

1619: nvl(per_pdp_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1620: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

1621: nvl(per_pdp_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1622: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

1623: nvl(per_pdp_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1624: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

1625: nvl(per_pdp_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1626: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

1627: nvl(per_pdp_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1628: nvl(p_rec.attribute20, hr_api.g_varchar2) or
1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

1629: nvl(per_pdp_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
1630: nvl(p_rec.attribute21, hr_api.g_varchar2) or
1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

1631: nvl(per_pdp_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
1632: nvl(p_rec.attribute22, hr_api.g_varchar2) or
1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

1633: nvl(per_pdp_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
1634: nvl(p_rec.attribute23, hr_api.g_varchar2) or
1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

1635: nvl(per_pdp_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
1636: nvl(p_rec.attribute24, hr_api.g_varchar2) or
1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

1637: nvl(per_pdp_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
1638: nvl(p_rec.attribute25, hr_api.g_varchar2) or
1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

1639: nvl(per_pdp_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
1640: nvl(p_rec.attribute26, hr_api.g_varchar2) or
1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

1641: nvl(per_pdp_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
1642: nvl(p_rec.attribute27, hr_api.g_varchar2) or
1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1648: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1649: or (p_rec.period_of_placement_id is null) then

Line 1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

1643: nvl(per_pdp_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
1644: nvl(p_rec.attribute28, hr_api.g_varchar2) or
1645: nvl(per_pdp_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
1646: nvl(p_rec.attribute29, hr_api.g_varchar2) or
1647: nvl(per_pdp_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
1648: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
1649: or (p_rec.period_of_placement_id is null) then
1650: --
1651: -- Only execute the validation if absolutely necessary:

Line 1755: ,p_rec in per_pdp_shd.g_rec_type

1751: -- {End Of Comments}
1752: -- ----------------------------------------------------------------------------
1753: Procedure chk_non_updateable_args
1754: (p_effective_date in date
1755: ,p_rec in per_pdp_shd.g_rec_type
1756: ) IS
1757: --
1758: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1759: --

Line 1765: IF NOT per_pdp_shd.api_updating

1761: --
1762: -- Only proceed with the validation if a row exists for the current
1763: -- record in the HR Schema.
1764: --
1765: IF NOT per_pdp_shd.api_updating
1766: (p_period_of_placement_id => p_rec.period_of_placement_id
1767: ,p_object_version_number => p_rec.object_version_number
1768: ) THEN
1769: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1783: ,p_rec in per_pdp_shd.g_rec_type

1779: -- |---------------------------< insert_validate >----------------------------|
1780: -- ----------------------------------------------------------------------------
1781: Procedure insert_validate
1782: (p_effective_date in date
1783: ,p_rec in per_pdp_shd.g_rec_type
1784: ) is
1785: --
1786: l_proc varchar2(72) := g_package||'insert_validate';
1787: --

Line 1795: ,p_associated_column1 => per_pdp_shd.g_tab_nam

1791: -- Call all supporting business operations
1792: --
1793: hr_api.validate_bus_grp_id
1794: (p_business_group_id => p_rec.business_group_id
1795: ,p_associated_column1 => per_pdp_shd.g_tab_nam
1796: || '.BUSINESS_GROUP_ID');
1797:
1798: hr_utility.set_location(l_proc, 10);
1799:

Line 1960: if per_pdp_shd.g_validate_df_flex then

1956: --
1957: -- Only validate the flexfields if the PDP being created
1958: -- is not the default for a new person.
1959: --
1960: if per_pdp_shd.g_validate_df_flex then
1961:
1962: per_pdp_bus.chk_ddf(p_rec);
1963: per_pdp_bus.chk_df(p_rec);
1964:

Line 1975: ,p_rec in per_pdp_shd.g_rec_type

1971: -- |---------------------------< update_validate >----------------------------|
1972: -- ----------------------------------------------------------------------------
1973: Procedure update_validate
1974: (p_effective_date in date
1975: ,p_rec in per_pdp_shd.g_rec_type
1976: ) is
1977: --
1978: l_proc varchar2(72) := g_package||'update_validate';
1979: --

Line 1987: ,p_associated_column1 => per_pdp_shd.g_tab_nam

1983: -- Call all supporting business operations
1984: --
1985: hr_api.validate_bus_grp_id
1986: (p_business_group_id => p_rec.business_group_id
1987: ,p_associated_column1 => per_pdp_shd.g_tab_nam
1988: || '.BUSINESS_GROUP_ID');
1989:
1990: hr_utility.set_location(l_proc, 10);
1991:

Line 2156: if per_pdp_shd.g_validate_df_flex then

2152: --
2153: -- Only validate the flexfields if the PDP being created
2154: -- is not the default for a new person.
2155: --
2156: if per_pdp_shd.g_validate_df_flex then
2157:
2158: per_pdp_bus.chk_ddf(p_rec);
2159: per_pdp_bus.chk_df(p_rec);
2160:

Line 2170: (p_rec in per_pdp_shd.g_rec_type

2166: -- ----------------------------------------------------------------------------
2167: -- |---------------------------< delete_validate >----------------------------|
2168: -- ----------------------------------------------------------------------------
2169: Procedure delete_validate
2170: (p_rec in per_pdp_shd.g_rec_type
2171: ) is
2172: --
2173: l_proc varchar2(72) := g_package||'delete_validate';
2174: --