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.HR_COMP_PROFILE_SS dependencies on PER_COMPETENCES

Line 32: ,per_competences_vl cvl

28: ,cvl.competence_alias
29: ,cmpe.status -- added for Competnce Qualification link enahncement
30: from per_rating_levels ratl
31: ,per_competence_elements cmpe
32: ,per_competences_vl cvl
33: where cmpe.competence_element_id = p_competence_element_id
34: and cmpe.competence_id = cvl.competence_id
35: and cmpe.proficiency_level_id = ratl.rating_level_id (+)
36: and trunc(sysdate) between nvl(cmpe.effective_date_from, trunc(sysdate))

Line 52: from per_competences_vl

48: from per_competence_elements
49: where competence_element_id = p_competence_element_id;
50: cursor get_comp_name(p_competence_id in number) is
51: select name
52: from per_competences_vl
53: where competence_id = p_competence_id;
54: cursor get_prev_start_date(p_competence_element_id in number) is
55: select effective_date_from
56: from per_competence_elements

Line 60: from per_competences_vl

56: from per_competence_elements
57: where competence_element_id = p_competence_element_id;
58: cursor get_comp_alias(p_competence_id in number) is
59: select competence_alias
60: from per_competences_vl
61: where competence_id = p_competence_id;
62: cursor get_mode(p_transaction_step_id in number) is
63: select varchar2_value
64: from hr_api_transaction_values

Line 1015: l_competence_name per_competences_vl.name%type;

1011: l_cmp_element_rec per_competence_elements%rowtype;
1012: l_system_generated varchar2(1) default null;
1013: l_upgraded_from_rec_id number DEFAULT Null;
1014: l_preupd_proficy_lvl_id number default NULL;
1015: l_competence_name per_competences_vl.name%type;
1016: l_step_value per_rating_levels.step_value%type;
1017: l_item_type hr_api_transaction_steps.item_type%type;
1018: l_item_key hr_api_transaction_steps.item_key%type;
1019: l_activity_id hr_api_transaction_steps.ACTIVITY_ID%type;

Line 1348: c_name per_competences.name%TYPE default null;

1344: l_prev_step_value number default null;
1345: l_prev_step_val number default null;
1346: l_prev_prof_lvl_value number default null;
1347: l_prev_prof_lvl_val number default null;
1348: c_name per_competences.name%TYPE default null;
1349: p_competence_name per_competences.name%TYPE default null;
1350: c_comp_alias varchar2(200) default null;
1351: p_competence_alias varchar2(200) default null;
1352: l_prev_date date;

Line 1349: p_competence_name per_competences.name%TYPE default null;

1345: l_prev_step_val number default null;
1346: l_prev_prof_lvl_value number default null;
1347: l_prev_prof_lvl_val number default null;
1348: c_name per_competences.name%TYPE default null;
1349: p_competence_name per_competences.name%TYPE default null;
1350: c_comp_alias varchar2(200) default null;
1351: p_competence_alias varchar2(200) default null;
1352: l_prev_date date;
1353: l_prev_start_date date;

Line 1389: from per_competences_vl

1385: AND f.varchar2_value = p_change_mode ;
1386: Cursor get_comp_dates ( p_competence_id IN Number )is
1387: select date_to end_date,
1388: date_from start_date
1389: from per_competences_vl
1390: where competence_id = p_competence_id;
1391: l_comp_dates_cur get_comp_dates%RowType;
1392: Begin
1393: hr_utility.set_location(' Entering:' || l_proc,5);

Line 2242: from per_competences_vl

2238: into p_competence_name, p_competence_alias
2239: from dual;
2240: --
2241: select name,competence_alias,competence_id into p_competence_name,p_competence_alias,p_competence_id
2242: from per_competences_vl
2243: where upper(name) = p_competence_name or upper(competence_alias) = p_competence_alias
2244: and (business_group_id+0 = p_business_group_id
2245: or business_group_id is null);
2246: hr_utility.set_location(' Leaving:' || l_proc,10);

Line 2268: select competence_id into l_competence_id from per_competences_vl

