DBA Data[Home] [Help]

APPS.BEN_BEO_INS dependencies on BEN_BEO_SHD

Line 80: (p_rec in out nocopy ben_beo_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ben_beo_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date

Line 94: ben_beo_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from ben_elig_obj_f t
92: where t.elig_obj_id = p_rec.elig_obj_id
93: and t.effective_start_date =
94: ben_beo_shd.g_old_rec.effective_start_date
95: and t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by ben_elig_obj_f.created_by%TYPE;

Line 196: ben_beo_shd.constraint_error

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

Line 201: ben_beo_shd.constraint_error

197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: --
201: ben_beo_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When Others Then
204: --
205: Raise;

Line 212: (p_rec in out nocopy ben_beo_shd.g_rec_type

208: -- ----------------------------------------------------------------------------
209: -- |------------------------------< insert_dml >------------------------------|
210: -- ----------------------------------------------------------------------------
211: Procedure insert_dml
212: (p_rec in out nocopy ben_beo_shd.g_rec_type
213: ,p_effective_date in date
214: ,p_datetrack_mode in varchar2
215: ,p_validation_start_date in date
216: ,p_validation_end_date in date

Line 275: (p_rec in out nocopy ben_beo_shd.g_rec_type

271: --
272: -- {End Of Comments}
273: -- ----------------------------------------------------------------------------
274: Procedure pre_insert
275: (p_rec in out nocopy ben_beo_shd.g_rec_type
276: ,p_effective_date in date
277: ,p_datetrack_mode in varchar2
278: ,p_validation_start_date in date
279: ,p_validation_end_date in date

Line 367: (p_rec in ben_beo_shd.g_rec_type

363: --
364: -- {End Of Comments}
365: -- ----------------------------------------------------------------------------
366: Procedure post_insert
367: (p_rec in ben_beo_shd.g_rec_type
368: ,p_effective_date in date
369: ,p_datetrack_mode in varchar2
370: ,p_validation_start_date in date
371: ,p_validation_end_date in date

Line 457: ,p_rec in ben_beo_shd.g_rec_type

453: -- ----------------------------------------------------------------------------
454: Procedure ins_lck
455: (p_effective_date in date
456: ,p_datetrack_mode in varchar2
457: ,p_rec in ben_beo_shd.g_rec_type
458: ,p_validation_start_date out nocopy date
459: ,p_validation_end_date out nocopy date
460: ) is
461: --

Line 500: ,p_rec in out nocopy ben_beo_shd.g_rec_type

496: -- |---------------------------------< ins >----------------------------------|
497: -- ----------------------------------------------------------------------------
498: Procedure ins
499: (p_effective_date in date
500: ,p_rec in out nocopy ben_beo_shd.g_rec_type
501: ) is
502: --
503: l_proc varchar2(72) := g_package||'ins';
504: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 585: l_rec ben_beo_shd.g_rec_type;

581: ,p_effective_start_date out nocopy date
582: ,p_effective_end_date out nocopy date
583: ) is
584: --
585: l_rec ben_beo_shd.g_rec_type;
586: l_proc varchar2(72) := g_package||'ins';
587: --
588: Begin
589: hr_utility.set_location('Entering:'||l_proc, 5);

Line 595: ben_beo_shd.convert_args

591: -- Call conversion function to turn arguments into the
592: -- p_rec structure.
593: --
594: l_rec :=
595: ben_beo_shd.convert_args
596: (null
597: ,null
598: ,null
599: ,p_table_name