APPS.AME_RTL_INS dependencies on AME_RULES_TL

Line 58: l_created_by ame_rules_tl.created_by%TYPE;

54: (p_rec in out nocopy ame_rtl_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by ame_rules_tl.created_by%TYPE;
59: l_creation_date ame_rules_tl.creation_date%TYPE;
60: l_last_update_date ame_rules_tl.last_update_date%TYPE;
61: l_last_updated_by ame_rules_tl.last_updated_by%TYPE;
62: l_last_update_login ame_rules_tl.last_update_login%TYPE;

Line 59: l_creation_date ame_rules_tl.creation_date%TYPE;

55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by ame_rules_tl.created_by%TYPE;
59: l_creation_date ame_rules_tl.creation_date%TYPE;
60: l_last_update_date ame_rules_tl.last_update_date%TYPE;
61: l_last_updated_by ame_rules_tl.last_updated_by%TYPE;
62: l_last_update_login ame_rules_tl.last_update_login%TYPE;
63: l_current_user_id integer;

Line 60: l_last_update_date ame_rules_tl.last_update_date%TYPE;

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by ame_rules_tl.created_by%TYPE;
59: l_creation_date ame_rules_tl.creation_date%TYPE;
60: l_last_update_date ame_rules_tl.last_update_date%TYPE;
61: l_last_updated_by ame_rules_tl.last_updated_by%TYPE;
62: l_last_update_login ame_rules_tl.last_update_login%TYPE;
63: l_current_user_id integer;
64:

Line 61: l_last_updated_by ame_rules_tl.last_updated_by%TYPE;

57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by ame_rules_tl.created_by%TYPE;
59: l_creation_date ame_rules_tl.creation_date%TYPE;
60: l_last_update_date ame_rules_tl.last_update_date%TYPE;
61: l_last_updated_by ame_rules_tl.last_updated_by%TYPE;
62: l_last_update_login ame_rules_tl.last_update_login%TYPE;
63: l_current_user_id integer;
64:
65: --

Line 62: l_last_update_login ame_rules_tl.last_update_login%TYPE;

58: l_created_by ame_rules_tl.created_by%TYPE;
59: l_creation_date ame_rules_tl.creation_date%TYPE;
60: l_last_update_date ame_rules_tl.last_update_date%TYPE;
61: l_last_updated_by ame_rules_tl.last_updated_by%TYPE;
62: l_last_update_login ame_rules_tl.last_update_login%TYPE;
63: l_current_user_id integer;
64:
65: --
66: Begin

Line 83: -- Insert the row into: ame_rules_tl

79: --
80: --
81: --
82: --
83: -- Insert the row into: ame_rules_tl
84: --
85: insert into ame_rules_tl
86: (rule_id
87: ,language

Line 85: insert into ame_rules_tl

81: --
82: --
83: -- Insert the row into: ame_rules_tl
84: --
85: insert into ame_rules_tl
86: (rule_id
87: ,language
88: ,source_lang
89: ,description

Line 242: (p_module_name => 'AME_RULES_TL'

238: --
239: when hr_api.cannot_find_prog_unit then
240: --
241: hr_api.cannot_find_prog_unit_error
242: (p_module_name => 'AME_RULES_TL'
243: ,p_hook_type => 'AI');
244: --
245: end;
246: --

Line 354: from ame_rules_tl rtl

350: select l.language_code
351: from fnd_languages l
352: where l.installed_flag in ('I','B')
353: and not exists (select null
354: from ame_rules_tl rtl
355: where rtl.rule_id = p_rule_id
356: and rtl.language = l.language_code);
357: --
358: l_proc varchar2(72) := g_package || 'ins_tl';