eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FR_SPEED dependencies on HR_UTILITY

Line 28: HR_UTILITY.set_location('Entering:'||l_proc,10);

24: l_proc VARCHAR2(72) := g_package||'get_increased_index';
25: --
26: BEGIN
27: --
28: HR_UTILITY.set_location('Entering:'||l_proc,10);
29: --
30: OPEN csr_increased_index;
31: FETCH csr_increased_index INTO l_increased_index;
32: CLOSE csr_increased_index;

Line 34: HR_UTILITY.set_location('Leaving:'||l_proc,20);

30: OPEN csr_increased_index;
31: FETCH csr_increased_index INTO l_increased_index;
32: CLOSE csr_increased_index;
33: --
34: HR_UTILITY.set_location('Leaving:'||l_proc,20);
35: --
36: RETURN l_increased_index;
37: --
38: END get_increased_index;

Line 62: HR_UTILITY.set_location('Entering:'||l_proc,10);

58: l_proc VARCHAR2(72) := g_package||'chk_notify';
59: --
60: BEGIN
61: --
62: HR_UTILITY.set_location('Entering:'||l_proc,10);
63: --
64: l_notify := NULL;
65: --
66: IF p_mgr_id IS NULL THEN

Line 94: HR_UTILITY.set_location('Leaving:'||l_proc,20);

90: END IF;
91: --
92: END IF;
93: --
94: HR_UTILITY.set_location('Leaving:'||l_proc,20);
95: --
96: RETURN l_notify;
97: --
98: END chk_notify;

Line 137: HR_UTILITY.set_location('Entering:'||l_proc,10);

133: l_proc VARCHAR2(72) := g_package||'get_appraisal';
134: --
135: BEGIN
136: --
137: HR_UTILITY.set_location('Entering:'||l_proc,10);
138: --
139: l_appraisal_type := NULL;
140: OPEN csr_appraisal_type;
141: FETCH csr_appraisal_type INTO l_appraisal_type;

Line 162: HR_UTILITY.set_location('Leaving:'||l_proc,20);

158: CLOSE csr_appraisal;
159: END IF;
160: END IF;
161: --
162: HR_UTILITY.set_location('Leaving:'||l_proc,20);
163: --
164: RETURN l_appraisal_id;
165: --
166: END get_appraisal;

Line 186: HR_UTILITY.set_location('Entering:'||l_proc,10);

182: l_proc VARCHAR2(72) := g_package||'get_marks';
183: --
184: BEGIN
185: --
186: HR_UTILITY.set_location('Entering:'||l_proc,10);
187: --
188: l_marks := 0;
189: OPEN csr_assessment;
190: FETCH csr_assessment INTO l_assessment_id;

Line 200: HR_UTILITY.set_location('Leaving:'||l_proc,20);

196: IF csr_assessment%ISOPEN THEN
197: CLOSE csr_assessment;
198: END IF;
199: --
200: HR_UTILITY.set_location('Leaving:'||l_proc,20);
201: --
202: l_marks := ROUND(l_marks,2); --Rounding to 2 decimal places.
203: --
204: RETURN l_marks;

Line 277: HR_UTILITY.set_location('Entering:'||l_proc,10);

273: l_proc VARCHAR2(72) := g_package||'chk_speed_quota';
274: --
275: BEGIN
276: --
277: HR_UTILITY.set_location('Entering:'||l_proc,10);
278: --
279: p_num_allowed := 0;
280: p_return_status := 'S';
281: IF p_speed <> 'MIN' THEN

Line 339: HR_UTILITY.set_location('Leaving:'||l_proc,20);

335: p_return_status := l_speed_quota_chk;
336: --
337: END IF;
338: --
339: HR_UTILITY.set_location('Leaving:'||l_proc,20);
340: --
341: END chk_speed_quota;
342: --
343: ------------------------------------------------------------------------------

Line 360: HR_UTILITY.set_location('Entering:'||l_proc,10);

356: l_proc VARCHAR2(72) := g_package||'update_speed';
357: --
358: BEGIN
359: --
360: HR_UTILITY.set_location('Entering:'||l_proc,10);
361: --
362: l_ovn := p_ovn;
363: --
364: HR_UTILITY.set_location('OVN before update: '||l_ovn,20);

Line 364: HR_UTILITY.set_location('OVN before update: '||l_ovn,20);

