DBA Data[Home] [Help]

APPS.PER_PHN_INS dependencies on PER_PHN_SHD

Line 67: Procedure insert_dml(p_rec in out nocopy per_phn_shd.g_rec_type) is

63: -- Internal Table Handler Use Only.
64: --
65: -- {End Of Comments}
66: -- ----------------------------------------------------------------------------
67: Procedure insert_dml(p_rec in out nocopy per_phn_shd.g_rec_type) is
68: --
69: l_proc varchar2(72) := g_package||'insert_dml';
70: --
71: Begin

Line 168: per_phn_shd.constraint_error

164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: per_phn_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.parent_integrity_violated Then
171: -- Parent integrity has been violated
172: per_phn_shd.constraint_error

Line 172: per_phn_shd.constraint_error

168: per_phn_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When hr_api.parent_integrity_violated Then
171: -- Parent integrity has been violated
172: per_phn_shd.constraint_error
173: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
174: When hr_api.unique_integrity_violated Then
175: -- Unique integrity has been violated
176: per_phn_shd.constraint_error

Line 176: per_phn_shd.constraint_error

172: per_phn_shd.constraint_error
173: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
174: When hr_api.unique_integrity_violated Then
175: -- Unique integrity has been violated
176: per_phn_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When Others Then
179: Raise;
180: End insert_dml;

Line 219: Procedure pre_insert(p_rec in out nocopy per_phn_shd.g_rec_type) is

215: -- Internal Table Handler Use Only.
216: --
217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure pre_insert(p_rec in out nocopy per_phn_shd.g_rec_type) is
220: --
221: l_proc varchar2(72) := g_package||'pre_insert';
222: l_exists varchar2(1);
223: --

Line 300: Procedure post_insert(p_rec in per_phn_shd.g_rec_type,

296: -- Internal Table Handler Use Only.
297: --
298: -- {End Of Comments}
299: -- ----------------------------------------------------------------------------
300: Procedure post_insert(p_rec in per_phn_shd.g_rec_type,
301: p_effective_date in date ) is
302: --
303: l_proc varchar2(72) := g_package||'post_insert';
304: --

Line 374: p_rec in out nocopy per_phn_shd.g_rec_type,

370: -- |---------------------------------< ins >----------------------------------|
371: -- ----------------------------------------------------------------------------
372: Procedure ins
373: (
374: p_rec in out nocopy per_phn_shd.g_rec_type,
375: p_validate in boolean default false,
376: p_effective_date in date
377: ) is
378: --

Line 485: l_rec per_phn_shd.g_rec_type;

481: p_validate in boolean default false,
482: p_effective_date in date
483: ) is
484: --
485: l_rec per_phn_shd.g_rec_type;
486: l_proc varchar2(72) := g_package||'ins';
487: --
488: Begin
489: hr_utility.set_location('Entering:'||l_proc, 5);

Line 495: per_phn_shd.convert_args

491: -- Call conversion function to turn arguments into the
492: -- p_rec structure.
493: --
494: l_rec :=
495: per_phn_shd.convert_args
496: (
497: null,
498: p_date_from,
499: p_date_to,