APPS.PER_ASR_BUS dependencies on PER_ASSESSMENT_GROUPS

Line 90: (p_name in per_assessment_groups.name%TYPE

86: -- ACCESS STATUS
87: -- Internal Development Use Only
88: --
89: Procedure chk_name_unique
90: (p_name in per_assessment_groups.name%TYPE
91: ,p_assessment_group_id in per_assessment_groups.assessment_group_id%TYPE
92: ,p_business_group_id in per_assessment_groups.business_group_id%TYPE
93: ,p_object_version_number in per_assessment_groups.object_version_number%TYPE
94: ) is

Line 91: ,p_assessment_group_id in per_assessment_groups.assessment_group_id%TYPE

87: -- Internal Development Use Only
88: --
89: Procedure chk_name_unique
90: (p_name in per_assessment_groups.name%TYPE
91: ,p_assessment_group_id in per_assessment_groups.assessment_group_id%TYPE
92: ,p_business_group_id in per_assessment_groups.business_group_id%TYPE
93: ,p_object_version_number in per_assessment_groups.object_version_number%TYPE
94: ) is
95: --

Line 92: ,p_business_group_id in per_assessment_groups.business_group_id%TYPE

88: --
89: Procedure chk_name_unique
90: (p_name in per_assessment_groups.name%TYPE
91: ,p_assessment_group_id in per_assessment_groups.assessment_group_id%TYPE
92: ,p_business_group_id in per_assessment_groups.business_group_id%TYPE
93: ,p_object_version_number in per_assessment_groups.object_version_number%TYPE
94: ) is
95: --
96: l_proc varchar2(72) := g_package||'chk_name_unique';

Line 93: ,p_object_version_number in per_assessment_groups.object_version_number%TYPE

89: Procedure chk_name_unique
90: (p_name in per_assessment_groups.name%TYPE
91: ,p_assessment_group_id in per_assessment_groups.assessment_group_id%TYPE
92: ,p_business_group_id in per_assessment_groups.business_group_id%TYPE
93: ,p_object_version_number in per_assessment_groups.object_version_number%TYPE
94: ) is
95: --
96: l_proc varchar2(72) := g_package||'chk_name_unique';
97: --

Line 102: from per_assessment_groups ag

98: -- Define cusror for duplicate name check
99: --
100: cursor csr_chk_name_unique is
101: select null
102: from per_assessment_groups ag
103: where ((p_assessment_group_id is NULL) -- if the row is being inserted
104: or (p_assessment_group_id <> ag.assessment_group_id))
105: and p_name = ag.name -- there is a duplicate name
106: and p_business_group_id = ag.business_group_id +0 ;

Line 159: (p_constraint_name => 'PER_ASSESSMENT_GROUPS_NAME_UK1');

155: hr_utility.set_location('name not unique:'||l_proc, 5);
156: -- The name already exists in the business group
157: close csr_chk_name_unique;
158: per_asr_shd.constraint_error
159: (p_constraint_name => 'PER_ASSESSMENT_GROUPS_NAME_UK1');
160: end if;
161: close csr_chk_name_unique;
162: --
163: end if;

Line 192: (p_assessment_group_id in per_assessment_groups.assessment_group_id%TYPE

188: -- ACCESS STATUS
189: -- Internal Development Use Only
190: --
191: Procedure chk_ref_rows_asn
192: (p_assessment_group_id in per_assessment_groups.assessment_group_id%TYPE
193: ) is
194: --
195: l_proc varchar2(72):=g_package||'chk_ref_rows_asn';
196: --

Line 312: ,p_descflex_name => 'PER_ASSESSMENT_GROUPS'

308: -- b) During insert.
309: --
310: hr_dflex_utility.ins_or_upd_descflex_attribs
311: (p_appl_short_name => 'PER'
312: ,p_descflex_name => 'PER_ASSESSMENT_GROUPS'
313: ,p_attribute_category => p_rec.attribute_category
314: ,p_attribute1_name => 'ATTRIBUTE1'
315: ,p_attribute1_value => p_rec.attribute1
316: ,p_attribute2_name => 'ATTRIBUTE2'

Line 470: per_assessment_groups pag

466: --
467: cursor csr_leg_code is
468: select legislation_code
469: from per_business_groups pbg,
470: per_assessment_groups pag
471: where pag.assessment_group_id = p_assessment_group_id
472: and pbg.business_group_id = pag.business_group_id;
473:
474: l_proc varchar2(72) := g_package||'return_legislation_code';