DBA Data[Home] [Help]

APPS.PAY_BAD_INS dependencies on PAY_BAD_SHD

Line 124: (p_rec in out nocopy pay_bad_shd.g_rec_type

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

Line 160: pay_bad_shd.constraint_error

156: Exception
157: When hr_api.check_integrity_violated Then
158: -- A check constraint has been violated
159: --
160: pay_bad_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.parent_integrity_violated Then
163: -- Parent integrity has been violated
164: --

Line 165: pay_bad_shd.constraint_error

161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.parent_integrity_violated Then
163: -- Parent integrity has been violated
164: --
165: pay_bad_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.unique_integrity_violated Then
168: -- Unique integrity has been violated
169: --

Line 170: pay_bad_shd.constraint_error

166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.unique_integrity_violated Then
168: -- Unique integrity has been violated
169: --
170: pay_bad_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When Others Then
173: --
174: Raise;

Line 215: (p_rec in out nocopy pay_bad_shd.g_rec_type

211: --
212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure pre_insert
215: (p_rec in out nocopy pay_bad_shd.g_rec_type
216: ) is
217: --
218: Cursor C_Sel1 is select pay_bal_attribute_definition_s.nextval from sys.dual;
219: --

Line 303: ,p_rec in pay_bad_shd.g_rec_type

299: -- {End Of Comments}
300: -- ----------------------------------------------------------------------------
301: Procedure post_insert
302: (p_effective_date in date
303: ,p_rec in pay_bad_shd.g_rec_type
304: ) is
305: --
306: l_proc varchar2(72) := g_package||'post_insert';
307: --

Line 352: ,p_rec in out nocopy pay_bad_shd.g_rec_type

348: -- |---------------------------------< ins >----------------------------------|
349: -- ----------------------------------------------------------------------------
350: Procedure ins
351: (p_effective_date in date
352: ,p_rec in out nocopy pay_bad_shd.g_rec_type
353: ) is
354: --
355: l_proc varchar2(72) := g_package||'ins';
356: --

Line 404: l_rec pay_bad_shd.g_rec_type;

400: ,p_user_attribute_name in varchar2 default null
401: ,p_attribute_id out nocopy number
402: ) is
403: --
404: l_rec pay_bad_shd.g_rec_type;
405: l_proc varchar2(72) := g_package||'ins';
406: --
407: Begin
408: hr_utility.set_location('Entering:'||l_proc, 5);

Line 414: pay_bad_shd.convert_args

410: -- Call conversion function to turn arguments into the
411: -- p_rec structure.
412: --
413: l_rec :=
414: pay_bad_shd.convert_args
415: (null
416: ,p_attribute_name
417: ,p_alterable
418: ,p_legislation_code