[Home] [Help]
73: l_object_version_number pqp_alien_transaction_data.object_version_number%TYPE;
74: --
75: begin
76: --
77: hr_utility.set_location('Entering:'|| l_proc, 10);
78: --
79: -- Issue a savepoint if operating in validation only mode
80: --
81: savepoint create_alien_trans_data;
79: -- Issue a savepoint if operating in validation only mode
80: --
81: savepoint create_alien_trans_data;
82: --
83: hr_utility.set_location(l_proc, 20);
84: --
85: -- Process Logic
86: --
87: begin
281: -- End of API User Hook for the after hook of create_alien_trans_data
282: --
283: end;
284: --
285: hr_utility.set_location(l_proc, 60);
286: --
287: -- When in validation only mode raise the Validate_Enabled exception
288: --
289: if p_validate then
294: --
295: p_alien_transaction_id := l_alien_transaction_id;
296: p_object_version_number := l_object_version_number;
297: --
298: hr_utility.set_location(' Leaving:'||l_proc, 70);
299: --
300: exception
301: --
302: when hr_api.validate_enabled then
311: -- when validation only mode is being used.)
312: --
313: p_alien_transaction_id := null;
314: p_object_version_number := null;
315: hr_utility.set_location(' Leaving:'||l_proc, 80);
316: --
317: when others then
318: --
319: -- A validation or unexpected error has occured
322: ROLLBACK TO create_alien_trans_data;
323:
324: p_alien_transaction_id := null;
325: p_object_version_number := null;
326: hr_utility.set_location(' Leaving:'||l_proc, 90);
327: raise;
328: --
329: end create_alien_trans_data;
330: -- ----------------------------------------------------------------------------
394: l_object_version_number pqp_alien_transaction_data.object_version_number%TYPE;
395: --
396: begin
397: --
398: hr_utility.set_location('Entering:'|| l_proc, 10);
399: --
400: -- Issue a savepoint if operating in validation only mode
401: --
402: savepoint update_alien_trans_data;
400: -- Issue a savepoint if operating in validation only mode
401: --
402: savepoint update_alien_trans_data;
403: --
404: hr_utility.set_location(l_proc, 20);
405: --
406: -- Process Logic
407: --
408: l_object_version_number := p_object_version_number;
605: -- End of API User Hook for the after hook of update_alien_trans_data
606: --
607: end;
608: --
609: hr_utility.set_location(l_proc, 60);
610: --
611: -- When in validation only mode raise the Validate_Enabled exception
612: --
613: if p_validate then
617: -- Set all output arguments
618: --
619: p_object_version_number := l_object_version_number;
620: --
621: hr_utility.set_location(' Leaving:'||l_proc, 70);
622: --
623: exception
624: --
625: when hr_api.validate_enabled then
632: -- Only set output warning arguments
633: -- (Any key or derived arguments must be set to null
634: -- when validation only mode is being used.)
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 80);
637: --
638: when others then
639: --
640: -- A validation or unexpected error has occured
640: -- A validation or unexpected error has occured
641: --
642: ROLLBACK TO update_alien_trans_data;
643: p_object_version_number := l_object_version_number;
644: hr_utility.set_location(' Leaving:'||l_proc, 90);
645: raise;
646: --
647: end update_alien_trans_data;
648: -- ----------------------------------------------------------------------------
662: l_object_version_number pqp_alien_transaction_data.object_version_number%TYPE;
663: --
664: begin
665: --
666: hr_utility.set_location('Entering:'|| l_proc, 10);
667: --
668: -- Issue a savepoint if operating in validation only mode
669: --
670: savepoint delete_alien_trans_data;
668: -- Issue a savepoint if operating in validation only mode
669: --
670: savepoint delete_alien_trans_data;
671: --
672: hr_utility.set_location(l_proc, 20);
673: --
674: -- Process Logic
675: --
676: l_object_version_number := p_object_version_number;
724: -- End of API User Hook for the after hook of delete_alien_trans_data
725: --
726: end;
727: --
728: hr_utility.set_location(l_proc, 60);
729: --
730: -- When in validation only mode raise the Validate_Enabled exception
731: --
732: if p_validate then
732: if p_validate then
733: raise hr_api.validate_enabled;
734: end if;
735: --
736: hr_utility.set_location(' Leaving:'||l_proc, 70);
737: --
738: exception
739: --
740: when hr_api.validate_enabled then
775: l_proc varchar2(72) := g_package||'lck';
776: --
777: begin
778: --
779: hr_utility.set_location('Entering:'|| l_proc, 10);
780: --
781: pqp_atd_shd.lck
782: (
783: p_alien_transaction_id => p_alien_transaction_id
783: p_alien_transaction_id => p_alien_transaction_id
784: ,p_object_version_number => p_object_version_number
785: );
786: --
787: hr_utility.set_location(' Leaving:'||l_proc, 70);
788: --
789: end lck;
790: --
791: end pqp_alien_trans_data_api;