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.PER_RTL_BUS dependencies on PER_RATING_LEVELS

Line 101: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE

97: -- Internal Table Handler Use Only.
98: --
99: --
100: procedure chk_rat_comp_bg_exists
101: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
102: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
103: ,p_business_group_id in per_rating_levels.business_group_id%TYPE default null
104: ,p_competence_id in per_rating_levels.competence_id%TYPE
105: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE

Line 102: ,p_object_version_number in per_rating_levels.object_version_number%TYPE

98: --
99: --
100: procedure chk_rat_comp_bg_exists
101: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
102: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
103: ,p_business_group_id in per_rating_levels.business_group_id%TYPE default null
104: ,p_competence_id in per_rating_levels.competence_id%TYPE
105: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
106: )

Line 103: ,p_business_group_id in per_rating_levels.business_group_id%TYPE default null

99: --
100: procedure chk_rat_comp_bg_exists
101: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
102: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
103: ,p_business_group_id in per_rating_levels.business_group_id%TYPE default null
104: ,p_competence_id in per_rating_levels.competence_id%TYPE
105: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
106: )
107: is

Line 104: ,p_competence_id in per_rating_levels.competence_id%TYPE

100: procedure chk_rat_comp_bg_exists
101: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
102: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
103: ,p_business_group_id in per_rating_levels.business_group_id%TYPE default null
104: ,p_competence_id in per_rating_levels.competence_id%TYPE
105: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
106: )
107: is
108: --

Line 105: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE

101: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
102: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
103: ,p_business_group_id in per_rating_levels.business_group_id%TYPE default null
104: ,p_competence_id in per_rating_levels.competence_id%TYPE
105: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
106: )
107: is
108: --
109: l_exists varchar2(1);

Line 112: l_business_group_id per_rating_levels.business_group_id%TYPE;

108: --
109: l_exists varchar2(1);
110: l_api_updating boolean;
111: l_proc varchar2(72) := g_package||'chk_rat_comp_bg_exists';
112: l_business_group_id per_rating_levels.business_group_id%TYPE;
113: --
114: --
115: -- Cursor to check if rating scale exists
116: --

Line 236: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE

232: -- Internal Table Handler Use Only.
233: --
234: --
235: procedure not_used_chk_name
236: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
237: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
238: ,p_name in per_rating_levels.name%TYPE
239: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
240: ,p_competence_id in per_rating_levels.competence_id%TYPE

Line 237: ,p_object_version_number in per_rating_levels.object_version_number%TYPE

233: --
234: --
235: procedure not_used_chk_name
236: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
237: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
238: ,p_name in per_rating_levels.name%TYPE
239: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
240: ,p_competence_id in per_rating_levels.competence_id%TYPE
241: )

Line 238: ,p_name in per_rating_levels.name%TYPE

234: --
235: procedure not_used_chk_name
236: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
237: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
238: ,p_name in per_rating_levels.name%TYPE
239: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
240: ,p_competence_id in per_rating_levels.competence_id%TYPE
241: )
242: is

Line 239: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE

235: procedure not_used_chk_name
236: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
237: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
238: ,p_name in per_rating_levels.name%TYPE
239: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
240: ,p_competence_id in per_rating_levels.competence_id%TYPE
241: )
242: is
243: --

Line 240: ,p_competence_id in per_rating_levels.competence_id%TYPE

236: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
237: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
238: ,p_name in per_rating_levels.name%TYPE
239: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
240: ,p_competence_id in per_rating_levels.competence_id%TYPE
241: )
242: is
243: --
244: l_exists varchar2(1);

Line 252: from per_rating_levels

248: -- Cursor to check if name is unique for rating scale or competence
249: --
250: cursor csr_chk_name_unique is
251: select 'Y'
252: from per_rating_levels
253: where ( (p_rating_level_id is null)
254: or(p_rating_level_id <> rating_level_id)
255: )
256: and name = p_name

Line 332: (p_step_value in per_rating_levels.step_value%TYPE

328: -- Access Status
329: -- Internal Table Handler Use Only.
330: --
331: procedure chk_step_value
332: (p_step_value in per_rating_levels.step_value%TYPE
333: ,p_rating_level_id in per_rating_levels.rating_level_id%TYPE
334: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
335: ,p_competence_id in per_rating_levels.competence_id%TYPE
336: ) is

Line 333: ,p_rating_level_id in per_rating_levels.rating_level_id%TYPE

329: -- Internal Table Handler Use Only.
330: --
331: procedure chk_step_value
332: (p_step_value in per_rating_levels.step_value%TYPE
333: ,p_rating_level_id in per_rating_levels.rating_level_id%TYPE
334: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
335: ,p_competence_id in per_rating_levels.competence_id%TYPE
336: ) is
337: --

Line 334: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE

330: --
331: procedure chk_step_value
332: (p_step_value in per_rating_levels.step_value%TYPE
333: ,p_rating_level_id in per_rating_levels.rating_level_id%TYPE
334: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
335: ,p_competence_id in per_rating_levels.competence_id%TYPE
336: ) is
337: --
338: l_proc varchar2(72) := g_package||' chk_step_value';

Line 335: ,p_competence_id in per_rating_levels.competence_id%TYPE

331: procedure chk_step_value
332: (p_step_value in per_rating_levels.step_value%TYPE
333: ,p_rating_level_id in per_rating_levels.rating_level_id%TYPE
334: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
335: ,p_competence_id in per_rating_levels.competence_id%TYPE
336: ) is
337: --
338: l_proc varchar2(72) := g_package||' chk_step_value';
339: l_api_updating boolean;

Line 349: from per_rating_levels

345: -- Cursor to check if step value is unique for rating scale or competence
346: --
347: cursor csr_chk_step_unique is
348: select 'Y'
349: from per_rating_levels
350: where ( (p_rating_level_id is null)
351: or(p_rating_level_id <> rating_level_id)
352: )
353: and step_value = p_step_value

Line 432: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE

428: -- Access Status
429: -- Internal Table Handler Use Only.
430: --
431: procedure chk_rating_level_add_del
432: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
433: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
434: ,p_competence_id in per_rating_levels.competence_id%TYPE
435: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
436: ,p_mode in varchar2 default null

Line 433: ,p_object_version_number in per_rating_levels.object_version_number%TYPE

429: -- Internal Table Handler Use Only.
430: --
431: procedure chk_rating_level_add_del
432: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
433: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
434: ,p_competence_id in per_rating_levels.competence_id%TYPE
435: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
436: ,p_mode in varchar2 default null
437: ) is

