DBA Data[Home] [Help]

APPS.AME_AYL_INS dependencies on AME_AYL_SHD

Line 54: (p_rec in out nocopy ame_ayl_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy ame_ayl_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_current_user_id number;

Line 115: ame_ayl_shd.constraint_error

111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: ame_ayl_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --

Line 120: ame_ayl_shd.constraint_error

116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
120: ame_ayl_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --

Line 125: ame_ayl_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: ame_ayl_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: --
129: Raise;

Line 170: (p_rec in out nocopy ame_ayl_shd.g_rec_type

166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure pre_insert
170: (p_rec in out nocopy ame_ayl_shd.g_rec_type
171: ,p_action_type_id in number
172: ) is
173: --
174: l_proc varchar2(72) := g_package||'pre_insert';

Line 217: (p_rec in ame_ayl_shd.g_rec_type

213: --
214: -- {End Of Comments}
215: -- ----------------------------------------------------------------------------
216: Procedure post_insert
217: (p_rec in ame_ayl_shd.g_rec_type
218: ) is
219: --
220: l_proc varchar2(72) := g_package||'post_insert';
221: --

Line 256: (p_rec in out nocopy ame_ayl_shd.g_rec_type

252: -- ----------------------------------------------------------------------------
253: -- |---------------------------------< ins >----------------------------------|
254: -- ----------------------------------------------------------------------------
255: Procedure ins
256: (p_rec in out nocopy ame_ayl_shd.g_rec_type
257: ,p_action_type_id in number
258: ) is
259: --
260: l_proc varchar2(72) := g_package||'ins';

Line 308: l_rec ame_ayl_shd.g_rec_type;

304: ,p_user_action_type_name in varchar2
305: ,p_description in varchar2
306: ) is
307: --
308: l_rec ame_ayl_shd.g_rec_type;
309: l_proc varchar2(72) := g_package||'ins';
310: --
311: Begin
312: hr_utility.set_location('Entering:'||l_proc, 5);

Line 318: ame_ayl_shd.convert_args

314: -- Call conversion function to turn arguments into the
315: -- p_rec structure.
316: --
317: l_rec :=
318: ame_ayl_shd.convert_args
319: (null
320: ,p_language
321: ,p_source_lang
322: ,p_user_action_type_name