DBA Data[Home] [Help]

APPS.BEN_BEP_INS dependencies on BEN_BEP_SHD

Line 80: (p_rec in out nocopy ben_bep_shd.g_rec_type

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

90: t.creation_date
91: from ben_elig_obj_elig_profl_f t
92: where t.elig_obj_elig_prfl_id = p_rec.elig_obj_elig_prfl_id
93: and t.effective_start_date =
94: ben_bep_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_elig_profl_f.created_by%TYPE;

Line 238: ben_bep_shd.constraint_error

234: Exception
235: When hr_api.check_integrity_violated Then
236: -- A check constraint has been violated
237: --
238: ben_bep_shd.constraint_error
239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240: When hr_api.unique_integrity_violated Then
241: -- Unique integrity has been violated
242: --

Line 243: ben_bep_shd.constraint_error

239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240: When hr_api.unique_integrity_violated Then
241: -- Unique integrity has been violated
242: --
243: ben_bep_shd.constraint_error
244: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
245: When Others Then
246: --
247: Raise;

Line 254: (p_rec in out nocopy ben_bep_shd.g_rec_type

250: -- ----------------------------------------------------------------------------
251: -- |------------------------------< insert_dml >------------------------------|
252: -- ----------------------------------------------------------------------------
253: Procedure insert_dml
254: (p_rec in out nocopy ben_bep_shd.g_rec_type
255: ,p_effective_date in date
256: ,p_datetrack_mode in varchar2
257: ,p_validation_start_date in date
258: ,p_validation_end_date in date

Line 317: (p_rec in out nocopy ben_bep_shd.g_rec_type

313: --
314: -- {End Of Comments}
315: -- ----------------------------------------------------------------------------
316: Procedure pre_insert
317: (p_rec in out nocopy ben_bep_shd.g_rec_type
318: ,p_effective_date in date
319: ,p_datetrack_mode in varchar2
320: ,p_validation_start_date in date
321: ,p_validation_end_date in date

Line 409: (p_rec in ben_bep_shd.g_rec_type

405: --
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure post_insert
409: (p_rec in ben_bep_shd.g_rec_type
410: ,p_effective_date in date
411: ,p_datetrack_mode in varchar2
412: ,p_validation_start_date in date
413: ,p_validation_end_date in date

Line 541: ,p_rec in ben_bep_shd.g_rec_type

537: -- ----------------------------------------------------------------------------
538: Procedure ins_lck
539: (p_effective_date in date
540: ,p_datetrack_mode in varchar2
541: ,p_rec in ben_bep_shd.g_rec_type
542: ,p_validation_start_date out nocopy date
543: ,p_validation_end_date out nocopy date
544: ) is
545: --

Line 587: ,p_rec in out nocopy ben_bep_shd.g_rec_type

583: -- |---------------------------------< ins >----------------------------------|
584: -- ----------------------------------------------------------------------------
585: Procedure ins
586: (p_effective_date in date
587: ,p_rec in out nocopy ben_bep_shd.g_rec_type
588: ) is
589: --
590: l_proc varchar2(72) := g_package||'ins';
591: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 693: l_rec ben_bep_shd.g_rec_type;

689: ,p_effective_start_date out nocopy date
690: ,p_effective_end_date out nocopy date
691: ) is
692: --
693: l_rec ben_bep_shd.g_rec_type;
694: l_proc varchar2(72) := g_package||'ins';
695: --
696: Begin
697: hr_utility.set_location('Entering:'||l_proc, 5);

Line 703: ben_bep_shd.convert_args

699: -- Call conversion function to turn arguments into the
700: -- p_rec structure.
701: --
702: l_rec :=
703: ben_bep_shd.convert_args
704: (null
705: ,null
706: ,null
707: ,p_elig_obj_id