DBA Data[Home] [Help]

APPS.PER_PMS_INS dependencies on PER_PMS_SHD

Line 76: (p_rec in out nocopy per_pms_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy per_pms_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 185: per_pms_shd.constraint_error

181: Exception
182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: --
185: per_pms_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --

Line 190: per_pms_shd.constraint_error

186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --
190: per_pms_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --

Line 195: per_pms_shd.constraint_error

191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: per_pms_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: --
199: Raise;

Line 240: (p_rec in out nocopy per_pms_shd.g_rec_type

236: --
237: -- {End Of Comments}
238: -- ----------------------------------------------------------------------------
239: Procedure pre_insert
240: (p_rec in out nocopy per_pms_shd.g_rec_type
241: ) is
242: --
243: Cursor C_Sel1 is select per_personal_scorecards_s.nextval from sys.dual;
244: --

Line 328: ,p_rec in per_pms_shd.g_rec_type

324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure post_insert
327: (p_effective_date in date
328: ,p_rec in per_pms_shd.g_rec_type
329: ,p_duplicate_name_warning in boolean
330: ) is
331: --
332: l_proc varchar2(72) := g_package||'post_insert';

Line 446: ,p_rec in out nocopy per_pms_shd.g_rec_type

442: -- |---------------------------------< ins >----------------------------------|
443: -- ----------------------------------------------------------------------------
444: Procedure ins
445: (p_effective_date in date
446: ,p_rec in out nocopy per_pms_shd.g_rec_type
447: ,p_duplicate_name_warning out nocopy boolean
448: ) is
449: --
450: l_proc varchar2(72) := g_package||'ins';

Line 556: l_rec per_pms_shd.g_rec_type;

552: ,p_status_code in varchar2
553: ,p_duplicate_name_warning out nocopy boolean
554: ) is
555: --
556: l_rec per_pms_shd.g_rec_type;
557: l_proc varchar2(72) := g_package||'ins';
558: -- l_STATUS_CODE CONSTANT varchar2(11) := 'NOT_STARTED';
559: --
560: Begin

Line 567: per_pms_shd.convert_args

563: -- Call conversion function to turn arguments into the
564: -- p_rec structure.
565: --
566: l_rec :=
567: per_pms_shd.convert_args
568: (null
569: ,null
570: ,p_scorecard_name
571: ,null --p_person_id (derived)