[Home] [Help]
48: l_object_version_number pqh_budgets.object_version_number%TYPE;
49: --
50: begin
51: --
52: hr_utility.set_location('Entering:'|| l_proc, 10);
53: --
54: -- Issue a savepoint if operating in validation only mode
55: --
56: savepoint create_budget;
54: -- Issue a savepoint if operating in validation only mode
55: --
56: savepoint create_budget;
57: --
58: hr_utility.set_location(l_proc, 20);
59: --
60: -- Process Logic
61: --
62: begin
181: -- End of API User Hook for the after hook of create_budget
182: --
183: end;
184: --
185: hr_utility.set_location(l_proc, 60);
186: --
187: -- When in validation only mode raise the Validate_Enabled exception
188: --
189: if p_validate then
194: --
195: p_budget_id := l_budget_id;
196: p_object_version_number := l_object_version_number;
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 70);
199: --
200: exception
201: --
202: when hr_api.validate_enabled then
211: -- when validation only mode is being used.)
212: --
213: p_budget_id := null;
214: p_object_version_number := null;
215: hr_utility.set_location(' Leaving:'||l_proc, 80);
216: --
217: when others then
218: p_budget_id := null;
219: p_object_version_number := null;
266: l_object_version_number pqh_budgets.object_version_number%TYPE;
267: --
268: begin
269: --
270: hr_utility.set_location('Entering:'|| l_proc, 10);
271: --
272: -- Issue a savepoint if operating in validation only mode
273: --
274: savepoint update_budget;
272: -- Issue a savepoint if operating in validation only mode
273: --
274: savepoint update_budget;
275: --
276: hr_utility.set_location(l_proc, 20);
277: --
278: -- Process Logic
279: --
280: l_object_version_number := p_object_version_number;
402: -- End of API User Hook for the after hook of update_budget
403: --
404: end;
405: --
406: hr_utility.set_location(l_proc, 60);
407: --
408: -- When in validation only mode raise the Validate_Enabled exception
409: --
410: if p_validate then
414: -- Set all output arguments
415: --
416: p_object_version_number := l_object_version_number;
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 70);
419: --
420: exception
421: --
422: when hr_api.validate_enabled then
429: -- Only set output warning arguments
430: -- (Any key or derived arguments must be set to null
431: -- when validation only mode is being used.)
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 80);
434: --
435: when others then
436: p_object_version_number := l_object_version_number;
437: --
458: l_object_version_number pqh_budgets.object_version_number%TYPE;
459: --
460: begin
461: --
462: hr_utility.set_location('Entering:'|| l_proc, 10);
463: --
464: -- Issue a savepoint if operating in validation only mode
465: --
466: savepoint delete_budget;
464: -- Issue a savepoint if operating in validation only mode
465: --
466: savepoint delete_budget;
467: --
468: hr_utility.set_location(l_proc, 20);
469: --
470: -- Process Logic
471: --
472: l_object_version_number := p_object_version_number;
520: -- End of API User Hook for the after hook of delete_budget
521: --
522: end;
523: --
524: hr_utility.set_location(l_proc, 60);
525: --
526: -- When in validation only mode raise the Validate_Enabled exception
527: --
528: if p_validate then
528: if p_validate then
529: raise hr_api.validate_enabled;
530: end if;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 70);
533: --
534: exception
535: --
536: when hr_api.validate_enabled then
570: l_proc varchar2(72) := g_package||'lck';
571: --
572: begin
573: --
574: hr_utility.set_location('Entering:'|| l_proc, 10);
575: --
576: PQH_BGT_shd.lck
577: (
578: p_budget_id => p_budget_id
578: p_budget_id => p_budget_id
579: ,p_object_version_number => p_object_version_number
580: );
581: --
582: hr_utility.set_location(' Leaving:'||l_proc, 70);
583: --
584: end lck;
585: --
586: end pqh_budgets_api;