[Home] [Help]
47: l_object_version_number pqp_analyzed_alien_details.object_version_number%TYPE;
48: --
49: begin
50: --
51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Issue a savepoint if operating in validation only mode
54: --
55: savepoint create_analyzed_alien_det;
53: -- Issue a savepoint if operating in validation only mode
54: --
55: savepoint create_analyzed_alien_det;
56: --
57: hr_utility.set_location(l_proc, 20);
58: --
59: -- Process Logic
60: --
61: begin
177: -- End of API User Hook for the after hook of create_analyzed_alien_det
178: --
179: end;
180: --
181: hr_utility.set_location(l_proc, 60);
182: --
183: -- When in validation only mode raise the Validate_Enabled exception
184: --
185: if p_validate then
190: --
191: p_analyzed_data_details_id := l_analyzed_data_details_id;
192: p_object_version_number := l_object_version_number;
193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 70);
195: --
196: exception
197: --
198: when hr_api.validate_enabled then
207: -- when validation only mode is being used.)
208: --
209: p_analyzed_data_details_id := null;
210: p_object_version_number := null;
211: hr_utility.set_location(' Leaving:'||l_proc, 80);
212: --
213: when others then
214: --
215: -- A validation or unexpected error has occured
217: ROLLBACK TO create_analyzed_alien_det;
218: p_analyzed_data_details_id := null;
219: p_object_version_number := null;
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 90);
222:
223: raise;
224: --
225: end create_analyzed_alien_det;
264: l_object_version_number pqp_analyzed_alien_details.object_version_number%TYPE;
265: --
266: begin
267: --
268: hr_utility.set_location('Entering:'|| l_proc, 10);
269: --
270: -- Issue a savepoint if operating in validation only mode
271: --
272: savepoint update_analyzed_alien_det;
270: -- Issue a savepoint if operating in validation only mode
271: --
272: savepoint update_analyzed_alien_det;
273: --
274: hr_utility.set_location(l_proc, 20);
275: --
276: -- Process Logic
277: --
278: l_object_version_number := p_object_version_number;
397: -- End of API User Hook for the after hook of update_analyzed_alien_det
398: --
399: end;
400: --
401: hr_utility.set_location(l_proc, 60);
402: --
403: -- When in validation only mode raise the Validate_Enabled exception
404: --
405: if p_validate then
409: -- Set all output arguments
410: --
411: p_object_version_number := l_object_version_number;
412: --
413: hr_utility.set_location(' Leaving:'||l_proc, 70);
414: --
415: exception
416: --
417: when hr_api.validate_enabled then
424: -- Only set output warning arguments
425: -- (Any key or derived arguments must be set to null
426: -- when validation only mode is being used.)
427: --
428: hr_utility.set_location(' Leaving:'||l_proc, 80);
429: --
430: when others then
431: --
432: -- A validation or unexpected error has occured
432: -- A validation or unexpected error has occured
433: --
434: ROLLBACK TO update_analyzed_alien_det;
435: p_object_version_number := l_object_version_number;
436: hr_utility.set_location(' Leaving:'||l_proc, 90);
437: raise;
438: --
439: end update_analyzed_alien_det;
440: -- ----------------------------------------------------------------------------
454: l_object_version_number pqp_analyzed_alien_details.object_version_number%TYPE;
455: --
456: begin
457: --
458: hr_utility.set_location('Entering:'|| l_proc, 10);
459: --
460: -- Issue a savepoint if operating in validation only mode
461: --
462: savepoint delete_analyzed_alien_det;
460: -- Issue a savepoint if operating in validation only mode
461: --
462: savepoint delete_analyzed_alien_det;
463: --
464: hr_utility.set_location(l_proc, 20);
465: --
466: -- Process Logic
467: --
468: l_object_version_number := p_object_version_number;
516: -- End of API User Hook for the after hook of delete_analyzed_alien_det
517: --
518: end;
519: --
520: hr_utility.set_location(l_proc, 60);
521: --
522: -- When in validation only mode raise the Validate_Enabled exception
523: --
524: if p_validate then
524: if p_validate then
525: raise hr_api.validate_enabled;
526: end if;
527: --
528: hr_utility.set_location(' Leaving:'||l_proc, 70);
529: --
530: exception
531: --
532: when hr_api.validate_enabled then
567: l_proc varchar2(72) := g_package||'lck';
568: --
569: begin
570: --
571: hr_utility.set_location('Entering:'|| l_proc, 10);
572: --
573: pqp_det_shd.lck
574: (
575: p_analyzed_data_details_id => p_analyzed_data_details_id
575: p_analyzed_data_details_id => p_analyzed_data_details_id
576: ,p_object_version_number => p_object_version_number
577: );
578: --
579: hr_utility.set_location(' Leaving:'||l_proc, 70);
580: --
581: end lck;
582: --
583: end pqp_analyzed_alien_det_api;