DBA Data[Home] [Help]

APPS.PER_ASR_INS dependencies on PER_ASR_SHD

Line 47: Procedure insert_dml(p_rec in out per_asr_shd.g_rec_type) is

43: -- Internal Table Handler Use Only.
44: --
45: -- {End Of Comments}
46: -- ----------------------------------------------------------------------------
47: Procedure insert_dml(p_rec in out per_asr_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin

Line 120: per_asr_shd.constraint_error

116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: per_asr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_asr_shd.constraint_error

Line 124: per_asr_shd.constraint_error

120: per_asr_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.parent_integrity_violated Then
123: -- Parent integrity has been violated
124: per_asr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: per_asr_shd.constraint_error

Line 128: per_asr_shd.constraint_error

124: per_asr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: per_asr_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When Others Then
131: Raise;
132: End insert_dml;

Line 171: Procedure pre_insert(p_rec in out per_asr_shd.g_rec_type) is

167: -- Internal Table Handler Use Only.
168: --
169: -- {End Of Comments}
170: -- ----------------------------------------------------------------------------
171: Procedure pre_insert(p_rec in out per_asr_shd.g_rec_type) is
172: --
173: l_proc varchar2(72) := g_package||'pre_insert';
174: --
175: Cursor C_Sel1 is select per_assessment_groups_s.nextval from sys.dual;

Line 222: Procedure post_insert(p_rec in per_asr_shd.g_rec_type) is

218: -- Internal Table Handler Use Only.
219: --
220: -- {End Of Comments}
221: -- ----------------------------------------------------------------------------
222: Procedure post_insert(p_rec in per_asr_shd.g_rec_type) is
223: --
224: l_proc varchar2(72) := g_package||'post_insert';
225: --
226: Begin

Line 277: p_rec in out per_asr_shd.g_rec_type,

273: -- |---------------------------------< ins >----------------------------------|
274: -- ----------------------------------------------------------------------------
275: Procedure ins
276: (
277: p_rec in out per_asr_shd.g_rec_type,
278: p_validate in boolean default false,
279: p_effective_date in date
280: ) is
281: --

Line 365: l_rec per_asr_shd.g_rec_type;

361: p_validate in boolean default false,
362: p_effective_date in date
363: ) is
364: --
365: l_rec per_asr_shd.g_rec_type;
366: l_proc varchar2(72) := g_package||'ins';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);

Line 375: per_asr_shd.convert_args

371: -- Call conversion function to turn arguments into the
372: -- p_rec structure.
373: --
374: l_rec :=
375: per_asr_shd.convert_args
376: (
377: null,
378: p_name,
379: p_business_group_id,