APPS.HR_WPM_UTIL dependencies on PER_OBJECTIVES

Line 28: FUNCTION is_los_enabled (p_obj_id IN per_objectives.objective_id%TYPE, p_align_id IN per_objectives.aligned_with_objective_id%TYPE)

24: END;
25: ------
26: -- Function to return the LOS icon enabled/disabled from view and track objective.
27: ------
28: FUNCTION is_los_enabled (p_obj_id IN per_objectives.objective_id%TYPE, p_align_id IN per_objectives.aligned_with_objective_id%TYPE)
29: RETURN varchar2
30: IS
31: l_up_hierarchy_enable varchar2(1);
32: l_down_hierarchy_enable varchar2(1);

Line 50: FUNCTION is_down_hierarchy_enabled (p_obj_id IN per_objectives.objective_id%TYPE)

46: END;
47: ------
48: -- Function to return if there is objective hierarchy DOWN the LOS
49: ------
50: FUNCTION is_down_hierarchy_enabled (p_obj_id IN per_objectives.objective_id%TYPE)
51: RETURN varchar2
52: IS
53: cursor get_objectives_down(c_obj_id IN per_objectives.objective_id%TYPE)
54: is

Line 53: cursor get_objectives_down(c_obj_id IN per_objectives.objective_id%TYPE)

49: ------
50: FUNCTION is_down_hierarchy_enabled (p_obj_id IN per_objectives.objective_id%TYPE)
51: RETURN varchar2
52: IS
53: cursor get_objectives_down(c_obj_id IN per_objectives.objective_id%TYPE)
54: is
55: select distinct 'Y' as enabled
56: from per_objectives
57: where aligned_with_objective_id = c_obj_id;

Line 56: from per_objectives

52: IS
53: cursor get_objectives_down(c_obj_id IN per_objectives.objective_id%TYPE)
54: is
55: select distinct 'Y' as enabled
56: from per_objectives
57: where aligned_with_objective_id = c_obj_id;
58:
59: result varchar2(1) default null;
60: BEGIN

Line 75: FUNCTION is_up_hierarchy_enabled (p_align_id IN per_objectives.objective_id%TYPE)

71:
72: ------
73: -- Function to return if there is objective hierarchy UP the LOS
74: ------
75: FUNCTION is_up_hierarchy_enabled (p_align_id IN per_objectives.objective_id%TYPE)
76: RETURN varchar2
77: IS
78: cursor get_objectives_up(c_align_id IN per_objectives.aligned_with_objective_id%TYPE)
79: is

Line 78: cursor get_objectives_up(c_align_id IN per_objectives.aligned_with_objective_id%TYPE)

74: ------
75: FUNCTION is_up_hierarchy_enabled (p_align_id IN per_objectives.objective_id%TYPE)
76: RETURN varchar2
77: IS
78: cursor get_objectives_up(c_align_id IN per_objectives.aligned_with_objective_id%TYPE)
79: is
80: select distinct 'Y' as enabled
81: from per_objectives
82: where objective_id = c_align_id;

Line 81: from per_objectives

77: IS
78: cursor get_objectives_up(c_align_id IN per_objectives.aligned_with_objective_id%TYPE)
79: is
80: select distinct 'Y' as enabled
81: from per_objectives
82: where objective_id = c_align_id;
83:
84: result varchar2(1) default null;
85: BEGIN