APPS.PAY_ROM_INS dependencies on PAY_ROM_SHD

Line 58: (p_rec in out nocopy pay_rom_shd.g_rec_type

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

68: t.creation_date
69: from pay_run_type_org_methods_f t
70: where t.run_type_org_method_id = p_rec.run_type_org_method_id
71: and t.effective_start_date =
72: pay_rom_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_org_methods_f.created_by%TYPE;

Line 178: pay_rom_shd.constraint_error

174: Exception
175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated
177: --
178: pay_rom_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --

Line 183: pay_rom_shd.constraint_error

179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --
183: pay_rom_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: --
187: Raise;

Line 247: (p_rec in out nocopy pay_rom_shd.g_rec_type

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

Line 310: (p_rec in out nocopy pay_rom_shd.g_rec_type

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

Line 368: (p_rec in pay_rom_shd.g_rec_type

364: --
365: -- {End Of Comments}
366: -- ----------------------------------------------------------------------------
367: Procedure post_insert
368: (p_rec in pay_rom_shd.g_rec_type
369: ,p_effective_date in date
370: ,p_datetrack_mode in varchar2
371: ,p_validation_start_date in date
372: ,p_validation_end_date in date

Line 468: ,p_rec in pay_rom_shd.g_rec_type

464: -- ----------------------------------------------------------------------------
465: Procedure ins_lck
466: (p_effective_date in date
467: ,p_datetrack_mode in varchar2
468: ,p_rec in pay_rom_shd.g_rec_type
469: ,p_validation_start_date out nocopy date
470: ,p_validation_end_date out nocopy date
471: ) is
472: --

Line 514: ,p_rec in out nocopy pay_rom_shd.g_rec_type

510: -- |---------------------------------< ins >----------------------------------|
511: -- ----------------------------------------------------------------------------
512: Procedure ins
513: (p_effective_date in date
514: ,p_rec in out nocopy pay_rom_shd.g_rec_type
515: ) is
516: --
517: l_proc varchar2(72) := g_package||'ins';
518: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 596: l_rec pay_rom_shd.g_rec_type;

592: ,p_effective_start_date out nocopy date
593: ,p_effective_end_date out nocopy date
594: ) is
595: --
596: l_rec pay_rom_shd.g_rec_type;
597: l_proc varchar2(72) := g_package||'ins';
598: --
599: Begin
600: hr_utility.set_location('Entering:'||l_proc, 5);

Line 606: pay_rom_shd.convert_args

602: -- Call conversion function to turn arguments into the
603: -- p_rec structure.
604: --
605: l_rec :=
606: pay_rom_shd.convert_args
607: (p_run_type_id
608: ,p_org_payment_method_id
609: ,null
610: ,null