APPS.PAY_RTU_INS dependencies on PAY_RTU_SHD

Line 58: (p_rec in out nocopy pay_rtu_shd.g_rec_type

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

68: t.creation_date
69: from pay_run_type_usages_f t
70: where t.run_type_usage_id = p_rec.run_type_usage_id
71: and t.effective_start_date =
72: pay_rtu_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_run_type_usages_f.created_by%TYPE;

Line 174: pay_rtu_shd.constraint_error

170: Exception
171: When hr_api.check_integrity_violated Then
172: -- A check constraint has been violated
173: --
174: pay_rtu_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: --

Line 179: pay_rtu_shd.constraint_error

175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: --
179: pay_rtu_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: --
183: Raise;

Line 237: (p_rec in out nocopy pay_rtu_shd.g_rec_type

233: -- ----------------------------------------------------------------------------
234: -- |------------------------------< insert_dml >------------------------------|
235: -- ----------------------------------------------------------------------------
236: Procedure insert_dml
237: (p_rec in out nocopy pay_rtu_shd.g_rec_type
238: ,p_effective_date in date
239: ,p_datetrack_mode in varchar2
240: ,p_validation_start_date in date
241: ,p_validation_end_date in date

Line 300: (p_rec in out nocopy pay_rtu_shd.g_rec_type

296: --
297: -- {End Of Comments}
298: -- ----------------------------------------------------------------------------
299: Procedure pre_insert
300: (p_rec in out nocopy pay_rtu_shd.g_rec_type
301: ,p_effective_date in date
302: ,p_datetrack_mode in varchar2
303: ,p_validation_start_date in date
304: ,p_validation_end_date in date

Line 358: (p_rec in pay_rtu_shd.g_rec_type

354: --
355: -- {End Of Comments}
356: -- ----------------------------------------------------------------------------
357: Procedure post_insert
358: (p_rec in pay_rtu_shd.g_rec_type
359: ,p_effective_date in date
360: ,p_datetrack_mode in varchar2
361: ,p_validation_start_date in date
362: ,p_validation_end_date in date

Line 454: ,p_rec in pay_rtu_shd.g_rec_type

450: -- ----------------------------------------------------------------------------
451: Procedure ins_lck
452: (p_effective_date in date
453: ,p_datetrack_mode in varchar2
454: ,p_rec in pay_rtu_shd.g_rec_type
455: ,p_validation_start_date out nocopy date
456: ,p_validation_end_date out nocopy date
457: ) is
458: --

Line 500: ,p_rec in out nocopy pay_rtu_shd.g_rec_type

496: -- |---------------------------------< ins >----------------------------------|
497: -- ----------------------------------------------------------------------------
498: Procedure ins
499: (p_effective_date in date
500: ,p_rec in out nocopy pay_rtu_shd.g_rec_type
501: ) is
502: --
503: l_proc varchar2(72) := g_package||'ins';
504: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 580: l_rec pay_rtu_shd.g_rec_type;

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

Line 590: pay_rtu_shd.convert_args

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