DBA Data[Home] [Help]

APPS.AME_ACL_UPD dependencies on AME_ACL_SHD

Line 55: (p_rec in out nocopy ame_acl_shd.g_rec_type

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

Line 96: ame_acl_shd.constraint_error

92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: --
96: ame_acl_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --

Line 101: ame_acl_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: ame_acl_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --

Line 106: ame_acl_shd.constraint_error

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: ame_acl_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: --
110: Raise;

Line 146: (p_rec in ame_acl_shd.g_rec_type

142: --
143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145: Procedure pre_update
146: (p_rec in ame_acl_shd.g_rec_type
147: ) is
148: --
149: l_proc varchar2(72) := g_package||'pre_update';
150: --

Line 190: (p_rec in ame_acl_shd.g_rec_type

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_update
190: (p_rec in ame_acl_shd.g_rec_type
191: ) is
192: --
193: l_proc varchar2(72) := g_package||'post_update';
194: --

Line 209: => ame_acl_shd.g_old_rec.source_lang

205: => p_rec.source_lang
206: ,p_description
207: => p_rec.description
208: ,p_source_lang_o
209: => ame_acl_shd.g_old_rec.source_lang
210: ,p_description_o
211: => ame_acl_shd.g_old_rec.description
212: );
213: --

Line 211: => ame_acl_shd.g_old_rec.description

207: => p_rec.description
208: ,p_source_lang_o
209: => ame_acl_shd.g_old_rec.source_lang
210: ,p_description_o
211: => ame_acl_shd.g_old_rec.description
212: );
213: --
214: exception
215: --

Line 271: (p_rec in out nocopy ame_acl_shd.g_rec_type

267: --
268: -- {End Of Comments}
269: -- ----------------------------------------------------------------------------
270: Procedure convert_defs
271: (p_rec in out nocopy ame_acl_shd.g_rec_type
272: ) is
273: --
274: Begin
275: --

Line 283: ame_acl_shd.g_old_rec.source_lang;

279: -- is being used then we must set to the 'current' argument value.
280: --
281: If (p_rec.source_lang = hr_api.g_varchar2) then
282: p_rec.source_lang :=
283: ame_acl_shd.g_old_rec.source_lang;
284: End If;
285: If (p_rec.description = hr_api.g_varchar2) then
286: p_rec.description :=
287: ame_acl_shd.g_old_rec.description;

Line 287: ame_acl_shd.g_old_rec.description;

283: ame_acl_shd.g_old_rec.source_lang;
284: End If;
285: If (p_rec.description = hr_api.g_varchar2) then
286: p_rec.description :=
287: ame_acl_shd.g_old_rec.description;
288: End If;
289: --
290: End convert_defs;
291: --

Line 296: (p_rec in out nocopy ame_acl_shd.g_rec_type

292: -- ----------------------------------------------------------------------------
293: -- |---------------------------------< upd >----------------------------------|
294: -- ----------------------------------------------------------------------------
295: Procedure upd
296: (p_rec in out nocopy ame_acl_shd.g_rec_type
297: ) is
298: --
299: l_proc varchar2(72) := g_package||'upd';
300: --

Line 306: ame_acl_shd.lck

302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: -- We must lock the row which we need to update.
305: --
306: ame_acl_shd.lck
307: (p_rec.action_id
308: ,p_rec.language
309: );
310: --

Line 353: l_rec ame_acl_shd.g_rec_type;

349: ,p_source_lang in varchar2 default hr_api.g_varchar2
350: ,p_description in varchar2 default hr_api.g_varchar2
351: ) is
352: --
353: l_rec ame_acl_shd.g_rec_type;
354: l_proc varchar2(72) := g_package||'upd';
355: --
356: Begin
357: hr_utility.set_location('Entering:'||l_proc, 5);

Line 363: ame_acl_shd.convert_args

359: -- Call conversion function to turn arguments into the
360: -- l_rec structure.
361: --
362: l_rec :=
363: ame_acl_shd.convert_args
364: (p_action_id
365: ,p_language
366: ,p_source_lang
367: ,p_description