APPS.PAY_ECU_INS dependencies on PAY_ECU_SHD

Line 80: (p_rec in out nocopy pay_ecu_shd.g_rec_type

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

90: t.creation_date
91: from pay_element_class_usages_f t
92: where t.element_class_usage_id = p_rec.element_class_usage_id
93: and t.effective_start_date =
94: pay_ecu_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_element_class_usages_f.created_by%TYPE;

Line 155: pay_ecu_shd.check_unique_constraint

151: p_rec.object_version_number := 1; -- Initialise the object version
152: End If;
153: --
154: --
155: pay_ecu_shd.check_unique_constraint
156: (p_classification_id => p_rec.classification_id,
157: p_run_type_id => p_rec.run_type_id,
158: p_effective_start_date=> p_rec.effective_start_date,
159: p_effective_end_date => p_rec.effective_end_date,

Line 203: pay_ecu_shd.constraint_error

199: Exception
200: When hr_api.check_integrity_violated Then
201: -- A check constraint has been violated
202: --
203: pay_ecu_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.unique_integrity_violated Then
206: -- Unique integrity has been violated
207: --

Line 208: pay_ecu_shd.constraint_error

204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.unique_integrity_violated Then
206: -- Unique integrity has been violated
207: --
208: pay_ecu_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When Others Then
211: --
212: Raise;

Line 267: (p_rec in out nocopy pay_ecu_shd.g_rec_type

263: -- ----------------------------------------------------------------------------
264: -- |------------------------------< insert_dml >------------------------------|
265: -- ----------------------------------------------------------------------------
266: Procedure insert_dml
267: (p_rec in out nocopy pay_ecu_shd.g_rec_type
268: ,p_effective_date in date
269: ,p_datetrack_mode in varchar2
270: ,p_validation_start_date in date
271: ,p_validation_end_date in date

Line 330: (p_rec in out nocopy pay_ecu_shd.g_rec_type

326: --
327: -- {End Of Comments}
328: -- ----------------------------------------------------------------------------
329: Procedure pre_insert
330: (p_rec in out nocopy pay_ecu_shd.g_rec_type
331: ,p_effective_date in date
332: ,p_datetrack_mode in varchar2
333: ,p_validation_start_date in date
334: ,p_validation_end_date in date

Line 422: (p_rec in pay_ecu_shd.g_rec_type

418: --
419: -- {End Of Comments}
420: -- ----------------------------------------------------------------------------
421: Procedure post_insert
422: (p_rec in pay_ecu_shd.g_rec_type
423: ,p_effective_date in date
424: ,p_datetrack_mode in varchar2
425: ,p_validation_start_date in date
426: ,p_validation_end_date in date

Line 518: ,p_rec in pay_ecu_shd.g_rec_type

514: -- ----------------------------------------------------------------------------
515: Procedure ins_lck
516: (p_effective_date in date
517: ,p_datetrack_mode in varchar2
518: ,p_rec in pay_ecu_shd.g_rec_type
519: ,p_validation_start_date out nocopy date
520: ,p_validation_end_date out nocopy date
521: ) is
522: --

Line 558: ,p_rec in out nocopy pay_ecu_shd.g_rec_type

554: -- |---------------------------------< ins >----------------------------------|
555: -- ----------------------------------------------------------------------------
556: Procedure ins
557: (p_effective_date in date
558: ,p_rec in out nocopy pay_ecu_shd.g_rec_type
559: ) is
560: --
561: l_proc varchar2(72) := g_package||'ins';
562: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 643: l_rec pay_ecu_shd.g_rec_type;

639: ,p_effective_start_date out nocopy date
640: ,p_effective_end_date out nocopy date
641: ) is
642: --
643: l_rec pay_ecu_shd.g_rec_type;
644: l_proc varchar2(72) := g_package||'ins';
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);

Line 653: pay_ecu_shd.convert_args

649: -- Call conversion function to turn arguments into the
650: -- p_rec structure.
651: --
652: l_rec :=
653: pay_ecu_shd.convert_args
654: (null
655: ,null
656: ,null
657: ,p_run_type_id