APPS.HR_OBJECTIVES_SWI dependencies on PER_OBJECTIVES

Line 25: FROM per_objectives

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;

Line 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';

Line 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'

Line 381: l_object_version_number per_objectives.object_version_number%TYPE;

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;

Line 383: cursor get_object_version_number(p_obj_id per_objectives.objective_id%TYPE) is

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

Line 384: select object_version_number from per_objectives

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);

Line 562: from per_objectives

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

Line 783: l_aligned_with_objective_id per_objectives.aligned_with_objective_id%type;

779: l_commitElement xmldom.DOMElement;
780: l_parser xmlparser.Parser;
781: l_CommitNode xmldom.DOMNode;
782: l_proc varchar2(72) := g_package || 'process_api';
783: l_aligned_with_objective_id per_objectives.aligned_with_objective_id%type;
784:
785: cursor chk_aligned_with_obj_id(p_obj_id per_objectives.objective_id%type ) is
786: SELECT aligned_with_objective_id
787: FROM per_objectives

Line 785: cursor chk_aligned_with_obj_id(p_obj_id per_objectives.objective_id%type ) is

781: l_CommitNode xmldom.DOMNode;
782: l_proc varchar2(72) := g_package || 'process_api';
783: l_aligned_with_objective_id per_objectives.aligned_with_objective_id%type;
784:
785: cursor chk_aligned_with_obj_id(p_obj_id per_objectives.objective_id%type ) is
786: SELECT aligned_with_objective_id
787: FROM per_objectives
788: WHERE objective_id = p_obj_id;
789:

Line 787: FROM per_objectives

783: l_aligned_with_objective_id per_objectives.aligned_with_objective_id%type;
784:
785: cursor chk_aligned_with_obj_id(p_obj_id per_objectives.objective_id%type ) is
786: SELECT aligned_with_objective_id
787: FROM per_objectives
788: WHERE objective_id = p_obj_id;
789:
790:
791: BEGIN