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.HR_PDT_BUS dependencies on HR_PERSON_DEPLOYMENTS

Line 31: , hr_person_deployments pdt

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , hr_person_deployments pdt
32: where pdt.person_deployment_id = p_person_deployment_id
33: and pbg.business_group_id = pdt.to_business_group_id;
34: --
35: -- Declare local variables

Line 98: , hr_person_deployments pdt

94: --
95: cursor csr_leg_code is
96: select pbg.legislation_code
97: from per_business_groups_perf pbg
98: , hr_person_deployments pdt
99: where pdt.person_deployment_id = p_person_deployment_id
100: and pbg.business_group_id = pdt.to_business_group_id;
101: --
102: -- Declare local variables

Line 451: (p_from_business_group_id in hr_person_deployments.from_business_group_id%type

447: -- {End of Comments}
448: --
449: -- ---------------------------------------------------------------------------
450: Procedure chk_business_groups
451: (p_from_business_group_id in hr_person_deployments.from_business_group_id%type
452: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
453: ) is
454: --
455: l_proc varchar2(72) := g_package||'chk_business_groups';

Line 452: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

448: --
449: -- ---------------------------------------------------------------------------
450: Procedure chk_business_groups
451: (p_from_business_group_id in hr_person_deployments.from_business_group_id%type
452: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
453: ) is
454: --
455: l_proc varchar2(72) := g_package||'chk_business_groups';
456: l_dummy number;

Line 483: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_BUSINESS_GROUP_ID');

479: if csr_bg_exists%notfound then
480: close csr_bg_exists;
481: fnd_message.set_name('PER','HR_449627_PDT_FROM_BG_NOTEXIST');
482: hr_multi_message.add
483: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_BUSINESS_GROUP_ID');
484: else
485: close csr_bg_exists;
486: end if;
487: --

Line 494: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID');

490: if csr_bg_exists%notfound then
491: close csr_bg_exists;
492: fnd_message.set_name('PER','HR_449628_PDT_TO_BG_NOTEXIST');
493: hr_multi_message.add
494: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID');
495: else
496: close csr_bg_exists;
497: end if;
498: --

Line 533: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type

529: -- {End of Comments}
530: --
531: -- ---------------------------------------------------------------------------
532: Procedure chk_from_person_id
533: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type
534: ,p_object_version_number in hr_person_deployments.object_version_number%type
535: ,p_from_person_id in hr_person_deployments.from_person_id%type
536: ,p_from_business_group_id in hr_person_deployments.from_business_group_id%type
537: ,p_start_date in date

Line 534: ,p_object_version_number in hr_person_deployments.object_version_number%type

530: --
531: -- ---------------------------------------------------------------------------
532: Procedure chk_from_person_id
533: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type
534: ,p_object_version_number in hr_person_deployments.object_version_number%type
535: ,p_from_person_id in hr_person_deployments.from_person_id%type
536: ,p_from_business_group_id in hr_person_deployments.from_business_group_id%type
537: ,p_start_date in date
538: ) is

Line 535: ,p_from_person_id in hr_person_deployments.from_person_id%type

531: -- ---------------------------------------------------------------------------
532: Procedure chk_from_person_id
533: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type
534: ,p_object_version_number in hr_person_deployments.object_version_number%type
535: ,p_from_person_id in hr_person_deployments.from_person_id%type
536: ,p_from_business_group_id in hr_person_deployments.from_business_group_id%type
537: ,p_start_date in date
538: ) is
539: --

Line 536: ,p_from_business_group_id in hr_person_deployments.from_business_group_id%type

532: Procedure chk_from_person_id
533: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type
534: ,p_object_version_number in hr_person_deployments.object_version_number%type
535: ,p_from_person_id in hr_person_deployments.from_person_id%type
536: ,p_from_business_group_id in hr_person_deployments.from_business_group_id%type
537: ,p_start_date in date
538: ) is
539: --
540: l_proc varchar2(72) := g_package||'chk_from_person_id';

Line 580: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_BUSINESS_GROUP_ID'

576: ,p_argument_value => p_start_date
577: );
578: --
579: if hr_multi_message.no_exclusive_error
580: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_BUSINESS_GROUP_ID'
581: ) then
582: --
583: l_api_updating := hr_pdt_shd.api_updating
584: (p_person_deployment_id => p_person_deployment_id

Line 614: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID'

610: --
611: exception
612: when app_exception.application_exception then
613: if hr_multi_message.exception_add
614: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID'
615: ) then
616: hr_utility.set_location(' Leaving:'||l_proc, 50);
617: raise;
618: end if;

Line 654: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type

650: -- {End of Comments}
651: --
652: -- ---------------------------------------------------------------------------
653: Procedure chk_to_person_id
654: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type
655: ,p_object_version_number in hr_person_deployments.object_version_number%type
656: ,p_to_person_id in hr_person_deployments.to_person_id%type
657: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
658: ,p_start_date in date

Line 655: ,p_object_version_number in hr_person_deployments.object_version_number%type

651: --
652: -- ---------------------------------------------------------------------------
653: Procedure chk_to_person_id
654: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type
655: ,p_object_version_number in hr_person_deployments.object_version_number%type
656: ,p_to_person_id in hr_person_deployments.to_person_id%type
657: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
658: ,p_start_date in date
659: ,p_status in hr_person_deployments.status%type

Line 656: ,p_to_person_id in hr_person_deployments.to_person_id%type

652: -- ---------------------------------------------------------------------------
653: Procedure chk_to_person_id
654: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type
655: ,p_object_version_number in hr_person_deployments.object_version_number%type
656: ,p_to_person_id in hr_person_deployments.to_person_id%type
657: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
658: ,p_start_date in date
659: ,p_status in hr_person_deployments.status%type
660: ) is

Line 657: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

653: Procedure chk_to_person_id
654: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type
655: ,p_object_version_number in hr_person_deployments.object_version_number%type
656: ,p_to_person_id in hr_person_deployments.to_person_id%type
657: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
658: ,p_start_date in date
659: ,p_status in hr_person_deployments.status%type
660: ) is
661: --

Line 659: ,p_status in hr_person_deployments.status%type

655: ,p_object_version_number in hr_person_deployments.object_version_number%type
656: ,p_to_person_id in hr_person_deployments.to_person_id%type
657: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
658: ,p_start_date in date
659: ,p_status in hr_person_deployments.status%type
660: ) is
661: --
662: l_proc varchar2(72) := g_package||'chk_to_person_id';
663: l_dummy number;

Line 723: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_BUSINESS_GROUP_ID'

719: ,p_argument_value => p_status
720: );
721: --
722: if hr_multi_message.no_exclusive_error
723: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_BUSINESS_GROUP_ID'
724: ) then
725: --
726: l_api_updating := hr_pdt_shd.api_updating
727: (p_person_deployment_id => p_person_deployment_id

Line 798: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.TO_PERSON_ID'

794: --
795: exception
796: when app_exception.application_exception then
797: if hr_multi_message.exception_add
798: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.TO_PERSON_ID'
799: ) then
800: hr_utility.set_location(' Leaving:'||l_proc, 50);
801: raise;
802: end if;

Line 835: (p_person_type_id in hr_person_deployments.person_type_id%type

831: -- {End of Comments}
832: --
833: -- ---------------------------------------------------------------------------
834: Procedure chk_person_type_id
835: (p_person_type_id in hr_person_deployments.person_type_id%type
836: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
837: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
838: ,p_object_version_number in hr_person_deployments.object_version_number%type
839: ) is

Line 836: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

832: --
833: -- ---------------------------------------------------------------------------
834: Procedure chk_person_type_id
835: (p_person_type_id in hr_person_deployments.person_type_id%type
836: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
837: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
838: ,p_object_version_number in hr_person_deployments.object_version_number%type
839: ) is
840: --

Line 837: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

833: -- ---------------------------------------------------------------------------
834: Procedure chk_person_type_id
835: (p_person_type_id in hr_person_deployments.person_type_id%type
836: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
837: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
838: ,p_object_version_number in hr_person_deployments.object_version_number%type
839: ) is
840: --
841: l_proc varchar2(72) := g_package||'chk_';

Line 838: ,p_object_version_number in hr_person_deployments.object_version_number%type

834: Procedure chk_person_type_id
835: (p_person_type_id in hr_person_deployments.person_type_id%type
836: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
837: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
838: ,p_object_version_number in hr_person_deployments.object_version_number%type
839: ) is
840: --
841: l_proc varchar2(72) := g_package||'chk_';
842: l_api_updating boolean;

Line 862: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

858: ,p_argument_value => p_to_business_group_id
859: );
860: --
861: if hr_multi_message.no_all_inclusive_error
862: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
863: ) then
864: --
865: l_api_updating := hr_pdt_shd.api_updating
866: (p_person_deployment_id => p_person_deployment_id

Line 906: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PERSON_TYPE_ID'

902: --
903: exception
904: when app_exception.application_exception then
905: if hr_multi_message.exception_add
906: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PERSON_TYPE_ID'
907: ) then
908: hr_utility.set_location(' Leaving:'||l_proc, 50);
909: raise;
910: end if;

Line 942: (p_start_date in hr_person_deployments.start_date%type

938: -- {End of Comments}
939: --
940: -- ---------------------------------------------------------------------------
941: Procedure chk_start_end_date
942: (p_start_date in hr_person_deployments.start_date%type
943: ,p_end_date in hr_person_deployments.end_date%type
944: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
945: ,p_object_version_number in hr_person_deployments.object_version_number%type
946: ,p_status in hr_person_deployments.status%type

Line 943: ,p_end_date in hr_person_deployments.end_date%type

939: --
940: -- ---------------------------------------------------------------------------
941: Procedure chk_start_end_date
942: (p_start_date in hr_person_deployments.start_date%type
943: ,p_end_date in hr_person_deployments.end_date%type
944: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
945: ,p_object_version_number in hr_person_deployments.object_version_number%type
946: ,p_status in hr_person_deployments.status%type
947: ) is

Line 944: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

940: -- ---------------------------------------------------------------------------
941: Procedure chk_start_end_date
942: (p_start_date in hr_person_deployments.start_date%type
943: ,p_end_date in hr_person_deployments.end_date%type
944: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
945: ,p_object_version_number in hr_person_deployments.object_version_number%type
946: ,p_status in hr_person_deployments.status%type
947: ) is
948: --

Line 945: ,p_object_version_number in hr_person_deployments.object_version_number%type

941: Procedure chk_start_end_date
942: (p_start_date in hr_person_deployments.start_date%type
943: ,p_end_date in hr_person_deployments.end_date%type
944: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
945: ,p_object_version_number in hr_person_deployments.object_version_number%type
946: ,p_status in hr_person_deployments.status%type
947: ) is
948: --
949: l_proc varchar2(72) := g_package||'chk_start_end_date';

Line 946: ,p_status in hr_person_deployments.status%type

942: (p_start_date in hr_person_deployments.start_date%type
943: ,p_end_date in hr_person_deployments.end_date%type
944: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
945: ,p_object_version_number in hr_person_deployments.object_version_number%type
946: ,p_status in hr_person_deployments.status%type
947: ) is
948: --
949: l_proc varchar2(72) := g_package||'chk_start_end_date';
950: l_api_updating boolean;

Line 962: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

958: ,p_argument_value => p_start_date
959: );
960: --
961: if hr_multi_message.no_all_inclusive_error
962: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
963: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.END_DATE'
964: ) then
965: --
966: l_api_updating := hr_pdt_shd.api_updating

