DBA Data[Home] [Help]

APPS.PER_PDM_INS dependencies on PER_PDM_SHD

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

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

Line 130: per_pdm_shd.constraint_error

126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: per_pdm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_pdm_shd.constraint_error

Line 134: per_pdm_shd.constraint_error

130: per_pdm_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_pdm_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_pdm_shd.constraint_error

Line 138: per_pdm_shd.constraint_error

134: per_pdm_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.unique_integrity_violated Then
137: -- Unique integrity has been violated
138: per_pdm_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: Raise;
142: End insert_dml;

Line 181: Procedure pre_insert(p_rec in out nocopy per_pdm_shd.g_rec_type) is

177: -- Internal Row Handler Use Only.
178: --
179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure pre_insert(p_rec in out nocopy per_pdm_shd.g_rec_type) is
182: --
183: l_proc varchar2(72) := g_package||'pre_insert';
184: --
185: Cursor C_Sel1 is select per_person_dlvry_methods_s.nextval from sys.dual;

Line 233: p_effective_date in date,p_rec in per_pdm_shd.g_rec_type) is

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure post_insert(
233: p_effective_date in date,p_rec in per_pdm_shd.g_rec_type) is
234: --
235: l_proc varchar2(72) := g_package||'post_insert';
236: --
237: Begin

Line 304: p_rec in out nocopy per_pdm_shd.g_rec_type

300: -- ----------------------------------------------------------------------------
301: Procedure ins
302: (
303: p_effective_date in date,
304: p_rec in out nocopy per_pdm_shd.g_rec_type
305: ) is
306: --
307: l_proc varchar2(72) := g_package||'ins';
308: --

Line 369: l_rec per_pdm_shd.g_rec_type;

365: p_attribute19 in varchar2 default null,
366: p_attribute20 in varchar2 default null
367: ) is
368: --
369: l_rec per_pdm_shd.g_rec_type;
370: l_proc varchar2(72) := g_package||'ins';
371: --
372: Begin
373: hr_utility.set_location('Entering:'||l_proc, 5);

Line 379: per_pdm_shd.convert_args

375: -- Call conversion function to turn arguments into the
376: -- p_rec structure.
377: --
378: l_rec :=
379: per_pdm_shd.convert_args
380: (
381: null,
382: p_date_start,
383: p_date_end,