APPS.HR_WPM_UTIL dependencies on HR_WPM_UTIL

Line 1: PACKAGE BODY hr_wpm_util AS

1: PACKAGE BODY hr_wpm_util AS
2: /* $Header: hrwpmutl.pkb 120.38.12020000.4 2012/10/18 12:59:55 venksund ship $*/
3: CURSOR get_latest_appraisal_info (p_person_id IN NUMBER)
4: IS
5: SELECT appraisal_id,

Line 1140: AND hr_wpm_util.is_hipo_key_inplan_worker (ppf.person_id, TRUNC (SYSDATE)) IN

1136: AND sp.plan_id = ssp.plan_id
1137: AND ssd.successee_type(+) = 'EMP'
1138: AND sp.successee_id = ssd.successee_id(+)
1139: AND ssp.successor_id = pa1.person_id
1140: AND hr_wpm_util.is_hipo_key_inplan_worker (ppf.person_id, TRUNC (SYSDATE)) IN
1141: ('Y', 'N')
1142: GROUP BY sp.plan_id, bg.org_information9, NVL (ssd.plan_readiness_rule, 'AVG')))
1143: WHERE legislation_code = p_legislation_code AND overall_readiness = p_mode
1144: GROUP BY legislation_code;

Line 1148: l_proc varchar2(80) :='hr_wpm_util.get_overall_readiness';

1144: GROUP BY legislation_code;
1145:
1146: l_leg_code varchar2(10);
1147: l_overall_readiness NUMBER;
1148: l_proc varchar2(80) :='hr_wpm_util.get_overall_readiness';
1149: BEGIN
1150: hr_utility.set_location('Entering:'||l_proc,10);
1151: hr_utility.trace('p_legislation_code:'||p_legislation_code);
1152: hr_utility.trace('Mode:'||p_mode);

Line 1204: l_proc VARCHAR2 (80) := 'hr_wpm_util.get_overall_readiness';

1200: AND ssp.successor_id = pa1.person_id
1201: GROUP BY sp.plan_id, NVL (ssd.plan_readiness_rule, 'AVG');
1202:
1203: l_overall_readiness NUMBER;
1204: l_proc VARCHAR2 (80) := 'hr_wpm_util.get_overall_readiness';
1205: BEGIN
1206: hr_utility.set_location ('Entering:' || l_proc, 10);
1207: hr_utility.TRACE ('p_plan_id:' || p_plan_id);
1208:

Line 1271: END hr_wpm_util; -- Package spec

1267: RETURN NVL (l_return, 'N');
1268: END is_obj_setting_open;
1269:
1270:
1271: END hr_wpm_util; -- Package spec