APPS.PAY_ISB_INS dependencies on PAY_ISB_SHD

Line 58: (p_rec in out nocopy pay_isb_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_insert_dml
58: (p_rec in out nocopy pay_isb_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: pay_isb_shd.g_old_rec.effective_start_date

68: t.creation_date
69: from pay_ie_social_benefits_f t
70: where t.social_benefit_id = p_rec.social_benefit_id
71: and t.effective_start_date =
72: pay_isb_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 pay_ie_social_benefits_f.created_by%TYPE;

Line 190: pay_isb_shd.constraint_error

186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: --
190: pay_isb_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --

Line 195: pay_isb_shd.constraint_error

191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: pay_isb_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: --
199: Raise;

Line 206: (p_rec in out nocopy pay_isb_shd.g_rec_type

202: -- ----------------------------------------------------------------------------
203: -- |------------------------------< insert_dml >------------------------------|
204: -- ----------------------------------------------------------------------------
205: Procedure insert_dml
206: (p_rec in out nocopy pay_isb_shd.g_rec_type
207: ,p_effective_date in date
208: ,p_datetrack_mode in varchar2
209: ,p_validation_start_date in date
210: ,p_validation_end_date in date

Line 269: (p_rec in out nocopy pay_isb_shd.g_rec_type

265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure pre_insert
269: (p_rec in out nocopy pay_isb_shd.g_rec_type
270: ,p_effective_date in date
271: ,p_datetrack_mode in varchar2
272: ,p_validation_start_date in date
273: ,p_validation_end_date in date

Line 327: (p_rec in pay_isb_shd.g_rec_type

323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure post_insert
327: (p_rec in pay_isb_shd.g_rec_type
328: ,p_effective_date in date
329: ,p_datetrack_mode in varchar2
330: ,p_validation_start_date in date
331: ,p_validation_end_date in date

Line 435: ,p_rec in pay_isb_shd.g_rec_type

431: -- ----------------------------------------------------------------------------
432: Procedure ins_lck
433: (p_effective_date in date
434: ,p_datetrack_mode in varchar2
435: ,p_rec in pay_isb_shd.g_rec_type
436: ,p_validation_start_date out nocopy date
437: ,p_validation_end_date out nocopy date
438: ) is
439: --

Line 478: ,p_rec in out nocopy pay_isb_shd.g_rec_type

474: -- |---------------------------------< ins >----------------------------------|
475: -- ----------------------------------------------------------------------------
476: Procedure ins
477: (p_effective_date in date
478: ,p_rec in out nocopy pay_isb_shd.g_rec_type
479: ) is
480: --
481: l_proc varchar2(72) := g_package||'ins';
482: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 566: l_rec pay_isb_shd.g_rec_type;

562: ,p_effective_start_date out nocopy date
563: ,p_effective_end_date out nocopy date
564: ) is
565: --
566: l_rec pay_isb_shd.g_rec_type;
567: l_proc varchar2(72) := g_package||'ins';
568: --
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);

Line 576: pay_isb_shd.convert_args

572: -- Call conversion function to turn arguments into the
573: -- p_rec structure.
574: --
575: l_rec :=
576: pay_isb_shd.convert_args
577: (null
578: ,null
579: ,null
580: ,null