DBA Data[Home] [Help]

APPS.PAY_PRF_INS dependencies on PAY_PRF_SHD

Line 124: (p_rec in out nocopy pay_prf_shd.g_rec_type

120: --
121: -- {End Of Comments}
122: -- ----------------------------------------------------------------------------
123: Procedure insert_dml
124: (p_rec in out nocopy pay_prf_shd.g_rec_type
125: ) is
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --

Line 297: pay_prf_shd.constraint_error

293: Exception
294: When hr_api.check_integrity_violated Then
295: -- A check constraint has been violated
296: --
297: pay_prf_shd.constraint_error
298: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
299: When hr_api.parent_integrity_violated Then
300: -- Parent integrity has been violated
301: --

Line 302: pay_prf_shd.constraint_error

298: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
299: When hr_api.parent_integrity_violated Then
300: -- Parent integrity has been violated
301: --
302: pay_prf_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: --

Line 307: pay_prf_shd.constraint_error

303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: --
307: pay_prf_shd.constraint_error
308: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
309: When Others Then
310: --
311: Raise;

Line 352: (p_rec in out nocopy pay_prf_shd.g_rec_type

348: --
349: -- {End Of Comments}
350: -- ----------------------------------------------------------------------------
351: Procedure pre_insert
352: (p_rec in out nocopy pay_prf_shd.g_rec_type
353: ) is
354: --
355: Cursor C_Sel1 is select pay_range_tables_f_s.nextval from sys.dual;
356: --

Line 439: (p_rec in pay_prf_shd.g_rec_type

435: --
436: -- {End Of Comments}
437: -- ----------------------------------------------------------------------------
438: Procedure post_insert
439: (p_rec in pay_prf_shd.g_rec_type
440: ) is
441: --
442: l_proc varchar2(72) := g_package||'post_insert';
443: --

Line 623: (p_rec in out nocopy pay_prf_shd.g_rec_type

619: -- ----------------------------------------------------------------------------
620: -- |---------------------------------< ins >----------------------------------|
621: -- ----------------------------------------------------------------------------
622: Procedure ins
623: (p_rec in out nocopy pay_prf_shd.g_rec_type
624: ) is
625: --
626: l_proc varchar2(72) := g_package||'ins';
627: --

Line 745: l_rec pay_prf_shd.g_rec_type;

741: ,p_range_table_id out nocopy number
742: ,p_object_version_number out nocopy number
743: ) is
744: --
745: l_rec pay_prf_shd.g_rec_type;
746: l_proc varchar2(72) := g_package||'ins';
747: --
748: Begin
749: hr_utility.set_location('Entering:'||l_proc, 5);

Line 755: pay_prf_shd.convert_args

751: -- Call conversion function to turn arguments into the
752: -- p_rec structure.
753: --
754: l_rec :=
755: pay_prf_shd.convert_args
756: (null
757: ,p_effective_start_date
758: ,p_effective_end_date
759: ,p_range_table_number