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_CPO_BUS dependencies on PER_COMPETENCE_OUTCOMES

Line 31: , per_competence_outcomes cpo

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_competence_outcomes cpo
32: where cpo.outcome_id = p_outcome_id;
33: --
34: -- Declare local variables
35: --

Line 100: , per_competence_outcomes cpo

96: --
97: cursor csr_leg_code is
98: select pbg.legislation_code
99: from per_business_groups_perf pbg
100: , per_competence_outcomes cpo
101: where cpo.outcome_id = p_outcome_id;
102: --
103: -- Declare local variables
104: --

Line 239: ( p_outcome_id in per_competence_outcomes.outcome_id%TYPE

235: --
236: -- {End Of Comments}
237: -- ----------------------------------------------------------------------------
238: Procedure chk_outcome_id
239: ( p_outcome_id in per_competence_outcomes.outcome_id%TYPE
240: ,p_object_version_number in per_competence_outcomes.object_version_number%TYPE
241: ) is
242: --
243: l_proc varchar2(72) := g_package||'chk_outcome_id';

Line 240: ,p_object_version_number in per_competence_outcomes.object_version_number%TYPE

236: -- {End Of Comments}
237: -- ----------------------------------------------------------------------------
238: Procedure chk_outcome_id
239: ( p_outcome_id in per_competence_outcomes.outcome_id%TYPE
240: ,p_object_version_number in per_competence_outcomes.object_version_number%TYPE
241: ) is
242: --
243: l_proc varchar2(72) := g_package||'chk_outcome_id';
244: l_api_updating boolean;

Line 260: per_cpo_shd.constraint_error('PER_COMPETENCE_OUTCOMES_PK');

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

Line 270: per_cpo_shd.constraint_error('PER_COMPETENCE_OUTCOMES_PK');

266: if p_outcome_id is not null then
267: --
268: -- raise error as PK is not null
269: --
270: per_cpo_shd.constraint_error('PER_COMPETENCE_OUTCOMES_PK');
271: --
272: end if;
273: --
274: end if;

Line 424: select null from per_competence_outcomes

420: --
421: -- Declare cursor
422: --
423: cursor csr_outcome_number is
424: select null from per_competence_outcomes
425: where competence_id = p_competence_id
426: and outcome_number = p_outcome_number
427: and (p_date_from <= nvl(date_to, hr_api.g_eot)
428: and NVL(p_date_to, hr_api.g_eot) >= date_from);

Line 431: select null from per_competence_outcomes

427: and (p_date_from <= nvl(date_to, hr_api.g_eot)
428: and NVL(p_date_to, hr_api.g_eot) >= date_from);
429:
430: cursor csr_upd_outcome_number is
431: select null from per_competence_outcomes
432: where outcome_id <> p_outcome_id
433: and competence_id = p_competence_id
434: and outcome_number = p_outcome_number
435: and (p_date_from <= nvl(date_to, hr_api.g_eot)

Line 553: select null from per_competence_outcomes

549: --
550: -- Declare cursor
551: --
552: cursor csr_name is
553: select null from per_competence_outcomes
554: where competence_id = p_competence_id
555: and name = p_name
556: and (p_date_from <= nvl(date_to, hr_api.g_eot)
557: and NVL(p_date_to, hr_api.g_eot) >= date_from);

Line 560: select null from per_competence_outcomes

556: and (p_date_from <= nvl(date_to, hr_api.g_eot)
557: and NVL(p_date_to, hr_api.g_eot) >= date_from);
558:
559: cursor csr_upd_name is
560: select null from per_competence_outcomes
561: where outcome_id <> p_outcome_id
562: and competence_id = p_competence_id
563: and name = p_name
564: and (p_date_from <= nvl(date_to, hr_api.g_eot)

Line 744: p_outcome_id in per_competence_outcomes.outcome_id%TYPE

740: -- {End Of Comments}
741: -- ----------------------------------------------------------------------------
742: --
743: PROCEDURE chk_delete(
744: p_outcome_id in per_competence_outcomes.outcome_id%TYPE
745: ) is
746: --
747: l_proc varchar2(72) := g_package||'chk_delete';
748: l_exists varchar2(1);

Line 1003: ,p_descflex_name => 'PER_COMPETENCE_OUTCOMES'

999: -- b) During insert.
1000: --
1001: hr_dflex_utility.ins_or_upd_descflex_attribs
1002: (p_appl_short_name => 'PER'
1003: ,p_descflex_name => 'PER_COMPETENCE_OUTCOMES'
1004: ,p_attribute_category => p_rec.attribute_category
1005: ,p_attribute1_name => 'ATTRIBUTE1'
1006: ,p_attribute1_value => p_rec.attribute1
1007: ,p_attribute2_name => 'ATTRIBUTE2'