DBA Data[Home] [Help]

APPS.PER_MEA_INS dependencies on PER_MEA_SHD

Line 54: (p_rec in out nocopy per_mea_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy per_mea_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_medical_assessments.created_by%TYPE;

Line 247: per_mea_shd.constraint_error

243: Exception
244: When hr_api.check_integrity_violated Then
245: -- A check constraint has been violated
246: --
247: per_mea_shd.constraint_error
248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.parent_integrity_violated Then
250: -- Parent integrity has been violated
251: --

Line 252: per_mea_shd.constraint_error

248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.parent_integrity_violated Then
250: -- Parent integrity has been violated
251: --
252: per_mea_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When hr_api.unique_integrity_violated Then
255: -- Unique integrity has been violated
256: --

Line 257: per_mea_shd.constraint_error

253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When hr_api.unique_integrity_violated Then
255: -- Unique integrity has been violated
256: --
257: per_mea_shd.constraint_error
258: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
259: When Others Then
260: --
261: Raise;

Line 302: (p_rec in out nocopy per_mea_shd.g_rec_type

298: --
299: -- {End Of Comments}
300: -- ----------------------------------------------------------------------------
301: Procedure pre_insert
302: (p_rec in out nocopy per_mea_shd.g_rec_type
303: ) is
304: --
305: l_proc varchar2(72) := g_package||'pre_insert';
306: --

Line 358: ,p_rec in per_mea_shd.g_rec_type

354: -- {End Of Comments}
355: -- ----------------------------------------------------------------------------
356: Procedure post_insert
357: (p_effective_date in date
358: ,p_rec in per_mea_shd.g_rec_type
359: ) is
360: --
361: l_proc varchar2(72) := g_package||'post_insert';
362: --

Line 465: ,p_rec in out nocopy per_mea_shd.g_rec_type

461: -- ----------------------------------------------------------------------------
462: --
463: Procedure ins
464: (p_effective_date in date
465: ,p_rec in out nocopy per_mea_shd.g_rec_type
466: ) is
467: --
468: l_proc varchar2(72) := g_package||'ins';
469: --

Line 580: l_rec per_mea_shd.g_rec_type;

576: ,p_medical_assessment_id out nocopy number
577: ,p_object_version_number out nocopy number
578: ) is
579: --
580: l_rec per_mea_shd.g_rec_type;
581: l_proc varchar2(72) := g_package||'ins';
582: --
583: Begin
584: hr_utility.set_location('Entering:'||l_proc, 5);

Line 590: per_mea_shd.convert_args

586: -- Call conversion function to turn arguments into the
587: -- p_rec structure.
588: --
589: l_rec :=
590: per_mea_shd.convert_args
591: (null
592: ,p_person_id
593: ,p_examiner_name
594: ,p_organization_id