DBA Data[Home] [Help]

APPS.PER_AST_INS dependencies on PER_AST_SHD

Line 71: Procedure insert_dml(p_rec in out nocopy per_ast_shd.g_rec_type) is

67: -- Internal Table Handler Use Only.
68: --
69: -- {End Of Comments}
70: -- ----------------------------------------------------------------------------
71: Procedure insert_dml(p_rec in out nocopy per_ast_shd.g_rec_type) is
72: --
73: l_proc varchar2(72) := g_package||'insert_dml';
74: --
75: Begin

Line 183: per_ast_shd.constraint_error

179: -- dbms_output.put_line('A check constraint has been violated insert-dml');
180: hr_utility.trace('A check constraint has been violated insert-dml');
181: -- dbms_output.put_line('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
182: hr_utility.trace('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
183: per_ast_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Bug#885806
187: -- dbms_output.put_line('Parent integrity has been violated insert-dml');

Line 190: per_ast_shd.constraint_error

186: -- Bug#885806
187: -- dbms_output.put_line('Parent integrity has been violated insert-dml');
188: hr_utility.trace('Parent integrity has been violated insert-dml');
189: -- Parent integrity has been violated
190: per_ast_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Bug#885806
194: -- dbms_output.put_line('Unique integrity has been violated insert-dml');

Line 197: per_ast_shd.constraint_error

193: -- Bug#885806
194: -- dbms_output.put_line('Unique integrity has been violated insert-dml');
195: hr_utility.trace('Unique integrity has been violated insert-dml');
196: -- Unique integrity has been violated
197: per_ast_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When Others Then
200: -- Bug#885806
201: -- dbms_output.put_line('Something else has been violated insert-dml');

Line 243: Procedure pre_insert(p_rec in out nocopy per_ast_shd.g_rec_type) is

239: -- Internal Table Handler Use Only.
240: --
241: -- {End Of Comments}
242: -- ----------------------------------------------------------------------------
243: Procedure pre_insert(p_rec in out nocopy per_ast_shd.g_rec_type) is
244: --
245: l_proc varchar2(72) := g_package||'pre_insert';
246: l_exists varchar2(1);
247: --

Line 324: Procedure post_insert(p_rec in per_ast_shd.g_rec_type) is

320: -- Internal Table Handler Use Only.
321: --
322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure post_insert(p_rec in per_ast_shd.g_rec_type) is
325: --
326: l_proc varchar2(72) := g_package||'post_insert';
327: --
328: Begin

Line 395: (p_rec in out nocopy per_ast_shd.g_rec_type

391: -- ----------------------------------------------------------------------------
392: -- |---------------------------------< ins >----------------------------------|
393: -- ----------------------------------------------------------------------------
394: Procedure ins
395: (p_rec in out nocopy per_ast_shd.g_rec_type
396: ,p_validate in boolean default false
397: ,p_effective_date in date
398: ) is
399: --

Line 505: l_rec per_ast_shd.g_rec_type;

501: p_validate in boolean default false,
502: p_effective_date in date
503: ) is
504: --
505: l_rec per_ast_shd.g_rec_type;
506: l_proc varchar2(72) := g_package||'ins';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);

Line 515: per_ast_shd.convert_args

511: -- Call conversion function to turn arguments into the
512: -- p_rec structure.
513: --
514: l_rec :=
515: per_ast_shd.convert_args
516: (
517: null,
518: p_name,
519: p_business_group_id,