[Home] [Help]
12: -- |-----------------------< chk_non_updateable_args >--------------|
13: -- -----------------------------------------------------------------
14: --
15: Procedure chk_non_updateable_args
16: (p_rec in per_pos_shd.g_rec_type
17: ) is
18: --
19: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
20: l_error exception;
25: --
26: -- Only proceed with validation if a row exists for
27: -- the current record in the HR Schema
28: --
29: IF not per_pos_shd.api_updating
30: (p_position_id => p_rec.position_id
31: ,p_object_version_number => p_rec.object_version_number)
32: THEN
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: END IF;
37: hr_utility.set_location(l_proc, 30);
38: --
39: if nvl(p_rec.business_group_id, hr_api.g_number) <>
40: nvl(per_pos_shd.g_old_rec.business_group_id
41: ,hr_api.g_number
42: ) then
43: l_argument := 'business_group_id';
44: raise l_error;
45: end if;
46: --
47: --
48: if nvl(p_rec.job_id, hr_api.g_number) <>
49: nvl(per_pos_shd.g_old_rec.job_id
50: ,hr_api.g_number
51: ) then
52: l_argument := 'job_id';
53: raise l_error;
54: end if;
55: --
56: --
57: if nvl(p_rec.organization_id, hr_api.g_number) <>
58: nvl(per_pos_shd.g_old_rec.organization_id
59: ,hr_api.g_number
60: ) then
61: l_argument := 'organization_id';
62: raise l_error;
394: (p_api_name => l_proc
395: ,p_argument => 'date effective'
396: ,p_argument_value => p_date_effective);
397: --
398: l_api_updating := per_pos_shd.api_updating
399: (p_position_id => p_position_id
400: ,p_object_version_number => p_object_version_number);
401: --
402: -- Check for valid successor position id
401: --
402: -- Check for valid successor position id
403: --
404: if ((l_api_updating and
405: per_pos_shd.g_old_rec.successor_position_id <>
406: p_successor_position_id) or
407: (NOT l_api_updating)) then
408: --
409: hr_utility.set_location(l_proc, 2);
491: (p_api_name => l_proc
492: ,p_argument => 'date effective'
493: ,p_argument_value => p_date_effective);
494: --
495: l_api_updating := per_pos_shd.api_updating
496: (p_position_id => p_position_id
497: ,p_object_version_number => p_object_version_number);
498: --
499: -- Check for valid relief position id
498: --
499: -- Check for valid relief position id
500: --
501: if ((l_api_updating and
502: per_pos_shd.g_old_rec.relief_position_id <>
503: p_relief_position_id) or
504: (NOT l_api_updating)) then
505: --
506: hr_utility.set_location(l_proc, 2);
589: -- Only proceed with validation if :
590: -- a) The current g_old_rec is current and
591: -- b) The location_id value has changed
592: --
593: l_api_updating := per_pos_shd.api_updating
594: (p_position_id => p_position_id
595: ,p_object_version_number => p_object_version_number);
596: --
597: if ((l_api_updating and
594: (p_position_id => p_position_id
595: ,p_object_version_number => p_object_version_number);
596: --
597: if ((l_api_updating and
598: nvl(per_pos_shd.g_old_rec.location_id,hr_api.g_number) <>
599: nvl(p_location_id,hr_api.g_number)) or
600: (NOT l_api_updating)) then
601: --
602: -- Validate that location id is valid for p_date_effective
669: );
670: --
671: hr_utility.set_location(l_proc, 2);
672: --
673: l_api_updating := per_pos_shd.api_updating
674: (p_position_id => p_position_id
675: ,p_object_version_number => p_object_version_number);
676: --
677: hr_utility.set_location(l_proc, 3);
676: --
677: hr_utility.set_location(l_proc, 3);
678: --
679: if ((l_api_updating and
680: (per_pos_shd.g_old_rec.position_definition_id <>
681: p_position_definition_id)) or
682: (NOT l_api_updating)) then
683: --
684: hr_utility.set_location(l_proc, 4);
753: -- Only proceed with validation if :
754: -- a) The current g_old_rec is current and
755: -- b) The date_end value has changed
756: --
757: l_api_updating := per_pos_shd.api_updating
758: (p_position_id => p_position_id
759: ,p_object_version_number => p_object_version_number);
760: --
761: if (((l_api_updating and
758: (p_position_id => p_position_id
759: ,p_object_version_number => p_object_version_number);
760: --
761: if (((l_api_updating and
762: (per_pos_shd.g_old_rec.date_end <> p_date_end) or
763: (per_pos_shd.g_old_rec.date_effective <> p_date_effective)) or
764: (NOT l_api_updating))) then
765: --
766: -- Check that date_effective <= date_end
759: ,p_object_version_number => p_object_version_number);
760: --
761: if (((l_api_updating and
762: (per_pos_shd.g_old_rec.date_end <> p_date_end) or
763: (per_pos_shd.g_old_rec.date_effective <> p_date_effective)) or
764: (NOT l_api_updating))) then
765: --
766: -- Check that date_effective <= date_end
767: --
851: -- b) The working hours value has changed or
852: -- c) The frequency value has changed
853: --
854: --
855: l_api_updating := per_pos_shd.api_updating
856: (p_position_id => p_position_id
857: ,p_object_version_number => p_object_version_number);
858: --
859: if ((l_api_updating and
856: (p_position_id => p_position_id
857: ,p_object_version_number => p_object_version_number);
858: --
859: if ((l_api_updating and
860: (nvl(per_pos_shd.g_old_rec.working_hours,hr_api.g_number) <>
861: nvl(p_working_hours,hr_api.g_number) or
862: (nvl(per_pos_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
863: nvl(p_frequency,hr_api.g_varchar2)))) or
864: (NOT l_api_updating)) then
858: --
859: if ((l_api_updating and
860: (nvl(per_pos_shd.g_old_rec.working_hours,hr_api.g_number) <>
861: nvl(p_working_hours,hr_api.g_number) or
862: (nvl(per_pos_shd.g_old_rec.frequency,hr_api.g_varchar2) <>
863: nvl(p_frequency,hr_api.g_varchar2)))) or
864: (NOT l_api_updating)) then
865: --
866: -- Check for values consistency
965: -- a) The current g_old_rec is current and
966: -- b) The probation_period value has changed
967: -- c) The probation_period_units value has changed
968: --
969: l_api_updating := per_pos_shd.api_updating
970: (p_position_id => p_position_id
971: ,p_object_version_number => p_object_version_number);
972: --
973: if ((l_api_updating and
970: (p_position_id => p_position_id
971: ,p_object_version_number => p_object_version_number);
972: --
973: if ((l_api_updating and
974: (nvl(per_pos_shd.g_old_rec.probation_period,hr_api.g_number) <>
975: nvl(p_probation_period,hr_api.g_number)) or
976: (nvl(per_pos_shd.g_old_rec.probation_period_units,hr_api.g_varchar2) <>
977: nvl(p_probation_period_units,hr_api.g_varchar2))) or
978: (NOT l_api_updating)) then
972: --
973: if ((l_api_updating and
974: (nvl(per_pos_shd.g_old_rec.probation_period,hr_api.g_number) <>
975: nvl(p_probation_period,hr_api.g_number)) or
976: (nvl(per_pos_shd.g_old_rec.probation_period_units,hr_api.g_varchar2) <>
977: nvl(p_probation_period_units,hr_api.g_varchar2))) or
978: (NOT l_api_updating)) then
979: --
980: -- Check for values consistency
1062: -- a) The current g_old_rec is current and
1063: -- b) The replacement_required_flag value has changed
1064: --
1065: if p_replacement_required_flag is not null then
1066: l_api_updating := per_pos_shd.api_updating
1067: (p_position_id => p_position_id
1068: ,p_object_version_number => p_object_version_number);
1069: --
1070: if ((l_api_updating and
1067: (p_position_id => p_position_id
1068: ,p_object_version_number => p_object_version_number);
1069: --
1070: if ((l_api_updating and
1071: (nvl(per_pos_shd.g_old_rec.replacement_required_flag,hr_api.g_varchar2) <>
1072: nvl(p_replacement_required_flag,hr_api.g_varchar2))) or
1073: (NOT l_api_updating)) then
1074: --
1075: -- Validate flag replacement_required_flag against fnd_common_lookups
1146: -- a) The current g_old_rec is current and
1147: -- b) The time_normal_start value has changed
1148: -- c) The time_normal_finish value has changed
1149: --
1150: l_api_updating := per_pos_shd.api_updating
1151: (p_position_id => p_position_id
1152: ,p_object_version_number => p_object_version_number);
1153: --
1154: if ((l_api_updating and
1151: (p_position_id => p_position_id
1152: ,p_object_version_number => p_object_version_number);
1153: --
1154: if ((l_api_updating and
1155: (nvl(per_pos_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
1156: nvl(p_time_normal_start,hr_api.g_varchar2) or
1157: (nvl(per_pos_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
1158: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
1159: (NOT l_api_updating)) then
1153: --
1154: if ((l_api_updating and
1155: (nvl(per_pos_shd.g_old_rec.time_normal_start,hr_api.g_varchar2) <>
1156: nvl(p_time_normal_start,hr_api.g_varchar2) or
1157: (nvl(per_pos_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
1158: nvl(p_time_normal_finish,hr_api.g_varchar2)))) or
1159: (NOT l_api_updating)) then
1160: --
1161: -- Check for values consistency
1247: -- a) The current g_old_rec is current and
1248: -- b) The status value has changed or
1249: -- c) Inserting
1250: --
1251: l_api_updating := per_pos_shd.api_updating
1252: (p_position_id => p_position_id
1253: ,p_object_version_number => p_object_version_number);
1254: --
1255: if ((l_api_updating and
1252: (p_position_id => p_position_id
1253: ,p_object_version_number => p_object_version_number);
1254: --
1255: if ((l_api_updating and
1256: (nvl(per_pos_shd.g_old_rec.status,hr_api.g_varchar2) <>
1257: nvl(p_status,hr_api.g_varchar2))) or
1258: (NOT l_api_updating)) then
1259: --
1260: -- Check for valid status against fnd_common_lookups
1303: -- Access Status:
1304: -- Internal Row Handler Use Only.
1305: --
1306: procedure chk_df
1307: (p_rec in per_pos_shd.g_rec_type) is
1308: --
1309: l_proc varchar2(72) := g_package||'chk_df';
1310: --
1311: begin
1311: begin
1312: hr_utility.set_location('Entering:'||l_proc, 10);
1313: --
1314: if ((p_rec.position_id is not null) and (
1315: nvl(per_pos_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1316: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1313: --
1314: if ((p_rec.position_id is not null) and (
1315: nvl(per_pos_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1316: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1315: nvl(per_pos_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1316: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1317: nvl(per_pos_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
1318: nvl(p_rec.attribute1, hr_api.g_varchar2) or
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1319: nvl(per_pos_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
1320: nvl(p_rec.attribute2, hr_api.g_varchar2) or
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1321: nvl(per_pos_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
1322: nvl(p_rec.attribute3, hr_api.g_varchar2) or
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1323: nvl(per_pos_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
1324: nvl(p_rec.attribute4, hr_api.g_varchar2) or
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1325: nvl(per_pos_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
1326: nvl(p_rec.attribute5, hr_api.g_varchar2) or
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1327: nvl(per_pos_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
1328: nvl(p_rec.attribute6, hr_api.g_varchar2) or
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1329: nvl(per_pos_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
1330: nvl(p_rec.attribute7, hr_api.g_varchar2) or
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1331: nvl(per_pos_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
1332: nvl(p_rec.attribute8, hr_api.g_varchar2) or
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1333: nvl(per_pos_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
1334: nvl(p_rec.attribute9, hr_api.g_varchar2) or
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1335: nvl(per_pos_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
1336: nvl(p_rec.attribute10, hr_api.g_varchar2) or
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1337: nvl(per_pos_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
1338: nvl(p_rec.attribute11, hr_api.g_varchar2) or
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1339: nvl(per_pos_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
1340: nvl(p_rec.attribute12, hr_api.g_varchar2) or
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1341: nvl(per_pos_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
1342: nvl(p_rec.attribute13, hr_api.g_varchar2) or
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1343: nvl(per_pos_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
1344: nvl(p_rec.attribute14, hr_api.g_varchar2) or
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1345: nvl(per_pos_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
1346: nvl(p_rec.attribute15, hr_api.g_varchar2) or
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1347: nvl(per_pos_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
1348: nvl(p_rec.attribute16, hr_api.g_varchar2) or
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1349: nvl(per_pos_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
1350: nvl(p_rec.attribute17, hr_api.g_varchar2) or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1356: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1357: or
1351: nvl(per_pos_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
1352: nvl(p_rec.attribute18, hr_api.g_varchar2) or
1353: nvl(per_pos_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
1354: nvl(p_rec.attribute19, hr_api.g_varchar2) or
1355: nvl(per_pos_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
1356: nvl(p_rec.attribute20, hr_api.g_varchar2)))
1357: or
1358: (p_rec.position_id is null) then
1359: --
1498: --if g_debug then
1499: hr_utility.set_location(l_proc, 30);
1500: --end if;
1501: --
1502: l_api_updating := per_pos_shd.api_updating
1503: (p_position_id => p_position_id
1504: ,p_object_version_number => p_object_version_number
1505: );
1506: --if g_debug then
1507: hr_utility.set_location(l_proc, 70);
1508: --end if;
1509: --
1510: if (l_api_updating and
1511: (nvl(per_pos_shd.g_old_rec.position_definition_id, hr_api.g_number)
1512: <> nvl(p_position_definition_id, hr_api.g_number))
1513: )
1514: or NOT l_api_updating
1515: then
1613: -- Bug 892165
1614: -- Amended changed this to p_name
1615:
1616: IF ((( p_name IS NOT NULL ) and
1617: NVL(per_pos_shd.g_old_rec.name,hr_api.g_varchar2)
1618: <> NVL(p_name,hr_api.g_varchar2))
1619: OR ( p_name IS NULL)) THEN
1620:
1621: open csr_name_unique;
1635: --
1636: -- ----------------------------------------------------------------------------
1637: -- |---------------------------< insert_validate >----------------------------|
1638: -- ----------------------------------------------------------------------------
1639: Procedure insert_validate(p_rec in per_pos_shd.g_rec_type) is
1640: --
1641: l_proc varchar2(72) := g_package||'insert_validate';
1642: --
1643: Begin
1789:
1790: -- ----------------------------------------------------------------------------
1791: -- |---------------------------< update_validate >----------------------------|
1792: -- ----------------------------------------------------------------------------
1793: Procedure update_validate(p_rec in per_pos_shd.g_rec_type) is
1794: --
1795: l_proc varchar2(72) := g_package||'update_validate';
1796: --
1797: Begin
1936: --
1937: -- ----------------------------------------------------------------------------
1938: -- |---------------------------< delete_validate >----------------------------|
1939: -- ----------------------------------------------------------------------------
1940: Procedure delete_validate(p_rec in per_pos_shd.g_rec_type) is
1941: --
1942: l_proc varchar2(72) := g_package||'delete_validate';
1943: --
1944: Begin