APPS.PAY_EVQ_INS dependencies on PAY_EVQ_SHD

Line 80: (p_rec in out nocopy pay_evq_shd.g_rec_type

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

90: t.creation_date
91: from pay_event_qualifiers_f t
92: where t.event_qualifier_id = p_rec.event_qualifier_id
93: and t.effective_start_date =
94: pay_evq_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_event_qualifiers_f.created_by%TYPE;

Line 208: pay_evq_shd.constraint_error

204: Exception
205: When hr_api.check_integrity_violated Then
206: -- A check constraint has been violated
207: --
208: pay_evq_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: --

Line 213: pay_evq_shd.constraint_error

209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated Then
211: -- Unique integrity has been violated
212: --
213: pay_evq_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others Then
216: --
217: Raise;

Line 272: (p_rec in out nocopy pay_evq_shd.g_rec_type

268: -- ----------------------------------------------------------------------------
269: -- |------------------------------< insert_dml >------------------------------|
270: -- ----------------------------------------------------------------------------
271: Procedure insert_dml
272: (p_rec in out nocopy pay_evq_shd.g_rec_type
273: ,p_effective_date in date
274: ,p_datetrack_mode in varchar2
275: ,p_validation_start_date in date
276: ,p_validation_end_date in date

Line 335: (p_rec in out nocopy pay_evq_shd.g_rec_type

331: --
332: -- {End Of Comments}
333: -- ----------------------------------------------------------------------------
334: Procedure pre_insert
335: (p_rec in out nocopy pay_evq_shd.g_rec_type
336: ,p_effective_date in date
337: ,p_datetrack_mode in varchar2
338: ,p_validation_start_date in date
339: ,p_validation_end_date in date

Line 427: (p_rec in pay_evq_shd.g_rec_type

423: --
424: -- {End Of Comments}
425: -- ----------------------------------------------------------------------------
426: Procedure post_insert
427: (p_rec in pay_evq_shd.g_rec_type
428: ,p_effective_date in date
429: ,p_datetrack_mode in varchar2
430: ,p_validation_start_date in date
431: ,p_validation_end_date in date

Line 537: ,p_rec in pay_evq_shd.g_rec_type

533: -- ----------------------------------------------------------------------------
534: Procedure ins_lck
535: (p_effective_date in date
536: ,p_datetrack_mode in varchar2
537: ,p_rec in pay_evq_shd.g_rec_type
538: ,p_validation_start_date out nocopy date
539: ,p_validation_end_date out nocopy date
540: ) is
541: --

Line 577: ,p_rec in out nocopy pay_evq_shd.g_rec_type

573: -- |---------------------------------< ins >----------------------------------|
574: -- ----------------------------------------------------------------------------
575: Procedure ins
576: (p_effective_date in date
577: ,p_rec in out nocopy pay_evq_shd.g_rec_type
578: ) is
579: --
580: l_proc varchar2(72) := g_package||'ins';
581: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 669: l_rec pay_evq_shd.g_rec_type;

665: ,p_effective_start_date out nocopy date
666: ,p_effective_end_date out nocopy date
667: ) is
668: --
669: l_rec pay_evq_shd.g_rec_type;
670: l_proc varchar2(72) := g_package||'ins';
671: --
672: Begin
673: hr_utility.set_location('Entering:'||l_proc, 5);

Line 679: pay_evq_shd.convert_args

675: -- Call conversion function to turn arguments into the
676: -- p_rec structure.
677: --
678: l_rec :=
679: pay_evq_shd.convert_args
680: (null
681: ,null
682: ,null
683: ,p_dated_table_id