DBA Data[Home] [Help]

APPS.PAY_IPD_INS dependencies on PAY_IPD_SHD

Line 58: (p_rec in out nocopy pay_ipd_shd.g_rec_type

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

68: t.creation_date
69: from pay_ie_paye_details_f t
70: where t.paye_details_id = p_rec.paye_details_id
71: and t.effective_start_date =
72: pay_ipd_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_paye_details_f.created_by%TYPE;

Line 272: pay_ipd_shd.constraint_error

268: Exception
269: When hr_api.check_integrity_violated Then
270: -- A check constraint has been violated
271: --
272: pay_ipd_shd.constraint_error
273: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
274: When hr_api.unique_integrity_violated Then
275: -- Unique integrity has been violated
276: --

Line 277: pay_ipd_shd.constraint_error

273: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
274: When hr_api.unique_integrity_violated Then
275: -- Unique integrity has been violated
276: --
277: pay_ipd_shd.constraint_error
278: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
279: When Others Then
280: --
281: Raise;

Line 288: (p_rec in out nocopy pay_ipd_shd.g_rec_type

284: -- ----------------------------------------------------------------------------
285: -- |------------------------------< insert_dml >------------------------------|
286: -- ----------------------------------------------------------------------------
287: Procedure insert_dml
288: (p_rec in out nocopy pay_ipd_shd.g_rec_type
289: ,p_effective_date in date
290: ,p_datetrack_mode in varchar2
291: ,p_validation_start_date in date
292: ,p_validation_end_date in date

Line 351: (p_rec in out nocopy pay_ipd_shd.g_rec_type

347: --
348: -- {End Of Comments}
349: -- ----------------------------------------------------------------------------
350: Procedure pre_insert
351: (p_rec in out nocopy pay_ipd_shd.g_rec_type
352: ,p_effective_date in date
353: ,p_datetrack_mode in varchar2
354: ,p_validation_start_date in date
355: ,p_validation_end_date in date

Line 409: (p_rec in pay_ipd_shd.g_rec_type

405: --
406: -- {End Of Comments}
407: -- ----------------------------------------------------------------------------
408: Procedure post_insert
409: (p_rec in pay_ipd_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 523: ,p_rec in pay_ipd_shd.g_rec_type

519: -- ----------------------------------------------------------------------------
520: Procedure ins_lck
521: (p_effective_date in date
522: ,p_datetrack_mode in varchar2
523: ,p_rec in pay_ipd_shd.g_rec_type
524: ,p_validation_start_date out nocopy date
525: ,p_validation_end_date out nocopy date
526: ) is
527: --

Line 566: ,p_rec in out nocopy pay_ipd_shd.g_rec_type

562: -- |---------------------------------< ins >----------------------------------|
563: -- ----------------------------------------------------------------------------
564: Procedure ins
565: (p_effective_date in date
566: ,p_rec in out nocopy pay_ipd_shd.g_rec_type
567: ) is
568: --
569: l_proc varchar2(72) := g_package||'ins';
570: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 695: l_rec pay_ipd_shd.g_rec_type;

691: ,p_usc_info_source in varchar2 default null
692: --13359423
693: ) is
694: --
695: l_rec pay_ipd_shd.g_rec_type;
696: l_proc varchar2(72) := g_package||'ins';
697: --
698: Begin
699: hr_utility.set_location('Entering:'||l_proc, 5);

Line 705: pay_ipd_shd.convert_args

701: -- Call conversion function to turn arguments into the
702: -- p_rec structure.
703: --
704: l_rec :=
705: pay_ipd_shd.convert_args
706: (null
707: ,null
708: ,null
709: ,null