[Home] [Help]
72: l_object_version_number ben_per_cm_f.object_version_number%TYPE;
73: --
74: begin
75: --
76: hr_utility.set_location('Entering:'|| l_proc, 10);
77: --
78: -- Issue a savepoint if operating in validation only mode
79: --
80: savepoint create_PER_CM;
78: -- Issue a savepoint if operating in validation only mode
79: --
80: savepoint create_PER_CM;
81: --
82: hr_utility.set_location(l_proc, 20);
83: --
84: -- Process Logic
85: --
86: begin
266: -- End of API User Hook for the after hook of create_PER_CM
267: --
268: end;
269: --
270: hr_utility.set_location(l_proc, 60);
271: --
272: -- When in validation only mode raise the Validate_Enabled exception
273: --
274: if p_validate then
281: p_effective_start_date := l_effective_start_date;
282: p_effective_end_date := l_effective_end_date;
283: p_object_version_number := l_object_version_number;
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 70);
286: --
287: exception
288: --
289: when hr_api.validate_enabled then
300: p_per_cm_id := null;
301: p_effective_start_date := null;
302: p_effective_end_date := null;
303: p_object_version_number := null;
304: hr_utility.set_location(' Leaving:'||l_proc, 80);
305: --
306: when others then
307: --
308: -- A validation or unexpected error has occured
311: p_per_cm_id := null;
312: p_effective_start_date := null;
313: p_effective_end_date := null;
314: p_object_version_number := null;
315: hr_utility.set_location(' Leaving:'||l_proc, 90);
316: raise;
317: --
318: end create_PER_CM;
319: --
731: -- End of API User Hook for the after hook of create_PER_CM
732: --
733: end;
734: --
735: hr_utility.set_location(l_proc, 60);
736: --
737: -- When in validation only mode raise the Validate_Enabled exception
738: --
739: if p_validate then
746: p_effective_start_date := l_effective_start_date;
747: p_effective_end_date := l_effective_end_date;
748: p_object_version_number := l_object_version_number;
749: --
750: hr_utility.set_location(' Leaving:'||l_proc, 70);
751: --
752: exception
753: --
754: when hr_api.validate_enabled then
765: p_per_cm_id := null;
766: p_effective_start_date := null;
767: p_effective_end_date := null;
768: p_object_version_number := null;
769: hr_utility.set_location(' Leaving:'||l_proc, 80);
770: --
771: when others then
772: --
773: -- A validation or unexpected error has occured
776: p_per_cm_id := null;
777: p_effective_start_date := null;
778: p_effective_end_date := null;
779: p_object_version_number := null;
780: hr_utility.set_location(' Leaving:'||l_proc, 90);
781: raise;
782: --
783: end create_PER_CM_perf;
784: -- ----------------------------------------------------------------------------
847: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
848: --
849: begin
850: --
851: hr_utility.set_location('Entering:'|| l_proc, 10);
852: --
853: -- Issue a savepoint if operating in validation only mode
854: --
855: savepoint update_PER_CM;
853: -- Issue a savepoint if operating in validation only mode
854: --
855: savepoint update_PER_CM;
856: --
857: hr_utility.set_location(l_proc, 20);
858: --
859: -- Process Logic
860: --
861: l_object_version_number := p_object_version_number;
1048: -- End of API User Hook for the after hook of update_PER_CM
1049: --
1050: end;
1051: --
1052: hr_utility.set_location(l_proc, 60);
1053: --
1054: -- When in validation only mode raise the Validate_Enabled exception
1055: --
1056: if p_validate then
1062: p_object_version_number := l_object_version_number;
1063: p_effective_start_date := l_effective_start_date;
1064: p_effective_end_date := l_effective_end_date;
1065: --
1066: hr_utility.set_location(' Leaving:'||l_proc, 70);
1067: --
1068: exception
1069: --
1070: when hr_api.validate_enabled then
1077: -- Only set output warning arguments
1078: -- (Any key or derived arguments must be set to null
1079: -- when validation only mode is being used.)
1080: --
1081: hr_utility.set_location(' Leaving:'||l_proc, 80);
1082: --
1083: when others then
1084: --
1085: -- A validation or unexpected error has occured
1086: --
1087: ROLLBACK TO update_PER_CM;
1088: p_effective_start_date := null;
1089: p_effective_end_date := null;
1090: hr_utility.set_location(' Leaving:'||l_proc, 90);
1091: raise;
1092: --
1093: end update_PER_CM;
1094: -- ----------------------------------------------------------------------------
1151: l_effective_end_date ben_per_cm_f.effective_end_date%TYPE;
1152: --
1153: begin
1154: --
1155: hr_utility.set_location('Entering:'|| l_proc, 10);
1156: --
1157: -- Issue a savepoint if operating in validation only mode
1158: --
1159: savepoint delete_PER_CM;
1157: -- Issue a savepoint if operating in validation only mode
1158: --
1159: savepoint delete_PER_CM;
1160: --
1161: hr_utility.set_location(l_proc, 20);
1162: --
1163: -- Process Logic
1164: --
1165: l_object_version_number := p_object_version_number;
1268: -- End of API User Hook for the after hook of delete_PER_CM
1269: --
1270: end;
1271: --
1272: hr_utility.set_location(l_proc, 60);
1273: --
1274: -- When in validation only mode raise the Validate_Enabled exception
1275: --
1276: if p_validate then
1276: if p_validate then
1277: raise hr_api.validate_enabled;
1278: end if;
1279: --
1280: hr_utility.set_location(' Leaving:'||l_proc, 70);
1281: --
1282: exception
1283: --
1284: when hr_api.validate_enabled then
1301: --
1302: ROLLBACK TO delete_PER_CM;
1303: p_effective_start_date := null;
1304: p_effective_end_date := null;
1305: hr_utility.set_location(' Leaving:'||l_proc, 90);
1306: raise;
1307: --
1308: end delete_PER_CM;
1309: --
1327: l_validation_end_date date;
1328: --
1329: begin
1330: --
1331: hr_utility.set_location('Entering:'|| l_proc, 10);
1332: --
1333: ben_pcm_shd.lck
1334: (p_per_cm_id => p_per_cm_id
1335: ,p_validation_start_date => l_validation_start_date
1337: ,p_object_version_number => p_object_version_number
1338: ,p_effective_date => p_effective_date
1339: ,p_datetrack_mode => p_datetrack_mode);
1340: --
1341: hr_utility.set_location(' Leaving:'||l_proc, 70);
1342: --
1343: end lck;
1344: --
1345: procedure create_PER_CM_W