Line 963: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.END_DATE'

959: );
960: --
961: if hr_multi_message.no_all_inclusive_error
962: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
963: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.END_DATE'
964: ) then
965: --
966: l_api_updating := hr_pdt_shd.api_updating
967: (p_person_deployment_id => p_person_deployment_id

Line 1011: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

1007: --
1008: exception
1009: when app_exception.application_exception then
1010: if hr_multi_message.exception_add
1011: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1012: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.END_DATE'
1013: ) then
1014: hr_utility.set_location(' Leaving:'||l_proc, 50);
1015: raise;

Line 1012: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.END_DATE'

1008: exception
1009: when app_exception.application_exception then
1010: if hr_multi_message.exception_add
1011: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1012: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.END_DATE'
1013: ) then
1014: hr_utility.set_location(' Leaving:'||l_proc, 50);
1015: raise;
1016: end if;

Line 1050: (p_person_id in HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID%type

1046: -- {End of Comments}
1047: --
1048: -- ---------------------------------------------------------------------------
1049: FUNCTION chk_start_date
1050: (p_person_id in HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID%type
1051: ,p_start_date in HR_PERSON_DEPLOYMENTS.START_DATE%type
1052: ) RETURN VARCHAR2
1053: is
1054:

Line 1051: ,p_start_date in HR_PERSON_DEPLOYMENTS.START_DATE%type

1047: --
1048: -- ---------------------------------------------------------------------------
1049: FUNCTION chk_start_date
1050: (p_person_id in HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID%type
1051: ,p_start_date in HR_PERSON_DEPLOYMENTS.START_DATE%type
1052: ) RETURN VARCHAR2
1053: is
1054:
1055: -- Declare Cursor

Line 1118: (p_permanent in hr_person_deployments.permanent%type

1114: -- {End of Comments}
1115: --
1116: -- ---------------------------------------------------------------------------
1117: Procedure chk_permanent
1118: (p_permanent in hr_person_deployments.permanent%type
1119: ,p_from_person_id in hr_person_deployments.from_person_id%type
1120: ,p_end_date in hr_person_deployments.end_date%type
1121: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1122: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 1119: ,p_from_person_id in hr_person_deployments.from_person_id%type

1115: --
1116: -- ---------------------------------------------------------------------------
1117: Procedure chk_permanent
1118: (p_permanent in hr_person_deployments.permanent%type
1119: ,p_from_person_id in hr_person_deployments.from_person_id%type
1120: ,p_end_date in hr_person_deployments.end_date%type
1121: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1122: ,p_object_version_number in hr_person_deployments.object_version_number%type
1123: ) is

Line 1120: ,p_end_date in hr_person_deployments.end_date%type

1116: -- ---------------------------------------------------------------------------
1117: Procedure chk_permanent
1118: (p_permanent in hr_person_deployments.permanent%type
1119: ,p_from_person_id in hr_person_deployments.from_person_id%type
1120: ,p_end_date in hr_person_deployments.end_date%type
1121: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1122: ,p_object_version_number in hr_person_deployments.object_version_number%type
1123: ) is
1124: --

Line 1121: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

1117: Procedure chk_permanent
1118: (p_permanent in hr_person_deployments.permanent%type
1119: ,p_from_person_id in hr_person_deployments.from_person_id%type
1120: ,p_end_date in hr_person_deployments.end_date%type
1121: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1122: ,p_object_version_number in hr_person_deployments.object_version_number%type
1123: ) is
1124: --
1125: l_proc varchar2(72) := g_package||'chk_permanent';

Line 1122: ,p_object_version_number in hr_person_deployments.object_version_number%type

1118: (p_permanent in hr_person_deployments.permanent%type
1119: ,p_from_person_id in hr_person_deployments.from_person_id%type
1120: ,p_end_date in hr_person_deployments.end_date%type
1121: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1122: ,p_object_version_number in hr_person_deployments.object_version_number%type
1123: ) is
1124: --
1125: l_proc varchar2(72) := g_package||'chk_permanent';
1126: l_api_updating boolean;

Line 1145: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.END_DATE'

1141: ,p_argument_value => p_from_person_id
1142: );
1143: --
1144: if hr_multi_message.no_exclusive_error
1145: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.END_DATE'
1146: ) then
1147: --
1148: l_api_updating := hr_pdt_shd.api_updating
1149: (p_person_deployment_id => p_person_deployment_id

Line 1185: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PERMANENT'

1181: --
1182: exception
1183: when app_exception.application_exception then
1184: if hr_multi_message.exception_add
1185: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PERMANENT'
1186: ) then
1187: hr_utility.set_location(' Leaving:'||l_proc, 50);
1188: raise;
1189: end if;

Line 1224: (p_deployment_reason in hr_person_deployments.deployment_reason%type

1220: -- {End of Comments}
1221: --
1222: -- ---------------------------------------------------------------------------
1223: Procedure chk_deployment_reason
1224: (p_deployment_reason in hr_person_deployments.deployment_reason%type
1225: ,p_start_date in hr_person_deployments.start_date%type
1226: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1227: ,p_object_version_number in hr_person_deployments.object_version_number%type
1228: ) is

Line 1225: ,p_start_date in hr_person_deployments.start_date%type

1221: --
1222: -- ---------------------------------------------------------------------------
1223: Procedure chk_deployment_reason
1224: (p_deployment_reason in hr_person_deployments.deployment_reason%type
1225: ,p_start_date in hr_person_deployments.start_date%type
1226: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1227: ,p_object_version_number in hr_person_deployments.object_version_number%type
1228: ) is
1229: --

Line 1226: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

1222: -- ---------------------------------------------------------------------------
1223: Procedure chk_deployment_reason
1224: (p_deployment_reason in hr_person_deployments.deployment_reason%type
1225: ,p_start_date in hr_person_deployments.start_date%type
1226: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1227: ,p_object_version_number in hr_person_deployments.object_version_number%type
1228: ) is
1229: --
1230: l_proc varchar2(72) := g_package||'chk_deployment_reason';

Line 1227: ,p_object_version_number in hr_person_deployments.object_version_number%type

1223: Procedure chk_deployment_reason
1224: (p_deployment_reason in hr_person_deployments.deployment_reason%type
1225: ,p_start_date in hr_person_deployments.start_date%type
1226: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1227: ,p_object_version_number in hr_person_deployments.object_version_number%type
1228: ) is
1229: --
1230: l_proc varchar2(72) := g_package||'chk_deployment_reason';
1231: l_api_updating boolean;

Line 1243: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

1239: ,p_argument_value => p_start_date
1240: );
1241: --
1242: if hr_multi_message.no_exclusive_error
1243: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1244: ) then
1245: --
1246: l_api_updating := hr_pdt_shd.api_updating
1247: (p_person_deployment_id => p_person_deployment_id

Line 1274: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.DEPLOYMENT_REASON'

1270: --
1271: exception
1272: when app_exception.application_exception then
1273: if hr_multi_message.exception_add
1274: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.DEPLOYMENT_REASON'
1275: ) then
1276: hr_utility.set_location(' Leaving:'||l_proc, 50);
1277: raise;
1278: end if;

Line 1315: (p_employee_number in hr_person_deployments.employee_number%type

1311: -- {End of Comments}
1312: --
1313: -- ---------------------------------------------------------------------------
1314: Procedure chk_employee_number
1315: (p_employee_number in hr_person_deployments.employee_number%type
1316: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1317: ,p_to_person_id in hr_person_deployments.to_person_id%type
1318: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1319: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 1316: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

1312: --
1313: -- ---------------------------------------------------------------------------
1314: Procedure chk_employee_number
1315: (p_employee_number in hr_person_deployments.employee_number%type
1316: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1317: ,p_to_person_id in hr_person_deployments.to_person_id%type
1318: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1319: ,p_object_version_number in hr_person_deployments.object_version_number%type
1320: ) is

Line 1317: ,p_to_person_id in hr_person_deployments.to_person_id%type

1313: -- ---------------------------------------------------------------------------
1314: Procedure chk_employee_number
1315: (p_employee_number in hr_person_deployments.employee_number%type
1316: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1317: ,p_to_person_id in hr_person_deployments.to_person_id%type
1318: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1319: ,p_object_version_number in hr_person_deployments.object_version_number%type
1320: ) is
1321: --

Line 1318: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

1314: Procedure chk_employee_number
1315: (p_employee_number in hr_person_deployments.employee_number%type
1316: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1317: ,p_to_person_id in hr_person_deployments.to_person_id%type
1318: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1319: ,p_object_version_number in hr_person_deployments.object_version_number%type
1320: ) is
1321: --
1322: l_proc varchar2(72) := g_package||'chk_employee_number';

Line 1319: ,p_object_version_number in hr_person_deployments.object_version_number%type

1315: (p_employee_number in hr_person_deployments.employee_number%type
1316: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1317: ,p_to_person_id in hr_person_deployments.to_person_id%type
1318: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1319: ,p_object_version_number in hr_person_deployments.object_version_number%type
1320: ) is
1321: --
1322: l_proc varchar2(72) := g_package||'chk_employee_number';
1323: l_api_updating boolean;

Line 1357: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

1353: ,p_argument_value => p_to_business_group_id
1354: );
1355: --
1356: if hr_multi_message.no_all_inclusive_error
1357: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
1358: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_PERSON_ID'
1359: ) then
1360: --
1361: l_api_updating := hr_pdt_shd.api_updating

Line 1358: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_PERSON_ID'

1354: );
1355: --
1356: if hr_multi_message.no_all_inclusive_error
1357: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
1358: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_PERSON_ID'
1359: ) then
1360: --
1361: l_api_updating := hr_pdt_shd.api_updating
1362: (p_person_deployment_id => p_person_deployment_id

Line 1417: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.EMPLOYEE_NUMBER'

1413: --
1414: exception
1415: when app_exception.application_exception then
1416: if hr_multi_message.exception_add
1417: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.EMPLOYEE_NUMBER'
1418: ) then
1419: hr_utility.set_location(' Leaving:'||l_proc, 50);
1420: raise;
1421: end if;

Line 1458: (p_leaving_reason in hr_person_deployments.leaving_reason%type

1454: -- {End of Comments}
1455: --
1456: -- ---------------------------------------------------------------------------
1457: Procedure chk_leaving_reason
1458: (p_leaving_reason in hr_person_deployments.leaving_reason%type
1459: ,p_start_date in hr_person_deployments.start_date%type
1460: ,p_permanent in hr_person_deployments.permanent%type
1461: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1462: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 1459: ,p_start_date in hr_person_deployments.start_date%type

1455: --
1456: -- ---------------------------------------------------------------------------
1457: Procedure chk_leaving_reason
1458: (p_leaving_reason in hr_person_deployments.leaving_reason%type
1459: ,p_start_date in hr_person_deployments.start_date%type
1460: ,p_permanent in hr_person_deployments.permanent%type
1461: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1462: ,p_object_version_number in hr_person_deployments.object_version_number%type
1463: ) is

Line 1460: ,p_permanent in hr_person_deployments.permanent%type

1456: -- ---------------------------------------------------------------------------
1457: Procedure chk_leaving_reason
1458: (p_leaving_reason in hr_person_deployments.leaving_reason%type
1459: ,p_start_date in hr_person_deployments.start_date%type
1460: ,p_permanent in hr_person_deployments.permanent%type
1461: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1462: ,p_object_version_number in hr_person_deployments.object_version_number%type
1463: ) is
1464: --

Line 1461: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

1457: Procedure chk_leaving_reason
1458: (p_leaving_reason in hr_person_deployments.leaving_reason%type
1459: ,p_start_date in hr_person_deployments.start_date%type
1460: ,p_permanent in hr_person_deployments.permanent%type
1461: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1462: ,p_object_version_number in hr_person_deployments.object_version_number%type
1463: ) is
1464: --
1465: l_proc varchar2(72) := g_package||'chk_leaving_reason';

Line 1462: ,p_object_version_number in hr_person_deployments.object_version_number%type

1458: (p_leaving_reason in hr_person_deployments.leaving_reason%type
1459: ,p_start_date in hr_person_deployments.start_date%type
1460: ,p_permanent in hr_person_deployments.permanent%type
1461: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1462: ,p_object_version_number in hr_person_deployments.object_version_number%type
1463: ) is
1464: --
1465: l_proc varchar2(72) := g_package||'chk_leaving_reason';
1466: l_api_updating boolean;

Line 1478: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

1474: ,p_argument_value => p_start_date
1475: );
1476: --
1477: if hr_multi_message.no_exclusive_error
1478: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1479: ) then
1480: --
1481: l_api_updating := hr_pdt_shd.api_updating
1482: (p_person_deployment_id => p_person_deployment_id

Line 1513: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LEAVING_REASON'

1509: --
1510: exception
1511: when app_exception.application_exception then
1512: if hr_multi_message.exception_add
1513: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LEAVING_REASON'
1514: ) then
1515: hr_utility.set_location(' Leaving:'||l_proc, 50);
1516: raise;
1517: end if;

Line 1552: (p_leaving_person_type_id in hr_person_deployments.leaving_person_type_id%type

1548: -- {End of Comments}
1549: --
1550: -- ---------------------------------------------------------------------------
1551: Procedure chk_leaving_person_type_id
1552: (p_leaving_person_type_id in hr_person_deployments.leaving_person_type_id%type
1553: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1554: ,p_permanent in hr_person_deployments.permanent%type
1555: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1556: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 1553: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

1549: --
1550: -- ---------------------------------------------------------------------------
1551: Procedure chk_leaving_person_type_id
1552: (p_leaving_person_type_id in hr_person_deployments.leaving_person_type_id%type
1553: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1554: ,p_permanent in hr_person_deployments.permanent%type
1555: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1556: ,p_object_version_number in hr_person_deployments.object_version_number%type
1557: ) is

Line 1554: ,p_permanent in hr_person_deployments.permanent%type

1550: -- ---------------------------------------------------------------------------
1551: Procedure chk_leaving_person_type_id
1552: (p_leaving_person_type_id in hr_person_deployments.leaving_person_type_id%type
1553: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1554: ,p_permanent in hr_person_deployments.permanent%type
1555: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1556: ,p_object_version_number in hr_person_deployments.object_version_number%type
1557: ) is
1558: --

Line 1555: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

1551: Procedure chk_leaving_person_type_id
1552: (p_leaving_person_type_id in hr_person_deployments.leaving_person_type_id%type
1553: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1554: ,p_permanent in hr_person_deployments.permanent%type
1555: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1556: ,p_object_version_number in hr_person_deployments.object_version_number%type
1557: ) is
1558: --
1559: l_proc varchar2(72) := g_package||'chk_';

Line 1556: ,p_object_version_number in hr_person_deployments.object_version_number%type

1552: (p_leaving_person_type_id in hr_person_deployments.leaving_person_type_id%type
1553: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1554: ,p_permanent in hr_person_deployments.permanent%type
1555: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1556: ,p_object_version_number in hr_person_deployments.object_version_number%type
1557: ) is
1558: --
1559: l_proc varchar2(72) := g_package||'chk_';
1560: l_api_updating boolean;

Line 1580: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

1576: ,p_argument_value => p_to_business_group_id
1577: );
1578: --
1579: if hr_multi_message.no_all_inclusive_error
1580: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
1581: ) then
1582: --
1583: l_api_updating := hr_pdt_shd.api_updating
1584: (p_person_deployment_id => p_person_deployment_id

Line 1629: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LEAVING_PERSON_TYPE_ID'

1625: --
1626: exception
1627: when app_exception.application_exception then
1628: if hr_multi_message.exception_add
1629: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LEAVING_PERSON_TYPE_ID'
1630: ) then
1631: hr_utility.set_location(' Leaving:'||l_proc, 50);
1632: raise;
1633: end if;

Line 1668: (p_status in hr_person_deployments.status%type

1664: -- {End of Comments}
1665: --
1666: -- ---------------------------------------------------------------------------
1667: Procedure chk_status
1668: (p_status in hr_person_deployments.status%type
1669: ,p_start_date in hr_person_deployments.start_date%type
1670: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1671: ,p_object_version_number in hr_person_deployments.object_version_number%type
1672: ) is

Line 1669: ,p_start_date in hr_person_deployments.start_date%type

1665: --
1666: -- ---------------------------------------------------------------------------
1667: Procedure chk_status
1668: (p_status in hr_person_deployments.status%type
1669: ,p_start_date in hr_person_deployments.start_date%type
1670: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1671: ,p_object_version_number in hr_person_deployments.object_version_number%type
1672: ) is
1673: --

Line 1670: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

1666: -- ---------------------------------------------------------------------------
1667: Procedure chk_status
1668: (p_status in hr_person_deployments.status%type
1669: ,p_start_date in hr_person_deployments.start_date%type
1670: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1671: ,p_object_version_number in hr_person_deployments.object_version_number%type
1672: ) is
1673: --
1674: l_proc varchar2(72) := g_package||'chk_status';

Line 1671: ,p_object_version_number in hr_person_deployments.object_version_number%type

1667: Procedure chk_status
1668: (p_status in hr_person_deployments.status%type
1669: ,p_start_date in hr_person_deployments.start_date%type
1670: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1671: ,p_object_version_number in hr_person_deployments.object_version_number%type
1672: ) is
1673: --
1674: l_proc varchar2(72) := g_package||'chk_status';
1675: l_api_updating boolean;

Line 1693: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.STATUS'

1689: ,p_argument_value => p_start_date
1690: );
1691: --
1692: if hr_multi_message.no_all_inclusive_error
1693: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.STATUS'
1694: ) then
1695: --
1696: l_api_updating := hr_pdt_shd.api_updating
1697: (p_person_deployment_id => p_person_deployment_id

Line 1726: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.STATUS'

1722: --
1723: exception
1724: when app_exception.application_exception then
1725: if hr_multi_message.exception_add
1726: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.STATUS'
1727: ) then
1728: hr_utility.set_location(' Leaving:'||l_proc, 50);
1729: raise;
1730: end if;

Line 1762: (p_deplymt_policy_id in hr_person_deployments.deplymt_policy_id%type

1758: -- {End of Comments}
1759: --
1760: -- ---------------------------------------------------------------------------
1761: Procedure chk_deplymt_policy_id
1762: (p_deplymt_policy_id in hr_person_deployments.deplymt_policy_id%type
1763: ) is
1764: --
1765: l_proc varchar2(72) := g_package||'chk_deplymt_policy_id';
1766: l_api_updating boolean;

Line 1781: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.DEPLYMT_POLICY_ID'

1777: --
1778: exception
1779: when app_exception.application_exception then
1780: if hr_multi_message.exception_add
1781: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.DEPLYMT_POLICY_ID'
1782: ) then
1783: hr_utility.set_location(' Leaving:'||l_proc, 50);
1784: raise;
1785: end if;

Line 1821: (p_retain_direct_reports in hr_person_deployments.retain_direct_reports%type

1817: -- {End of Comments}
1818: --
1819: -- ---------------------------------------------------------------------------
1820: Procedure chk_retain_direct_reports
1821: (p_retain_direct_reports in hr_person_deployments.retain_direct_reports%type
1822: ,p_from_person_id in hr_person_deployments.from_person_id%type
1823: ,p_start_date in hr_person_deployments.start_date%type
1824: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1825: ,p_from_business_group_id in hr_person_deployments.to_business_group_id%type

Line 1822: ,p_from_person_id in hr_person_deployments.from_person_id%type

1818: --
1819: -- ---------------------------------------------------------------------------
1820: Procedure chk_retain_direct_reports
1821: (p_retain_direct_reports in hr_person_deployments.retain_direct_reports%type
1822: ,p_from_person_id in hr_person_deployments.from_person_id%type
1823: ,p_start_date in hr_person_deployments.start_date%type
1824: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1825: ,p_from_business_group_id in hr_person_deployments.to_business_group_id%type
1826: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

Line 1823: ,p_start_date in hr_person_deployments.start_date%type

1819: -- ---------------------------------------------------------------------------
1820: Procedure chk_retain_direct_reports
1821: (p_retain_direct_reports in hr_person_deployments.retain_direct_reports%type
1822: ,p_from_person_id in hr_person_deployments.from_person_id%type
1823: ,p_start_date in hr_person_deployments.start_date%type
1824: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1825: ,p_from_business_group_id in hr_person_deployments.to_business_group_id%type
1826: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1827: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 1824: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

1820: Procedure chk_retain_direct_reports
1821: (p_retain_direct_reports in hr_person_deployments.retain_direct_reports%type
1822: ,p_from_person_id in hr_person_deployments.from_person_id%type
1823: ,p_start_date in hr_person_deployments.start_date%type
1824: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1825: ,p_from_business_group_id in hr_person_deployments.to_business_group_id%type
1826: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1827: ,p_object_version_number in hr_person_deployments.object_version_number%type
1828: ) is

Line 1825: ,p_from_business_group_id in hr_person_deployments.to_business_group_id%type

1821: (p_retain_direct_reports in hr_person_deployments.retain_direct_reports%type
1822: ,p_from_person_id in hr_person_deployments.from_person_id%type
1823: ,p_start_date in hr_person_deployments.start_date%type
1824: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1825: ,p_from_business_group_id in hr_person_deployments.to_business_group_id%type
1826: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1827: ,p_object_version_number in hr_person_deployments.object_version_number%type
1828: ) is
1829: --

Line 1826: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

1822: ,p_from_person_id in hr_person_deployments.from_person_id%type
1823: ,p_start_date in hr_person_deployments.start_date%type
1824: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1825: ,p_from_business_group_id in hr_person_deployments.to_business_group_id%type
1826: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1827: ,p_object_version_number in hr_person_deployments.object_version_number%type
1828: ) is
1829: --
1830: l_proc varchar2(72) := g_package||'chk_retain_direct_reports';

Line 1827: ,p_object_version_number in hr_person_deployments.object_version_number%type

1823: ,p_start_date in hr_person_deployments.start_date%type
1824: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1825: ,p_from_business_group_id in hr_person_deployments.to_business_group_id%type
1826: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1827: ,p_object_version_number in hr_person_deployments.object_version_number%type
1828: ) is
1829: --
1830: l_proc varchar2(72) := g_package||'chk_retain_direct_reports';
1831: l_api_updating boolean;

Line 1856: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID'

1852: ,p_argument_value => p_start_date
1853: );
1854: --
1855: if hr_multi_message.no_exclusive_error
1856: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID'
1857: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1858: ) then
1859: --
1860: l_api_updating := hr_pdt_shd.api_updating

