APPS.HR_WPM_UTIL dependencies on PER_OBJECTIVES

Line 185: p_obj_id IN per_objectives.objective_id%TYPE,

181: ------
182: -- Function to return the LOS icon enabled/disabled from view and track objective.
183: ------
184: FUNCTION is_los_enabled (
185: p_obj_id IN per_objectives.objective_id%TYPE,
186: p_align_id IN per_objectives.aligned_with_objective_id%TYPE
187: )
188: RETURN VARCHAR2
189: IS

Line 186: p_align_id IN per_objectives.aligned_with_objective_id%TYPE

182: -- Function to return the LOS icon enabled/disabled from view and track objective.
183: ------
184: FUNCTION is_los_enabled (
185: p_obj_id IN per_objectives.objective_id%TYPE,
186: p_align_id IN per_objectives.aligned_with_objective_id%TYPE
187: )
188: RETURN VARCHAR2
189: IS
190: l_up_hierarchy_enable VARCHAR2 (1);

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

208:
209: ------
210: -- Function to return if there is objective hierarchy DOWN the LOS
211: ------
212: FUNCTION is_down_hierarchy_enabled (p_obj_id IN per_objectives.objective_id%TYPE)
213: RETURN VARCHAR2
214: IS
215: CURSOR get_objectives_down (c_obj_id IN per_objectives.objective_id%TYPE)
216: IS

Line 215: CURSOR get_objectives_down (c_obj_id IN per_objectives.objective_id%TYPE)

211: ------
212: FUNCTION is_down_hierarchy_enabled (p_obj_id IN per_objectives.objective_id%TYPE)
213: RETURN VARCHAR2
214: IS
215: CURSOR get_objectives_down (c_obj_id IN per_objectives.objective_id%TYPE)
216: IS
217: SELECT 'Y'
218: FROM DUAL
219: WHERE EXISTS (SELECT 'X'

Line 220: FROM per_objectives

216: IS
217: SELECT 'Y'
218: FROM DUAL
219: WHERE EXISTS (SELECT 'X'
220: FROM per_objectives
221: WHERE aligned_with_objective_id = c_obj_id); -- 8789635 bug fix changes
222:
223: RESULT VARCHAR2 (1) DEFAULT NULL;
224: BEGIN

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

238:
239: ------
240: -- Function to return if there is objective hierarchy UP the LOS
241: ------
242: FUNCTION is_up_hierarchy_enabled (p_align_id IN per_objectives.objective_id%TYPE)
243: RETURN VARCHAR2
244: IS
245: CURSOR get_objectives_up (c_align_id IN per_objectives.aligned_with_objective_id%TYPE)
246: IS

Line 245: CURSOR get_objectives_up (c_align_id IN per_objectives.aligned_with_objective_id%TYPE)

241: ------
242: FUNCTION is_up_hierarchy_enabled (p_align_id IN per_objectives.objective_id%TYPE)
243: RETURN VARCHAR2
244: IS
245: CURSOR get_objectives_up (c_align_id IN per_objectives.aligned_with_objective_id%TYPE)
246: IS
247: SELECT DISTINCT 'Y' AS enabled
248: FROM per_objectives
249: WHERE objective_id = c_align_id;

Line 248: FROM per_objectives

244: IS
245: CURSOR get_objectives_up (c_align_id IN per_objectives.aligned_with_objective_id%TYPE)
246: IS
247: SELECT DISTINCT 'Y' AS enabled
248: FROM per_objectives
249: WHERE objective_id = c_align_id;
250:
251: RESULT VARCHAR2 (1) DEFAULT NULL;
252: BEGIN