APPS.AME_UTIL dependencies on AME_CONFIG_VARS

Line 249: adminName ame_config_vars.variable_value%type;

245: end escapeSpaceChars;
246: function getAdminName(applicationIdIn in integer default null) return varchar2 is
247: badAdminApproverException exception;
248: commaLocation integer;
249: adminName ame_config_vars.variable_value%type;
250: configVarLength integer;
251: errorCode integer;
252: errorMessage ame_util.longestStringType;
253: begin

Line 256: from ame_config_vars

252: errorMessage ame_util.longestStringType;
253: begin
254: select variable_value
255: into adminName
256: from ame_config_vars
257: where variable_name = ame_util.adminApproverConfigVar and
258: application_id = applicationIdIn and
259: sysdate between start_date and
260: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 268: from ame_config_vars

264: exception
265: when no_data_found then
266: select variable_value
267: into adminName
268: from ame_config_vars
269: where variable_name = ame_util.adminApproverConfigVar and
270: (application_id is null or application_id = 0) and
271: sysdate between start_date and
272: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 388: description ame_config_vars.description%type;

384: raise;
385: return(null);
386: end getColumnLength;
387: function getConfigDesc(variableNameIn in varchar2) return varchar2 as
388: description ame_config_vars.description%type;
389: begin
390: select description
391: into description
392: from ame_config_vars

Line 392: from ame_config_vars

388: description ame_config_vars.description%type;
389: begin
390: select description
391: into description
392: from ame_config_vars
393: where
394: variable_name = variableNameIn and
395: (application_id is null or application_id = 0) and
396: sysdate between start_date and

Line 410: variableValue ame_config_vars.variable_value%type;

406: return(null);
407: end getConfigDesc;
408: function getConfigVar(variableNameIn in varchar2,
409: applicationIdIn in integer default null) return varchar2 as
410: variableValue ame_config_vars.variable_value%type;
411: begin
412: if(applicationIdIn is null) then
413: select variable_value
414: into variableValue

Line 415: from ame_config_vars

411: begin
412: if(applicationIdIn is null) then
413: select variable_value
414: into variableValue
415: from ame_config_vars
416: where
417: variable_name = variableNameIn and
418: (application_id is null or application_id = 0) and
419: sysdate between start_date and

Line 425: from ame_config_vars

421: else
422: begin
423: select variable_value
424: into variableValue
425: from ame_config_vars
426: where
427: variable_name = variableNameIn and
428: application_id = applicationIdIn and
429: sysdate between start_date and

Line 436: from ame_config_vars

432: /* If no transaction-type-specific config var exists, revert to the application-wide value. */
433: when no_data_found then
434: select variable_value
435: into variableValue
436: from ame_config_vars
437: where
438: variable_name = variableNameIn and
439: (application_id is null or application_id = 0) and
440: sysdate between start_date and

Line 4033: distributedEnvironment ame_config_vars.variable_value%type;

4029: routineNameIn in varchar2,
4030: exceptionNumberIn in integer,
4031: exceptionStringIn in varchar2) as
4032: applicationId integer;
4033: distributedEnvironment ame_config_vars.variable_value%type;
4034: localError boolean;
4035: logId integer;
4036: transactionId ame_temp_transactions.transaction_id%type;
4037: useWorkflow boolean;

Line 4170: description ame_config_vars.description%type;

4166: procedure setConfigVar(variableNameIn in varchar2,
4167: variableValueIn in varchar2,
4168: applicationIdIn in integer default null) as
4169: currentUserId integer;
4170: description ame_config_vars.description%type;
4171: errorCode varchar2(10);
4172: errorMessage ame_util.longestStringType;
4173: found varchar2(1);
4174: invalidDayException exception;

Line 4192: from ame_config_vars

4188: raise nullVariableValue;
4189: end if;
4190: select description
4191: into description
4192: from ame_config_vars
4193: where variable_name = variableNameIn and
4194: (application_id is null or application_id = 0) and
4195: end_date is null;
4196: currentUserId := ame_util.getCurrentUserId;

Line 4197: if (ame_util.isArgumentTooLong(tableNameIn => 'ame_config_vars',

4193: where variable_name = variableNameIn and
4194: (application_id is null or application_id = 0) and
4195: end_date is null;
4196: currentUserId := ame_util.getCurrentUserId;
4197: if (ame_util.isArgumentTooLong(tableNameIn => 'ame_config_vars',
4198: columnNameIn => 'variable_name',
4199: argumentIn => variableNameIn)) then
4200: raise variableNameTooLong;
4201: end if;

Line 4202: if (ame_util.isArgumentTooLong(tableNameIn => 'ame_config_vars',

4198: columnNameIn => 'variable_name',
4199: argumentIn => variableNameIn)) then
4200: raise variableNameTooLong;
4201: end if;
4202: if (ame_util.isArgumentTooLong(tableNameIn => 'ame_config_vars',
4203: columnNameIn => 'variable_value',
4204: argumentIn => variableValueIn)) then
4205: raise variableValueTooLong;
4206: end if;

Line 4207: update ame_config_vars

4203: columnNameIn => 'variable_value',
4204: argumentIn => variableValueIn)) then
4205: raise variableValueTooLong;
4206: end if;
4207: update ame_config_vars
4208: set
4209: last_updated_by = currentUserId,
4210: last_update_date = sysdate,
4211: last_update_login = currentUserId,

Line 4218: insert into ame_config_vars(variable_name,

4214: ((applicationIdIn is null and (application_id is null or application_id = 0)) or
4215: application_id = applicationIdIn) and
4216: sysdate between start_date and
4217: nvl(end_date - (ame_util.oneSecond), sysdate);
4218: insert into ame_config_vars(variable_name,
4219: variable_value,
4220: description,
4221: created_by,
4222: creation_date,