360: HR_UTILITY.set_location('Entering:'||l_proc,10);
361: --
362: l_ovn := p_ovn;
363: --
364: HR_UTILITY.set_location('OVN before update: '||l_ovn,20);
365: --
366: l_datetrack_mode := PQH_FR_UTILITY.get_datetrack_mode(p_eff_dt
367: ,'PER_SPINAL_POINT_PLACEMENTS_F'
368: ,'PLACEMENT_ID'

Line 371: HR_UTILITY.set_location('l_datetrack_mode: '||l_datetrack_mode,30);

367: ,'PER_SPINAL_POINT_PLACEMENTS_F'
368: ,'PLACEMENT_ID'
369: ,p_place_id);
370: --
371: HR_UTILITY.set_location('l_datetrack_mode: '||l_datetrack_mode,30);
372: --
373: HR_SP_PLACEMENT_API.update_spp(p_effective_date => p_eff_dt
374: ,p_datetrack_mode => l_datetrack_mode
375: ,p_placement_id => p_place_id

Line 381: HR_UTILITY.set_location('OVN after update: '||l_ovn,40);

377: ,p_object_version_number => l_ovn
378: ,p_effective_start_date => p_eff_st_dt
379: ,p_effective_end_date => p_eff_end_dt);
380: --
381: HR_UTILITY.set_location('OVN after update: '||l_ovn,40);
382: --
383: HR_UTILITY.set_location('Leaving:'||l_proc,50);
384: --
385: END update_speed;

Line 383: HR_UTILITY.set_location('Leaving:'||l_proc,50);

379: ,p_effective_end_date => p_eff_end_dt);
380: --
381: HR_UTILITY.set_location('OVN after update: '||l_ovn,40);
382: --
383: HR_UTILITY.set_location('Leaving:'||l_proc,50);
384: --
385: END update_speed;
386: --
387: ------------------------------------------------------------------------------

Line 410: HR_UTILITY.set_location('Entering:'||l_proc,10);

406: l_proc VARCHAR2(72) := g_package||'notify_manager';
407: --
408: BEGIN
409: --
410: HR_UTILITY.set_location('Entering:'||l_proc,10);
411: --
412: SELECT PQH_WORKFLOW_ITEM_KEY_S.nextval INTO l_itemKey FROM dual;
413: l_itemKey := 'FRPS'||l_itemKey;
414: --

Line 485: HR_UTILITY.set_location('Leaving:'||l_proc,20);

481: WF_ENGINE.StartProcess(p_itemtype,l_itemkey);
482: --
483: COMMIT;
484: --
485: HR_UTILITY.set_location('Leaving:'||l_proc,20);
486: --
487: END notify_manager;
488: --
489: ------------------------------------------------------------------------------

Line 553: HR_UTILITY.set_location('Entering:'||l_proc,10);

549: l_proc VARCHAR2(72) := g_package||'chk_speed_length';
550: --
551: BEGIN
552: --
553: HR_UTILITY.set_location('Entering:'||l_proc,10);
554: --
555: OPEN csr_step_dtls;
556: FETCH csr_step_dtls INTO l_grade_id,l_step_id,l_speed_cd,l_step_los_mon,l_step_los_day,l_speed_start_dt;
557: IF csr_step_dtls%NOTFOUND THEN

Line 561: HR_UTILITY.set_location('Leaving:'||l_proc,20);

557: IF csr_step_dtls%NOTFOUND THEN
558: CLOSE csr_step_dtls;
559: l_return_cd := 'N'; --Assignment not found. Return Failure.
560: --
561: HR_UTILITY.set_location('Leaving:'||l_proc,20);
562: --
563: RETURN l_return_cd;
564: END IF;
565: IF csr_step_dtls%ISOPEN THEN

Line 572: HR_UTILITY.set_location('Leaving:'||l_proc,20);

568: --
569: IF l_step_id IS NULL OR l_speed_cd IS NULL THEN
570: l_return_cd := 'N'; --Person not on Step or Speed not set for Person. Return Failure.
571: --
572: HR_UTILITY.set_location('Leaving:'||l_proc,20);
573: --
574: RETURN l_return_cd;
575: ELSE
576: --

Line 583: HR_UTILITY.set_location('Leaving:'||l_proc,20);

579: IF csr_speed_length%NOTFOUND THEN
580: CLOSE csr_speed_length;
581: l_return_cd := 'Y'; --Speed Lengths not defined in Corps Setup. Return Success.
582: --
583: HR_UTILITY.set_location('Leaving:'||l_proc,20);
584: --
585: RETURN l_return_cd;
586: END IF;
587: IF csr_speed_length%ISOPEN THEN

Line 644: HR_UTILITY.set_location('Leaving:'||l_proc,20);

640: END IF;
641: --
642: END IF;
643: --
644: HR_UTILITY.set_location('Leaving:'||l_proc,20);
645: --
646: RETURN l_return_cd;
647: --
648: END chk_speed_length;

Line 668: HR_UTILITY.set_location('Entering:'||l_proc,10);

664: --Variable Declarations.
665: l_proc VARCHAR2(72) := g_package||'get_mgr_user';
666: BEGIN
667: --
668: HR_UTILITY.set_location('Entering:'||l_proc,10);
669: --
670: OPEN csr_fnduser;
671: FETCH csr_fnduser INTO p_mgr_username;
672: IF csr_fnduser%NOTFOUND THEN

Line 677: HR_UTILITY.set_location('Leaving:'||l_proc,20);

673: p_mgr_username := 'N';
674: END IF;
675: CLOSE csr_fnduser;
676: --
677: HR_UTILITY.set_location('Leaving:'||l_proc,20);
678: --
679: END get_mgr_user;
680: --
681: --