Line 1857: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

1853: );
1854: --
1855: if hr_multi_message.no_exclusive_error
1856: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.FROM_PERSON_ID'
1857: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
1858: ) then
1859: --
1860: l_api_updating := hr_pdt_shd.api_updating
1861: (p_person_deployment_id => p_person_deployment_id

Line 1890: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.RETAIN_DIRECT_REPORTS'

1886: --
1887: exception
1888: when app_exception.application_exception then
1889: if hr_multi_message.exception_add
1890: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.RETAIN_DIRECT_REPORTS'
1891: ) then
1892: hr_utility.set_location(' Leaving:'||l_proc, 50);
1893: raise;
1894: end if;

Line 1926: (p_organization_id in hr_person_deployments.organization_id%type

1922: -- {End of Comments}
1923: --
1924: -- ---------------------------------------------------------------------------
1925: Procedure chk_organization_id
1926: (p_organization_id in hr_person_deployments.organization_id%type
1927: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1928: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1929: ,p_object_version_number in hr_person_deployments.object_version_number%type
1930: ) is

Line 1927: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

1923: --
1924: -- ---------------------------------------------------------------------------
1925: Procedure chk_organization_id
1926: (p_organization_id in hr_person_deployments.organization_id%type
1927: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1928: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1929: ,p_object_version_number in hr_person_deployments.object_version_number%type
1930: ) is
1931: --

Line 1928: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

1924: -- ---------------------------------------------------------------------------
1925: Procedure chk_organization_id
1926: (p_organization_id in hr_person_deployments.organization_id%type
1927: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1928: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1929: ,p_object_version_number in hr_person_deployments.object_version_number%type
1930: ) is
1931: --
1932: l_proc varchar2(72) := g_package||'chk_organization_id';

Line 1929: ,p_object_version_number in hr_person_deployments.object_version_number%type

1925: Procedure chk_organization_id
1926: (p_organization_id in hr_person_deployments.organization_id%type
1927: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
1928: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
1929: ,p_object_version_number in hr_person_deployments.object_version_number%type
1930: ) is
1931: --
1932: l_proc varchar2(72) := g_package||'chk_organization_id';
1933: l_api_updating boolean;

Line 2003: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'

1999: --
2000: exception
2001: when app_exception.application_exception then
2002: if hr_multi_message.exception_add
2003: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'
2004: ) then
2005: hr_utility.set_location(' Leaving:'||l_proc, 50);
2006: raise;
2007: end if;

Line 2040: (p_location_id in hr_person_deployments.location_id%type

2036: -- {End of Comments}
2037: --
2038: -- ---------------------------------------------------------------------------
2039: Procedure chk_location_id
2040: (p_location_id in hr_person_deployments.location_id%type
2041: ,p_start_date in hr_person_deployments.start_date%type
2042: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2043: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2044: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 2041: ,p_start_date in hr_person_deployments.start_date%type

2037: --
2038: -- ---------------------------------------------------------------------------
2039: Procedure chk_location_id
2040: (p_location_id in hr_person_deployments.location_id%type
2041: ,p_start_date in hr_person_deployments.start_date%type
2042: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2043: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2044: ,p_object_version_number in hr_person_deployments.object_version_number%type
2045: ) is

Line 2042: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

2038: -- ---------------------------------------------------------------------------
2039: Procedure chk_location_id
2040: (p_location_id in hr_person_deployments.location_id%type
2041: ,p_start_date in hr_person_deployments.start_date%type
2042: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2043: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2044: ,p_object_version_number in hr_person_deployments.object_version_number%type
2045: ) is
2046: --

Line 2043: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

2039: Procedure chk_location_id
2040: (p_location_id in hr_person_deployments.location_id%type
2041: ,p_start_date in hr_person_deployments.start_date%type
2042: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2043: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2044: ,p_object_version_number in hr_person_deployments.object_version_number%type
2045: ) is
2046: --
2047: l_proc varchar2(72) := g_package||'chk_location_id';

Line 2044: ,p_object_version_number in hr_person_deployments.object_version_number%type

2040: (p_location_id in hr_person_deployments.location_id%type
2041: ,p_start_date in hr_person_deployments.start_date%type
2042: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2043: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2044: ,p_object_version_number in hr_person_deployments.object_version_number%type
2045: ) is
2046: --
2047: l_proc varchar2(72) := g_package||'chk_location_id';
2048: l_api_updating boolean;

Line 2073: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

2069: ,p_argument_value => p_to_business_group_id
2070: );
2071: --
2072: if hr_multi_message.no_all_inclusive_error
2073: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2074: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2075: ) then
2076: --
2077: l_api_updating := hr_pdt_shd.api_updating

Line 2074: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

2070: );
2071: --
2072: if hr_multi_message.no_all_inclusive_error
2073: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2074: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2075: ) then
2076: --
2077: l_api_updating := hr_pdt_shd.api_updating
2078: (p_person_deployment_id => p_person_deployment_id

Line 2111: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LOCATION_ID'

2107: --
2108: exception
2109: when app_exception.application_exception then
2110: if hr_multi_message.exception_add
2111: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LOCATION_ID'
2112: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2113: ) then
2114: hr_utility.set_location(' Leaving:'||l_proc, 50);
2115: raise;

Line 2112: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

2108: exception
2109: when app_exception.application_exception then
2110: if hr_multi_message.exception_add
2111: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.LOCATION_ID'
2112: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2113: ) then
2114: hr_utility.set_location(' Leaving:'||l_proc, 50);
2115: raise;
2116: end if;

Line 2150: (p_job_id in hr_person_deployments.job_id%type

2146: -- {End of Comments}
2147: --
2148: -- ---------------------------------------------------------------------------
2149: Procedure chk_job_id
2150: (p_job_id in hr_person_deployments.job_id%type
2151: ,p_start_date in hr_person_deployments.start_date%type
2152: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2153: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2154: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 2151: ,p_start_date in hr_person_deployments.start_date%type

2147: --
2148: -- ---------------------------------------------------------------------------
2149: Procedure chk_job_id
2150: (p_job_id in hr_person_deployments.job_id%type
2151: ,p_start_date in hr_person_deployments.start_date%type
2152: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2153: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2154: ,p_object_version_number in hr_person_deployments.object_version_number%type
2155: ) is

Line 2152: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

2148: -- ---------------------------------------------------------------------------
2149: Procedure chk_job_id
2150: (p_job_id in hr_person_deployments.job_id%type
2151: ,p_start_date in hr_person_deployments.start_date%type
2152: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2153: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2154: ,p_object_version_number in hr_person_deployments.object_version_number%type
2155: ) is
2156: --

Line 2153: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

2149: Procedure chk_job_id
2150: (p_job_id in hr_person_deployments.job_id%type
2151: ,p_start_date in hr_person_deployments.start_date%type
2152: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2153: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2154: ,p_object_version_number in hr_person_deployments.object_version_number%type
2155: ) is
2156: --
2157: l_proc varchar2(72) := g_package||'chk_job_id';

Line 2154: ,p_object_version_number in hr_person_deployments.object_version_number%type

2150: (p_job_id in hr_person_deployments.job_id%type
2151: ,p_start_date in hr_person_deployments.start_date%type
2152: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2153: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2154: ,p_object_version_number in hr_person_deployments.object_version_number%type
2155: ) is
2156: --
2157: l_proc varchar2(72) := g_package||'chk_job_id';
2158: l_api_updating boolean;

Line 2189: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

2185: ,p_argument_value => p_to_business_group_id
2186: );
2187: --
2188: if hr_multi_message.no_all_inclusive_error
2189: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2190: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2191: ) then
2192: --
2193: l_api_updating := hr_pdt_shd.api_updating

Line 2190: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

2186: );
2187: --
2188: if hr_multi_message.no_all_inclusive_error
2189: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2190: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2191: ) then
2192: --
2193: l_api_updating := hr_pdt_shd.api_updating
2194: (p_person_deployment_id => p_person_deployment_id

Line 2222: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'

2218: --
2219: exception
2220: when app_exception.application_exception then
2221: if hr_multi_message.exception_add
2222: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2223: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2224: ) then
2225: hr_utility.set_location(' Leaving:'||l_proc, 50);
2226: raise;

Line 2223: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

2219: exception
2220: when app_exception.application_exception then
2221: if hr_multi_message.exception_add
2222: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2223: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2224: ) then
2225: hr_utility.set_location(' Leaving:'||l_proc, 50);
2226: raise;
2227: end if;

Line 2261: (p_position_id in hr_person_deployments.position_id%type

2257: -- {End of Comments}
2258: --
2259: -- ---------------------------------------------------------------------------
2260: Procedure chk_position_id
2261: (p_position_id in hr_person_deployments.position_id%type
2262: ,p_start_date in hr_person_deployments.start_date%type
2263: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2264: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2265: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 2262: ,p_start_date in hr_person_deployments.start_date%type

2258: --
2259: -- ---------------------------------------------------------------------------
2260: Procedure chk_position_id
2261: (p_position_id in hr_person_deployments.position_id%type
2262: ,p_start_date in hr_person_deployments.start_date%type
2263: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2264: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2265: ,p_object_version_number in hr_person_deployments.object_version_number%type
2266: ) is

Line 2263: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

2259: -- ---------------------------------------------------------------------------
2260: Procedure chk_position_id
2261: (p_position_id in hr_person_deployments.position_id%type
2262: ,p_start_date in hr_person_deployments.start_date%type
2263: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2264: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2265: ,p_object_version_number in hr_person_deployments.object_version_number%type
2266: ) is
2267: --

Line 2264: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

2260: Procedure chk_position_id
2261: (p_position_id in hr_person_deployments.position_id%type
2262: ,p_start_date in hr_person_deployments.start_date%type
2263: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2264: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2265: ,p_object_version_number in hr_person_deployments.object_version_number%type
2266: ) is
2267: --
2268: l_proc varchar2(72) := g_package||'chk_position_id';

Line 2265: ,p_object_version_number in hr_person_deployments.object_version_number%type

2261: (p_position_id in hr_person_deployments.position_id%type
2262: ,p_start_date in hr_person_deployments.start_date%type
2263: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2264: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2265: ,p_object_version_number in hr_person_deployments.object_version_number%type
2266: ) is
2267: --
2268: l_proc varchar2(72) := g_package||'chk_position_id';
2269: l_api_updating boolean;

Line 2301: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

2297: ,p_argument_value => p_to_business_group_id
2298: );
2299: --
2300: if hr_multi_message.no_all_inclusive_error
2301: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2302: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2303: ) then
2304: --
2305: l_api_updating := hr_pdt_shd.api_updating

Line 2302: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

