DBA Data[Home] [Help]

APPS.PER_APT_INS dependencies on PER_APT_SHD

Line 71: Procedure insert_dml(p_rec in out nocopy per_apt_shd.g_rec_type) is

67: -- Internal Table Handler Use Only.
68:
69: -- {End Of Comments}
70: -- ---------------------------------------------------------------------------+
71: Procedure insert_dml(p_rec in out nocopy per_apt_shd.g_rec_type) is
72:
73: l_proc varchar2(72) := g_package||'insert_dml';
74:
75: Begin

Line 201: per_apt_shd.constraint_error

197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: per_apt_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
204: -- Parent integrity has been violated
205: per_apt_shd.constraint_error

Line 205: per_apt_shd.constraint_error

201: per_apt_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
204: -- Parent integrity has been violated
205: per_apt_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.unique_integrity_violated Then
208: -- Unique integrity has been violated
209: per_apt_shd.constraint_error

Line 209: per_apt_shd.constraint_error

205: per_apt_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.unique_integrity_violated Then
208: -- Unique integrity has been violated
209: per_apt_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: Raise;
213: End insert_dml;

Line 252: Procedure pre_insert(p_rec in out nocopy per_apt_shd.g_rec_type) is

248: -- Internal Table Handler Use Only.
249:
250: -- {End Of Comments}
251: -- ---------------------------------------------------------------------------+
252: Procedure pre_insert(p_rec in out nocopy per_apt_shd.g_rec_type) is
253:
254: l_proc varchar2(72) := g_package||'pre_insert';
255: l_exists varchar2(1);
256:

Line 327: Procedure post_insert(p_rec in per_apt_shd.g_rec_type) is

323: -- Internal Table Handler Use Only.
324:
325: -- {End Of Comments}
326: -- ---------------------------------------------------------------------------+
327: Procedure post_insert(p_rec in per_apt_shd.g_rec_type) is
328:
329: l_proc varchar2(72) := g_package||'post_insert';
330:
331: Begin

Line 411: p_rec in out nocopy per_apt_shd.g_rec_type,

407: -- |---------------------------------< ins >----------------------------------|
408: -- ---------------------------------------------------------------------------+
409: Procedure ins
410: (
411: p_rec in out nocopy per_apt_shd.g_rec_type,
412: p_effective_date in date ,
413: p_validate in boolean default false
414: ) is
415:

Line 526: l_rec per_apt_shd.g_rec_type;

522: ,p_part_rev_off_template_code in varchar2 default null,
523: p_validate in boolean default false
524: ) is
525:
526: l_rec per_apt_shd.g_rec_type;
527: l_proc varchar2(72) := g_package||'ins';
528:
529: Begin
530: hr_utility.set_location('Entering:'||l_proc, 5);

Line 536: per_apt_shd.convert_args

532: -- Call conversion function to turn arguments into the
533: -- p_rec structure.
534:
535: l_rec :=
536: per_apt_shd.convert_args
537: (
538: null,
539: p_business_group_id,
540: null,