2264: begin
2265: hr_utility.set_location(' Entering:' || l_proc,5);
2266: if p_competence_name is null and p_competence_alias is not null then
2267: hr_utility.set_location(l_proc,10);
2268: select competence_id into l_competence_id from per_competences_vl
2269: where trim(upper(competence_alias)) = trim(upper(p_competence_alias));
2270: if sql%notfound then
2271: hr_utility.set_location(l_proc,15);
2272: raise g_invalid_competence;

Line 2278: select competence_id into l_competence_id from per_competences_vl

2274: end if;
2275: hr_utility.set_location(l_proc,20);
2276: if p_competence_alias is null and p_competence_name is not null then
2277: hr_utility.set_location(l_proc,25);
2278: select competence_id into l_competence_id from per_competences_vl
2279: where trim(upper(name)) = trim(upper(p_competence_name));
2280: if sql%notfound then
2281: hr_utility.set_location(l_proc,30);
2282: raise g_invalid_competence;

Line 2288: select competence_id into l_competence_id from per_competences_vl

2284: end if;
2285: hr_utility.set_location(l_proc,35);
2286: if ((p_competence_name is not null) and (p_competence_alias is not null)) then
2287: hr_utility.set_location(l_proc,40);
2288: select competence_id into l_competence_id from per_competences_vl
2289: where ( (trim(upper(name))) = (trim(upper(p_competence_name)))) or ((trim(upper(competence_alias))) = (trim(upper(p_competence_alias))) );
2290: if sql%notfound then
2291: hr_utility.set_location(l_proc,45);
2292: raise g_invalid_competence;

Line 2536: from per_competences_vl cvl, per_rating_levels ratl

2532: ,p_error_message => p_error_message);
2533: IF p_step_value IS NOT NULL Then
2534: select ratl.step_value,ratl.rating_level_id
2535: into l_step_value,l_new_prof_level
2536: from per_competences_vl cvl, per_rating_levels ratl
2537: where ((ratl.competence_id = cvl.competence_id and cvl.competence_id = p_competence_id)
2538: or (cvl.rating_scale_id = ratl.rating_scale_id and cvl.competence_id = p_competence_id))
2539: and ratl.step_value = p_step_value;
2540: r_step_value := l_step_value ;

Line 2627: into l_competence_name,l_competence_alias from per_competences_vl

2623: l_proc varchar2(200) := g_package || 'set_name_alias';
2624: begin
2625: hr_utility.set_location(' Entering:' || l_proc,5);
2626: select name,competence_alias
2627: into l_competence_name,l_competence_alias from per_competences_vl
2628: where competence_id = p_competence_id;
2629: hr_utility.set_location(' Leaving:' || l_proc,10);
2630: exception
2631: when others then

Line 2660: from per_competences_vl

2656: l_proc varchar2(200) := g_package || 'set_parameters';
2657: l_count number;
2658: Cursor get_comp_dates ( p_competence_id IN Number )is
2659: select to_date(date_from, g_date_format) start_date
2660: from per_competences_vl
2661: where competence_id = p_competence_id;
2662: --bug 2946360 Fix
2663: cursor c1 is
2664: select 'F' status

Line 2694: l_competence_name per_competences_vl.name%TYPE;

2690: and pce.competence_id = p_competence_id;
2691: l_dup_comp_not_exists varchar(1);
2692: --bug 2946360 Fix
2693: l_comp_dates_cur get_comp_dates%RowType;
2694: l_competence_name per_competences_vl.name%TYPE;
2695: l_competence_alias per_competences_vl.competence_alias%TYPE;
2696: --
2697: begin
2698: hr_utility.set_location(' Entering:' || l_proc,5);

Line 2695: l_competence_alias per_competences_vl.competence_alias%TYPE;

2691: l_dup_comp_not_exists varchar(1);
2692: --bug 2946360 Fix
2693: l_comp_dates_cur get_comp_dates%RowType;
2694: l_competence_name per_competences_vl.name%TYPE;
2695: l_competence_alias per_competences_vl.competence_alias%TYPE;
2696: --
2697: begin
2698: hr_utility.set_location(' Entering:' || l_proc,5);
2699: l_count := 0;

Line 2717: from per_competences_vl

2713: If p_competence_id is not null then
2714: hr_utility.set_location(l_proc,20);
2715: select name, competence_alias
2716: into l_competence_name, l_competence_alias
2717: from per_competences_vl
2718: where competence_id = p_competence_id;
2719: End if;
2720: hr_utility.set_location(l_proc,25);
2721: If (l_competence_name <> p_competence_name or l_competence_alias <> p_competence_alias) Or

