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_COMPETENCE_ELEMENTS

Line 31: ,per_competence_elements cmpe

27: ,cmpe.comments
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 (+)

Line 43: from per_rating_levels a,per_competence_elements b

39: select step_value from per_rating_levels
40: where rating_level_id = p_proficiency_level_id;
41: cursor get_previous_step_value(p_competence_element_id in number) is
42: select a.step_value
43: from per_rating_levels a,per_competence_elements b
44: where b.proficiency_level_id = a.rating_level_id(+)
45: and b.competence_element_id = p_competence_element_id;
46: cursor get_prev_prof_lvl_id(p_competence_element_id in number) is
47: select proficiency_level_id

Line 48: from per_competence_elements

44: where b.proficiency_level_id = a.rating_level_id(+)
45: and b.competence_element_id = p_competence_element_id;
46: cursor get_prev_prof_lvl_id(p_competence_element_id in number) is
47: select proficiency_level_id
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

Line 56: from per_competence_elements

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
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

Line 68: FROM per_competence_elements

64: from hr_api_transaction_values
65: where transaction_step_id = p_transaction_step_id and name = 'P_CHANGE_MODE';
66: CURSOR get_prev_status(p_competence_element_id IN number) is
67: SELECT status
68: FROM per_competence_elements
69: WHERE competence_element_id = p_competence_element_id;
70: --
71: -- ------------------------------------------------------------------------
72: -- ----------------------------------------

Line 432: from per_competence_elements

428: If l_mode_value = 'UPGRADE' and p_transaction_step_id is not null then
429: hr_utility.set_location(l_proc,20);
430: select max(effective_date_from)
431: into l_eff_date_from
432: from per_competence_elements
433: where person_id = to_number(p_person_id)
434: and competence_id = p_competence_id group by competence_id;
435: select competence_element_id, object_version_number
436: into l_competence_element_id, l_obj_ver_num

Line 437: from per_competence_elements

433: where person_id = to_number(p_person_id)
434: and competence_id = p_competence_id group by competence_id;
435: select competence_element_id, object_version_number
436: into l_competence_element_id, l_obj_ver_num
437: from per_competence_elements
438: where person_id = to_number(p_person_id)
439: and effective_date_from = l_eff_date_from
440: and competence_id = p_competence_id;
441: End If;

Line 1011: l_cmp_element_rec per_competence_elements%rowtype;

1007: ,p_transaction_step_id in number
1008: ,p_effective_date in varchar2 default null) is
1009: --
1010: l_proc varchar2(200) := g_package || 'process_api';
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;

Line 1020: l_cmp_element_id per_competence_elements.competence_element_id%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;
1020: l_cmp_element_id per_competence_elements.competence_element_id%type;
1021: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;
1022: l_change_mode varchar2(80);
1023: l_status per_competence_elements.status%type;
1024: --

Line 1021: l_achieved_date per_competence_elements.ACHIEVED_DATE%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;
1020: l_cmp_element_id per_competence_elements.competence_element_id%type;
1021: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;
1022: l_change_mode varchar2(80);
1023: l_status per_competence_elements.status%type;
1024: --
1025: Begin

Line 1023: l_status per_competence_elements.status%type;

1019: l_activity_id hr_api_transaction_steps.ACTIVITY_ID%type;
1020: l_cmp_element_id per_competence_elements.competence_element_id%type;
1021: l_achieved_date per_competence_elements.ACHIEVED_DATE%type;
1022: l_change_mode varchar2(80);
1023: l_status per_competence_elements.status%type;
1024: --
1025: Begin
1026: --
1027: hr_utility.set_location(' Entering:' || l_proc,5);

Line 1199: per_competence_elements pce

1195: ELSIF l_cmp_element_rec.competence_element_id is not null THEN
1196: hr_utility.set_location(l_proc,25);
1197: Select pce.status, Achieved_date INTO l_status, l_achieved_date
1198: FROM
1199: per_competence_elements pce
1200: Where pce.competence_element_id = l_cmp_element_rec.competence_element_id;
1201: IF l_status = l_cmp_element_rec.status then
1202: l_cmp_element_rec.achieved_date := l_achieved_date;
1203: END if;

Line 2685: Select 'F' status from per_competence_elements pce