Line 434: ,p_competence_id in per_rating_levels.competence_id%TYPE

430: --
431: procedure chk_rating_level_add_del
432: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
433: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
434: ,p_competence_id in per_rating_levels.competence_id%TYPE
435: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
436: ,p_mode in varchar2 default null
437: ) is
438: --

Line 435: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE

431: procedure chk_rating_level_add_del
432: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
433: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
434: ,p_competence_id in per_rating_levels.competence_id%TYPE
435: ,p_rating_scale_id in per_rating_levels.rating_scale_id%TYPE
436: ,p_mode in varchar2 default null
437: ) is
438: --
439: l_proc varchar2(72) := g_package||'chk_rating_level_add_del';

Line 459: from per_rating_levels rtl, per_competences cp,

455: -- bug fix 4063493
456: -- condition added to cursor to check the competence element type.
457: Cursor csr_chk_competence is
458: select null
459: from per_rating_levels rtl, per_competences cp,
460: per_competence_elements ce
461: where rtl.competence_id = p_competence_id
462: and rtl.competence_id = cp.competence_id
463: and cp.competence_id = ce.competence_id

Line 472: from per_rating_levels rtl,

468: -- in a competence
469: --
470: Cursor csr_chk_rat_competence is
471: select null
472: from per_rating_levels rtl,
473: per_rating_scales rsc,
474: per_competences cp
475: where rtl.rating_scale_id = p_rating_scale_id
476: and rtl.rating_scale_id = rsc.rating_scale_id

Line 484: from per_rating_levels rtl,

480: -- Cursor to check if rating level used in an Assessment Type that is
481: --
482: Cursor csr_chk_ass_types is
483: select null
484: from per_rating_levels rtl,
485: per_rating_scales rsc,
486: per_assessment_types aty
487: where rtl.rating_scale_id = p_rating_scale_id
488: and rtl.rating_scale_id = rsc.rating_scale_id

Line 580: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE

576: -- Bug 3771360 Starts Here
577: -- Desc: Re written the procedure by using the ref cursor to improve the performance
578: --
579: procedure chk_rating_level_in_ele
580: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
581: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
582: ) is
583: --
584: l_proc varchar2(72) := g_package||'chk_rating_level_in_ele';

Line 581: ,p_object_version_number in per_rating_levels.object_version_number%TYPE

577: -- Desc: Re written the procedure by using the ref cursor to improve the performance
578: --
579: procedure chk_rating_level_in_ele
580: (p_rating_level_id in per_rating_levels.rating_level_id%TYPE
581: ,p_object_version_number in per_rating_levels.object_version_number%TYPE
582: ) is
583: --
584: l_proc varchar2(72) := g_package||'chk_rating_level_in_ele';
585: l_api_updating boolean;

Line 605: from per_rating_levels rtl,per_competence_elements perce

601: -- check if rating level is used in competence element
602: hr_utility.set_location (l_proc, 1);
603: l_error := 'N';
604: l_sql_stmt := 'select null
605: from per_rating_levels rtl,per_competence_elements perce
606: where rtl.rating_level_id = '||p_rating_level_id||
607: ' and rtl.rating_level_id = ';
608: l_sql_stmt1 := l_sql_stmt||'perce.rating_level_id';
609:

Line 755: ,p_descflex_name => 'PER_RATING_LEVELS'

751: -- b) During insert.
752: --
753: hr_dflex_utility.ins_or_upd_descflex_attribs
754: (p_appl_short_name => 'PER'
755: ,p_descflex_name => 'PER_RATING_LEVELS'
756: ,p_attribute_category => p_rec.attribute_category
757: ,p_attribute1_name => 'ATTRIBUTE1'
758: ,p_attribute1_value => p_rec.attribute1
759: ,p_attribute2_name => 'ATTRIBUTE2'

Line 981: per_rating_levels prl

977: --
978: cursor csr_leg_code is
979: select legislation_code
980: from per_business_groups pbg,
981: per_rating_levels prl
982: where prl.rating_level_id = p_rating_level_id
983: and pbg.business_group_id = prl.business_group_id;
984:
985: l_proc varchar2(72) := g_package||'return_legislation_code';

Line 993: from per_rating_levels

989: Begin
990: hr_utility.set_location('Entering:'||l_proc, 5);
991: -- ngundura changes for pa requirement
992: select 'Y' into l_business_group_flag
993: from per_rating_levels
994: where rating_level_id = p_rating_level_id
995: and business_group_id is null;
996:
997: if l_business_group_flag = 'Y' then