APPS.BEN_CTY_INS dependencies on BEN_CTY_SHD

Line 80: (p_rec in out nocopy ben_cty_shd.g_rec_type

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

90: t.creation_date
91: from ben_comptncy_rt_f t
92: where t.comptncy_rt_id = p_rec.comptncy_rt_id
93: and t.effective_start_date =
94: ben_cty_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_comptncy_rt_f.created_by%TYPE;

Line 260: ben_cty_shd.constraint_error

256: Exception
257: When hr_api.check_integrity_violated Then
258: -- A check constraint has been violated
259: --
260: ben_cty_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When hr_api.unique_integrity_violated Then
263: -- Unique integrity has been violated
264: --

Line 265: ben_cty_shd.constraint_error

261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When hr_api.unique_integrity_violated Then
263: -- Unique integrity has been violated
264: --
265: ben_cty_shd.constraint_error
266: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
267: When Others Then
268: --
269: Raise;

Line 276: (p_rec in out nocopy ben_cty_shd.g_rec_type

272: -- ----------------------------------------------------------------------------
273: -- |------------------------------< insert_dml >------------------------------|
274: -- ----------------------------------------------------------------------------
275: Procedure insert_dml
276: (p_rec in out nocopy ben_cty_shd.g_rec_type
277: ,p_effective_date in date
278: ,p_datetrack_mode in varchar2
279: ,p_validation_start_date in date
280: ,p_validation_end_date in date

Line 339: (p_rec in out nocopy ben_cty_shd.g_rec_type

335: --
336: -- {End Of Comments}
337: -- ----------------------------------------------------------------------------
338: Procedure pre_insert
339: (p_rec in out nocopy ben_cty_shd.g_rec_type
340: ,p_effective_date in date
341: ,p_datetrack_mode in varchar2
342: ,p_validation_start_date in date
343: ,p_validation_end_date in date

Line 431: (p_rec in ben_cty_shd.g_rec_type

427: --
428: -- {End Of Comments}
429: -- ----------------------------------------------------------------------------
430: Procedure post_insert
431: (p_rec in ben_cty_shd.g_rec_type
432: ,p_effective_date in date
433: ,p_datetrack_mode in varchar2
434: ,p_validation_start_date in date
435: ,p_validation_end_date in date

Line 587: ,p_rec in ben_cty_shd.g_rec_type

583: -- ----------------------------------------------------------------------------
584: Procedure ins_lck
585: (p_effective_date in date
586: ,p_datetrack_mode in varchar2
587: ,p_rec in ben_cty_shd.g_rec_type
588: ,p_validation_start_date out nocopy date
589: ,p_validation_end_date out nocopy date
590: ) is
591: --

Line 630: ,p_rec in out nocopy ben_cty_shd.g_rec_type

626: -- |---------------------------------< ins >----------------------------------|
627: -- ----------------------------------------------------------------------------
628: Procedure ins
629: (p_effective_date in date
630: ,p_rec in out nocopy ben_cty_shd.g_rec_type
631: ) is
632: --
633: l_proc varchar2(72) := g_package||'ins';
634: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 748: l_rec ben_cty_shd.g_rec_type;

744: ,p_effective_start_date out nocopy date
745: ,p_effective_end_date out nocopy date
746: ) is
747: --
748: l_rec ben_cty_shd.g_rec_type;
749: l_proc varchar2(72) := g_package||'ins';
750: --
751: Begin
752: hr_utility.set_location('Entering:'||l_proc, 5);

Line 758: ben_cty_shd.convert_args

754: -- Call conversion function to turn arguments into the
755: -- p_rec structure.
756: --
757: l_rec :=
758: ben_cty_shd.convert_args
759: (null
760: ,null
761: ,null
762: ,p_competence_id