APPS.PAY_SID_INS dependencies on PAY_SID_SHD

Line 58: (p_rec in out nocopy pay_sid_shd.g_rec_type

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

68: t.creation_date
69: from pay_ie_prsi_details_f t
70: where t.prsi_details_id = p_rec.prsi_details_id
71: and t.effective_start_date =
72: pay_sid_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_prsi_details_f.created_by%TYPE;

Line 196: pay_sid_shd.constraint_error

192: Exception
193: When hr_api.check_integrity_violated Then
194: -- A check constraint has been violated
195: --
196: pay_sid_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: --

Line 201: pay_sid_shd.constraint_error

197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: --
201: pay_sid_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When Others Then
204: --
205: Raise;

Line 212: (p_rec in out nocopy pay_sid_shd.g_rec_type

208: -- ----------------------------------------------------------------------------
209: -- |------------------------------< insert_dml >------------------------------|
210: -- ----------------------------------------------------------------------------
211: Procedure insert_dml
212: (p_rec in out nocopy pay_sid_shd.g_rec_type
213: ,p_effective_date in date
214: ,p_datetrack_mode in varchar2
215: ,p_validation_start_date in date
216: ,p_validation_end_date in date

Line 275: (p_rec in out nocopy pay_sid_shd.g_rec_type

271: --
272: -- {End Of Comments}
273: -- ----------------------------------------------------------------------------
274: Procedure pre_insert
275: (p_rec in out nocopy pay_sid_shd.g_rec_type
276: ,p_effective_date in date
277: ,p_datetrack_mode in varchar2
278: ,p_validation_start_date in date
279: ,p_validation_end_date in date

Line 333: (p_rec in pay_sid_shd.g_rec_type

329: --
330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure post_insert
333: (p_rec in pay_sid_shd.g_rec_type
334: ,p_effective_date in date
335: ,p_datetrack_mode in varchar2
336: ,p_validation_start_date in date
337: ,p_validation_end_date in date

Line 447: ,p_rec in pay_sid_shd.g_rec_type

443: -- ----------------------------------------------------------------------------
444: Procedure ins_lck
445: (p_effective_date in date
446: ,p_datetrack_mode in varchar2
447: ,p_rec in pay_sid_shd.g_rec_type
448: ,p_validation_start_date out nocopy date
449: ,p_validation_end_date out nocopy date
450: ) is
451: --

Line 490: ,p_rec in out nocopy pay_sid_shd.g_rec_type

486: -- |---------------------------------< ins >----------------------------------|
487: -- ----------------------------------------------------------------------------
488: Procedure ins
489: (p_effective_date in date
490: ,p_rec in out nocopy pay_sid_shd.g_rec_type
491: ) is
492: --
493: l_proc varchar2(72) := g_package||'ins';
494: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 581: l_rec pay_sid_shd.g_rec_type;

577: ,p_effective_start_date out nocopy date
578: ,p_effective_end_date out nocopy date
579: ) is
580: --
581: l_rec pay_sid_shd.g_rec_type;
582: l_proc varchar2(72) := g_package||'ins';
583: --
584: Begin
585: hr_utility.set_location('Entering:'||l_proc, 5);

Line 591: pay_sid_shd.convert_args

587: -- Call conversion function to turn arguments into the
588: -- p_rec structure.
589: --
590: l_rec :=
591: pay_sid_shd.convert_args
592: (null
593: ,null
594: ,null
595: ,null