APPS.AME_CONDITION_PKG dependencies on AME_STRING_VALUES

Line 226: from ame_string_values

222: end getNextConditionKey;
223: function getDescription(conditionIdIn in integer) return varchar2 as
224: cursor stringValueCursor(conditionIdIn in integer) is
225: select string_value
226: from ame_string_values
227: where
228: condition_id = conditionIdIn and
229: sysdate between start_date and
230: nvl(end_date - ame_util.oneSecond, sysdate)

Line 255: tempValue ame_string_values.string_value%type;

251: parameterTwoDateString varchar2(500);
252: parameterTwoNumberString varchar2(500);
253: parameterThree ame_conditions.parameter_three%type;
254: tempIndex integer;
255: tempValue ame_string_values.string_value%type;
256: wfRolesName wf_roles.name%type;
257: begin
258: conditionType := getConditionType(conditionIdIn => conditionIdIn);
259: if(conditionType = ame_util.listModConditionType) then

Line 1068: insert into ame_string_values(condition_id,

1064: null);
1065: if(attributeType = ame_util.stringAttributeType) then
1066: upperLimit := stringValueList.count;
1067: for i in 1..upperLimit loop
1068: insert into ame_string_values(condition_id,
1069: string_value,
1070: created_by,
1071: creation_date,
1072: last_updated_by,

Line 1369: from ame_string_values

1365: processingDate := processingDateIn;
1366: end if;
1367: select count(*)
1368: into useCount
1369: from ame_string_values
1370: where
1371: condition_id = conditionIdIn and
1372: /* string values are case sensitive */
1373: string_value = valueIn and

Line 1379: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_string_values',

1375: nvl(end_date - ame_util.oneSecond, sysdate) ;
1376: if(useCount > 0) then
1377: return(false);
1378: end if;
1379: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_string_values',
1380: columnNameIn => 'string_value',
1381: argumentIn => valueIn)) then
1382: raise stringValueLengthException;
1383: end if;

Line 1385: insert into ame_string_values(condition_id,

1381: argumentIn => valueIn)) then
1382: raise stringValueLengthException;
1383: end if;
1384: currentUserId := ame_util.getCurrentUserId;
1385: insert into ame_string_values(condition_id,
1386: string_value,
1387: created_by,
1388: creation_date,
1389: last_updated_by,

Line 1411: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_string_values',

1407: errorCode := -20001;
1408: errorMessage := ame_util.getMessage(applicationShortNameIn => 'PER',
1409: messageNameIn => 'AME_400190_CON_STR_VAL_LONG',
1410: tokenNameOneIn => 'COLUMN_LENGTH',
1411: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_string_values',
1412: columnNameIn => 'string_value'));
1413: ame_util.runtimeException(packageNameIn => 'ame_condition_pkg',
1414: routineNameIn => 'newStringValue',
1415: exceptionNumberIn => errorCode,

Line 1491: tempStringValue ame_string_values.string_value%type;

1487: startDate date;
1488: stringValueList ame_util.longestStringList;
1489: tempCount integer;
1490: tempIndex integer;
1491: tempStringValue ame_string_values.string_value%type;
1492: tempStringValueList ame_util.longestStringList;
1493: processingDate date;
1494: begin
1495: if processingDateIn is null then

Line 1577: delete from ame_string_values where condition_id = conditionIdIn;

1573: sysdate between start_date and
1574: nvl(end_date - ame_util.oneSecond, sysdate) ;
1575: if conditionType <> ame_util.listModConditionType then
1576: if(attributeType = ame_util.stringAttributeType) then
1577: delete from ame_string_values where condition_id = conditionIdIn;
1578: end if;
1579: end if;
1580: /* (The new function does a commit.) */
1581: conditionId := new(typeIn => conditionType,

Line 2230: from ame_string_values

2226: procedure getStringValueList(conditionIdIn in integer,
2227: stringValueListOut out nocopy ame_util.longestStringList) as
2228: cursor stringValueCursor(conditionIdIn in integer) is
2229: select string_value
2230: from ame_string_values
2231: where condition_id = conditionIdIn and
2232: sysdate between start_date and
2233: nvl(end_date - ame_util.oneSecond, sysdate)
2234: order by string_value asc;

Line 2314: update ame_string_values

2310: if versionStartDateIn = startDate then
2311: if conditionType <> ame_util.listModConditionType then
2312: attributeType := ame_condition_pkg.getAttributeType(conditionIdIn => conditionIdIn);
2313: if(attributeType = ame_util.stringAttributeType) then
2314: update ame_string_values
2315: set
2316: last_updated_by = currentUserId,
2317: last_update_date = processingDate,
2318: last_update_login = currentUserId,

Line 2519: update ame_string_values

2515: currentUserId := ame_util.getCurrentUserId;
2516: if versionStartDateIn = startDate then
2517: stringCount := stringValueListIn.count;
2518: for i in 1..stringCount loop
2519: update ame_string_values
2520: set
2521: last_updated_by = currentUserId,
2522: last_update_date = processingDate,
2523: last_update_login = currentUserId,