2298: );
2299: --
2300: if hr_multi_message.no_all_inclusive_error
2301: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2302: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2303: ) then
2304: --
2305: l_api_updating := hr_pdt_shd.api_updating
2306: (p_person_deployment_id => p_person_deployment_id

Line 2334: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'

2330: --
2331: exception
2332: when app_exception.application_exception then
2333: if hr_multi_message.exception_add
2334: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2335: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2336: ) then
2337: hr_utility.set_location(' Leaving:'||l_proc, 50);
2338: raise;

Line 2335: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

2331: exception
2332: when app_exception.application_exception then
2333: if hr_multi_message.exception_add
2334: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2335: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2336: ) then
2337: hr_utility.set_location(' Leaving:'||l_proc, 50);
2338: raise;
2339: end if;

Line 2373: (p_grade_id in hr_person_deployments.grade_id%type

2369: -- {End of Comments}
2370: --
2371: -- ---------------------------------------------------------------------------
2372: Procedure chk_grade_id
2373: (p_grade_id in hr_person_deployments.grade_id%type
2374: ,p_start_date in hr_person_deployments.start_date%type
2375: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2376: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2377: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 2374: ,p_start_date in hr_person_deployments.start_date%type

2370: --
2371: -- ---------------------------------------------------------------------------
2372: Procedure chk_grade_id
2373: (p_grade_id in hr_person_deployments.grade_id%type
2374: ,p_start_date in hr_person_deployments.start_date%type
2375: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2376: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2377: ,p_object_version_number in hr_person_deployments.object_version_number%type
2378: ) is

Line 2375: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

2371: -- ---------------------------------------------------------------------------
2372: Procedure chk_grade_id
2373: (p_grade_id in hr_person_deployments.grade_id%type
2374: ,p_start_date in hr_person_deployments.start_date%type
2375: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2376: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2377: ,p_object_version_number in hr_person_deployments.object_version_number%type
2378: ) is
2379: --

Line 2376: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

2372: Procedure chk_grade_id
2373: (p_grade_id in hr_person_deployments.grade_id%type
2374: ,p_start_date in hr_person_deployments.start_date%type
2375: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2376: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2377: ,p_object_version_number in hr_person_deployments.object_version_number%type
2378: ) is
2379: --
2380: l_proc varchar2(72) := g_package||'chk_grade_id';

Line 2377: ,p_object_version_number in hr_person_deployments.object_version_number%type

2373: (p_grade_id in hr_person_deployments.grade_id%type
2374: ,p_start_date in hr_person_deployments.start_date%type
2375: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2376: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2377: ,p_object_version_number in hr_person_deployments.object_version_number%type
2378: ) is
2379: --
2380: l_proc varchar2(72) := g_package||'chk_grade_id';
2381: l_api_updating boolean;

Line 2408: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

2404: ,p_argument_value => p_to_business_group_id
2405: );
2406: --
2407: if hr_multi_message.no_all_inclusive_error
2408: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2409: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2410: ) then
2411: --
2412: l_api_updating := hr_pdt_shd.api_updating

Line 2409: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

2405: );
2406: --
2407: if hr_multi_message.no_all_inclusive_error
2408: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2409: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2410: ) then
2411: --
2412: l_api_updating := hr_pdt_shd.api_updating
2413: (p_person_deployment_id => p_person_deployment_id

Line 2441: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'

2437: --
2438: exception
2439: when app_exception.application_exception then
2440: if hr_multi_message.exception_add
2441: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2442: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2443: ) then
2444: hr_utility.set_location(' Leaving:'||l_proc, 50);
2445: raise;

Line 2442: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

2438: exception
2439: when app_exception.application_exception then
2440: if hr_multi_message.exception_add
2441: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2442: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2443: ) then
2444: hr_utility.set_location(' Leaving:'||l_proc, 50);
2445: raise;
2446: end if;

Line 2479: (p_position_id in hr_person_deployments.position_id%type

2475: -- {End of Comments}
2476: --
2477: -- ---------------------------------------------------------------------------
2478: Procedure chk_position_id_job_id
2479: (p_position_id in hr_person_deployments.position_id%type
2480: ,p_job_id in hr_person_deployments.job_id%type
2481: ,p_start_date in hr_person_deployments.start_date%type
2482: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2483: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 2480: ,p_job_id in hr_person_deployments.job_id%type

2476: --
2477: -- ---------------------------------------------------------------------------
2478: Procedure chk_position_id_job_id
2479: (p_position_id in hr_person_deployments.position_id%type
2480: ,p_job_id in hr_person_deployments.job_id%type
2481: ,p_start_date in hr_person_deployments.start_date%type
2482: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2483: ,p_object_version_number in hr_person_deployments.object_version_number%type
2484: ) is

Line 2481: ,p_start_date in hr_person_deployments.start_date%type

2477: -- ---------------------------------------------------------------------------
2478: Procedure chk_position_id_job_id
2479: (p_position_id in hr_person_deployments.position_id%type
2480: ,p_job_id in hr_person_deployments.job_id%type
2481: ,p_start_date in hr_person_deployments.start_date%type
2482: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2483: ,p_object_version_number in hr_person_deployments.object_version_number%type
2484: ) is
2485: --

Line 2482: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

2478: Procedure chk_position_id_job_id
2479: (p_position_id in hr_person_deployments.position_id%type
2480: ,p_job_id in hr_person_deployments.job_id%type
2481: ,p_start_date in hr_person_deployments.start_date%type
2482: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2483: ,p_object_version_number in hr_person_deployments.object_version_number%type
2484: ) is
2485: --
2486: l_proc varchar2(72) := g_package||'chk_position_id_job_id';

Line 2483: ,p_object_version_number in hr_person_deployments.object_version_number%type

2479: (p_position_id in hr_person_deployments.position_id%type
2480: ,p_job_id in hr_person_deployments.job_id%type
2481: ,p_start_date in hr_person_deployments.start_date%type
2482: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2483: ,p_object_version_number in hr_person_deployments.object_version_number%type
2484: ) is
2485: --
2486: l_proc varchar2(72) := g_package||'chk_position_id_job_id';
2487: l_api_updating boolean;

Line 2513: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'

2509: ,p_argument_value => p_start_date
2510: );
2511: --
2512: if hr_multi_message.no_exclusive_error
2513: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2514: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2515: ) then
2516: --
2517: l_api_updating := hr_pdt_shd.api_updating

Line 2514: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'

2510: );
2511: --
2512: if hr_multi_message.no_exclusive_error
2513: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2514: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2515: ) then
2516: --
2517: l_api_updating := hr_pdt_shd.api_updating
2518: (p_person_deployment_id => p_person_deployment_id

Line 2548: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'

2544: --
2545: exception
2546: when app_exception.application_exception then
2547: if hr_multi_message.exception_add
2548: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2549: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2550: ) then
2551: hr_utility.set_location(' Leaving:'||l_proc, 50);
2552: raise;

Line 2549: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'

2545: exception
2546: when app_exception.application_exception then
2547: if hr_multi_message.exception_add
2548: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2549: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2550: ) then
2551: hr_utility.set_location(' Leaving:'||l_proc, 50);
2552: raise;
2553: end if;

Line 2584: (p_position_id in hr_person_deployments.position_id%type

2580: -- {End of Comments}
2581: --
2582: -- ---------------------------------------------------------------------------
2583: Procedure chk_position_id_grade_id
2584: (p_position_id in hr_person_deployments.position_id%type
2585: ,p_grade_id in hr_person_deployments.grade_id%type
2586: ,p_start_date in hr_person_deployments.start_date%type
2587: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2588: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 2585: ,p_grade_id in hr_person_deployments.grade_id%type

2581: --
2582: -- ---------------------------------------------------------------------------
2583: Procedure chk_position_id_grade_id
2584: (p_position_id in hr_person_deployments.position_id%type
2585: ,p_grade_id in hr_person_deployments.grade_id%type
2586: ,p_start_date in hr_person_deployments.start_date%type
2587: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2588: ,p_object_version_number in hr_person_deployments.object_version_number%type
2589: ,p_inv_pos_grade_warning out nocopy boolean

Line 2586: ,p_start_date in hr_person_deployments.start_date%type

2582: -- ---------------------------------------------------------------------------
2583: Procedure chk_position_id_grade_id
2584: (p_position_id in hr_person_deployments.position_id%type
2585: ,p_grade_id in hr_person_deployments.grade_id%type
2586: ,p_start_date in hr_person_deployments.start_date%type
2587: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2588: ,p_object_version_number in hr_person_deployments.object_version_number%type
2589: ,p_inv_pos_grade_warning out nocopy boolean
2590: ) is

Line 2587: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

2583: Procedure chk_position_id_grade_id
2584: (p_position_id in hr_person_deployments.position_id%type
2585: ,p_grade_id in hr_person_deployments.grade_id%type
2586: ,p_start_date in hr_person_deployments.start_date%type
2587: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2588: ,p_object_version_number in hr_person_deployments.object_version_number%type
2589: ,p_inv_pos_grade_warning out nocopy boolean
2590: ) is
2591: --

Line 2588: ,p_object_version_number in hr_person_deployments.object_version_number%type

2584: (p_position_id in hr_person_deployments.position_id%type
2585: ,p_grade_id in hr_person_deployments.grade_id%type
2586: ,p_start_date in hr_person_deployments.start_date%type
2587: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2588: ,p_object_version_number in hr_person_deployments.object_version_number%type
2589: ,p_inv_pos_grade_warning out nocopy boolean
2590: ) is
2591: --
2592: l_proc varchar2(72) := g_package||'chk_position_id_grade_id';

Line 2622: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'

2618: ,p_argument_value => p_start_date
2619: );
2620: --
2621: if hr_multi_message.no_exclusive_error
2622: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2623: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2624: ) then
2625: --
2626: l_api_updating := hr_pdt_shd.api_updating

Line 2623: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'

2619: );
2620: --
2621: if hr_multi_message.no_exclusive_error
2622: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2623: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2624: ) then
2625: --
2626: l_api_updating := hr_pdt_shd.api_updating
2627: (p_person_deployment_id => p_person_deployment_id

Line 2664: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'

2660: --
2661: exception
2662: when app_exception.application_exception then
2663: if hr_multi_message.exception_add
2664: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2665: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2666: ) then
2667: hr_utility.set_location(' Leaving:'||l_proc, 50);
2668: raise;

Line 2665: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'

2661: exception
2662: when app_exception.application_exception then
2663: if hr_multi_message.exception_add
2664: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2665: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2666: ) then
2667: hr_utility.set_location(' Leaving:'||l_proc, 50);
2668: raise;
2669: end if;

