DBA Data[Home] [Help]

APPS.PER_RTL_INS dependencies on PER_RTL_SHD

Line 47: Procedure insert_dml(p_rec in out nocopy per_rtl_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 nocopy per_rtl_shd.g_rec_type) is
48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin

Line 124: per_rtl_shd.constraint_error

120: hr_utility.set_location(' Leaving:'||l_proc, 10);
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: per_rtl_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: per_rtl_shd.constraint_error

Line 128: per_rtl_shd.constraint_error

124: per_rtl_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: per_rtl_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: per_rtl_shd.constraint_error

Line 132: per_rtl_shd.constraint_error

128: per_rtl_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: per_rtl_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: Raise;
136: End insert_dml;

Line 175: Procedure pre_insert(p_rec in out nocopy per_rtl_shd.g_rec_type) is

171: -- Internal Table Handler Use Only.
172: --
173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure pre_insert(p_rec in out nocopy per_rtl_shd.g_rec_type) is
176: --
177: l_proc varchar2(72) := g_package||'pre_insert';
178: --
179: Cursor C_Sel1 is select per_rating_levels_s.nextval from sys.dual;

Line 226: Procedure post_insert(p_rec in per_rtl_shd.g_rec_type) is

222: -- Internal Table Handler Use Only.
223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure post_insert(p_rec in per_rtl_shd.g_rec_type) is
227: --
228: l_proc varchar2(72) := g_package||'post_insert';
229: --
230: Begin

Line 284: p_rec in out nocopy per_rtl_shd.g_rec_type,

280: -- |---------------------------------< ins >----------------------------------|
281: -- ----------------------------------------------------------------------------
282: Procedure ins
283: (
284: p_rec in out nocopy per_rtl_shd.g_rec_type,
285: p_effective_date in date default null,
286: p_validate in boolean default false
287: ) is
288: --

Line 373: l_rec per_rtl_shd.g_rec_type;

369: p_effective_date in date ,
370: p_validate in boolean default false
371: ) is
372: --
373: l_rec per_rtl_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'ins';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);

Line 383: per_rtl_shd.convert_args

379: -- Call conversion function to turn arguments into the
380: -- p_rec structure.
381: --
382: l_rec :=
383: per_rtl_shd.convert_args
384: (
385: null,
386: p_business_group_id,
387: p_step_value,