APPS.AME_MULTI_TENANCY_PKG dependencies on AME_CONFIG_VARS

Line 203: from ame_config_vars

199: l_proc_name varchar2(100);
200: --
201: cursor checkConfigExists(c_var_name in varchar2) is
202: select count(*)
203: from ame_config_vars
204: where application_id = g_ent_appl_id
205: and variable_name = c_var_name
206: and sysdate between start_date and nvl(end_Date,sysdate);
207: --

Line 213: from ame_config_vars ent

209: select ent.object_version_number
210: ,ent.variable_value
211: ,ent.creation_date
212: ,ent.last_update_date
213: from ame_config_vars ent
214: where ent.application_id = g_ent_appl_id
215: and ent.variable_name = c_var_name
216: and ent.variable_value <> c_var_value
217: and sysdate between ent.start_Date and nvl(ent.end_Date,sysdate)

Line 243: update ame_config_vars

239: ,p_object_version_number => l_ovn
240: ,p_start_date => l_start_date
241: ,p_end_date => l_end_Date
242: );
243: update ame_config_vars
244: set created_by = getSeedUser
245: ,last_updated_by = getSeedUser
246: where application_id = g_ent_appl_id
247: and variable_name = g_seed_config_usg(i).variable_name

Line 266: update ame_config_vars

262: ,p_object_version_number => l_ovn
263: ,p_start_date => l_start_date
264: ,p_end_date => l_end_Date
265: );
266: update ame_config_vars
267: set created_by = getSeedUser
268: ,last_updated_by = getSeedUser
269: where application_id = g_ent_appl_id
270: and variable_name = g_seed_config_usg(i).variable_name

Line 1235: from ame_config_vars

1231: l_start_date date;
1232: l_end_Date date;
1233: cursor getAllowApprTypeConfig(c_appl_id in number) is
1234: select variable_value,object_version_number
1235: from ame_config_vars
1236: where variable_name = ame_util.allowAllApproverTypesConfigVar
1237: and application_id = c_appl_id
1238: and sysdate between start_date and nvl(end_date,sysdate);
1239: begin

Line 1275: update ame_config_vars

1271: ,p_object_version_number => l_ovn
1272: ,p_start_date => l_start_date
1273: ,p_end_date => l_end_Date
1274: );
1275: update ame_config_vars
1276: set last_updated_by = getSeedUser
1277: where application_id = g_seed_appl_id
1278: and variable_name = ame_util.allowAllApproverTypesConfigVar
1279: and sysdate between start_date and nvl(end_date,sysdate);

Line 1287: from ame_Config_vars seed

1283: end if;
1284: logMessage(l_proc_name,'Reading configuration variables data');
1285: open seed_row for
1286: select *
1287: from ame_Config_vars seed
1288: where application_id = g_seed_appl_id
1289: and sysdate between start_Date and nvl(end_Date,sysdate);
1290: fetch seed_row bulk collect into g_seed_config_usg;
1291: close seed_row;