40: L_Effective_Date Date;
41: l_Wrkplc_vldtn_Ver_id PQH_DE_WRKPLC_VLDTN_VERS.WRKPLC_VLDTN_VER_ID%TYPE;
42: l_version_Number PQH_DE_WRKPLC_VLDTN_VERS.VERSION_NUMBER%TYPE;
43: begin
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Issue a savepoint
47: --
48: savepoint Insert_Vldtn_Vern;
154: p_wrkplc_vldtn_Ver_id := l_Wrkplc_vldtn_Ver_id;
155: p_object_version_number := l_object_version_number;
156:
157: --
158: hr_utility.set_location(' Leaving:'||l_proc, 70);
159: exception
160: when hr_api.validate_enabled then
161: --
162: -- As the Validate_Enabled exception has been raised
169: -- when validation only mode is being used.)
170: --
171: p_wrkplc_vldtn_Ver_id := null;
172: p_object_version_number := null;
173: hr_utility.set_location(' Leaving:'||l_proc, 80);
174:
175: when others then
176: p_wrkplc_vldtn_Ver_id := null;
177: p_object_version_number := null;
178: --
179: -- A validation or unexpected error has occured
180: --
181: rollback to Insert_Vldtn_Vern;
182: hr_utility.set_location(' Leaving:'||l_proc, 90);
183: raise;
184: end Insert_Vldtn_Vern;
185:
186: --
213: l_object_Version_Number PQH_DE_WRKPLC_VLDTN_VERS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
214: L_Effective_Date Date;
215:
216: Begin
217: hr_utility.set_location('Entering:'|| l_proc, 10);
218: --
219: -- Issue a savepoint
220: --
221: savepoint Update_Vldtn_Vern;
321:
322: p_object_version_number := l_object_version_number;
323:
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised
334: -- Only set output warning arguments
335: -- (Any key or derived arguments must be set to null
336: -- when validation only mode is being used.)
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 80);
339:
340: when others then
341: p_object_version_number := l_object_version_number;
342: --
342: --
343: -- A validation or unexpected error has occured
344: --
345: rollback to Update_Vldtn_Vern;
346: hr_utility.set_location(' Leaving:'||l_proc, 90);
347: raise;
348: end Update_Vldtn_Vern;
349:
350: --
360: --
361: l_proc varchar2(72) := g_package||'delete_Vldtn_Vern';
362: --
363: begin
364: hr_utility.set_location('Entering:'|| l_proc, 10);
365: --
366: -- Issue a savepoint
367: --
368: savepoint delete_Vldtn_Vern;
408: end if;
409: --
410: -- Set all output arguments
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 70);
413: exception
414: when hr_api.validate_enabled then
415: --
416: -- As the Validate_Enabled exception has been raised
421: -- Only set output warning arguments
422: -- (Any key or derived arguments must be set to null
423: -- when validation only mode is being used.)
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 80);
426: when others then
427: --
428: -- A validation or unexpected error has occured
429: --
427: --
428: -- A validation or unexpected error has occured
429: --
430: rollback to delete_Vldtn_Vern;
431: hr_utility.set_location(' Leaving:'||l_proc, 90);
432: raise;
433: end delete_Vldtn_Vern;
434:
435: end PQH_DE_VLDVER_API;