eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_CFV_INS dependencies on AME_CONFIG_VARS

Line 93: from ame_config_vars t

89: -- Cursor to select 'old' created AOL who column values
90: --
91: Cursor C_Sel1 Is
92: select t.creation_date
93: from ame_config_vars t
94: where t.application_id = p_rec.application_id
95: and t.variable_name = p_rec.variable_name
96: and t.start_date =
97: ame_cfv_shd.g_old_rec.start_date

Line 102: from ame_config_vars t

98: and t.end_date = p_validation_start_date;
99: --
100: Cursor C_Sel2 Is
101: select created_by
102: from ame_config_vars t
103: where t.application_id = p_rec.application_id
104: and t.variable_name = p_rec.variable_name
105: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
106: and rownum <2;

Line 109: l_created_by ame_config_vars.created_by%TYPE;

105: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById
106: and rownum <2;
107: --
108: l_proc varchar2(72) := g_package||'dt_insert_dml';
109: l_created_by ame_config_vars.created_by%TYPE;
110: l_creation_date ame_config_vars.creation_date%TYPE;
111: l_last_update_date ame_config_vars.last_update_date%TYPE;
112: l_last_updated_by ame_config_vars.last_updated_by%TYPE;
113: l_last_update_login ame_config_vars.last_update_login%TYPE;

Line 110: l_creation_date ame_config_vars.creation_date%TYPE;

106: and rownum <2;
107: --
108: l_proc varchar2(72) := g_package||'dt_insert_dml';
109: l_created_by ame_config_vars.created_by%TYPE;
110: l_creation_date ame_config_vars.creation_date%TYPE;
111: l_last_update_date ame_config_vars.last_update_date%TYPE;
112: l_last_updated_by ame_config_vars.last_updated_by%TYPE;
113: l_last_update_login ame_config_vars.last_update_login%TYPE;
114: l_current_user_id integer;

Line 111: l_last_update_date ame_config_vars.last_update_date%TYPE;

107: --
108: l_proc varchar2(72) := g_package||'dt_insert_dml';
109: l_created_by ame_config_vars.created_by%TYPE;
110: l_creation_date ame_config_vars.creation_date%TYPE;
111: l_last_update_date ame_config_vars.last_update_date%TYPE;
112: l_last_updated_by ame_config_vars.last_updated_by%TYPE;
113: l_last_update_login ame_config_vars.last_update_login%TYPE;
114: l_current_user_id integer;
115: l_temp_count integer;

Line 112: l_last_updated_by ame_config_vars.last_updated_by%TYPE;

108: l_proc varchar2(72) := g_package||'dt_insert_dml';
109: l_created_by ame_config_vars.created_by%TYPE;
110: l_creation_date ame_config_vars.creation_date%TYPE;
111: l_last_update_date ame_config_vars.last_update_date%TYPE;
112: l_last_updated_by ame_config_vars.last_updated_by%TYPE;
113: l_last_update_login ame_config_vars.last_update_login%TYPE;
114: l_current_user_id integer;
115: l_temp_count integer;
116: --

Line 113: l_last_update_login ame_config_vars.last_update_login%TYPE;

109: l_created_by ame_config_vars.created_by%TYPE;
110: l_creation_date ame_config_vars.creation_date%TYPE;
111: l_last_update_date ame_config_vars.last_update_date%TYPE;
112: l_last_updated_by ame_config_vars.last_updated_by%TYPE;
113: l_last_update_login ame_config_vars.last_update_login%TYPE;
114: l_current_user_id integer;
115: l_temp_count integer;
116: --
117: Begin

Line 192: -- Insert the row into: ame_config_vars

188: End If;
189: --
190: --
191: --
192: -- Insert the row into: ame_config_vars
193: --
194: insert into ame_config_vars
195: (application_id
196: ,variable_name

Line 194: insert into ame_config_vars

190: --
191: --
192: -- Insert the row into: ame_config_vars
193: --
194: insert into ame_config_vars
195: (application_id
196: ,variable_name
197: ,variable_value
198: ,description

Line 320: from ame_config_vars

316: ) is
317: --
318: Cursor csr_description(p_variable_name varchar2) is
319: Select description
320: from ame_config_vars
321: where application_id = ame_utility_pkg.defaultAmeAppId
322: and variable_name = p_variable_name;
323: Cursor C_Sel2 is
324: Select null

Line 325: from ame_config_vars

321: where application_id = ame_utility_pkg.defaultAmeAppId
322: and variable_name = p_variable_name;
323: Cursor C_Sel2 is
324: Select null
325: from ame_config_vars
326: where application_id =
327: ame_cfv_ins.g_application_id_i
328: and variable_name =
329: ame_cfv_ins.g_variable_name_i

Line 352: fnd_message.set_token('TABLE_NAME','ame_config_vars');

348: --
349: -- The primary key values are already in use.
350: --
351: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
352: fnd_message.set_token('TABLE_NAME','ame_config_vars');
353: fnd_message.raise_error;
354: End If;
355: Close C_Sel2;
356: --

Line 455: (p_module_name => 'AME_CONFIG_VARS'

451: --
452: when hr_api.cannot_find_prog_unit then
453: --
454: hr_api.cannot_find_prog_unit_error
455: (p_module_name => 'AME_CONFIG_VARS'
456: ,p_hook_type => 'AI');
457: --
458: end;
459: --