APPS.BEN_BER_INS dependencies on BEN_BER_SHD

Line 80: (p_rec in out nocopy ben_ber_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy ben_ber_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_ber_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from ben_elig_rslt_f t
92: where t.elig_rslt_id = p_rec.elig_rslt_id
93: and t.effective_start_date =
94: ben_ber_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_rslt_f.created_by%TYPE;

Line 198: ben_ber_shd.constraint_error

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

Line 203: ben_ber_shd.constraint_error

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

Line 214: (p_rec in out nocopy ben_ber_shd.g_rec_type

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

Line 277: (p_rec in out nocopy ben_ber_shd.g_rec_type

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

Line 369: (p_rec in ben_ber_shd.g_rec_type

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

Line 461: ,p_rec in ben_ber_shd.g_rec_type

457: -- ----------------------------------------------------------------------------
458: Procedure ins_lck
459: (p_effective_date in date
460: ,p_datetrack_mode in varchar2
461: ,p_rec in ben_ber_shd.g_rec_type
462: ,p_validation_start_date out nocopy date
463: ,p_validation_end_date out nocopy date
464: ) is
465: --

Line 504: ,p_rec in out nocopy ben_ber_shd.g_rec_type

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

Line 590: l_rec ben_ber_shd.g_rec_type;

586: ,p_effective_start_date out nocopy date
587: ,p_effective_end_date out nocopy date
588: ) is
589: --
590: l_rec ben_ber_shd.g_rec_type;
591: l_proc varchar2(72) := g_package||'ins';
592: --
593: Begin
594: hr_utility.set_location('Entering:'||l_proc, 5);

Line 600: ben_ber_shd.convert_args

596: -- Call conversion function to turn arguments into the
597: -- p_rec structure.
598: --
599: l_rec :=
600: ben_ber_shd.convert_args
601: (null
602: ,null
603: ,null
604: ,p_elig_obj_id