2681: Where c.transaction_step_id = ts.transaction_step_id
2682: and c.name = 'P_COMPETENCE_ID'
2683: and c.number_value = p_competence_id)
2684: union
2685: Select 'F' status from per_competence_elements pce
2686: where pce.person_id = p_person_id
2687: and pce.type = 'PERSONAL'
2688: and trunc(sysdate) between nvl(pce.effective_date_from,sysdate)
2689: and nvl(pce.effective_date_to,sysdate)

Line 2946: from per_competence_elements

2942: begin
2943: hr_utility.set_location( l_proc,15);
2944: select max(effective_date_from)
2945: into l_eff_date_from
2946: from per_competence_elements
2947: where person_id = to_number(p_person_id)
2948: and competence_id = to_number(p_competence_id) group by competence_id;
2949: if l_start_date <= l_eff_date_from then
2950: hr_utility.set_location( l_proc,20);

Line 2980: from per_competence_elements

2976: hr_utility.set_location(' Entering:' || l_proc,5);
2977: l_eff_date_from := to_date(p_eff_date_from,g_date_format);
2978: select effective_date_to
2979: into m_eff_date_to
2980: from per_competence_elements
2981: where person_id = p_person_id
2982: and competence_id = p_competence_id
2983: and effective_date_to < trunc(sysdate);
2984: if SQL%FOUND then

Line 3453: from per_competence_elements

3449: ,next_certification_date
3450: ,source_of_proficiency_level
3451: ,comments
3452: ,status
3453: from per_competence_elements
3454: where competence_element_id = p_competence_element_id;
3455: --
3456: l_changed boolean default null;
3457: --

Line 3684: From per_competence_elements pce, per_all_assignments_f paaf,

3680: l_proc varchar2(200) := g_package || 'get_preferred_prof_range';
3681: Cursor csr_bg_profrange is
3682: Select rl1.step_value || decode(rl1.name, '', '', ' ' || rl1.name) minprof,
3683: rl2.step_value || decode(rl2.name, '', '', ' ' || rl2.name) maxprof
3684: From per_competence_elements pce, per_all_assignments_f paaf,
3685: per_rating_levels rl1, per_rating_levels rl2
3686: Where paaf.person_id = p_person_id
3687: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3688: And pce.enterprise_id = paaf.business_group_id

Line 3697: From per_competence_elements pce, per_all_assignments_f paaf,

3693: And high_proficiency_level_id = rl2.rating_level_id (+);
3694: Cursor csr_job_profrange is
3695: Select rl1.step_value || decode(rl1.name, '', '', ', ' || rl1.name) minprof,
3696: rl2.step_value || decode(rl2.name, '', '', ', ' || rl2.name) maxprof
3697: From per_competence_elements pce, per_all_assignments_f paaf,
3698: per_rating_levels rl1, per_rating_levels rl2
3699: Where paaf.person_id = p_person_id
3700: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3701: And pce.job_id = paaf.job_id

Line 3710: From per_competence_elements pce, per_all_assignments_f paaf,

3706: And high_proficiency_level_id = rl2.rating_level_id (+);
3707: Cursor csr_pos_profrange is
3708: Select rl1.step_value || decode(rl1.name, '', '', ', ' || rl1.name) minprof,
3709: rl2.step_value || decode(rl2.name, '', '', ', ' || rl2.name) maxprof
3710: From per_competence_elements pce, per_all_assignments_f paaf,
3711: per_rating_levels rl1, per_rating_levels rl2
3712: Where paaf.person_id = p_person_id
3713: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3714: And pce.position_id = paaf.position_id

Line 3723: From per_competence_elements pce, per_all_assignments_f paaf,

3719: And high_proficiency_level_id = rl2.rating_level_id (+);
3720: Cursor csr_org_profrange is
3721: Select rl1.step_value || decode(rl1.name, '', '', ', ' || rl1.name) minprof,
3722: rl2.step_value || decode(rl2.name, '', '', ', ' || rl2.name) maxprof
3723: From per_competence_elements pce, per_all_assignments_f paaf,
3724: per_rating_levels rl1, per_rating_levels rl2
3725: Where paaf.person_id = p_person_id
3726: And trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date
3727: And pce.organization_id = paaf.organization_id

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