APPS.PER_CAG_INS dependencies on PER_CAG_SHD

Line 55: Procedure insert_dml(p_rec in out nocopy per_cag_shd.g_rec_type) is

51: -- Internal Row Handler Use Only.
52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure insert_dml(p_rec in out nocopy per_cag_shd.g_rec_type) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin

Line 194: per_cag_shd.constraint_error

190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: Exception
192: When hr_api.check_integrity_violated Then
193: -- A check constraint has been violated
194: per_cag_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: per_cag_shd.constraint_error

Line 198: per_cag_shd.constraint_error

194: per_cag_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: per_cag_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: per_cag_shd.constraint_error

Line 202: per_cag_shd.constraint_error

198: per_cag_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: per_cag_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When Others Then
205: Raise;
206: End insert_dml;

Line 245: Procedure pre_insert(p_rec in out nocopy per_cag_shd.g_rec_type) is

241: -- Internal Row Handler Use Only.
242: --
243: -- {End Of Comments}
244: -- ----------------------------------------------------------------------------
245: Procedure pre_insert(p_rec in out nocopy per_cag_shd.g_rec_type) is
246: --
247: l_proc varchar2(72) := g_package||'pre_insert';
248: --
249: Cursor C_Sel1 is select per_collective_agreements_s.nextval from sys.dual;

Line 296: Procedure post_insert(p_rec in per_cag_shd.g_rec_type) is

292: -- Internal Row Handler Use Only.
293: --
294: -- {End Of Comments}
295: -- ----------------------------------------------------------------------------
296: Procedure post_insert(p_rec in per_cag_shd.g_rec_type) is
297: --
298: l_proc varchar2(72) := g_package||'post_insert';
299: --
300: Begin

Line 392: p_rec in out nocopy per_cag_shd.g_rec_type

388: -- |---------------------------------< ins >----------------------------------|
389: -- ----------------------------------------------------------------------------
390: Procedure ins
391: (
392: p_rec in out nocopy per_cag_shd.g_rec_type
393: ) is
394: --
395: l_proc varchar2(72) := g_package||'ins';
396: --

Line 483: l_rec per_cag_shd.g_rec_type;

479: p_attribute19 in varchar2 default null,
480: p_attribute20 in varchar2 default null
481: ) is
482: --
483: l_rec per_cag_shd.g_rec_type;
484: l_proc varchar2(72) := g_package||'ins';
485: --
486: Begin
487: hr_utility.set_location('Entering:'||l_proc, 5);

Line 493: per_cag_shd.convert_args

489: -- Call conversion function to turn arguments into the
490: -- p_rec structure.
491: --
492: l_rec :=
493: per_cag_shd.convert_args
494: (
495: null,
496: p_business_group_id,
497: null,