Line 2700: (p_job_id in hr_person_deployments.job_id%type

2696: -- {End of Comments}
2697: --
2698: -- ---------------------------------------------------------------------------
2699: Procedure chk_job_id_grade_id
2700: (p_job_id in hr_person_deployments.job_id%type
2701: ,p_grade_id in hr_person_deployments.grade_id%type
2702: ,p_start_date in hr_person_deployments.start_date%type
2703: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2704: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 2701: ,p_grade_id in hr_person_deployments.grade_id%type

2697: --
2698: -- ---------------------------------------------------------------------------
2699: Procedure chk_job_id_grade_id
2700: (p_job_id in hr_person_deployments.job_id%type
2701: ,p_grade_id in hr_person_deployments.grade_id%type
2702: ,p_start_date in hr_person_deployments.start_date%type
2703: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2704: ,p_object_version_number in hr_person_deployments.object_version_number%type
2705: ,p_inv_job_grade_warning out nocopy boolean

Line 2702: ,p_start_date in hr_person_deployments.start_date%type

2698: -- ---------------------------------------------------------------------------
2699: Procedure chk_job_id_grade_id
2700: (p_job_id in hr_person_deployments.job_id%type
2701: ,p_grade_id in hr_person_deployments.grade_id%type
2702: ,p_start_date in hr_person_deployments.start_date%type
2703: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2704: ,p_object_version_number in hr_person_deployments.object_version_number%type
2705: ,p_inv_job_grade_warning out nocopy boolean
2706: ) is

Line 2703: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

2699: Procedure chk_job_id_grade_id
2700: (p_job_id in hr_person_deployments.job_id%type
2701: ,p_grade_id in hr_person_deployments.grade_id%type
2702: ,p_start_date in hr_person_deployments.start_date%type
2703: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2704: ,p_object_version_number in hr_person_deployments.object_version_number%type
2705: ,p_inv_job_grade_warning out nocopy boolean
2706: ) is
2707: --

Line 2704: ,p_object_version_number in hr_person_deployments.object_version_number%type

2700: (p_job_id in hr_person_deployments.job_id%type
2701: ,p_grade_id in hr_person_deployments.grade_id%type
2702: ,p_start_date in hr_person_deployments.start_date%type
2703: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2704: ,p_object_version_number in hr_person_deployments.object_version_number%type
2705: ,p_inv_job_grade_warning out nocopy boolean
2706: ) is
2707: --
2708: l_proc varchar2(72) := g_package||'chk_job_id_grade_id';

Line 2738: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'

2734: ,p_argument_value => p_start_date
2735: );
2736: --
2737: if hr_multi_message.no_exclusive_error
2738: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2739: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2740: ) then
2741: --
2742: l_api_updating := hr_pdt_shd.api_updating

Line 2739: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'

2735: );
2736: --
2737: if hr_multi_message.no_exclusive_error
2738: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2739: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2740: ) then
2741: --
2742: l_api_updating := hr_pdt_shd.api_updating
2743: (p_person_deployment_id => p_person_deployment_id

Line 2780: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'

2776: --
2777: exception
2778: when app_exception.application_exception then
2779: if hr_multi_message.exception_add
2780: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2781: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2782: ) then
2783: hr_utility.set_location(' Leaving:'||l_proc, 50);
2784: raise;

Line 2781: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'

2777: exception
2778: when app_exception.application_exception then
2779: if hr_multi_message.exception_add
2780: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.JOB_ID'
2781: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.GRADE_ID'
2782: ) then
2783: hr_utility.set_location(' Leaving:'||l_proc, 50);
2784: raise;
2785: end if;

Line 2818: (p_position_id in hr_person_deployments.position_id%type

2814: -- {End of Comments}
2815: --
2816: -- ---------------------------------------------------------------------------
2817: Procedure chk_position_id_org_id
2818: (p_position_id in hr_person_deployments.position_id%type
2819: ,p_organization_id in hr_person_deployments.organization_id%type
2820: ,p_start_date in hr_person_deployments.start_date%type
2821: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2822: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 2819: ,p_organization_id in hr_person_deployments.organization_id%type

2815: --
2816: -- ---------------------------------------------------------------------------
2817: Procedure chk_position_id_org_id
2818: (p_position_id in hr_person_deployments.position_id%type
2819: ,p_organization_id in hr_person_deployments.organization_id%type
2820: ,p_start_date in hr_person_deployments.start_date%type
2821: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2822: ,p_object_version_number in hr_person_deployments.object_version_number%type
2823: ) is

Line 2820: ,p_start_date in hr_person_deployments.start_date%type

2816: -- ---------------------------------------------------------------------------
2817: Procedure chk_position_id_org_id
2818: (p_position_id in hr_person_deployments.position_id%type
2819: ,p_organization_id in hr_person_deployments.organization_id%type
2820: ,p_start_date in hr_person_deployments.start_date%type
2821: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2822: ,p_object_version_number in hr_person_deployments.object_version_number%type
2823: ) is
2824: --

Line 2821: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

2817: Procedure chk_position_id_org_id
2818: (p_position_id in hr_person_deployments.position_id%type
2819: ,p_organization_id in hr_person_deployments.organization_id%type
2820: ,p_start_date in hr_person_deployments.start_date%type
2821: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2822: ,p_object_version_number in hr_person_deployments.object_version_number%type
2823: ) is
2824: --
2825: l_proc varchar2(72) := g_package||'chk_position_id_org_id';

Line 2822: ,p_object_version_number in hr_person_deployments.object_version_number%type

2818: (p_position_id in hr_person_deployments.position_id%type
2819: ,p_organization_id in hr_person_deployments.organization_id%type
2820: ,p_start_date in hr_person_deployments.start_date%type
2821: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2822: ,p_object_version_number in hr_person_deployments.object_version_number%type
2823: ) is
2824: --
2825: l_proc varchar2(72) := g_package||'chk_position_id_org_id';
2826: l_api_updating boolean;

Line 2852: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'

2848: ,p_argument_value => p_start_date
2849: );
2850: --
2851: if hr_multi_message.no_exclusive_error
2852: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'
2853: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2854: ) then
2855: --
2856: l_api_updating := hr_pdt_shd.api_updating

Line 2853: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'

2849: );
2850: --
2851: if hr_multi_message.no_exclusive_error
2852: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'
2853: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2854: ) then
2855: --
2856: l_api_updating := hr_pdt_shd.api_updating
2857: (p_person_deployment_id => p_person_deployment_id

Line 2886: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'

2882: --
2883: exception
2884: when app_exception.application_exception then
2885: if hr_multi_message.exception_add
2886: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2887: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'
2888: ) then
2889: hr_utility.set_location(' Leaving:'||l_proc, 50);
2890: raise;

Line 2887: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'

2883: exception
2884: when app_exception.application_exception then
2885: if hr_multi_message.exception_add
2886: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.POSITION_ID'
2887: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.ORGANIZATION_ID'
2888: ) then
2889: hr_utility.set_location(' Leaving:'||l_proc, 50);
2890: raise;
2891: end if;

Line 2927: (p_payroll_id in hr_person_deployments.payroll_id%type

2923: -- {End of Comments}
2924: --
2925: -- ---------------------------------------------------------------------------
2926: Procedure chk_payroll_id
2927: (p_payroll_id in hr_person_deployments.payroll_id%type
2928: ,p_start_date in hr_person_deployments.start_date%type
2929: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2930: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2931: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 2928: ,p_start_date in hr_person_deployments.start_date%type

2924: --
2925: -- ---------------------------------------------------------------------------
2926: Procedure chk_payroll_id
2927: (p_payroll_id in hr_person_deployments.payroll_id%type
2928: ,p_start_date in hr_person_deployments.start_date%type
2929: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2930: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2931: ,p_object_version_number in hr_person_deployments.object_version_number%type
2932: ) is

Line 2929: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

2925: -- ---------------------------------------------------------------------------
2926: Procedure chk_payroll_id
2927: (p_payroll_id in hr_person_deployments.payroll_id%type
2928: ,p_start_date in hr_person_deployments.start_date%type
2929: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2930: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2931: ,p_object_version_number in hr_person_deployments.object_version_number%type
2932: ) is
2933: --

Line 2930: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

2926: Procedure chk_payroll_id
2927: (p_payroll_id in hr_person_deployments.payroll_id%type
2928: ,p_start_date in hr_person_deployments.start_date%type
2929: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2930: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2931: ,p_object_version_number in hr_person_deployments.object_version_number%type
2932: ) is
2933: --
2934: l_proc varchar2(72) := g_package||'chk_payroll_id';

Line 2931: ,p_object_version_number in hr_person_deployments.object_version_number%type

2927: (p_payroll_id in hr_person_deployments.payroll_id%type
2928: ,p_start_date in hr_person_deployments.start_date%type
2929: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
2930: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
2931: ,p_object_version_number in hr_person_deployments.object_version_number%type
2932: ) is
2933: --
2934: l_proc varchar2(72) := g_package||'chk_payroll_id';
2935: l_api_updating boolean;

Line 2968: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

2964: ,p_argument_value => p_to_business_group_id
2965: );
2966: --
2967: if hr_multi_message.no_all_inclusive_error
2968: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2969: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2970: ) then
2971: --
2972: l_api_updating := hr_pdt_shd.api_updating

Line 2969: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

2965: );
2966: --
2967: if hr_multi_message.no_all_inclusive_error
2968: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
2969: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
2970: ) then
2971: --
2972: l_api_updating := hr_pdt_shd.api_updating
2973: (p_person_deployment_id => p_person_deployment_id

Line 3017: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID'

3013: --
3014: exception
3015: when app_exception.application_exception then
3016: if hr_multi_message.exception_add
3017: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID'
3018: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3019: ) then
3020: hr_utility.set_location(' Leaving:'||l_proc, 50);
3021: raise;

Line 3018: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

3014: exception
3015: when app_exception.application_exception then
3016: if hr_multi_message.exception_add
3017: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID'
3018: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3019: ) then
3020: hr_utility.set_location(' Leaving:'||l_proc, 50);
3021: raise;
3022: end if;

Line 3054: (p_assignment_status_type_id in hr_person_deployments.assignment_status_type_id%type

3050: -- {End of Comments}
3051: --
3052: -- ---------------------------------------------------------------------------
3053: Procedure chk_assignment_status_type_id
3054: (p_assignment_status_type_id in hr_person_deployments.assignment_status_type_id%type
3055: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3056: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3057: ,p_object_version_number in hr_person_deployments.object_version_number%type
3058: ) is

Line 3055: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

3051: --
3052: -- ---------------------------------------------------------------------------
3053: Procedure chk_assignment_status_type_id
3054: (p_assignment_status_type_id in hr_person_deployments.assignment_status_type_id%type
3055: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3056: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3057: ,p_object_version_number in hr_person_deployments.object_version_number%type
3058: ) is
3059: --

Line 3056: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

3052: -- ---------------------------------------------------------------------------
3053: Procedure chk_assignment_status_type_id
3054: (p_assignment_status_type_id in hr_person_deployments.assignment_status_type_id%type
3055: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3056: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3057: ,p_object_version_number in hr_person_deployments.object_version_number%type
3058: ) is
3059: --
3060: l_proc varchar2(72) := g_package||'chk_assignment_status_type_id';

Line 3057: ,p_object_version_number in hr_person_deployments.object_version_number%type

3053: Procedure chk_assignment_status_type_id
3054: (p_assignment_status_type_id in hr_person_deployments.assignment_status_type_id%type
3055: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3056: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3057: ,p_object_version_number in hr_person_deployments.object_version_number%type
3058: ) is
3059: --
3060: l_proc varchar2(72) := g_package||'chk_assignment_status_type_id';
3061: l_api_updating boolean;

Line 3101: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

3097: ,p_argument_value => p_to_business_group_id
3098: );
3099: --
3100: if hr_multi_message.no_all_inclusive_error
3101: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
3102: ) then
3103: --
3104: l_api_updating := hr_pdt_shd.api_updating
3105: (p_person_deployment_id => p_person_deployment_id

Line 3153: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ASSIGNMENT_STATUS_TYPE_ID'

3149: --
3150: exception
3151: when app_exception.application_exception then
3152: if hr_multi_message.exception_add
3153: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ASSIGNMENT_STATUS_TYPE_ID'
3154: ) then
3155: hr_utility.set_location(' Leaving:'||l_proc, 50);
3156: raise;
3157: end if;

