APPS.PAY_RAN_INS dependencies on PAY_RAN_SHD

Line 76: (p_rec in out nocopy pay_ran_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy pay_ran_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 131: pay_ran_shd.constraint_error

127: Exception
128: When hr_api.check_integrity_violated Then
129: -- A check constraint has been violated
130: --
131: pay_ran_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: --

Line 136: pay_ran_shd.constraint_error

132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.parent_integrity_violated Then
134: -- Parent integrity has been violated
135: --
136: pay_ran_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: --

Line 141: pay_ran_shd.constraint_error

137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.unique_integrity_violated Then
139: -- Unique integrity has been violated
140: --
141: pay_ran_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When Others Then
144: --
145: Raise;

Line 186: (p_rec in out nocopy pay_ran_shd.g_rec_type

182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure pre_insert
186: (p_rec in out nocopy pay_ran_shd.g_rec_type
187: ) is
188: --
189: Cursor C_Sel1 is select pay_ranges_f_s.nextval from sys.dual;
190: --

Line 273: (p_rec in pay_ran_shd.g_rec_type

269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure post_insert
273: (p_rec in pay_ran_shd.g_rec_type
274: ) is
275: --
276: l_proc varchar2(72) := g_package||'post_insert';
277: --

Line 318: (p_rec in out nocopy pay_ran_shd.g_rec_type

314: -- ----------------------------------------------------------------------------
315: -- |---------------------------------< ins >----------------------------------|
316: -- ----------------------------------------------------------------------------
317: Procedure ins
318: (p_rec in out nocopy pay_ran_shd.g_rec_type
319: ) is
320: --
321: l_proc varchar2(72) := g_package||'ins';
322: --

Line 381: l_rec pay_ran_shd.g_rec_type;

377: ,p_range_id out nocopy number
378: ,p_object_version_number out nocopy number
379: ) is
380: --
381: l_rec pay_ran_shd.g_rec_type;
382: l_proc varchar2(72) := g_package||'ins';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);

Line 391: pay_ran_shd.convert_args

387: -- Call conversion function to turn arguments into the
388: -- p_rec structure.
389: --
390: l_rec :=
391: pay_ran_shd.convert_args
392: (null
393: ,p_range_table_id
394: ,p_low_band
395: ,p_high_band