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

Line 31: , per_comp_element_outcomes ceo

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , per_comp_element_outcomes ceo
32: where ceo.comp_element_outcome_id = p_comp_element_outcome_id;
33: --
34: -- Declare local variables
35: --

Line 100: , per_comp_element_outcomes ceo

96: --
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups_perf pbg
100: , per_comp_element_outcomes ceo
101: where ceo.comp_element_outcome_id = p_comp_element_outcome_id;
102: --
103: -- Declare local variables
104: --

Line 240: ( p_comp_element_outcome_id in per_comp_element_outcomes.comp_element_outcome_id%TYPE

236: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure chk_comp_element_outcome_id
240: ( p_comp_element_outcome_id in per_comp_element_outcomes.comp_element_outcome_id%TYPE
241: ,p_object_version_number in per_comp_element_outcomes.object_version_number%TYPE
242: ) is
243: --
244: l_proc varchar2(72) := g_package||'chk_comp_element_outcome_id';

Line 241: ,p_object_version_number in per_comp_element_outcomes.object_version_number%TYPE

237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure chk_comp_element_outcome_id
240: ( p_comp_element_outcome_id in per_comp_element_outcomes.comp_element_outcome_id%TYPE
241: ,p_object_version_number in per_comp_element_outcomes.object_version_number%TYPE
242: ) is
243: --
244: l_proc varchar2(72) := g_package||'chk_comp_element_outcome_id';
245: l_api_updating boolean;

Line 261: per_ceo_shd.constraint_error('PER_COMP_ELEMENT_OUTCOMES_PK');

257: <> per_ceo_shd.g_old_rec.comp_element_outcome_id) then
258: --
259: -- raise error as PK has changed
260: --
261: per_ceo_shd.constraint_error('PER_COMP_ELEMENT_OUTCOMES_PK');
262: --
263: elsif not l_api_updating then
264: --
265: -- check if PK is null

Line 271: per_ceo_shd.constraint_error('PER_COMP_ELEMENT_OUTCOMES_PK');

267: if p_comp_element_outcome_id is not null then
268: --
269: -- raise error as PK is not null
270: --
271: per_ceo_shd.constraint_error('PER_COMP_ELEMENT_OUTCOMES_PK');
272: --
273: end if;
274: --
275: end if;

Line 528: select 'x' from per_comp_element_outcomes o

524: --
525: -- Declare cursor
526: --
527: cursor csr_uniq_comp_element_outcome is
528: select 'x' from per_comp_element_outcomes o
529: where o.competence_element_id = p_competence_element_id
530: and o.outcome_id = p_outcome_id
531: and p_date_from < nvl(o.date_to,hr_api.g_eot)
532: and nvl(p_date_to,hr_api.g_eot) > o.date_from;

Line 535: select 'x' from per_comp_element_outcomes o

531: and p_date_from < nvl(o.date_to,hr_api.g_eot)
532: and nvl(p_date_to,hr_api.g_eot) > o.date_from;
533:
534: /* cursor csr_upd_uniq_comp_ele_outcome is
535: select 'x' from per_comp_element_outcomes o
536: where o.comp_element_outcome_id = p_comp_element_outcome_id
537: and o.competence_element_id = p_competence_element_id
538: and o.outcome_id = p_outcome_id
539: and p_date_from < nvl(o.date_to,hr_api.g_eot)

Line 545: select 'x' from per_comp_element_outcomes o,per_competence_outcomes co

541:
542: l_outcome_name per_competence_outcomes.name%type;
543:
544: cursor csr_upd_uniq_comp_ele_outcome(p_name per_competence_outcomes.name%type)is
545: select 'x' from per_comp_element_outcomes o,per_competence_outcomes co
546: where o.comp_element_outcome_id <> p_comp_element_outcome_id
547: and o.competence_element_id = p_competence_element_id
548: and co.outcome_id = o.outcome_id
549: and co.name = p_name

Line 600: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');

596: if csr_upd_uniq_comp_ele_outcome%FOUND then
597: close csr_upd_uniq_comp_ele_outcome;
598: hr_utility.set_message(800,'HR_449132_QUA_FWK_OUTCM_EXISTS');
599: hr_multi_message.add
600: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
601:
602: hr_utility.raise_error;
603: end if;
604: close csr_upd_uniq_comp_ele_outcome;

Line 616: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');

612: if csr_uniq_comp_element_outcome%FOUND then
613: close csr_uniq_comp_element_outcome;
614: hr_utility.set_message(800,'HR_449132_QUA_FWK_OUTCM_EXISTS');
615: hr_multi_message.add
616: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
617:
618: hr_utility.raise_error;
619: end if;
620: close csr_uniq_comp_element_outcome;

Line 711: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');

707: --
708: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
709: hr_utility.set_message(800,'HR_6758_APPL_DATE_FROM_CHK');
710: hr_multi_message.add
711: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
712: hr_utility.raise_error;
713: end if;
714: --
715: --

Line 727: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');

723:
724: if p_date_from < nvl( l_outcome_active_date,hr_api.g_eot) then
725: hr_utility.set_message(800,'HR_34724_COMP_OUTCME_DATE_INVL');
726: hr_multi_message.add
727: (p_associated_column1 => 'PER_COMP_ELEMENT_OUTCOMES.DATE_FROM');
728: hr_utility.raise_error;
729: end if;
730: --
731:

Line 959: ,p_descflex_name => 'PER_COMP_ELEMENT_OUTCOMES'

955: -- b) During insert.
956: --
957: hr_dflex_utility.ins_or_upd_descflex_attribs
958: (p_appl_short_name => 'PER'
959: ,p_descflex_name => 'PER_COMP_ELEMENT_OUTCOMES'
960: ,p_attribute_category => p_rec.attribute_category
961: ,p_attribute1_name => 'ATTRIBUTE1'
962: ,p_attribute1_value => p_rec.attribute1
963: ,p_attribute2_name => 'ATTRIBUTE2'

Line 1214: from per_comp_element_outcomes ceo

1210:
1211: cursor csr_get_achieved_number is
1212: select count(ceo.comp_element_outcome_id)
1213: ,max(ceo.date_from)
1214: from per_comp_element_outcomes ceo
1215: where ceo.competence_element_id = p_competence_element_id
1216: -- and p_effective_date between ceo.date_from
1217: -- and nvl(date_to,hr_api.g_eot)
1218: and ceo.outcome_id in (