APPS.HR_WPM_UTIL dependencies on HR_UTILITY

Line 1150: hr_utility.set_location('Entering:'||l_proc,10);

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);
1153: OPEN csr_overall_ready;
1154: FETCH csr_overall_ready INTO l_leg_code, l_overall_readiness;

Line 1151: hr_utility.trace('p_legislation_code:'||p_legislation_code);

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);
1153: OPEN csr_overall_ready;
1154: FETCH csr_overall_ready INTO l_leg_code, l_overall_readiness;
1155: CLOSE csr_overall_ready;

Line 1152: hr_utility.trace('Mode:'||p_mode);

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);
1153: OPEN csr_overall_ready;
1154: FETCH csr_overall_ready INTO l_leg_code, l_overall_readiness;
1155: CLOSE csr_overall_ready;
1156: hr_utility.trace('l_overall-readiness:'||l_overall_readiness);

Line 1156: hr_utility.trace('l_overall-readiness:'||l_overall_readiness);

1152: hr_utility.trace('Mode:'||p_mode);
1153: OPEN csr_overall_ready;
1154: FETCH csr_overall_ready INTO l_leg_code, l_overall_readiness;
1155: CLOSE csr_overall_ready;
1156: hr_utility.trace('l_overall-readiness:'||l_overall_readiness);
1157: hr_utility.set_location('Leaving:'||l_proc,20);
1158: RETURN ROUND (NVL (l_overall_readiness, 0), 2);
1159: END get_overall_readiness;
1160:

Line 1157: hr_utility.set_location('Leaving:'||l_proc,20);

1153: OPEN csr_overall_ready;
1154: FETCH csr_overall_ready INTO l_leg_code, l_overall_readiness;
1155: CLOSE csr_overall_ready;
1156: hr_utility.trace('l_overall-readiness:'||l_overall_readiness);
1157: hr_utility.set_location('Leaving:'||l_proc,20);
1158: RETURN ROUND (NVL (l_overall_readiness, 0), 2);
1159: END get_overall_readiness;
1160:
1161: ------

Line 1206: hr_utility.set_location ('Entering:' || l_proc, 10);

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:
1209: OPEN csr_overall_ready;
1210:

Line 1207: hr_utility.TRACE ('p_plan_id:' || p_plan_id);

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:
1209: OPEN csr_overall_ready;
1210:
1211: FETCH csr_overall_ready

Line 1216: hr_utility.TRACE ('l_overall-readiness:' || l_overall_readiness);

1212: INTO l_overall_readiness;
1213:
1214: CLOSE csr_overall_ready;
1215:
1216: hr_utility.TRACE ('l_overall-readiness:' || l_overall_readiness);
1217: hr_utility.set_location ('Leaving:' || l_proc, 20);
1218: RETURN ROUND (NVL (l_overall_readiness, 0), 2);
1219: END get_readiness_by_plan;
1220:

Line 1217: hr_utility.set_location ('Leaving:' || l_proc, 20);

1213:
1214: CLOSE csr_overall_ready;
1215:
1216: hr_utility.TRACE ('l_overall-readiness:' || l_overall_readiness);
1217: hr_utility.set_location ('Leaving:' || l_proc, 20);
1218: RETURN ROUND (NVL (l_overall_readiness, 0), 2);
1219: END get_readiness_by_plan;
1220:
1221: