DBA Data[Home] [Help]

APPS.BEN_CSO_INS dependencies on BEN_CSO_SHD

Line 76: (p_rec in out nocopy ben_cso_shd.g_rec_type

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

Line 215: ben_cso_shd.constraint_error

211: Exception
212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: --
215: ben_cso_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: --

Line 220: ben_cso_shd.constraint_error

216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: --
220: ben_cso_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: --

Line 225: ben_cso_shd.constraint_error

221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: --
225: ben_cso_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: --
229: Raise;

Line 270: (p_rec in out nocopy ben_cso_shd.g_rec_type

266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure pre_insert
270: (p_rec in out nocopy ben_cso_shd.g_rec_type
271: ) is
272: --
273: Cursor C_Sel1 is select ben_cwb_stock_optn_dtls_s.nextval from sys.dual;
274: --

Line 358: ,p_rec in ben_cso_shd.g_rec_type

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

Line 503: ,p_rec in out nocopy ben_cso_shd.g_rec_type

499: -- |---------------------------------< ins >----------------------------------|
500: -- ----------------------------------------------------------------------------
501: Procedure ins
502: (p_effective_date in date
503: ,p_rec in out nocopy ben_cso_shd.g_rec_type
504: ) is
505: --
506: l_proc varchar2(72) := g_package||'ins';
507: --

Line 606: l_rec ben_cso_shd.g_rec_type;

602: ,p_cwb_stock_optn_dtls_id out nocopy number
603: ,p_object_version_number out nocopy number
604: ) is
605: --
606: l_rec ben_cso_shd.g_rec_type;
607: l_proc varchar2(72) := g_package||'ins';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);

Line 616: ben_cso_shd.convert_args

612: -- Call conversion function to turn arguments into the
613: -- p_rec structure.
614: --
615: l_rec :=
616: ben_cso_shd.convert_args
617: (null
618: ,p_grant_id
619: ,p_grant_number
620: ,p_grant_name