Line 3192: (p_supervisor_id in hr_person_deployments.supervisor_id%type

3188: -- {End of Comments}
3189: --
3190: -- ---------------------------------------------------------------------------
3191: Procedure chk_supervisor_id
3192: (p_supervisor_id in hr_person_deployments.supervisor_id%type
3193: ,p_start_date in hr_person_deployments.start_date%type
3194: ,p_from_person_id in hr_person_deployments.from_person_id%type
3195: ,p_to_person_id in hr_person_deployments.to_person_id%type
3196: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

Line 3193: ,p_start_date in hr_person_deployments.start_date%type

3189: --
3190: -- ---------------------------------------------------------------------------
3191: Procedure chk_supervisor_id
3192: (p_supervisor_id in hr_person_deployments.supervisor_id%type
3193: ,p_start_date in hr_person_deployments.start_date%type
3194: ,p_from_person_id in hr_person_deployments.from_person_id%type
3195: ,p_to_person_id in hr_person_deployments.to_person_id%type
3196: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3197: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

Line 3194: ,p_from_person_id in hr_person_deployments.from_person_id%type

3190: -- ---------------------------------------------------------------------------
3191: Procedure chk_supervisor_id
3192: (p_supervisor_id in hr_person_deployments.supervisor_id%type
3193: ,p_start_date in hr_person_deployments.start_date%type
3194: ,p_from_person_id in hr_person_deployments.from_person_id%type
3195: ,p_to_person_id in hr_person_deployments.to_person_id%type
3196: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3197: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3198: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 3195: ,p_to_person_id in hr_person_deployments.to_person_id%type

3191: Procedure chk_supervisor_id
3192: (p_supervisor_id in hr_person_deployments.supervisor_id%type
3193: ,p_start_date in hr_person_deployments.start_date%type
3194: ,p_from_person_id in hr_person_deployments.from_person_id%type
3195: ,p_to_person_id in hr_person_deployments.to_person_id%type
3196: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3197: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3198: ,p_object_version_number in hr_person_deployments.object_version_number%type
3199: ) is

Line 3196: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

3192: (p_supervisor_id in hr_person_deployments.supervisor_id%type
3193: ,p_start_date in hr_person_deployments.start_date%type
3194: ,p_from_person_id in hr_person_deployments.from_person_id%type
3195: ,p_to_person_id in hr_person_deployments.to_person_id%type
3196: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3197: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3198: ,p_object_version_number in hr_person_deployments.object_version_number%type
3199: ) is
3200: --

Line 3197: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

3193: ,p_start_date in hr_person_deployments.start_date%type
3194: ,p_from_person_id in hr_person_deployments.from_person_id%type
3195: ,p_to_person_id in hr_person_deployments.to_person_id%type
3196: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3197: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3198: ,p_object_version_number in hr_person_deployments.object_version_number%type
3199: ) is
3200: --
3201: l_proc varchar2(72) := g_package||'chk_supervisor_id';

Line 3198: ,p_object_version_number in hr_person_deployments.object_version_number%type

3194: ,p_from_person_id in hr_person_deployments.from_person_id%type
3195: ,p_to_person_id in hr_person_deployments.to_person_id%type
3196: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3197: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3198: ,p_object_version_number in hr_person_deployments.object_version_number%type
3199: ) is
3200: --
3201: l_proc varchar2(72) := g_package||'chk_supervisor_id';
3202: l_api_updating boolean;

Line 3233: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

3229: ,p_argument_value => p_start_date
3230: );
3231: --
3232: if hr_multi_message.no_all_inclusive_error
3233: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3234: ) then
3235: --
3236: l_api_updating := hr_pdt_shd.api_updating
3237: (p_person_deployment_id => p_person_deployment_id

Line 3290: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SUPERVISOR_ID'

3286: --
3287: exception
3288: when app_exception.application_exception then
3289: if hr_multi_message.exception_add
3290: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SUPERVISOR_ID'
3291: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3292: ) then
3293: hr_utility.set_location(' Leaving:'||l_proc, 50);
3294: raise;

Line 3291: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

3287: exception
3288: when app_exception.application_exception then
3289: if hr_multi_message.exception_add
3290: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SUPERVISOR_ID'
3291: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3292: ) then
3293: hr_utility.set_location(' Leaving:'||l_proc, 50);
3294: raise;
3295: end if;

Line 3329: (p_supervisor_assignment_id in out nocopy hr_person_deployments.supervisor_assignment_id%type

3325: -- {End of Comments}
3326: --
3327: -- ---------------------------------------------------------------------------
3328: Procedure chk_supervisor_assignment_id
3329: (p_supervisor_assignment_id in out nocopy hr_person_deployments.supervisor_assignment_id%type
3330: ,p_supervisor_id in hr_person_deployments.supervisor_id%type
3331: ,p_start_date in hr_person_deployments.start_date%type
3332: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3333: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 3330: ,p_supervisor_id in hr_person_deployments.supervisor_id%type

3326: --
3327: -- ---------------------------------------------------------------------------
3328: Procedure chk_supervisor_assignment_id
3329: (p_supervisor_assignment_id in out nocopy hr_person_deployments.supervisor_assignment_id%type
3330: ,p_supervisor_id in hr_person_deployments.supervisor_id%type
3331: ,p_start_date in hr_person_deployments.start_date%type
3332: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3333: ,p_object_version_number in hr_person_deployments.object_version_number%type
3334: ) is

Line 3331: ,p_start_date in hr_person_deployments.start_date%type

3327: -- ---------------------------------------------------------------------------
3328: Procedure chk_supervisor_assignment_id
3329: (p_supervisor_assignment_id in out nocopy hr_person_deployments.supervisor_assignment_id%type
3330: ,p_supervisor_id in hr_person_deployments.supervisor_id%type
3331: ,p_start_date in hr_person_deployments.start_date%type
3332: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3333: ,p_object_version_number in hr_person_deployments.object_version_number%type
3334: ) is
3335: --

Line 3332: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

3328: Procedure chk_supervisor_assignment_id
3329: (p_supervisor_assignment_id in out nocopy hr_person_deployments.supervisor_assignment_id%type
3330: ,p_supervisor_id in hr_person_deployments.supervisor_id%type
3331: ,p_start_date in hr_person_deployments.start_date%type
3332: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3333: ,p_object_version_number in hr_person_deployments.object_version_number%type
3334: ) is
3335: --
3336: l_proc varchar2(72) := g_package||'chk_supervisor_assignment_id';

Line 3333: ,p_object_version_number in hr_person_deployments.object_version_number%type

3329: (p_supervisor_assignment_id in out nocopy hr_person_deployments.supervisor_assignment_id%type
3330: ,p_supervisor_id in hr_person_deployments.supervisor_id%type
3331: ,p_start_date in hr_person_deployments.start_date%type
3332: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3333: ,p_object_version_number in hr_person_deployments.object_version_number%type
3334: ) is
3335: --
3336: l_proc varchar2(72) := g_package||'chk_supervisor_assignment_id';
3337: l_api_updating boolean;

Line 3357: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

3353: ,p_argument_value => p_start_date
3354: );
3355: --
3356: if hr_multi_message.no_all_inclusive_error
3357: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3358: ) then
3359: --
3360: l_api_updating := hr_pdt_shd.api_updating
3361: (p_person_deployment_id => p_person_deployment_id

Line 3405: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SUPERVISOR_ASSIGNMENT_ID'

3401: --
3402: exception
3403: when app_exception.application_exception then
3404: if hr_multi_message.exception_add
3405: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SUPERVISOR_ASSIGNMENT_ID'
3406: ) then
3407: hr_utility.set_location(' Leaving:'||l_proc, 50);
3408: raise;
3409: end if;

Line 3441: (p_pay_basis_id in hr_person_deployments.pay_basis_id%type

3437: -- {End of Comments}
3438: --
3439: -- ---------------------------------------------------------------------------
3440: Procedure chk_pay_basis_id
3441: (p_pay_basis_id in hr_person_deployments.pay_basis_id%type
3442: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3443: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3444: ,p_object_version_number in hr_person_deployments.object_version_number%type
3445: ) is

Line 3442: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

3438: --
3439: -- ---------------------------------------------------------------------------
3440: Procedure chk_pay_basis_id
3441: (p_pay_basis_id in hr_person_deployments.pay_basis_id%type
3442: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3443: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3444: ,p_object_version_number in hr_person_deployments.object_version_number%type
3445: ) is
3446: --

Line 3443: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

3439: -- ---------------------------------------------------------------------------
3440: Procedure chk_pay_basis_id
3441: (p_pay_basis_id in hr_person_deployments.pay_basis_id%type
3442: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3443: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3444: ,p_object_version_number in hr_person_deployments.object_version_number%type
3445: ) is
3446: --
3447: l_proc varchar2(72) := g_package||'chk_pay_basis_id';

Line 3444: ,p_object_version_number in hr_person_deployments.object_version_number%type

3440: Procedure chk_pay_basis_id
3441: (p_pay_basis_id in hr_person_deployments.pay_basis_id%type
3442: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3443: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3444: ,p_object_version_number in hr_person_deployments.object_version_number%type
3445: ) is
3446: --
3447: l_proc varchar2(72) := g_package||'chk_pay_basis_id';
3448: l_api_updating boolean;

Line 3490: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAY_BASIS_ID'

3486: --
3487: exception
3488: when app_exception.application_exception then
3489: if hr_multi_message.exception_add
3490: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAY_BASIS_ID'
3491: ) then
3492: hr_utility.set_location(' Leaving:'||l_proc, 50);
3493: raise;
3494: end if;

