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_OUTCOME_PROFILE_SS dependencies on PER_COMP_ELEMENT_OUTCOMES

Line 22: from per_comp_element_outcomes cmpe

18: ,cmpe.COMPETENCE_ELEMENT_ID
19: ,cmpe.OUTCOME_ID
20: ,cmpe.date_from
21: ,cmpe.date_to
22: from per_comp_element_outcomes cmpe
23: ,per_competence_outcomes_VL cvl
24: where cmpe.comp_element_outcome_id = p_comp_element_outcome_id
25: and cmpe.outcome_id = cvl.outcome_id
26: and trunc(sysdate) between nvl(cmpe.date_from, trunc(sysdate))

Line 34: from per_comp_element_outcomes

30: from per_competence_outcomes_vl
31: where outcome_id = p_outcome_id;
32: cursor get_prev_start_date(p_comp_element_outcome_id in number) is
33: select date_from
34: from per_comp_element_outcomes
35: where comp_element_outcome_id = p_comp_element_outcome_id;
36: cursor get_mode(p_transaction_step_id in number) is
37: select varchar2_value
38: from hr_api_transaction_values

Line 134: l_comp_element_outcome_id per_comp_element_outcomes.comp_element_outcome_id%type;

130: l_trans_tbl transaction_table1;
131: l_count Number:=0;
132: x_trans_ovn Number;
133: l_review_region Varchar2(200);
134: l_comp_element_outcome_id per_comp_element_outcomes.comp_element_outcome_id%type;
135: l_proc varchar2(200);
136: Begin
137: l_proc := g_package || 'writeTo_transTbl';
138: hr_utility.set_location(' Entering:' || l_proc,5);

Line 283: SELECT object_version_number FROM per_comp_element_outcomes

279: ,p_transaction_step_id in out nocopy number
280: ,p_person_id IN number DEFAULT null
281: ,p_error_message out nocopy long) is
282: CURSOR getobjno (p_comp_element_outcome_id IN number) is
283: SELECT object_version_number FROM per_comp_element_outcomes
284: WHERE comp_element_outcome_id = p_comp_element_outcome_id;
285: --
286: l_transaction_id number default null;
287: l_transaction_step_id number default null;

Line 296: l_comp_element_outcome_id per_comp_element_outcomes.comp_element_outcome_id%type;

292: l_preupd_cmpocm_row g_csr_get_preupd_cmpocm_rec%rowtype;
293: --
294: l_date_from date default null;
295: l_obj_ver_num number default null;
296: l_comp_element_outcome_id per_comp_element_outcomes.comp_element_outcome_id%type;
297: l_trans_obj_vers_num NUMBER DEFAULT null;
298: l_proc varchar2(200) ;
299: --
300: ----------------------------------

Line 458: per_comp_element_outcomes ceo,

454: ---
455: Cursor get_enddate_outcome_ids(p_comp_ele_id IN number) is
456: Select ceo.comp_element_outcome_id ,ts.transaction_step_id,ceo.object_version_number
457: FROM
458: per_comp_element_outcomes ceo,
459: hr_api_transaction_steps ts,
460: hr_api_transaction_values tv
461: where
462: ceo.competence_element_id = p_comp_ele_id

Line 477: ,Per_comp_element_outcomes ceo

