DBA Data[Home] [Help]

APPS.HR_LIP_INS dependencies on HR_LIP_SHD

Line 58: (p_rec in out nocopy hr_lip_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy hr_lip_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 72: hr_lip_shd.g_old_rec.effective_start_date

68: t.creation_date
69: from hr_de_liability_premiums_f t
70: where t.liability_premiums_id = p_rec.liability_premiums_id
71: and t.effective_start_date =
72: hr_lip_shd.g_old_rec.effective_start_date
73: and t.effective_end_date = (p_validation_start_date - 1);
74: --
75: l_proc varchar2(72) := g_package||'dt_insert_dml';
76: l_created_by hr_de_liability_premiums_f.created_by%TYPE;

Line 216: hr_lip_shd.constraint_error

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

Line 221: hr_lip_shd.constraint_error

217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.unique_integrity_violated Then
219: -- Unique integrity has been violated
220: --
221: hr_lip_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When Others Then
224: --
225: Raise;

Line 232: (p_rec in out nocopy hr_lip_shd.g_rec_type

228: -- ----------------------------------------------------------------------------
229: -- |------------------------------< insert_dml >------------------------------|
230: -- ----------------------------------------------------------------------------
231: Procedure insert_dml
232: (p_rec in out nocopy hr_lip_shd.g_rec_type
233: ,p_effective_date in date
234: ,p_datetrack_mode in varchar2
235: ,p_validation_start_date in date
236: ,p_validation_end_date in date

Line 295: (p_rec in out nocopy hr_lip_shd.g_rec_type

291: --
292: -- {End Of Comments}
293: -- ----------------------------------------------------------------------------
294: Procedure pre_insert
295: (p_rec in out nocopy hr_lip_shd.g_rec_type
296: ,p_effective_date in date
297: ,p_datetrack_mode in varchar2
298: ,p_validation_start_date in date
299: ,p_validation_end_date in date

Line 353: (p_rec in hr_lip_shd.g_rec_type

349: --
350: -- {End Of Comments}
351: -- ----------------------------------------------------------------------------
352: Procedure post_insert
353: (p_rec in hr_lip_shd.g_rec_type
354: ,p_effective_date in date
355: ,p_datetrack_mode in varchar2
356: ,p_validation_start_date in date
357: ,p_validation_end_date in date

Line 487: ,p_rec in hr_lip_shd.g_rec_type

483: -- ----------------------------------------------------------------------------
484: Procedure ins_lck
485: (p_effective_date in date
486: ,p_datetrack_mode in varchar2
487: ,p_rec in hr_lip_shd.g_rec_type
488: ,p_validation_start_date out nocopy date
489: ,p_validation_end_date out nocopy date
490: ) is
491: --

Line 527: ,p_rec in out nocopy hr_lip_shd.g_rec_type

523: -- |---------------------------------< ins >----------------------------------|
524: -- ----------------------------------------------------------------------------
525: Procedure ins
526: (p_effective_date in date
527: ,p_rec in out nocopy hr_lip_shd.g_rec_type
528: ) is
529: --
530: l_proc varchar2(72) := g_package||'ins';
531: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 628: l_rec hr_lip_shd.g_rec_type;

624: ,p_effective_start_date out nocopy date
625: ,p_effective_end_date out nocopy date
626: ) is
627: --
628: l_rec hr_lip_shd.g_rec_type;
629: l_proc varchar2(72) := g_package||'ins';
630: --
631: Begin
632: hr_utility.set_location('Entering:'||l_proc, 5);

Line 638: hr_lip_shd.convert_args

634: -- Call conversion function to turn arguments into the
635: -- p_rec structure.
636: --
637: l_rec :=
638: hr_lip_shd.convert_args
639: (null
640: ,p_organization_link_id
641: ,null
642: ,null