DBA Data[Home] [Help]

APPS.PER_OBJ_BUS dependencies on PER_OBJ_SHD

Line 15: Procedure chk_non_updateable_args(p_rec in per_obj_shd.g_rec_type) is

11: -- ----------------------------------------------------------------------------
12: -- |----------------------< chk_non_updateable_args >-----------------------|
13: -- ----------------------------------------------------------------------------
14: --
15: Procedure chk_non_updateable_args(p_rec in per_obj_shd.g_rec_type) is
16: --
17: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
18: l_error exception;
19: l_argument varchar2(30);

Line 27: if not per_obj_shd.api_updating

23: --
24: -- Only proceed with validation if a row exists for
25: -- the current record in the HR Schema
26: --
27: if not per_obj_shd.api_updating
28: (p_objective_id => p_rec.objective_id
29: ,p_object_version_number => p_rec.object_version_number
30: ) then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 38: if p_rec.business_group_id <> per_obj_shd.g_old_rec.business_group_id then

34: end if;
35: --
36: hr_utility.set_location(l_proc, 6);
37: --
38: if p_rec.business_group_id <> per_obj_shd.g_old_rec.business_group_id then
39: l_argument := 'business_group_id';
40: raise l_error;
41: elsif p_rec.appraisal_id <> per_obj_shd.g_old_rec.appraisal_id then
42: hr_utility.set_location(l_proc, 7);

Line 41: elsif p_rec.appraisal_id <> per_obj_shd.g_old_rec.appraisal_id then

37: --
38: if p_rec.business_group_id <> per_obj_shd.g_old_rec.business_group_id then
39: l_argument := 'business_group_id';
40: raise l_error;
41: elsif p_rec.appraisal_id <> per_obj_shd.g_old_rec.appraisal_id then
42: hr_utility.set_location(l_proc, 7);
43: l_argument := 'appraisal_id';
44: raise l_error;
45: elsif p_rec.owning_person_id <> per_obj_shd.g_old_rec.owning_person_id then

Line 45: elsif p_rec.owning_person_id <> per_obj_shd.g_old_rec.owning_person_id then

41: elsif p_rec.appraisal_id <> per_obj_shd.g_old_rec.appraisal_id then
42: hr_utility.set_location(l_proc, 7);
43: l_argument := 'appraisal_id';
44: raise l_error;
45: elsif p_rec.owning_person_id <> per_obj_shd.g_old_rec.owning_person_id then
46: hr_utility.set_location(l_proc, 8);
47: l_argument := 'owning_person_id';
48: raise l_error;
49: end if;

Line 206: if( p_appraisal_id <> per_obj_shd.g_old_rec.appraisal_id ) then

202: --
203: --
204: hr_utility.set_location('Entering:'|| l_proc, 2);
205: --
206: if( p_appraisal_id <> per_obj_shd.g_old_rec.appraisal_id ) then
207: if per_obj_shd.g_old_rec.appraisal_id is not null then
208: hr_utility.set_message(801,'HR_52055_OBJ_APPR_ID');
209: hr_utility.raise_error;
210: end if;

Line 207: if per_obj_shd.g_old_rec.appraisal_id is not null then

203: --
204: hr_utility.set_location('Entering:'|| l_proc, 2);
205: --
206: if( p_appraisal_id <> per_obj_shd.g_old_rec.appraisal_id ) then
207: if per_obj_shd.g_old_rec.appraisal_id is not null then
208: hr_utility.set_message(801,'HR_52055_OBJ_APPR_ID');
209: hr_utility.raise_error;
210: end if;
211: end if;

Line 770: l_api_updating := per_obj_shd.api_updating

