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 456: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.DATE_START'

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

Line 509: l_api_updating := per_pdp_shd.api_updating

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

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

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

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

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

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

600: -- does not already contain an error associated with the
601: -- below columns.
602: --
603: if hr_multi_message.no_exclusive_error
604: (p_check_column1 => per_pdp_shd.g_tab_nam||
605: '.LAST_STANDARD_PROCESS_DATE'
606: ,p_check_column2 => per_pdp_shd.g_tab_nam||
607: '.ACTUAL_TERMINATION_DATE'
608: ,p_associated_column1 => per_pdp_shd.g_tab_nam||

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

602: --
603: if hr_multi_message.no_exclusive_error
604: (p_check_column1 => per_pdp_shd.g_tab_nam||
605: '.LAST_STANDARD_PROCESS_DATE'
606: ,p_check_column2 => per_pdp_shd.g_tab_nam||
607: '.ACTUAL_TERMINATION_DATE'
608: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
609: '.LAST_STANDARD_PROCESS_DATE'
610: ,p_associated_column2 => per_pdp_shd.g_tab_nam||

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

604: (p_check_column1 => per_pdp_shd.g_tab_nam||
605: '.LAST_STANDARD_PROCESS_DATE'
606: ,p_check_column2 => per_pdp_shd.g_tab_nam||
607: '.ACTUAL_TERMINATION_DATE'
608: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
609: '.LAST_STANDARD_PROCESS_DATE'
610: ,p_associated_column2 => per_pdp_shd.g_tab_nam||
611: '.ACTUAL_TERMINATION_DATE'
612: ) then

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

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

Line 617: l_api_updating := per_pdp_shd.api_updating

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

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

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

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

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

Line 778: l_api_updating := per_pdp_shd.api_updating

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

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

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

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

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

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

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

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

894:
895: exception
896: when app_exception.application_exception then
897: if hr_multi_message.exception_add
898: (p_associated_column1 => per_pdp_shd.g_tab_nam||
899: '.LAST_STANDARD_PROCESS_DATE'
900: ) then
901: hr_utility.set_location(' Leaving:'|| l_proc, 140);
902: raise;

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

967: -- does not already contain an error associated with the
968: -- below columns.
969: --
970: if hr_multi_message.no_exclusive_error
971: (p_check_column1 => per_pdp_shd.g_tab_nam||
972: '.LAST_STANDARD_PROCESS_DATE'
973: ,p_check_column2 => per_pdp_shd.g_tab_nam||
974: '.ACTUAL_TERMINATION_DATE'
975: ,p_associated_column1 => per_pdp_shd.g_tab_nam||

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

969: --
970: if hr_multi_message.no_exclusive_error
971: (p_check_column1 => per_pdp_shd.g_tab_nam||
972: '.LAST_STANDARD_PROCESS_DATE'
973: ,p_check_column2 => per_pdp_shd.g_tab_nam||
974: '.ACTUAL_TERMINATION_DATE'
975: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
976: '.LAST_STANDARD_PROCESS_DATE'
977: ,p_associated_column2 => per_pdp_shd.g_tab_nam||

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

971: (p_check_column1 => per_pdp_shd.g_tab_nam||
972: '.LAST_STANDARD_PROCESS_DATE'
973: ,p_check_column2 => per_pdp_shd.g_tab_nam||
974: '.ACTUAL_TERMINATION_DATE'
975: ,p_associated_column1 => per_pdp_shd.g_tab_nam||
976: '.LAST_STANDARD_PROCESS_DATE'
977: ,p_associated_column2 => per_pdp_shd.g_tab_nam||
978: '.ACTUAL_TERMINATION_DATE'
979: ) then

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

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

Line 984: l_api_updating := per_pdp_shd.api_updating

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

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

992: -- b) The value for actual_termination_date or last_standard_process_date
993: -- has changed
994: --
995: if (l_api_updating
996: and ((nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date)
997: <> nvl(p_actual_termination_date, hr_api.g_date))
998: or
999: (nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date)
1000: <> nvl(p_last_standard_process_date, hr_api.g_date))))

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

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

Line 1030: if (per_pdp_shd.g_old_rec.actual_termination_date is null

1026: --
1027: -- Check combination when either actual_termination_date or
1028: -- last_standard_process_date are set
1029: --
1030: if (per_pdp_shd.g_old_rec.actual_termination_date is null
1031: and p_actual_termination_date is not null)
1032: and p_last_standard_process_date is null
1033: then
1034: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');

Line 1104: l_rec per_pdp_shd.g_rec_type;

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

Line 1117: l_api_updating := per_pdp_shd.api_updating

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

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

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

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

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

Line 1203: l_rec per_pdp_shd.g_rec_type;

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

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

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

Line 1324: l_api_updating := per_pdp_shd.api_updating

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

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

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

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

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

Line 1397: (p_rec in per_pdp_shd.g_rec_type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1575: (p_rec in per_pdp_shd.g_rec_type

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1752: ,p_rec in per_pdp_shd.g_rec_type

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

Line 1762: IF NOT per_pdp_shd.api_updating

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

Line 1780: ,p_rec in per_pdp_shd.g_rec_type

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

Line 1792: ,p_associated_column1 => per_pdp_shd.g_tab_nam

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

Line 1957: if per_pdp_shd.g_validate_df_flex then

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

Line 1972: ,p_rec in per_pdp_shd.g_rec_type

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

Line 1984: ,p_associated_column1 => per_pdp_shd.g_tab_nam

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

Line 2153: if per_pdp_shd.g_validate_df_flex then

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

Line 2167: (p_rec in per_pdp_shd.g_rec_type

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