[Home] [Help]
31: l_date_to date;
32: --
33: begin
34: --
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Issue a savepoint if operating in validation only mode
38: --
39: savepoint create_noac_remarks;
37: -- Issue a savepoint if operating in validation only mode
38: --
39: savepoint create_noac_remarks;
40: --
41: hr_utility.set_location(l_proc, 20);
42: --
43: -- Process Logic
44: --
45: -- Truncate the time portion from all IN date parameters
113: -- End of API User Hook for the after hook of create_noac_remarks
114: --
115: end;
116: --
117: hr_utility.set_location(l_proc, 60);
118: --
119: -- When in validation only mode raise the Validate_Enabled exception
120: --
121: if p_validate then
126: --
127: p_noac_remark_id := l_noac_remark_id;
128: p_object_version_number := l_object_version_number;
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: --
132: exception
133: --
134: when hr_api.validate_enabled then
143: -- when validation only mode is being used.)
144: --
145: p_noac_remark_id := null;
146: p_object_version_number := null;
147: hr_utility.set_location(' Leaving:'||l_proc, 80);
148: --
149: when others then
150: --
151: -- A validation or unexpected error has occured
179: l_date_to date;
180: --
181: begin
182: --
183: hr_utility.set_location('Entering:'|| l_proc, 10);
184: --
185: -- Issue a savepoint if operating in validation only mode
186: --
187: savepoint update_noac_remarks;
185: -- Issue a savepoint if operating in validation only mode
186: --
187: savepoint update_noac_remarks;
188: --
189: hr_utility.set_location(l_proc, 20);
190: --
191: -- Process Logic
192: --
193: --
265: -- End of API User Hook for the after hook of update_noac_remarks
266: --
267: end;
268: --
269: hr_utility.set_location(l_proc, 60);
270: --
271: -- When in validation only mode raise the Validate_Enabled exception
272: --
273: if p_validate then
277: -- Set all output arguments
278: --
279: p_object_version_number := l_object_version_number;
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 70);
282: --
283: exception
284: --
285: when hr_api.validate_enabled then
292: -- Only set output warning arguments
293: -- (Any key or derived arguments must be set to null
294: -- when validation only mode is being used.)
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 80);
297: --
298: when others then
299: --
300: -- A validation or unexpected error has occured
320: l_object_version_number ghr_noac_remarks.object_version_number%TYPE;
321: --
322: begin
323: --
324: hr_utility.set_location('Entering:'|| l_proc, 10);
325: --
326: -- Issue a savepoint if operating in validation only mode
327: --
328: savepoint delete_noac_remarks;
326: -- Issue a savepoint if operating in validation only mode
327: --
328: savepoint delete_noac_remarks;
329: --
330: hr_utility.set_location(l_proc, 20);
331: --
332: -- Process Logic
333: --
334: l_object_version_number := p_object_version_number;
382: -- End of API User Hook for the after hook of delete_noac_remarks
383: --
384: end;
385: --
386: hr_utility.set_location(l_proc, 60);
387: --
388: -- When in validation only mode raise the Validate_Enabled exception
389: --
390: if p_validate then
390: if p_validate then
391: raise hr_api.validate_enabled;
392: end if;
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 70);
395: --
396: exception
397: --
398: when hr_api.validate_enabled then
432: l_proc varchar2(72) := g_package||'lck';
433: --
434: begin
435: --
436: hr_utility.set_location('Entering:'|| l_proc, 10);
437: --
438: ghr_nre_shd.lck
439: (
440: p_noac_remark_id => p_noac_remark_id
440: p_noac_remark_id => p_noac_remark_id
441: ,p_object_version_number => p_object_version_number
442: );
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 70);
445: --
446: end lck;
447: --
448: end ghr_noac_remarks_api;