766: -- Only proceed with validation if :
767: -- a) The current g_old_rec is current and
768: -- b) The date values have changed
769: --
770: l_api_updating := per_obj_shd.api_updating
771: (p_objective_id => p_objective_id
772: ,p_object_version_number => p_object_version_number);
773: --
774: IF (l_api_updating

Line 775: AND nvl(per_obj_shd.g_old_rec.group_code, hr_api.g_varchar2)

771: (p_objective_id => p_objective_id
772: ,p_object_version_number => p_object_version_number);
773: --
774: IF (l_api_updating
775: AND nvl(per_obj_shd.g_old_rec.group_code, hr_api.g_varchar2)
776: = nvl(p_group_code, hr_api.g_varchar2))
777: THEN
778: RETURN;
779: END IF;

Line 858: l_api_updating := per_obj_shd.api_updating

854: -- Only proceed with validation if :
855: -- a) The current g_old_rec is current and
856: -- b) The date values have changed
857: --
858: l_api_updating := per_obj_shd.api_updating
859: (p_objective_id => p_objective_id
860: ,p_object_version_number => p_object_version_number);
861: --
862: IF (l_api_updating

Line 863: AND nvl(per_obj_shd.g_old_rec.priority_code, hr_api.g_varchar2)

859: (p_objective_id => p_objective_id
860: ,p_object_version_number => p_object_version_number);
861: --
862: IF (l_api_updating
863: AND nvl(per_obj_shd.g_old_rec.priority_code, hr_api.g_varchar2)
864: = nvl(p_priority_code, hr_api.g_varchar2))
865: THEN
866: RETURN;
867: END IF;

Line 955: l_api_updating := per_obj_shd.api_updating

951: -- Only proceed with validation if :
952: -- a) The current g_old_rec is current and
953: -- b) The date values have changed
954: --
955: l_api_updating := per_obj_shd.api_updating
956: (p_objective_id => p_objective_id
957: ,p_object_version_number => p_object_version_number);
958: --
959: IF (l_api_updating

Line 960: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)

956: (p_objective_id => p_objective_id
957: ,p_object_version_number => p_object_version_number);
958: --
959: IF (l_api_updating
960: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
961: = nvl(p_appraise_flag, hr_api.g_varchar2))
962: THEN
963: RETURN;
964: END IF;

Line 1040: l_api_updating := per_obj_shd.api_updating

1036: -- Only proceed with validation if :
1037: -- a) The current g_old_rec is current and
1038: -- b) The date values have changed
1039: --
1040: l_api_updating := per_obj_shd.api_updating
1041: (p_objective_id => p_objective_id
1042: ,p_object_version_number => p_object_version_number);
1043: --
1044: IF (l_api_updating

Line 1045: AND nvl(per_obj_shd.g_old_rec.complete_percent, hr_api.g_number)

1041: (p_objective_id => p_objective_id
1042: ,p_object_version_number => p_object_version_number);
1043: --
1044: IF (l_api_updating
1045: AND nvl(per_obj_shd.g_old_rec.complete_percent, hr_api.g_number)
1046: = nvl(p_complete_percent, hr_api.g_number))
1047: THEN
1048: RETURN;
1049: END IF;

Line 1136: l_api_updating := per_obj_shd.api_updating

1132: -- Only proceed with validation if :
1133: -- a) The current g_old_rec is current and
1134: -- b) The date values have changed
1135: --
1136: l_api_updating := per_obj_shd.api_updating
1137: (p_objective_id => p_objective_id
1138: ,p_object_version_number => p_object_version_number);
1139: --
1140: IF (l_api_updating

Line 1141: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)

1137: (p_objective_id => p_objective_id
1138: ,p_object_version_number => p_object_version_number);
1139: --
1140: IF (l_api_updating
1141: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
1142: = nvl(p_appraise_flag, hr_api.g_varchar2)
1143: AND nvl(per_obj_shd.g_old_rec.weighting_percent, hr_api.g_number)
1144: = nvl(p_weighting_percent, hr_api.g_number))
1145: THEN

Line 1143: AND nvl(per_obj_shd.g_old_rec.weighting_percent, hr_api.g_number)

1139: --
1140: IF (l_api_updating
1141: AND nvl(per_obj_shd.g_old_rec.appraise_flag, hr_api.g_varchar2)
1142: = nvl(p_appraise_flag, hr_api.g_varchar2)
1143: AND nvl(per_obj_shd.g_old_rec.weighting_percent, hr_api.g_number)
1144: = nvl(p_weighting_percent, hr_api.g_number))
1145: THEN
1146: RETURN;
1147: END IF;

Line 1255: l_api_updating := per_obj_shd.api_updating