Line 3528: (p_people_group_id in hr_person_deployments.people_group_id%type

3524: -- {End of Comments}
3525: --
3526: -- ---------------------------------------------------------------------------
3527: Procedure chk_people_group_id
3528: (p_people_group_id in hr_person_deployments.people_group_id%type
3529: ,p_start_date in hr_person_deployments.start_date%type
3530: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3531: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3532: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 3529: ,p_start_date in hr_person_deployments.start_date%type

3525: --
3526: -- ---------------------------------------------------------------------------
3527: Procedure chk_people_group_id
3528: (p_people_group_id in hr_person_deployments.people_group_id%type
3529: ,p_start_date in hr_person_deployments.start_date%type
3530: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3531: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3532: ,p_object_version_number in hr_person_deployments.object_version_number%type
3533: ) is

Line 3530: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

3526: -- ---------------------------------------------------------------------------
3527: Procedure chk_people_group_id
3528: (p_people_group_id in hr_person_deployments.people_group_id%type
3529: ,p_start_date in hr_person_deployments.start_date%type
3530: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3531: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3532: ,p_object_version_number in hr_person_deployments.object_version_number%type
3533: ) is
3534: --

Line 3531: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

3527: Procedure chk_people_group_id
3528: (p_people_group_id in hr_person_deployments.people_group_id%type
3529: ,p_start_date in hr_person_deployments.start_date%type
3530: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3531: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3532: ,p_object_version_number in hr_person_deployments.object_version_number%type
3533: ) is
3534: --
3535: l_proc varchar2(72) := g_package||'chk_people_group_id';

Line 3532: ,p_object_version_number in hr_person_deployments.object_version_number%type

3528: (p_people_group_id in hr_person_deployments.people_group_id%type
3529: ,p_start_date in hr_person_deployments.start_date%type
3530: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3531: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3532: ,p_object_version_number in hr_person_deployments.object_version_number%type
3533: ) is
3534: --
3535: l_proc varchar2(72) := g_package||'chk_people_group_id';
3536: l_api_updating boolean;

Line 3569: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

3565: ,p_argument_value => p_to_business_group_id
3566: );
3567: --
3568: if hr_multi_message.no_all_inclusive_error
3569: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3570: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
3571: ) then
3572: --
3573: l_api_updating := hr_pdt_shd.api_updating

Line 3570: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

3566: );
3567: --
3568: if hr_multi_message.no_all_inclusive_error
3569: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3570: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
3571: ) then
3572: --
3573: l_api_updating := hr_pdt_shd.api_updating
3574: (p_person_deployment_id => p_person_deployment_id

Line 3616: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PEOPLE_GROUP_ID'

3612: --
3613: exception
3614: when app_exception.application_exception then
3615: if hr_multi_message.exception_add
3616: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PEOPLE_GROUP_ID'
3617: ) then
3618: hr_utility.set_location(' Leaving:'||l_proc, 50);
3619: raise;
3620: end if;

Line 3654: (p_soft_coding_keyflex_id in hr_person_deployments.soft_coding_keyflex_id%type

3650: -- {End of Comments}
3651: --
3652: -- ---------------------------------------------------------------------------
3653: Procedure chk_soft_coding_keyflex_id
3654: (p_soft_coding_keyflex_id in hr_person_deployments.soft_coding_keyflex_id%type
3655: ,p_start_date in hr_person_deployments.start_date%type
3656: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3657: ,p_payroll_id in hr_person_deployments.payroll_id%type
3658: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

Line 3655: ,p_start_date in hr_person_deployments.start_date%type

3651: --
3652: -- ---------------------------------------------------------------------------
3653: Procedure chk_soft_coding_keyflex_id
3654: (p_soft_coding_keyflex_id in hr_person_deployments.soft_coding_keyflex_id%type
3655: ,p_start_date in hr_person_deployments.start_date%type
3656: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3657: ,p_payroll_id in hr_person_deployments.payroll_id%type
3658: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3659: ,p_object_version_number in hr_person_deployments.object_version_number%type

Line 3656: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type

3652: -- ---------------------------------------------------------------------------
3653: Procedure chk_soft_coding_keyflex_id
3654: (p_soft_coding_keyflex_id in hr_person_deployments.soft_coding_keyflex_id%type
3655: ,p_start_date in hr_person_deployments.start_date%type
3656: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3657: ,p_payroll_id in hr_person_deployments.payroll_id%type
3658: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3659: ,p_object_version_number in hr_person_deployments.object_version_number%type
3660: ) is

Line 3657: ,p_payroll_id in hr_person_deployments.payroll_id%type

3653: Procedure chk_soft_coding_keyflex_id
3654: (p_soft_coding_keyflex_id in hr_person_deployments.soft_coding_keyflex_id%type
3655: ,p_start_date in hr_person_deployments.start_date%type
3656: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3657: ,p_payroll_id in hr_person_deployments.payroll_id%type
3658: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3659: ,p_object_version_number in hr_person_deployments.object_version_number%type
3660: ) is
3661: --

Line 3658: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

3654: (p_soft_coding_keyflex_id in hr_person_deployments.soft_coding_keyflex_id%type
3655: ,p_start_date in hr_person_deployments.start_date%type
3656: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3657: ,p_payroll_id in hr_person_deployments.payroll_id%type
3658: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3659: ,p_object_version_number in hr_person_deployments.object_version_number%type
3660: ) is
3661: --
3662: l_proc varchar2(72) := g_package||'chk_soft_coding_keyflex_id';

Line 3659: ,p_object_version_number in hr_person_deployments.object_version_number%type

3655: ,p_start_date in hr_person_deployments.start_date%type
3656: ,p_to_business_group_id in hr_person_deployments.to_business_group_id%type
3657: ,p_payroll_id in hr_person_deployments.payroll_id%type
3658: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3659: ,p_object_version_number in hr_person_deployments.object_version_number%type
3660: ) is
3661: --
3662: l_proc varchar2(72) := g_package||'chk_soft_coding_keyflex_id';
3663: l_api_updating boolean;

Line 3709: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

3705: ,p_argument_value => p_to_business_group_id
3706: );
3707: --
3708: if hr_multi_message.no_all_inclusive_error
3709: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3710: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
3711: ) then
3712: --
3713: l_api_updating := hr_pdt_shd.api_updating

Line 3710: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'

3706: );
3707: --
3708: if hr_multi_message.no_all_inclusive_error
3709: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3710: ,p_check_column2 => 'HR_PERSON_DEPLOYMENTS.TO_BUSINESS_GROUP_ID'
3711: ) then
3712: --
3713: l_api_updating := hr_pdt_shd.api_updating
3714: (p_person_deployment_id => p_person_deployment_id

Line 3732: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SOFT_CODING_KEYFLEX_ID' ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE');

3728: if csr_check_scl%notfound then
3729: close csr_check_scl;
3730: fnd_message.set_name('PER','HR_7383_ASG_INV_KEYFLEX');
3731: hr_multi_message.add
3732: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SOFT_CODING_KEYFLEX_ID' ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE');
3733: else
3734: close csr_check_scl;
3735: --
3736: end if;

Line 3752: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID');

3748: close csr_pay_legislation_rules;
3749: if l_legislation_code = 'US' then
3750: fnd_message.set_name('PER','HR_50001_EMP_ASS_NO_GRE');
3751: hr_multi_message.add
3752: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID');
3753: else
3754: open csr_tax_unit_message('HR_INV_LEG_ENT_'||l_legislation_code);
3755: fetch csr_tax_unit_message into l_dummy;
3756: if csr_tax_unit_message%found then

Line 3764: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID');

3760: close csr_tax_unit_message;
3761: fnd_message.set_name('PER','HR_34024_IP_INV_LEG_ENT');
3762: end if;
3763: hr_multi_message.add
3764: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.PAYROLL_ID');
3765: end if; --legislation code
3766: end if; --csr_pay_legislation_rules found
3767: end if; --payroll_id not null
3768: -- end if; --csr_check_scl not found

Line 3778: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SOFT_CODING_KEYFLEX_ID'

3774: --
3775: exception
3776: when app_exception.application_exception then
3777: if hr_multi_message.exception_add
3778: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.SOFT_CODING_KEYFLEX_ID'
3779: ) then
3780: hr_utility.set_location(' Leaving:'||l_proc, 50);
3781: raise;
3782: end if;

Line 3814: (p_assignment_category in hr_person_deployments.assignment_category%type

3810: -- {End of Comments}
3811: --
3812: -- ---------------------------------------------------------------------------
3813: Procedure chk_assignment_category
3814: (p_assignment_category in hr_person_deployments.assignment_category%type
3815: ,p_start_date in hr_person_deployments.start_date%type
3816: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3817: ,p_object_version_number in hr_person_deployments.object_version_number%type
3818: ) is

Line 3815: ,p_start_date in hr_person_deployments.start_date%type

3811: --
3812: -- ---------------------------------------------------------------------------
3813: Procedure chk_assignment_category
3814: (p_assignment_category in hr_person_deployments.assignment_category%type
3815: ,p_start_date in hr_person_deployments.start_date%type
3816: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3817: ,p_object_version_number in hr_person_deployments.object_version_number%type
3818: ) is
3819: --

Line 3816: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type

3812: -- ---------------------------------------------------------------------------
3813: Procedure chk_assignment_category
3814: (p_assignment_category in hr_person_deployments.assignment_category%type
3815: ,p_start_date in hr_person_deployments.start_date%type
3816: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3817: ,p_object_version_number in hr_person_deployments.object_version_number%type
3818: ) is
3819: --
3820: l_proc varchar2(72) := g_package||'chk_assignment_category';

Line 3817: ,p_object_version_number in hr_person_deployments.object_version_number%type

3813: Procedure chk_assignment_category
3814: (p_assignment_category in hr_person_deployments.assignment_category%type
3815: ,p_start_date in hr_person_deployments.start_date%type
3816: ,p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3817: ,p_object_version_number in hr_person_deployments.object_version_number%type
3818: ) is
3819: --
3820: l_proc varchar2(72) := g_package||'chk_assignment_category';
3821: l_api_updating boolean;

Line 3833: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

3829: ,p_argument_value => p_start_date
3830: );
3831: --
3832: if hr_multi_message.no_all_inclusive_error
3833: (p_check_column1 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3834: ) then
3835: --
3836: l_api_updating := hr_pdt_shd.api_updating
3837: (p_person_deployment_id => p_person_deployment_id

Line 3863: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ASSIGNMENT_CATEGORY'

3859: --
3860: exception
3861: when app_exception.application_exception then
3862: if hr_multi_message.exception_add
3863: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ASSIGNMENT_CATEGORY'
3864: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3865: ) then
3866: hr_utility.set_location(' Leaving:'||l_proc, 50);
3867: raise;

Line 3864: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'

3860: exception
3861: when app_exception.application_exception then
3862: if hr_multi_message.exception_add
3863: (p_associated_column1 => 'HR_PERSON_DEPLOYMENTS.ASSIGNMENT_CATEGORY'
3864: ,p_associated_column2 => 'HR_PERSON_DEPLOYMENTS.START_DATE'
3865: ) then
3866: hr_utility.set_location(' Leaving:'||l_proc, 50);
3867: raise;
3868: end if;

Line 3899: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type

3895: -- {End of Comments}
3896: --
3897: -- ---------------------------------------------------------------------------
3898: Procedure chk_delete
3899: (p_person_deployment_id in hr_person_deployments.person_deployment_id%type
3900: ) is
3901: --
3902: l_proc varchar2(72) := g_package||'chk_delete';
3903: l_api_updating boolean;

Line 3905: l_status hr_person_deployments.status%type;

3901: --
3902: l_proc varchar2(72) := g_package||'chk_delete';
3903: l_api_updating boolean;
3904: l_start_date date;
3905: l_status hr_person_deployments.status%type;
3906: --
3907: cursor csr_deployment is
3908: select start_date,status
3909: from hr_person_deployments

Line 3909: from hr_person_deployments

3905: l_status hr_person_deployments.status%type;
3906: --
3907: cursor csr_deployment is
3908: select start_date,status
3909: from hr_person_deployments
3910: where person_deployment_id = p_person_deployment_id;
3911: --
3912: begin
3913: hr_utility.set_location('Entering:'||l_proc, 10);