DBA Data[Home] [Help]

APPS.PAY_PPD_INS dependencies on PAY_PPD_SHD

Line 80: (p_rec in out nocopy pay_ppd_shd.g_rec_type

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

90: t.creation_date
91: from pay_pl_paye_details_f t
92: where t.paye_details_id = p_rec.paye_details_id
93: and t.effective_start_date =
94: pay_ppd_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 pay_pl_paye_details_f.created_by%TYPE;

Line 212: pay_ppd_shd.constraint_error

208: Exception
209: When hr_api.check_integrity_violated Then
210: -- A check constraint has been violated
211: --
212: pay_ppd_shd.constraint_error
213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
214: When hr_api.unique_integrity_violated Then
215: -- Unique integrity has been violated
216: --

Line 217: pay_ppd_shd.constraint_error

213: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
214: When hr_api.unique_integrity_violated Then
215: -- Unique integrity has been violated
216: --
217: pay_ppd_shd.constraint_error
218: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
219: When Others Then
220: --
221: Raise;

Line 228: (p_rec in out nocopy pay_ppd_shd.g_rec_type

224: -- ----------------------------------------------------------------------------
225: -- |------------------------------< insert_dml >------------------------------|
226: -- ----------------------------------------------------------------------------
227: Procedure insert_dml
228: (p_rec in out nocopy pay_ppd_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 291: (p_rec in out nocopy pay_ppd_shd.g_rec_type

287: --
288: -- {End Of Comments}
289: -- ----------------------------------------------------------------------------
290: Procedure pre_insert
291: (p_rec in out nocopy pay_ppd_shd.g_rec_type
292: ,p_effective_date in date
293: ,p_datetrack_mode in varchar2
294: ,p_validation_start_date in date
295: ,p_validation_end_date in date

Line 383: (p_rec in pay_ppd_shd.g_rec_type

379: --
380: -- {End Of Comments}
381: -- ----------------------------------------------------------------------------
382: Procedure post_insert
383: (p_rec in pay_ppd_shd.g_rec_type
384: ,p_effective_date in date
385: ,p_datetrack_mode in varchar2
386: ,p_validation_start_date in date
387: ,p_validation_end_date in date

Line 489: ,p_rec in pay_ppd_shd.g_rec_type

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

Line 564: ,p_rec in out nocopy pay_ppd_shd.g_rec_type

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

Line 658: l_rec pay_ppd_shd.g_rec_type;

654: ,p_effective_start_date out nocopy date
655: ,p_effective_end_date out nocopy date
656: ) is
657: --
658: l_rec pay_ppd_shd.g_rec_type;
659: l_proc varchar2(72) := g_package||'ins';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);

Line 668: pay_ppd_shd.convert_args

664: -- Call conversion function to turn arguments into the
665: -- p_rec structure.
666: --
667: l_rec :=
668: pay_ppd_shd.convert_args
669: (null
670: ,null
671: ,null
672: ,p_per_or_asg_id