1251: -- Only proceed with validation if :
1252: -- a) The current g_old_rec is current and
1253: -- b) The date values have changed
1254: --
1255: l_api_updating := per_obj_shd.api_updating
1256: (p_objective_id => p_objective_id
1257: ,p_object_version_number => p_object_version_number);
1258: --
1259: IF (l_api_updating

Line 1260: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1256: (p_objective_id => p_objective_id
1257: ,p_object_version_number => p_object_version_number);
1258: --
1259: IF (l_api_updating
1260: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1261: = nvl(p_measurement_style_code, hr_api.g_varchar2))
1262: THEN
1263: RETURN;
1264: END IF;

Line 1345: l_api_updating := per_obj_shd.api_updating

1341: -- Only proceed with validation if :
1342: -- a) The current g_old_rec is current and
1343: -- b) The date values have changed
1344: --
1345: l_api_updating := per_obj_shd.api_updating
1346: (p_objective_id => p_objective_id
1347: ,p_object_version_number => p_object_version_number);
1348: --
1349: IF (l_api_updating

Line 1350: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1346: (p_objective_id => p_objective_id
1347: ,p_object_version_number => p_object_version_number);
1348: --
1349: IF (l_api_updating
1350: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1351: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1352: AND nvl(per_obj_shd.g_old_rec.measure_name, hr_api.g_varchar2)
1353: = nvl(p_measure_name, hr_api.g_varchar2))
1354: THEN

Line 1352: AND nvl(per_obj_shd.g_old_rec.measure_name, hr_api.g_varchar2)

1348: --
1349: IF (l_api_updating
1350: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1351: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1352: AND nvl(per_obj_shd.g_old_rec.measure_name, hr_api.g_varchar2)
1353: = nvl(p_measure_name, hr_api.g_varchar2))
1354: THEN
1355: RETURN;
1356: END IF;

Line 1440: l_api_updating := per_obj_shd.api_updating

1436: -- Only proceed with validation if :
1437: -- a) The current g_old_rec is current and
1438: -- b) The date values have changed
1439: --
1440: l_api_updating := per_obj_shd.api_updating
1441: (p_objective_id => p_objective_id
1442: ,p_object_version_number => p_object_version_number);
1443: --
1444: IF (l_api_updating

Line 1445: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1441: (p_objective_id => p_objective_id
1442: ,p_object_version_number => p_object_version_number);
1443: --
1444: IF (l_api_updating
1445: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1446: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1447: AND nvl(per_obj_shd.g_old_rec.target_value, hr_api.g_number)
1448: = nvl(p_target_value, hr_api.g_number))
1449: THEN

Line 1447: AND nvl(per_obj_shd.g_old_rec.target_value, hr_api.g_number)

1443: --
1444: IF (l_api_updating
1445: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1446: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1447: AND nvl(per_obj_shd.g_old_rec.target_value, hr_api.g_number)
1448: = nvl(p_target_value, hr_api.g_number))
1449: THEN
1450: RETURN;
1451: END IF;

Line 1534: l_api_updating := per_obj_shd.api_updating

1530: -- Only proceed with validation if :
1531: -- a) The current g_old_rec is current and
1532: -- b) The date values have changed
1533: --
1534: l_api_updating := per_obj_shd.api_updating
1535: (p_objective_id => p_objective_id
1536: ,p_object_version_number => p_object_version_number);
1537: --
1538: IF (l_api_updating

Line 1539: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1535: (p_objective_id => p_objective_id
1536: ,p_object_version_number => p_object_version_number);
1537: --
1538: IF (l_api_updating
1539: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1540: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1541: AND nvl(per_obj_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1542: = nvl(p_uom_code, hr_api.g_varchar2))
1543: THEN

Line 1541: AND nvl(per_obj_shd.g_old_rec.uom_code, hr_api.g_varchar2)

1537: --
1538: IF (l_api_updating
1539: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1540: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1541: AND nvl(per_obj_shd.g_old_rec.uom_code, hr_api.g_varchar2)
1542: = nvl(p_uom_code, hr_api.g_varchar2))
1543: THEN
1544: RETURN;
1545: END IF;

Line 1645: l_api_updating := per_obj_shd.api_updating

1641: -- Only proceed with validation if :
1642: -- a) The current g_old_rec is current and
1643: -- b) The date values have changed
1644: --
1645: l_api_updating := per_obj_shd.api_updating
1646: (p_objective_id => p_objective_id
1647: ,p_object_version_number => p_object_version_number);
1648: --
1649: IF (l_api_updating

Line 1650: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)

