81: select person_id,learning_path_id
82: from ota_training_plans
83: where training_plan_id = crs_id;
84: begin
85: hr_utility.set_location('Entering:'|| l_proc, 10);
86: --
87: -- Issue a savepoint
88: --
89: savepoint CREATE_TRAINING_PLAN;
300: p_learningpath_ids => l_learning_path_id,
301: p_itemkey =>l_item_key);
302: end if;
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 70);
305: exception
306: when hr_api.validate_enabled then
307: --
308: -- As the Validate_Enabled exception has been raised
315: -- when validation only mode is being used.)
316: --
317: p_training_plan_id := null;
318: p_object_version_number := null;
319: hr_utility.set_location(' Leaving:'||l_proc, 80);
320: when others then
321: --
322: -- A validation or unexpected error has occured
323: --
323: --
324: rollback to CREATE_TRAINING_PLAN;
325: p_training_plan_id := null;
326: p_object_version_number := null;
327: hr_utility.set_location(' Leaving:'||l_proc, 90);
328: raise;
329: end create_training_plan;
330: -- ----------------------------------------------------------------------------
331: -- |-------------------------< UPDATE_TRAINING_PLAN >-------------------------|
399: from ota_training_plans
400: where training_plan_id = p_training_plan_id;
401:
402: begin
403: hr_utility.set_location('Entering:'|| l_proc, 10);
404: --
405: -- Issue a savepoint
406: --
407: savepoint UPDATE_TRAINING_PLAN;
604: end if;
605: --
606: -- Set all output arguments
607: --
608: hr_utility.set_location(' Leaving:'||l_proc, 70);
609: exception
610: when hr_api.validate_enabled then
611: --
612: -- As the Validate_Enabled exception has been raised
618: -- (Any key or derived arguments must be set to null
619: -- when validation only mode is being used.)
620: --
621: p_object_version_number := null;
622: hr_utility.set_location(' Leaving:'||l_proc, 80);
623: when others then
624: --
625: -- A validation or unexpected error has occured
626: --
625: -- A validation or unexpected error has occured
626: --
627: rollback to UPDATE_TRAINING_PLAN;
628: p_object_version_number := l_object_version_number;
629: hr_utility.set_location(' Leaving:'||l_proc, 90);
630: raise;
631: end update_training_plan;
632: --
633: -- ----------------------------------------------------------------------------
646: l_budget_version_id number;
647: --
648: --
649: begin
650: hr_utility.set_location('Entering:'|| l_proc, 10);
651: --
652: -- Issue a savepoint
653: --
654: savepoint DELETE_TRAINING_PLAN;
704: --
705: -- Set all output arguments
706: --
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 170);
709: exception
710: when hr_api.validate_enabled then
711: --
712: -- As the Validate_Enabled exception has been raised
717: -- Only set output warning arguments
718: -- (Any key or derived arguments must be set to null
719: -- when validation only mode is being used.)
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 180);
722: when others then
723: --
724: -- A validation or unexpected error has occured
725: --
723: --
724: -- A validation or unexpected error has occured
725: --
726: rollback to DELETE_TRAINING_PLAN;
727: hr_utility.set_location(' Leaving:'||l_proc, 190);
728: raise;
729: end delete_training_plan;
730: --
731: end ota_tps_api;