Line 2727: from per_competences_vl

2723: Begin
2724: hr_utility.set_location(l_proc,30);
2725: select name, competence_alias, competence_id
2726: into p_competence_name,p_competence_alias,p_competence_id
2727: from per_competences_vl
2728: where upper(name) = nvl(upper(p_competence_name), upper(name))
2729: and nvl(upper(competence_alias),'#') = nvl(upper(p_competence_alias), nvl(upper(competence_alias),'#'))
2730: and (business_group_id+0 = p_business_group_id or business_group_id is null);
2731: Exception when OTHERS then

Line 2747: from per_competences_vl, per_rating_levels

2743: Begin
2744: hr_utility.set_location(l_proc,40);
2745: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2746: into p_step_value,p_prof_level_id
2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id

Line 2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id

2744: hr_utility.set_location(l_proc,40);
2745: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2746: into p_step_value,p_prof_level_id
2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id
2752: or per_competences_vl.business_group_id is null);

Line 2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)

2745: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2746: into p_step_value,p_prof_level_id
2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id
2752: or per_competences_vl.business_group_id is null);
2753: Exception when OTHERS then

Line 2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))

2746: into p_step_value,p_prof_level_id
2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id
2752: or per_competences_vl.business_group_id is null);
2753: Exception when OTHERS then
2754: hr_utility.set_location(l_proc,560);

Line 2751: and (per_competences_vl.business_group_id+0 = p_business_group_id

2747: from per_competences_vl, per_rating_levels
2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id
2752: or per_competences_vl.business_group_id is null);
2753: Exception when OTHERS then
2754: hr_utility.set_location(l_proc,560);
2755: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

Line 2752: or per_competences_vl.business_group_id is null);

2748: where ((per_rating_levels.competence_id = per_competences_vl.competence_id
2749: or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2750: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value))
2751: and (per_competences_vl.business_group_id+0 = p_business_group_id
2752: or per_competences_vl.business_group_id is null);
2753: Exception when OTHERS then
2754: hr_utility.set_location(l_proc,560);
2755: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2756: p_error_message => p_error_message,

Line 2859: from per_competences_vl, per_rating_levels

2855: if p_step_value is not null then
2856: hr_utility.set_location(l_proc,10);
2857: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2858: into l_step_value,l_prof_level_id
2859: from per_competences_vl, per_rating_levels
2860: where ((per_rating_levels.competence_id = per_competences_vl.competence_id or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2861: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value) );
2862: if sql%notfound then
2863: hr_utility.set_location(l_proc,15);

Line 2860: where ((per_rating_levels.competence_id = per_competences_vl.competence_id or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)

2856: hr_utility.set_location(l_proc,10);
2857: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2858: into l_step_value,l_prof_level_id
2859: from per_competences_vl, per_rating_levels
2860: where ((per_rating_levels.competence_id = per_competences_vl.competence_id or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2861: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value) );
2862: if sql%notfound then
2863: hr_utility.set_location(l_proc,15);
2864: raise g_invalid_competence;

Line 2861: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value) );

2857: select per_rating_levels.step_value ,per_rating_levels.rating_level_id
2858: into l_step_value,l_prof_level_id
2859: from per_competences_vl, per_rating_levels
2860: where ((per_rating_levels.competence_id = per_competences_vl.competence_id or per_competences_vl.rating_scale_id = per_rating_levels.rating_scale_id)
2861: and (per_competences_vl.competence_id = p_competence_id) and (per_rating_levels.step_value = p_step_value) );
2862: if sql%notfound then
2863: hr_utility.set_location(l_proc,15);
2864: raise g_invalid_competence;
2865: end if;

Line 3806: From per_competence_elements pce, per_all_assignments_f paaf, per_competences pc

3802: | given person and competence. |
3803: +------------------------------------------------------------*/
3804: Cursor prof_rec is
3805: Select 'Y'
3806: From per_competence_elements pce, per_all_assignments_f paaf, per_competences pc
3807: Where paaf.person_id = p_person_id
3808: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3809: And pc.competence_id = p_competence_id
3810: And pce.competence_id = pc.competence_id