34: l_object_version_number pqh_worksheets.object_version_number%TYPE;
35: --
36: begin
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: -- Issue a savepoint if operating in validation only mode
41: --
42: savepoint create_WORKSHEET;
40: -- Issue a savepoint if operating in validation only mode
41: --
42: savepoint create_WORKSHEET;
43: --
44: hr_utility.set_location(l_proc, 20);
45: --
46: -- Process Logic
47: --
48: begin
125: -- End of API User Hook for the after hook of create_WORKSHEET
126: --
127: end;
128: --
129: hr_utility.set_location(l_proc, 60);
130: --
131: -- When in validation only mode raise the Validate_Enabled exception
132: --
133: if p_validate then
138: --
139: p_worksheet_id := l_worksheet_id;
140: p_object_version_number := l_object_version_number;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: --
144: exception
145: --
146: when hr_api.validate_enabled then
155: -- when validation only mode is being used.)
156: --
157: p_worksheet_id := null;
158: p_object_version_number := null;
159: hr_utility.set_location(' Leaving:'||l_proc, 80);
160: --
161: when others then
162: p_worksheet_id := null;
163: p_object_version_number := null;
196: l_object_version_number pqh_worksheets.object_version_number%TYPE;
197: --
198: begin
199: --
200: hr_utility.set_location('Entering:'|| l_proc, 10);
201: --
202: -- Issue a savepoint if operating in validation only mode
203: --
204: savepoint update_WORKSHEET;
202: -- Issue a savepoint if operating in validation only mode
203: --
204: savepoint update_WORKSHEET;
205: --
206: hr_utility.set_location(l_proc, 20);
207: --
208: -- Process Logic
209: --
210: l_object_version_number := p_object_version_number;
290: -- End of API User Hook for the after hook of update_WORKSHEET
291: --
292: end;
293: --
294: hr_utility.set_location(l_proc, 60);
295: --
296: -- When in validation only mode raise the Validate_Enabled exception
297: --
298: if p_validate then
302: -- Set all output arguments
303: --
304: p_object_version_number := l_object_version_number;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 70);
307: --
308: exception
309: --
310: when hr_api.validate_enabled then
317: -- Only set output warning arguments
318: -- (Any key or derived arguments must be set to null
319: -- when validation only mode is being used.)
320: --
321: hr_utility.set_location(' Leaving:'||l_proc, 80);
322: --
323: when others then
324: p_object_version_number := l_object_version_number;
325: --
346: l_object_version_number pqh_worksheets.object_version_number%TYPE;
347: --
348: begin
349: --
350: hr_utility.set_location('Entering:'|| l_proc, 10);
351: --
352: -- Issue a savepoint if operating in validation only mode
353: --
354: savepoint delete_WORKSHEET;
352: -- Issue a savepoint if operating in validation only mode
353: --
354: savepoint delete_WORKSHEET;
355: --
356: hr_utility.set_location(l_proc, 20);
357: --
358: -- Process Logic
359: --
360: l_object_version_number := p_object_version_number;
408: -- End of API User Hook for the after hook of delete_WORKSHEET
409: --
410: end;
411: --
412: hr_utility.set_location(l_proc, 60);
413: --
414: -- When in validation only mode raise the Validate_Enabled exception
415: --
416: if p_validate then
416: if p_validate then
417: raise hr_api.validate_enabled;
418: end if;
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 70);
421: --
422: exception
423: --
424: when hr_api.validate_enabled then
458: l_proc varchar2(72) := g_package||'lck';
459: --
460: begin
461: --
462: hr_utility.set_location('Entering:'|| l_proc, 10);
463: --
464: pqh_wks_shd.lck
465: (
466: p_worksheet_id => p_worksheet_id
466: p_worksheet_id => p_worksheet_id
467: ,p_object_version_number => p_object_version_number
468: );
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 70);
471: --
472: end lck;
473: --
474: end pqh_WORKSHEETS_api;