APPS.PAY_PSD_INS dependencies on PAY_PSD_SHD

Line 80: (p_rec in out nocopy pay_psd_shd.g_rec_type

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

90: t.creation_date
91: from pay_pl_sii_details_f t
92: where t.sii_details_id = p_rec.sii_details_id
93: and t.effective_start_date =
94: pay_psd_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_sii_details_f.created_by%TYPE;

Line 232: pay_psd_shd.constraint_error

228: Exception
229: When hr_api.check_integrity_violated Then
230: -- A check constraint has been violated
231: --
232: pay_psd_shd.constraint_error
233: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
234: When hr_api.unique_integrity_violated Then
235: -- Unique integrity has been violated
236: --

Line 237: pay_psd_shd.constraint_error

233: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
234: When hr_api.unique_integrity_violated Then
235: -- Unique integrity has been violated
236: --
237: pay_psd_shd.constraint_error
238: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
239: When Others Then
240: --
241: Raise;

Line 248: (p_rec in out nocopy pay_psd_shd.g_rec_type

244: -- ----------------------------------------------------------------------------
245: -- |------------------------------< insert_dml >------------------------------|
246: -- ----------------------------------------------------------------------------
247: Procedure insert_dml
248: (p_rec in out nocopy pay_psd_shd.g_rec_type
249: ,p_effective_date in date
250: ,p_datetrack_mode in varchar2
251: ,p_validation_start_date in date
252: ,p_validation_end_date in date

Line 311: (p_rec in out nocopy pay_psd_shd.g_rec_type

307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure pre_insert
311: (p_rec in out nocopy pay_psd_shd.g_rec_type
312: ,p_effective_date in date
313: ,p_datetrack_mode in varchar2
314: ,p_validation_start_date in date
315: ,p_validation_end_date in date

Line 403: (p_rec in pay_psd_shd.g_rec_type

399: --
400: -- {End Of Comments}
401: -- ----------------------------------------------------------------------------
402: Procedure post_insert
403: (p_rec in pay_psd_shd.g_rec_type
404: ,p_effective_date in date
405: ,p_datetrack_mode in varchar2
406: ,p_validation_start_date in date
407: ,p_validation_end_date in date

Line 529: ,p_rec in pay_psd_shd.g_rec_type

525: -- ----------------------------------------------------------------------------
526: Procedure ins_lck
527: (p_effective_date in date
528: ,p_datetrack_mode in varchar2
529: ,p_rec in pay_psd_shd.g_rec_type
530: ,p_validation_start_date out nocopy date
531: ,p_validation_end_date out nocopy date
532: ) is
533: --

Line 602: ,p_rec in out nocopy pay_psd_shd.g_rec_type

598: -- |---------------------------------< ins >----------------------------------|
599: -- ----------------------------------------------------------------------------
600: Procedure ins
601: (p_effective_date in date
602: ,p_rec in out nocopy pay_psd_shd.g_rec_type
603: ) is
604: --
605: l_proc varchar2(72) := g_package||'ins';
606: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 705: l_rec pay_psd_shd.g_rec_type;

701: ,p_effective_start_date out nocopy date
702: ,p_effective_end_date out nocopy date
703: ) is
704: --
705: l_rec pay_psd_shd.g_rec_type;
706: l_proc varchar2(72) := g_package||'ins';
707: --
708: Begin
709: hr_utility.set_location('Entering:'||l_proc, 5);

Line 715: pay_psd_shd.convert_args

711: -- Call conversion function to turn arguments into the
712: -- p_rec structure.
713: --
714: l_rec :=
715: pay_psd_shd.convert_args
716: (null
717: ,null
718: ,null
719: ,p_per_or_asg_id