21: cursor chk_obj_shared is
22: SELECT scorecard_id
23: ,sharing_access_code
24: ,object_version_number
25: FROM per_objectives
26: WHERE objective_id = p_aligned_with_obj_id;
27:
28: l_mgr_scorecard_id number;
29: l_access_code per_objectives.sharing_access_code%TYPE;
25: FROM per_objectives
26: WHERE objective_id = p_aligned_with_obj_id;
27:
28: l_mgr_scorecard_id number;
29: l_access_code per_objectives.sharing_access_code%TYPE;
30: l_mgr_obj_ovn number;
31: l_weightin_over_warn boolean :=FALSE;
32: l_weightin_appraisal_warn boolean :=FALSE;
33: l_align_access per_objectives.sharing_access_code%TYPE := 'ALIGN';
29: l_access_code per_objectives.sharing_access_code%TYPE;
30: l_mgr_obj_ovn number;
31: l_weightin_over_warn boolean :=FALSE;
32: l_weightin_appraisal_warn boolean :=FALSE;
33: l_align_access per_objectives.sharing_access_code%TYPE := 'ALIGN';
34: --
35: cursor chk_shr_instance(p_mgr_scorecard_id in number)
36: is
37: SELECT 'Y'
377: -- Variables for IN/OUT parameters
378: --
379: -- Other variables
380: l_proc varchar2(72) := g_package ||'delete_objective';
381: l_object_version_number per_objectives.object_version_number%TYPE;
382:
383: cursor get_object_version_number(p_obj_id per_objectives.objective_id%TYPE) is
384: select object_version_number from per_objectives
385: where objective_id = p_obj_id;
379: -- Other variables
380: l_proc varchar2(72) := g_package ||'delete_objective';
381: l_object_version_number per_objectives.object_version_number%TYPE;
382:
383: cursor get_object_version_number(p_obj_id per_objectives.objective_id%TYPE) is
384: select object_version_number from per_objectives
385: where objective_id = p_obj_id;
386:
387: Begin
380: l_proc varchar2(72) := g_package ||'delete_objective';
381: l_object_version_number per_objectives.object_version_number%TYPE;
382:
383: cursor get_object_version_number(p_obj_id per_objectives.objective_id%TYPE) is
384: select object_version_number from per_objectives
385: where objective_id = p_obj_id;
386:
387: Begin
388: hr_utility.set_location(' Entering:' || l_proc,10);
558: t_scorecard_id number;
559:
560: cursor get_obj_info is
561: select copied_from_objective_id, aligned_with_objective_id, scorecard_id, appraisal_id
562: from per_objectives
563: where objective_id = p_objective_id;
564:
565: --
566: -- Other variables