DBA Data[Home] [Help]

APPS.AME_ADMIN_PKG dependencies on AME_CONFIG_VARS

Line 954: from ame_config_vars

950: isStripingOn varchar2(20);
951: begin
952: select variable_value
953: into isStripingOn
954: from ame_config_vars
955: where application_id = applicationIdIn and
956: variable_name = ame_util.useRuleStripingConfigVar and
957: (start_date <= sysdate and
958: (end_date is null or sysdate < end_date));

Line 1304: from ame_config_vars

1300: tempCount integer;
1301: begin
1302: select count(*)
1303: into tempCount
1304: from ame_config_vars
1305: where
1306: application_id = applicationIdIn and
1307: variable_name = variableNameIn and
1308: sysdate between start_date and

Line 2380: update ame_config_vars

2376: end clearTransException;
2377: procedure clearTransTypeConfigVarValue(applicationIdIn in integer,
2378: variableNameIn in varchar2) as
2379: begin
2380: update ame_config_vars
2381: set end_date = sysdate
2382: where
2383: application_id = applicationIdIn and
2384: variable_name = variableNameIn and

Line 2807: from ame_config_vars

2803: cursor configVariablesCursor is
2804: select
2805: variable_name,
2806: description
2807: from ame_config_vars
2808: where
2809: application_id is null and
2810: sysdate between start_date and
2811: nvl(end_date - ame_util.oneSecond, sysdate)

Line 5392: update ame_config_vars

5388: where
5389: application_id = applicationIdIn and
5390: processingDate between start_date and
5391: nvl(end_date - ame_util.oneSecond, processingDate);
5392: update ame_config_vars
5393: set
5394: last_updated_by = currentUserId,
5395: last_update_date = processingDate,
5396: last_update_login = currentUserId,