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_GRS_BUS dependencies on PER_CAGR_GRADE_STRUCTURES

Line 58: per_grs_shd.constraint_error('PER_CAGR_GRADE_STRUCTURES_PK');

54: <> per_grs_shd.g_old_rec.cagr_grade_structure_id) then
55: --
56: -- raise error as PK has changed
57: --
58: per_grs_shd.constraint_error('PER_CAGR_GRADE_STRUCTURES_PK');
59: --
60: elsif not l_api_updating then
61: --
62: -- check if PK is null

Line 68: per_grs_shd.constraint_error('PER_CAGR_GRADE_STRUCTURES_PK');

64: if p_cagr_grade_structure_id is not null then
65: --
66: -- raise error as PK is not null
67: --
68: per_grs_shd.constraint_error('PER_CAGR_GRADE_STRUCTURES_PK');
69: --
70: end if;
71: --
72: end if;

Line 108: (p_collective_agreement_id in per_cagr_grade_structures.collective_agreement_id%TYPE

104: -- {End of Comments}
105: --
106: -- -----------------------------------------------------------------------
107: Procedure chk_collective_agreement_id
108: (p_collective_agreement_id in per_cagr_grade_structures.collective_agreement_id%TYPE
109: ) is
110: --
111: l_proc varchar2(72) := g_package||'chk_collective_agreement_id';
112: l_exists varchar2(2);

Line 258: (p_id_flex_num in per_cagr_grade_structures.id_flex_num%TYPE,

254: -- {End of Comments}
255: --
256: -- -----------------------------------------------------------------------
257: Procedure chk_comb_flex_cagr
258: (p_id_flex_num in per_cagr_grade_structures.id_flex_num%TYPE,
259: p_collective_agreement_id in per_cagr_grade_structures.collective_agreement_id%TYPE
260: ) is
261: --
262: l_proc varchar2(72) := g_package||'chk_comb_flex_cagr';

Line 259: p_collective_agreement_id in per_cagr_grade_structures.collective_agreement_id%TYPE

255: --
256: -- -----------------------------------------------------------------------
257: Procedure chk_comb_flex_cagr
258: (p_id_flex_num in per_cagr_grade_structures.id_flex_num%TYPE,
259: p_collective_agreement_id in per_cagr_grade_structures.collective_agreement_id%TYPE
260: ) is
261: --
262: l_proc varchar2(72) := g_package||'chk_comb_flex_cagr';
263: l_exists varchar2(2);

Line 269: from per_cagr_grade_structures pcg

265: -- Cursor to check that ID_FLEX_NUM exists
266: --
267: cursor csr_comb_flex_cagr is
268: select '1'
269: from per_cagr_grade_structures pcg
270: where pcg.id_flex_num = p_id_flex_num
271: and pcg.collective_agreement_id = p_collective_agreement_id;
272: --
273: begin

Line 402: ,p_descflex_name => 'PER_CAGR_GRADE_STRUCTURES'

398: -- b) During insert.
399: --
400: hr_dflex_utility.ins_or_upd_descflex_attribs
401: (p_appl_short_name => 'PER'
402: ,p_descflex_name => 'PER_CAGR_GRADE_STRUCTURES'
403: ,p_attribute_category => p_rec.attribute_category
404: ,p_attribute1_name => 'ATTRIBUTE1'
405: ,p_attribute1_value => p_rec.attribute1
406: ,p_attribute2_name => 'ATTRIBUTE2'

Line 477: (p_cagr_grade_structure_id in per_cagr_grade_structures.cagr_grade_structure_id%TYPE

473: -- Access Status:
474: -- Internal Row Handler Use Only.
475: --
476: procedure chk_dynamic_insert_allowed
477: (p_cagr_grade_structure_id in per_cagr_grade_structures.cagr_grade_structure_id%TYPE
478: ,p_dynamic_insert_allowed in per_cagr_grade_structures.dynamic_insert_allowed%TYPE
479: ,p_effective_date in date
480: ,p_object_version_number in per_cagr_grade_structures.object_version_number%TYPE
481: ) is

Line 478: ,p_dynamic_insert_allowed in per_cagr_grade_structures.dynamic_insert_allowed%TYPE

474: -- Internal Row Handler Use Only.
475: --
476: procedure chk_dynamic_insert_allowed
477: (p_cagr_grade_structure_id in per_cagr_grade_structures.cagr_grade_structure_id%TYPE
478: ,p_dynamic_insert_allowed in per_cagr_grade_structures.dynamic_insert_allowed%TYPE
479: ,p_effective_date in date
480: ,p_object_version_number in per_cagr_grade_structures.object_version_number%TYPE
481: ) is
482: --

Line 480: ,p_object_version_number in per_cagr_grade_structures.object_version_number%TYPE

476: procedure chk_dynamic_insert_allowed
477: (p_cagr_grade_structure_id in per_cagr_grade_structures.cagr_grade_structure_id%TYPE
478: ,p_dynamic_insert_allowed in per_cagr_grade_structures.dynamic_insert_allowed%TYPE
479: ,p_effective_date in date
480: ,p_object_version_number in per_cagr_grade_structures.object_version_number%TYPE
481: ) is
482: --
483: l_proc varchar2(72) := g_package||'chk_dynamic_insert_allowed';
484: l_exists varchar2(1);