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 195: per_pms_shd.constraint_error

191: Exception
192: When hr_api.check_integrity_violated Then
193: -- A check constraint has been violated
194: --
195: per_pms_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.parent_integrity_violated Then
198: -- Parent integrity has been violated
199: --

Line 200: per_pms_shd.constraint_error

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

Line 205: per_pms_shd.constraint_error

201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: --
205: per_pms_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: --
209: Raise;

Line 250: (p_rec in out nocopy per_pms_shd.g_rec_type

246: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure pre_insert
250: (p_rec in out nocopy per_pms_shd.g_rec_type
251: ) is
252: --
253: Cursor C_Sel1 is select per_personal_scorecards_s.nextval from sys.dual;
254: --

Line 338: ,p_rec in per_pms_shd.g_rec_type

334: -- {End Of Comments}
335: -- ----------------------------------------------------------------------------
336: Procedure post_insert
337: (p_effective_date in date
338: ,p_rec in per_pms_shd.g_rec_type
339: ,p_duplicate_name_warning in boolean
340: ) is
341: --
342: l_proc varchar2(72) := g_package||'post_insert';

Line 466: ,p_rec in out nocopy per_pms_shd.g_rec_type

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

Line 581: l_rec per_pms_shd.g_rec_type;

577: ,p_eligibility_status in varchar2 default null
578: ,p_eligibility_eval_date in date default null
579: ) is
580: --
581: l_rec per_pms_shd.g_rec_type;
582: l_proc varchar2(72) := g_package||'ins';
583: -- l_STATUS_CODE CONSTANT varchar2(11) := 'NOT_STARTED';
584: --
585: Begin

Line 592: per_pms_shd.convert_args

588: -- Call conversion function to turn arguments into the
589: -- p_rec structure.
590: --
591: l_rec :=
592: per_pms_shd.convert_args
593: (null
594: ,null
595: ,p_scorecard_name
596: ,null --p_person_id (derived)