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 213: per_apt_shd.constraint_error

209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: Exception
211: When hr_api.check_integrity_violated Then
212: -- A check constraint has been violated
213: per_apt_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.parent_integrity_violated Then
216: -- Parent integrity has been violated
217: per_apt_shd.constraint_error

Line 217: per_apt_shd.constraint_error

213: per_apt_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.parent_integrity_violated Then
216: -- Parent integrity has been violated
217: per_apt_shd.constraint_error
218: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
219: When hr_api.unique_integrity_violated Then
220: -- Unique integrity has been violated
221: per_apt_shd.constraint_error

Line 221: per_apt_shd.constraint_error

217: per_apt_shd.constraint_error
218: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
219: When hr_api.unique_integrity_violated Then
220: -- Unique integrity has been violated
221: per_apt_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When Others Then
224: Raise;
225: End insert_dml;

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

260: -- Internal Table Handler Use Only.
261:
262: -- {End Of Comments}
263: -- ---------------------------------------------------------------------------+
264: Procedure pre_insert(p_rec in out nocopy per_apt_shd.g_rec_type) is
265:
266: l_proc varchar2(72) := g_package||'pre_insert';
267: l_exists varchar2(1);
268:

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

335: -- Internal Table Handler Use Only.
336:
337: -- {End Of Comments}
338: -- ---------------------------------------------------------------------------+
339: Procedure post_insert(p_rec in per_apt_shd.g_rec_type) is
340:
341: l_proc varchar2(72) := g_package||'post_insert';
342:
343: Begin

Line 430: p_rec in out nocopy per_apt_shd.g_rec_type,

426: -- |---------------------------------< ins >----------------------------------|
427: -- ---------------------------------------------------------------------------+
428: Procedure ins
429: (
430: p_rec in out nocopy per_apt_shd.g_rec_type,
431: p_effective_date in date ,
432: p_validate in boolean default false
433: ) is
434:

Line 551: l_rec per_apt_shd.g_rec_type;

547: ,p_show_future_term_employee in varchar2 default null -- 6181267 bug fix
548:
549: ) is
550:
551: l_rec per_apt_shd.g_rec_type;
552: l_proc varchar2(72) := g_package||'ins';
553:
554: Begin
555: hr_utility.set_location('Entering:'||l_proc, 5);

Line 561: per_apt_shd.convert_args

557: -- Call conversion function to turn arguments into the
558: -- p_rec structure.
559:
560: l_rec :=
561: per_apt_shd.convert_args
562: (
563: null,
564: p_business_group_id,
565: null,