DBA Data[Home] [Help]

APPS.PER_SSL_INS dependencies on PER_SSL_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy per_ssl_shd.g_rec_type) is

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

Line 242: per_ssl_shd.constraint_error

238: Exception
239: When hr_api.check_integrity_violated Then
240: -- A check constraint has been violated
241: hr_utility.set_location('check integrity constraint',11);
242: per_ssl_shd.constraint_error
243: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
244: When hr_api.parent_integrity_violated Then
245: -- Parent integrity has been violated
246: hr_utility.set_location('parent integrity constraint',11);

Line 247: per_ssl_shd.constraint_error

243: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
244: When hr_api.parent_integrity_violated Then
245: -- Parent integrity has been violated
246: hr_utility.set_location('parent integrity constraint',11);
247: per_ssl_shd.constraint_error
248: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249: When hr_api.unique_integrity_violated Then
250: -- Unique integrity has been violated
251: hr_utility.set_location('unique integrity constraint ',11);

Line 253: per_ssl_shd.constraint_error

249: When hr_api.unique_integrity_violated Then
250: -- Unique integrity has been violated
251: hr_utility.set_location('unique integrity constraint ',11);
252: hr_utility.set_location(SQLERRM,12);
253: per_ssl_shd.constraint_error
254: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
255: When Others Then
256: Raise;
257: End insert_dml;

Line 296: Procedure pre_insert(p_rec in out nocopy per_ssl_shd.g_rec_type) is

292: -- Internal Row Handler Use Only.
293: --
294: -- {End Of Comments}
295: -- ----------------------------------------------------------------------------
296: Procedure pre_insert(p_rec in out nocopy per_ssl_shd.g_rec_type) is
297: --
298: l_proc varchar2(72) := g_package||'pre_insert';
299: --
300: Cursor C_Sel1 is select per_salary_survey_lines_s.nextval from sys.dual;

Line 347: Procedure post_insert(p_rec in per_ssl_shd.g_rec_type,

343: -- Internal Row Handler Use Only.
344: --
345: -- {End Of Comments}
346: -- ----------------------------------------------------------------------------
347: Procedure post_insert(p_rec in per_ssl_shd.g_rec_type,
348: p_effective_date in date) is
349: --
350: l_proc varchar2(72) := g_package||'post_insert';
351: --

Line 541: p_rec in out nocopy per_ssl_shd.g_rec_type,

537: -- |---------------------------------< ins >----------------------------------|
538: -- ----------------------------------------------------------------------------
539: Procedure ins
540: (
541: p_rec in out nocopy per_ssl_shd.g_rec_type,
542: p_effective_date in date
543: ) is
544: --
545: l_proc varchar2(72) := g_package||'ins';

Line 658: l_rec per_ssl_shd.g_rec_type;

654: /*End Enhancement 4021737 */
655: p_effective_date in date default null
656: ) is
657: --
658: l_rec per_ssl_shd.g_rec_type;
659: l_proc varchar2(72) := g_package||'ins';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);

Line 668: per_ssl_shd.convert_args

664: -- Call conversion function to turn arguments into the
665: -- p_rec structure.
666: --
667: l_rec :=
668: per_ssl_shd.convert_args
669: (
670: null,
671: null,
672: p_salary_survey_id,