1646: (p_objective_id => p_objective_id
1647: ,p_object_version_number => p_object_version_number);
1648: --
1649: IF (l_api_updating
1650: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1651: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1652: AND nvl(per_obj_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1653: = nvl(p_measure_type_code, hr_api.g_varchar2))
1654: THEN

Line 1652: AND nvl(per_obj_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)

1648: --
1649: IF (l_api_updating
1650: AND nvl(per_obj_shd.g_old_rec.measurement_style_code, hr_api.g_varchar2)
1651: = nvl(p_measurement_style_code, hr_api.g_varchar2)
1652: AND nvl(per_obj_shd.g_old_rec.measure_type_code, hr_api.g_varchar2)
1653: = nvl(p_measure_type_code, hr_api.g_varchar2))
1654: THEN
1655: RETURN;
1656: END IF;

Line 1755: l_api_updating := per_obj_shd.api_updating

1751: -- Only proceed with validation if :
1752: -- a) The current g_old_rec is current and
1753: -- b) The scorecard value has changed
1754: --
1755: l_api_updating := per_obj_shd.api_updating
1756: (p_objective_id => p_objective_id
1757: ,p_object_version_number => p_object_version_number);
1758: --
1759: IF (l_api_updating

Line 1760: AND nvl(per_obj_shd.g_old_rec.scorecard_id, hr_api.g_number)

1756: (p_objective_id => p_objective_id
1757: ,p_object_version_number => p_object_version_number);
1758: --
1759: IF (l_api_updating
1760: AND nvl(per_obj_shd.g_old_rec.scorecard_id, hr_api.g_number)
1761: = nvl(p_scorecard_id, hr_api.g_number))
1762: THEN
1763: RETURN;
1764: END IF;

Line 1854: l_api_updating := per_obj_shd.api_updating

1850: -- Only proceed with validation if :
1851: -- a) The current g_old_rec is current and
1852: -- b) The copied_from_library_id value has changed
1853: --
1854: l_api_updating := per_obj_shd.api_updating
1855: (p_objective_id => p_objective_id
1856: ,p_object_version_number => p_object_version_number);
1857: --
1858: IF (l_api_updating

Line 1859: AND nvl(per_obj_shd.g_old_rec.copied_from_library_id, hr_api.g_number)

1855: (p_objective_id => p_objective_id
1856: ,p_object_version_number => p_object_version_number);
1857: --
1858: IF (l_api_updating
1859: AND nvl(per_obj_shd.g_old_rec.copied_from_library_id, hr_api.g_number)
1860: = nvl(p_copied_from_lib_id, hr_api.g_number))
1861: THEN
1862: RETURN;
1863: END IF;

Line 1944: l_api_updating := per_obj_shd.api_updating

1940: -- Only proceed with validation if :
1941: -- a) The current g_old_rec is current and
1942: -- b) The copied_from_objective_id value has changed
1943: --
1944: l_api_updating := per_obj_shd.api_updating
1945: (p_objective_id => p_objective_id
1946: ,p_object_version_number => p_object_version_number);
1947: --
1948: IF (l_api_updating

Line 1949: AND nvl(per_obj_shd.g_old_rec.copied_from_objective_id, hr_api.g_number)

1945: (p_objective_id => p_objective_id
1946: ,p_object_version_number => p_object_version_number);
1947: --
1948: IF (l_api_updating
1949: AND nvl(per_obj_shd.g_old_rec.copied_from_objective_id, hr_api.g_number)
1950: = nvl(p_copied_from_obj_id, hr_api.g_number))
1951: THEN
1952: RETURN;
1953: END IF;

Line 2112: l_api_updating := per_obj_shd.api_updating

2108: -- Only proceed with validation if :
2109: -- a) The current g_old_rec is current and
2110: -- b) The aligned_with_obj_id value has changed
2111: --
2112: l_api_updating := per_obj_shd.api_updating
2113: (p_objective_id => p_objective_id
2114: ,p_object_version_number => p_object_version_number);
2115: --
2116: IF (l_api_updating

Line 2117: AND nvl(per_obj_shd.g_old_rec.aligned_with_objective_id, hr_api.g_number)

2113: (p_objective_id => p_objective_id
2114: ,p_object_version_number => p_object_version_number);
2115: --
2116: IF (l_api_updating
2117: AND nvl(per_obj_shd.g_old_rec.aligned_with_objective_id, hr_api.g_number)
2118: = nvl(p_aligned_with_obj_id, hr_api.g_number))
2119: THEN
2120: RETURN;
2121: END IF;

Line 2303: l_api_updating := per_obj_shd.api_updating

2299: -- Only proceed with validation if :
2300: -- a) The current g_old_rec is current and
2301: -- b) The sharing access code values have changed
2302: --
2303: l_api_updating := per_obj_shd.api_updating
2304: (p_objective_id => p_objective_id
2305: ,p_object_version_number => p_object_version_number);
2306: --
2307: IF (l_api_updating

Line 2308: AND nvl(per_obj_shd.g_old_rec.sharing_access_code, hr_api.g_varchar2)

2304: (p_objective_id => p_objective_id
2305: ,p_object_version_number => p_object_version_number);
2306: --
2307: IF (l_api_updating
2308: AND nvl(per_obj_shd.g_old_rec.sharing_access_code, hr_api.g_varchar2)
2309: = nvl(p_sharing_access_code, hr_api.g_varchar2))
2310: THEN
2311: RETURN;
2312: END IF;

Line 2370: (p_rec in per_obj_shd.g_rec_type) is

2366: -- Access Status:
2367: -- Internal Row Handler Use Only.
2368: --
2369: procedure chk_df
2370: (p_rec in per_obj_shd.g_rec_type) is
2371: --
2372: l_proc varchar2(72) := g_package||'chk_df';
2373: --
2374: begin

Line 2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

2374: begin
2375: hr_utility.set_location('Entering:'||l_proc, 10);
2376: --
2377: if ((p_rec.objective_id is not null) and (
2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2379: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

2376: --
2377: if ((p_rec.objective_id is not null) and (
2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2379: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

2378: nvl(per_obj_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
2379: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

2380: nvl(per_obj_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
2381: nvl(p_rec.attribute1, hr_api.g_varchar2) or
2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

2382: nvl(per_obj_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
2383: nvl(p_rec.attribute2, hr_api.g_varchar2) or
2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

2384: nvl(per_obj_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
2385: nvl(p_rec.attribute3, hr_api.g_varchar2) or
2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

2386: nvl(per_obj_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
2387: nvl(p_rec.attribute4, hr_api.g_varchar2) or
2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

2388: nvl(per_obj_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
2389: nvl(p_rec.attribute5, hr_api.g_varchar2) or
2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

2390: nvl(per_obj_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
2391: nvl(p_rec.attribute6, hr_api.g_varchar2) or
2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

2392: nvl(per_obj_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
2393: nvl(p_rec.attribute7, hr_api.g_varchar2) or
2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

2394: nvl(per_obj_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
2395: nvl(p_rec.attribute8, hr_api.g_varchar2) or
2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

2396: nvl(per_obj_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
2397: nvl(p_rec.attribute9, hr_api.g_varchar2) or
2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

2398: nvl(per_obj_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
2399: nvl(p_rec.attribute10, hr_api.g_varchar2) or
2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

2400: nvl(per_obj_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
2401: nvl(p_rec.attribute11, hr_api.g_varchar2) or
2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

2402: nvl(per_obj_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
2403: nvl(p_rec.attribute12, hr_api.g_varchar2) or
2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

2404: nvl(per_obj_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
2405: nvl(p_rec.attribute13, hr_api.g_varchar2) or
2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

2406: nvl(per_obj_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
2407: nvl(p_rec.attribute14, hr_api.g_varchar2) or
2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

2408: nvl(per_obj_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
2409: nvl(p_rec.attribute15, hr_api.g_varchar2) or
2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

2410: nvl(per_obj_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
2411: nvl(p_rec.attribute16, hr_api.g_varchar2) or
2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

2412: nvl(per_obj_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
2413: nvl(p_rec.attribute17, hr_api.g_varchar2) or
2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:

Line 2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

2414: nvl(per_obj_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
2415: nvl(p_rec.attribute18, hr_api.g_varchar2) or
2416: nvl(per_obj_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or

Line 2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

2417: nvl(p_rec.attribute19, hr_api.g_varchar2) or
2418: nvl(per_obj_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

2419: nvl(p_rec.attribute20, hr_api.g_varchar2) or
2420:
2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

2421: nvl(per_obj_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
2422: nvl(p_rec.attribute21, hr_api.g_varchar2) or
2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

2423: nvl(per_obj_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
2424: nvl(p_rec.attribute22, hr_api.g_varchar2) or
2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

2425: nvl(per_obj_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
2426: nvl(p_rec.attribute23, hr_api.g_varchar2) or
2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

2427: nvl(per_obj_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
2428: nvl(p_rec.attribute24, hr_api.g_varchar2) or
2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

2429: nvl(per_obj_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
2430: nvl(p_rec.attribute25, hr_api.g_varchar2) or
2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

2431: nvl(per_obj_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
2432: nvl(p_rec.attribute26, hr_api.g_varchar2) or
2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

2433: nvl(per_obj_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
2434: nvl(p_rec.attribute27, hr_api.g_varchar2) or
2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
2440: nvl(p_rec.attribute30, hr_api.g_varchar2)))
2441:

Line 2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

2435: nvl(per_obj_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
2436: nvl(p_rec.attribute28, hr_api.g_varchar2) or
2437: nvl(per_obj_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
2438: nvl(p_rec.attribute29, hr_api.g_varchar2) or
2439: nvl(per_obj_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
2440: nvl(p_rec.attribute30, hr_api.g_varchar2)))
2441:
2442:
2443: or

Line 2525: Procedure insert_validate(p_rec in per_obj_shd.g_rec_type

2521: --
2522: -- ----------------------------------------------------------------------------
2523: -- |---------------------------< insert_validate >----------------------------|
2524: -- ----------------------------------------------------------------------------
2525: Procedure insert_validate(p_rec in per_obj_shd.g_rec_type
2526: ,p_effective_date in date
2527: ,p_weighting_over_100_warning out nocopy boolean
2528: ,p_weighting_appraisal_warning out nocopy boolean
2529: ) is

Line 2539: ,p_associated_column1 => per_obj_shd.g_tab_nam ||

2535: --
2536: -- Call all supporting business operations
2537: --
2538: hr_api.validate_bus_grp_id(p_rec.business_group_id
2539: ,p_associated_column1 => per_obj_shd.g_tab_nam ||
2540: '.BUSINESS_GROUP_ID'); -- Validate Bus Grp
2541:
2542: hr_multi_message.end_validation_set;
2543: --

Line 2792: Procedure update_validate(p_rec in per_obj_shd.g_rec_type

2788: --
2789: -- ----------------------------------------------------------------------------
2790: -- |---------------------------< update_validate >----------------------------|
2791: -- ----------------------------------------------------------------------------
2792: Procedure update_validate(p_rec in per_obj_shd.g_rec_type
2793: ,p_effective_date in date
2794: ,p_weighting_over_100_warning out nocopy boolean
2795: ,p_weighting_appraisal_warning out nocopy boolean
2796: ) is

Line 2809: ,p_associated_column1 => per_obj_shd.g_tab_nam ||

2805: --
2806: -- Validate business_group_id
2807: --
2808: hr_api.validate_bus_grp_id(p_rec.business_group_id
2809: ,p_associated_column1 => per_obj_shd.g_tab_nam ||
2810: '.BUSINESS_GROUP_ID'
2811: );
2812:
2813: hr_multi_message.end_validation_set;

Line 3060: Procedure delete_validate(p_rec in per_obj_shd.g_rec_type) is

3056: --
3057: -- ----------------------------------------------------------------------------
3058: -- |---------------------------< delete_validate >----------------------------|
3059: -- ----------------------------------------------------------------------------
3060: Procedure delete_validate(p_rec in per_obj_shd.g_rec_type) is
3061: --
3062: l_proc varchar2(72) := g_package||'delete_validate';
3063: --
3064: Begin