473: ,ceo.DATE_FROM
474: ,ceo.DATE_TO
475: ,ceo.object_version_number
476: From per_Competence_Outcomes co
477: ,Per_comp_element_outcomes ceo
478: Where ceo.COMPETENCE_ELEMENT_ID = p_comp_ele_id
479: AND co.outcome_id = ceo.outcome_id
480: AND NOT EXISTS (Select 1 FROM hr_api_transaction_values tv1,
481: hr_api_transaction_values tv2,

Line 502: Select 1 from per_comp_element_outcomes pco

498: AND tv3.name = 'P_DATE_TO'
499: AND tv2.date_Value >= co.date_from
500: AND nvl(tv3.date_Value,trunc(sysdate)) <= nvl(co.date_to,nvl(tv3.date_Value,trunc(sysdate)))
501: and not exists (
502: Select 1 from per_comp_element_outcomes pco
503: Where pco.competence_element_id = ceo.COMPETENCE_ELEMENT_ID
504: and pco.outcome_id = co.OUTCOME_ID
505: and pco.date_from = tv2.date_value
506: and nvl(pco.date_to,to_date('01-01-1001','DD-MM-YYYY')) = nvl(tv3.

Line 525: From per_comp_element_outcomes ceo,

521: From per_competence_elements ce
522: Where ce.COMPETENCE_ELEMENT_ID = p_new_comp_ele_id;
523: /* Select ceo.outcome_id,ceo.date_from,ceo.date_to,
524: ce.Effective_date_From,ce.Effective_date_to, ceo.object_version_number
525: From per_comp_element_outcomes ceo,
526: per_competence_elements ce
527: Where ceo.competence_element_id = p_comp_ele_id
528: AND ce.competence_element_id = p_new_comp_ele_id;*/
529: --

Line 536: l_Start_Date per_Comp_Element_Outcomes.Date_from%type;

532: Effective_date_to per_competence_elements.Effective_date_to%TYPE
533: );
534: new_compele_dtl_record new_compele_dtl_rec;
535: l_count number;
536: l_Start_Date per_Comp_Element_Outcomes.Date_from%type;
537: l_End_Date per_Comp_Element_Outcomes.Date_to%type;
538: l_comp_ele_outcome_id per_Comp_Element_Outcomes.comp_Element_Outcome_id%type;
539: l_obj_ver_no number;
540: l_proc varchar2(200) ;

Line 537: l_End_Date per_Comp_Element_Outcomes.Date_to%type;

533: );
534: new_compele_dtl_record new_compele_dtl_rec;
535: l_count number;
536: l_Start_Date per_Comp_Element_Outcomes.Date_from%type;
537: l_End_Date per_Comp_Element_Outcomes.Date_to%type;
538: l_comp_ele_outcome_id per_Comp_Element_Outcomes.comp_Element_Outcome_id%type;
539: l_obj_ver_no number;
540: l_proc varchar2(200) ;
541: begin

Line 538: l_comp_ele_outcome_id per_Comp_Element_Outcomes.comp_Element_Outcome_id%type;

534: new_compele_dtl_record new_compele_dtl_rec;
535: l_count number;
536: l_Start_Date per_Comp_Element_Outcomes.Date_from%type;
537: l_End_Date per_Comp_Element_Outcomes.Date_to%type;
538: l_comp_ele_outcome_id per_Comp_Element_Outcomes.comp_Element_Outcome_id%type;
539: l_obj_ver_no number;
540: l_proc varchar2(200) ;
541: begin
542: -- hr_utility.trace_on(null,'COMPQUAL');

Line 678: FROM per_comp_element_outcomes

674: Select COMPETENCE_ELEMENT_ID ,
675: OUTCOME_ID,
676: DATE_FROM,
677: DATE_TO
678: FROM per_comp_element_outcomes
679: Where comp_element_outcome_id = p_comp_element_outcome_id;
680: l_cmpout_element_rec per_comp_element_outcomes%rowtype;
681: l_system_generated varchar2(1) default null;
682: l_upgraded_from_rec_id number DEFAULT Null;

Line 680: l_cmpout_element_rec per_comp_element_outcomes%rowtype;

676: DATE_FROM,
677: DATE_TO
678: FROM per_comp_element_outcomes
679: Where comp_element_outcome_id = p_comp_element_outcome_id;
680: l_cmpout_element_rec per_comp_element_outcomes%rowtype;
681: l_system_generated varchar2(1) default null;
682: l_upgraded_from_rec_id number DEFAULT Null;
683: l_preupd_proficy_lvl_id number default NULL;
684: l_outcome_name per_competence_outcomes_vl.name%type;

Line 1072: from per_comp_element_outcomes ceo

1068: hr_utility.set_location(' Entering p_date_from:' || p_date_from,105);
1069: x_count :=0;
1070: IF x_comp_ele_out_id IS NULL then
1071: Select count(*) INTO x_count
1072: from per_comp_element_outcomes ceo
1073: where competence_element_id = x_comp_ele_id
1074: and outcome_id = p_outcome_id and
1075: ceo.date_from <= to_date(p_date_from,g_date_format) and
1076: nvl(ceo.date_to,trunc(sysdate)) >= to_date(p_date_from,g_date_format)

Line 1097: from per_comp_element_outcomes ceo

1093: return;
1094: END if;
1095: IF l_date_to IS NULL then
1096: Select count(*) INTO x_count
1097: from per_comp_element_outcomes ceo
1098: where competence_element_id = x_comp_ele_id
1099: and outcome_id = p_outcome_id and
1100: ceo.date_from >= to_date(p_date_from,g_date_format)
1101: AND NOT exists(

Line 1114: from per_comp_element_outcomes ceo

1110: AND C.NUMBER_VALUE = CEO.COMP_ELEMENT_OUTCOME_ID);
1111: hr_utility.set_location(' Entering x_count:' || x_count,108);
1112: else
1113: Select count(*) INTO x_count
1114: from per_comp_element_outcomes ceo
1115: where competence_element_id = x_comp_ele_id
1116: and outcome_id = p_outcome_id and
1117: ceo.date_from >= to_date(p_date_from,g_date_format)
1118: AND ceo.date_from <= to_date(p_date_to,g_date_format)

Line 1731: from per_comp_element_outcomes

1727: ,competence_element_id
1728: ,outcome_id
1729: ,date_from
1730: ,date_to
1731: from per_comp_element_outcomes
1732: where comp_element_outcome_id = p_comp_element_outcome_id;
1733: --
1734: l_changed boolean default null;
1735: l_proc varchar2(200);

Line 1879: per_comp_element_outcomes ceo,

1875: hr_utility.set_location(' Entering:' || l_proc ,10);
1876: SELECT s.transaction_step_id INTO l_txn_step_id
1877: FROM hr_api_transaction_steps S,
1878: hr_api_transaction_values C,
1879: per_comp_element_outcomes ceo,
1880: per_competence_elements pce
1881: Where s.item_type = p_item_type
1882: and s.item_key = p_item_key
1883: and s.activity_id = nvl((p_actid),s.activity_id)

Line 1960: per_comp_element_outcomes ceo

1956: hr_utility.set_location(' Entering:' || l_proc ,30);
1957: SELECT COUNT(*) INTO l_count
1958: FROM hr_api_transaction_steps S,
1959: hr_api_transaction_values C,
1960: per_comp_element_outcomes ceo
1961: Where s.item_type = p_item_type
1962: and s.item_key = p_item_key
1963: and s.activity_id = nvl((p_activity_id),s.activity_id)
1964: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'

Line 2005: per_comp_element_outcomes ceo

2001: CURSOR get_del_tsid is
2002: Select DISTINCT s.transaction_step_id
2003: FROM hr_api_transaction_steps S,
2004: hr_api_transaction_values C,
2005: per_comp_element_outcomes ceo
2006: Where s.item_type = p_item_type
2007: and s.item_key = p_item_key
2008: and s.activity_id = nvl((p_activity_id),s.activity_id)
2009: and s.api_name = 'HR_COMP_OUTCOME_PROFILE_SS.DELETE'