APPS.AME_ATTRIBUTE_PKG dependencies on AME_ATTRIBUTES

Line 8: from ame_attributes

4: attributeCount integer;
5: begin
6: select count(*)
7: into attributeCount
8: from ame_attributes
9: where
10: attribute_id = attributeIdIn and
11: sysdate between start_date and
12: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 36: from ame_attributes

32: itemClassId integer;
33: begin
34: select item_class_id
35: into itemClassId
36: from ame_attributes
37: where
38: name = attributeNameIn and
39: sysdate between start_date and
40: nvl(end_date - ame_util.oneSecond, sysdate);

Line 208: from ame_attributes

204: approverTypeId integer;
205: begin
206: select approver_type_id
207: into approverTypeId
208: from ame_attributes
209: where
210: attribute_id = attributeIdIn and
211: sysdate between ame_attributes.start_date and
212: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);

Line 211: sysdate between ame_attributes.start_date and

207: into approverTypeId
208: from ame_attributes
209: where
210: attribute_id = attributeIdIn and
211: sysdate between ame_attributes.start_date and
212: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
213: return(approverTypeId);
214: exception
215: when others then

Line 212: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);

208: from ame_attributes
209: where
210: attribute_id = attributeIdIn and
211: sysdate between ame_attributes.start_date and
212: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate);
213: return(approverTypeId);
214: exception
215: when others then
216: rollback;

Line 233: from ame_attributes,

229: attributeConditionCnt integer;
230: begin
231: select count(*)
232: into attributeConditionCnt
233: from ame_attributes,
234: ame_conditions
235: where
236: ame_attributes.attribute_id = ame_conditions.attribute_id and
237: ame_attributes.attribute_id = attributeIdIn and

Line 236: ame_attributes.attribute_id = ame_conditions.attribute_id and

232: into attributeConditionCnt
233: from ame_attributes,
234: ame_conditions
235: where
236: ame_attributes.attribute_id = ame_conditions.attribute_id and
237: ame_attributes.attribute_id = attributeIdIn and
238: ame_conditions.condition_type = conditionTypeIn and
239: sysdate between ame_attributes.start_date and
240: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 237: ame_attributes.attribute_id = attributeIdIn and

233: from ame_attributes,
234: ame_conditions
235: where
236: ame_attributes.attribute_id = ame_conditions.attribute_id and
237: ame_attributes.attribute_id = attributeIdIn and
238: ame_conditions.condition_type = conditionTypeIn and
239: sysdate between ame_attributes.start_date and
240: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
241: sysdate between ame_conditions.start_date and

Line 239: sysdate between ame_attributes.start_date and

235: where
236: ame_attributes.attribute_id = ame_conditions.attribute_id and
237: ame_attributes.attribute_id = attributeIdIn and
238: ame_conditions.condition_type = conditionTypeIn and
239: sysdate between ame_attributes.start_date and
240: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
241: sysdate between ame_conditions.start_date and
242: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
243: return(attributeConditionCnt);

Line 240: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

236: ame_attributes.attribute_id = ame_conditions.attribute_id and
237: ame_attributes.attribute_id = attributeIdIn and
238: ame_conditions.condition_type = conditionTypeIn and
239: sysdate between ame_attributes.start_date and
240: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
241: sysdate between ame_conditions.start_date and
242: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate);
243: return(attributeConditionCnt);
244: exception

Line 264: from ame_attributes,

260: attributeConditionInUseCnt integer;
261: begin
262: select count(*)
263: into attributeConditionInUseCnt
264: from ame_attributes,
265: ame_conditions,
266: ame_rules,
267: ame_condition_usages
268: where

Line 269: ame_attributes.attribute_id = ame_conditions.attribute_id and

265: ame_conditions,
266: ame_rules,
267: ame_condition_usages
268: where
269: ame_attributes.attribute_id = ame_conditions.attribute_id and
270: ame_conditions.condition_id = ame_condition_usages.condition_id and
271: ame_rules.rule_id = ame_condition_usages.rule_id and
272: ame_rules.rule_id = ruleIdIn and
273: ame_attributes.attribute_id = attributeIdIn and

Line 273: ame_attributes.attribute_id = attributeIdIn and

269: ame_attributes.attribute_id = ame_conditions.attribute_id and
270: ame_conditions.condition_id = ame_condition_usages.condition_id and
271: ame_rules.rule_id = ame_condition_usages.rule_id and
272: ame_rules.rule_id = ruleIdIn and
273: ame_attributes.attribute_id = attributeIdIn and
274: ame_conditions.condition_type = conditionTypeIn and
275: sysdate between ame_attributes.start_date and
276: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
277: sysdate between ame_conditions.start_date and

Line 275: sysdate between ame_attributes.start_date and

271: ame_rules.rule_id = ame_condition_usages.rule_id and
272: ame_rules.rule_id = ruleIdIn and
273: ame_attributes.attribute_id = attributeIdIn and
274: ame_conditions.condition_type = conditionTypeIn and
275: sysdate between ame_attributes.start_date and
276: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
277: sysdate between ame_conditions.start_date and
278: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
279: ((sysdate between ame_condition_usages.start_date and

Line 276: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

272: ame_rules.rule_id = ruleIdIn and
273: ame_attributes.attribute_id = attributeIdIn and
274: ame_conditions.condition_type = conditionTypeIn and
275: sysdate between ame_attributes.start_date and
276: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
277: sysdate between ame_conditions.start_date and
278: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
279: ((sysdate between ame_condition_usages.start_date and
280: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 305: select ame_attributes.name

301: return(null);
302: end getAttributeConditionInUseCnt;
303: function getAttributeNames(actionTypeIdIn in integer) return varchar2 as
304: cursor getAttributeNames(actionTypeIdIn in integer) is
305: select ame_attributes.name
306: from ame_attributes,
307: ame_mandatory_attributes
308: where
309: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

Line 306: from ame_attributes,

302: end getAttributeConditionInUseCnt;
303: function getAttributeNames(actionTypeIdIn in integer) return varchar2 as
304: cursor getAttributeNames(actionTypeIdIn in integer) is
305: select ame_attributes.name
306: from ame_attributes,
307: ame_mandatory_attributes
308: where
309: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
310: ame_mandatory_attributes.action_type_id = actionTypeIdIn and

Line 309: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

305: select ame_attributes.name
306: from ame_attributes,
307: ame_mandatory_attributes
308: where
309: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
310: ame_mandatory_attributes.action_type_id = actionTypeIdIn and
311: sysdate between ame_attributes.start_date and
312: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
313: sysdate between ame_mandatory_attributes.start_date and

Line 311: sysdate between ame_attributes.start_date and

307: ame_mandatory_attributes
308: where
309: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
310: ame_mandatory_attributes.action_type_id = actionTypeIdIn and
311: sysdate between ame_attributes.start_date and
312: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
313: sysdate between ame_mandatory_attributes.start_date and
314: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
315: order by ame_attributes.name;

Line 312: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

308: where
309: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
310: ame_mandatory_attributes.action_type_id = actionTypeIdIn and
311: sysdate between ame_attributes.start_date and
312: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
313: sysdate between ame_mandatory_attributes.start_date and
314: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
315: order by ame_attributes.name;
316: tempCount integer;

Line 315: order by ame_attributes.name;

311: sysdate between ame_attributes.start_date and
312: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
313: sysdate between ame_mandatory_attributes.start_date and
314: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
315: order by ame_attributes.name;
316: tempCount integer;
317: attributeNames varchar2(500);
318: begin
319: tempCount := 1;

Line 344: description ame_attributes.description%type;

340: raise;
341: return(null);
342: end getAttributeNames;
343: function getDescription(attributeIdIn in integer) return varchar2 as
344: description ame_attributes.description%type;
345: begin
346: select description
347: into description
348: from ame_attributes

Line 348: from ame_attributes

344: description ame_attributes.description%type;
345: begin
346: select description
347: into description
348: from ame_attributes
349: where
350: attribute_id = attributeIdIn and
351: sysdate between start_date and
352: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 372: from ame_attributes

368: attributeId integer;
369: begin
370: select attribute_id
371: into attributeId
372: from ame_attributes
373: where
374: name = upper(attributeNameIn) and
375: sysdate between start_date and
376: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 392: itemClassId ame_attributes.item_class_id%type;

388: raise;
389: return(null);
390: end getIdByName;
391: function getItemClassId(attributeIdIn in integer) return integer as
392: itemClassId ame_attributes.item_class_id%type;
393: begin
394: select item_class_id
395: into itemClassId
396: from ame_attributes

Line 396: from ame_attributes

392: itemClassId ame_attributes.item_class_id%type;
393: begin
394: select item_class_id
395: into itemClassId
396: from ame_attributes
397: where
398: attribute_id = attributeIdIn and
399: sysdate between start_date and
400: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 416: lineItem ame_attributes.line_item%type;

412: raise;
413: return(null);
414: end getItemClassId;
415: function getLineItem(attributeIdIn in integer) return varchar2 as
416: lineItem ame_attributes.line_item%type;
417: begin
418: select line_item
419: into lineItem
420: from ame_attributes

Line 420: from ame_attributes

416: lineItem ame_attributes.line_item%type;
417: begin
418: select line_item
419: into lineItem
420: from ame_attributes
421: where
422: attribute_id = attributeIdIn and
423: sysdate between start_date and
424: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 440: name ame_attributes.name%type;

436: raise;
437: return(ame_util.booleanFalse);
438: end getLineItem;
439: function getName(attributeIdIn in integer) return varchar2 as
440: name ame_attributes.name%type;
441: begin
442: select name
443: into name
444: from ame_attributes

Line 444: from ame_attributes

440: name ame_attributes.name%type;
441: begin
442: select name
443: into name
444: from ame_attributes
445: where
446: attribute_id = attributeIdIn and
447: sysdate between start_date and
448: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 513: from ame_attributes

509: startDate date;
510: begin
511: select start_date
512: into startDate
513: from ame_attributes
514: where
515: attribute_id = attributeIdIn and
516: sysdate between start_date and
517: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 681: from ame_attributes

677: stringStartDate varchar2(50);
678: begin
679: select start_date
680: into startDate
681: from ame_attributes
682: where
683: attribute_id = attributeIdIn and
684: sysdate between start_date and
685: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 702: attributeType ame_attributes.attribute_type%type;

698: raise;
699: return(null);
700: end getParentVersionStartDate;
701: function getType(attributeIdIn in integer) return varchar2 as
702: attributeType ame_attributes.attribute_type%type;
703: begin
704: select attribute_type
705: into attributeType
706: from ame_attributes

Line 706: from ame_attributes

702: attributeType ame_attributes.attribute_type%type;
703: begin
704: select attribute_type
705: into attributeType
706: from ame_attributes
707: where
708: attribute_id = attributeIdIn and
709: sysdate between start_date and
710: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 935: from ame_attributes

931: lineItemCount integer;
932: begin
933: select count(*)
934: into lineItemCount
935: from ame_attributes
936: where
937: attribute_id = attributeIdIn and
938: line_item = ame_util.booleanTrue and
939: sysdate between start_date and

Line 990: from ame_attributes

986: itemClassId integer;
987: begin
988: select item_class_id
989: into itemClassId
990: from ame_attributes
991: where
992: attribute_id = attributeIdIn and
993: sysdate between start_date and
994: nvl(end_date - ame_util.oneSecond, sysdate);

Line 1046: from ame_attributes

1042: createdByValue integer;
1043: begin
1044: select created_by
1045: into createdByValue
1046: from ame_attributes
1047: where
1048: attribute_id = attributeIdIn and
1049: sysdate between start_date and
1050: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 1108: from ame_attributes

1104: tempCount integer;
1105: begin
1106: select count(*)
1107: into tempCount
1108: from ame_attributes
1109: where
1110: name = upper(nameIn) and
1111: sysdate between start_date and
1112: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 1138: attributeName ame_attributes.name%type;

1134: attributeIdIn in integer default null,
1135: createdByIn in integer default null) return integer as
1136: attributeExistsException exception;
1137: attributeId integer;
1138: attributeName ame_attributes.name%type;
1139: createdBy integer;
1140: currentUserId integer;
1141: descriptionLengthException exception;
1142: errorCode integer;

Line 1155: from ame_attributes

1151: processingDate := sysdate;
1152: begin
1153: select attribute_id
1154: into attributeId
1155: from ame_attributes
1156: where
1157: (attributeIdIn is null or attribute_id <> attributeIdIn) and
1158: name = attributeName and
1159: sysdate between start_date and

Line 1167: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_attributes',

1163: end if;
1164: exception
1165: when no_data_found then null;
1166: end;
1167: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_attributes',
1168: columnNameIn => 'name',
1169: argumentIn => attributeName)) then
1170: raise nameLengthException;
1171: end if;

Line 1172: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_attributes',

1168: columnNameIn => 'name',
1169: argumentIn => attributeName)) then
1170: raise nameLengthException;
1171: end if;
1172: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_attributes',
1173: columnNameIn => 'attribute_type',
1174: argumentIn => typeIn)) then
1175: raise typeLengthException;
1176: end if;

Line 1177: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_attributes',

1173: columnNameIn => 'attribute_type',
1174: argumentIn => typeIn)) then
1175: raise typeLengthException;
1176: end if;
1177: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_attributes',
1178: columnNameIn => 'description',
1179: argumentIn => descriptionIn)) then
1180: raise descriptionLengthException;
1181: end if;

Line 1195: select ame_attributes_s.nextval into attributeId from dual;

1191: createdBy := currentUserId;
1192: else
1193: createdBy := createdByIn;
1194: end if;
1195: select ame_attributes_s.nextval into attributeId from dual;
1196: else
1197: attributeId := attributeIdIn;
1198: select count(*)
1199: into tempCount

Line 1200: from ame_attributes

1196: else
1197: attributeId := attributeIdIn;
1198: select count(*)
1199: into tempCount
1200: from ame_attributes
1201: where
1202: attribute_id = attributeId and
1203: created_by = ame_util.seededDataCreatedById;
1204: if(tempCount > 0) then

Line 1212: insert into ame_attributes(attribute_id,

1208: else
1209: createdBy := createdByIn;
1210: end if;
1211: end if;
1212: insert into ame_attributes(attribute_id,
1213: name,
1214: attribute_type,
1215: created_by,
1216: creation_date,

Line 1265: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attributes',

1261: errorMessage :=
1262: ame_util.getMessage(applicationShortNameIn => 'PER',
1263: messageNameIn => 'AME_400153_ATT_NAME_LONG',
1264: tokenNameOneIn => 'COLUMN_LENGTH',
1265: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attributes',
1266: columnNameIn => 'name'));
1267: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1268: routineNameIn => 'new',
1269: exceptionNumberIn => errorCode,

Line 1281: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attributes',

1277: errorMessage :=
1278: ame_util.getMessage(applicationShortNameIn => 'PER',
1279: messageNameIn => 'AME_400154_ATT_TYPE_LONG',
1280: tokenNameOneIn => 'COLUMN_LENGTH',
1281: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attributes',
1282: columnNameIn => 'attribute_type'));
1283: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1284: routineNameIn => 'new',
1285: exceptionNumberIn => errorCode,

Line 1297: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attributes',

1293: errorMessage :=
1294: ame_util.getMessage(applicationShortNameIn => 'PER',
1295: messageNameIn => 'AME_400155_ATT_DESC_LONG',
1296: tokenNameOneIn => 'COLUMN_LENGTH',
1297: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attributes',
1298: columnNameIn => 'description'));
1299: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
1300: routineNameIn => 'new',
1301: exceptionNumberIn => errorCode,

Line 1364: update ame_attributes

1360: currentUserId integer;
1361: begin
1362: currentUserId := ame_util.getCurrentUserId;
1363: approverTypeId := getApproverTypeId(attributeIdIn => attributeIdIn);
1364: update ame_attributes
1365: set
1366: last_updated_by = currentUserId,
1367: last_update_date = endDateIn,
1368: last_update_login = currentUserId,

Line 1409: from ame_attributes

1405: itemClassIdIn in integer,
1406: finalizeIn in boolean default false) as
1407: cursor startDateCursor is
1408: select start_date
1409: from ame_attributes
1410: where
1411: attribute_id = attributeIdIn and
1412: sysdate between start_date and
1413: nvl(end_date - ame_util.oneSecond, sysdate)

Line 1428: name ame_attributes.name%type;

1424: attributeId integer;
1425: currentUserId integer;
1426: errorCode integer;
1427: errorMessage ame_util.longestStringType;
1428: name ame_attributes.name%type;
1429: attributeType ame_attributes.attribute_type%type;
1430: description ame_attributes.description%type;
1431: invalidReferenceException exception;
1432: newStartAndEndDate date;

Line 1429: attributeType ame_attributes.attribute_type%type;

1425: currentUserId integer;
1426: errorCode integer;
1427: errorMessage ame_util.longestStringType;
1428: name ame_attributes.name%type;
1429: attributeType ame_attributes.attribute_type%type;
1430: description ame_attributes.description%type;
1431: invalidReferenceException exception;
1432: newStartAndEndDate date;
1433: objectVersionNoDataException exception;

Line 1430: description ame_attributes.description%type;

1426: errorCode integer;
1427: errorMessage ame_util.longestStringType;
1428: name ame_attributes.name%type;
1429: attributeType ame_attributes.attribute_type%type;
1430: description ame_attributes.description%type;
1431: invalidReferenceException exception;
1432: newStartAndEndDate date;
1433: objectVersionNoDataException exception;
1434: queryString ame_attribute_usages.query_string%type;

Line 1469: ame_attributes,

1465: /* Check whether the input values match the existing values; if so, just return. */
1466: select count(*)
1467: into tempCount
1468: from
1469: ame_attributes,
1470: ame_attribute_usages
1471: where
1472: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1473: ame_attributes.attribute_id = attributeIdIn and

Line 1472: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

1468: from
1469: ame_attributes,
1470: ame_attribute_usages
1471: where
1472: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1473: ame_attributes.attribute_id = attributeIdIn and
1474: ame_attribute_usages.application_id = applicationIdIn and
1475: ame_attribute_usages.is_static = staticUsageIn and
1476: ame_attribute_usages.query_string = queryString and

Line 1473: ame_attributes.attribute_id = attributeIdIn and

1469: ame_attributes,
1470: ame_attribute_usages
1471: where
1472: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1473: ame_attributes.attribute_id = attributeIdIn and
1474: ame_attribute_usages.application_id = applicationIdIn and
1475: ame_attribute_usages.is_static = staticUsageIn and
1476: ame_attribute_usages.query_string = queryString and
1477: (nameIn is null or name = upper(nameIn)) and

Line 1480: sysdate between ame_attributes.start_date and

1476: ame_attribute_usages.query_string = queryString and
1477: (nameIn is null or name = upper(nameIn)) and
1478: (attributeType is null or upper(attribute_type) = upper(attributeType)) and
1479: (descriptionIn is null or description = descriptionIn) and
1480: sysdate between ame_attributes.start_date and
1481: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1482: sysdate between ame_attribute_usages.start_date and
1483: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) ;
1484: if(tempCount > 0) then

Line 1481: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

1477: (nameIn is null or name = upper(nameIn)) and
1478: (attributeType is null or upper(attribute_type) = upper(attributeType)) and
1479: (descriptionIn is null or description = descriptionIn) and
1480: sysdate between ame_attributes.start_date and
1481: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1482: sysdate between ame_attribute_usages.start_date and
1483: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) ;
1484: if(tempCount > 0) then
1485: return;

Line 1611: attributeName ame_attributes.name%type;

1607: queryStringIn in varchar2 default null,
1608: endDateIn in date,
1609: newStartDateIn in date,
1610: finalizeIn in boolean default false) as
1611: attributeName ame_attributes.name%type;
1612: attributeType ame_attributes.attribute_type%type;
1613: comma1Location integer;
1614: comma2Location integer;
1615: currentUserId integer;

Line 1612: attributeType ame_attributes.attribute_type%type;

1608: endDateIn in date,
1609: newStartDateIn in date,
1610: finalizeIn in boolean default false) as
1611: attributeName ame_attributes.name%type;
1612: attributeType ame_attributes.attribute_type%type;
1613: comma1Location integer;
1614: comma2Location integer;
1615: currentUserId integer;
1616: errorCode integer;

Line 1701: ame_attributes.attribute_id attribute_id,

1697: attributeIdsOut out nocopy ame_util.idList,
1698: attributeNamesOut out nocopy ame_util.stringList) as
1699: cursor activeAttributeCursor(applicationIdIn in integer) is
1700: select
1701: ame_attributes.attribute_id attribute_id,
1702: ame_attributes.name name
1703: from
1704: ame_attributes,
1705: ame_attribute_usages

Line 1702: ame_attributes.name name

1698: attributeNamesOut out nocopy ame_util.stringList) as
1699: cursor activeAttributeCursor(applicationIdIn in integer) is
1700: select
1701: ame_attributes.attribute_id attribute_id,
1702: ame_attributes.name name
1703: from
1704: ame_attributes,
1705: ame_attribute_usages
1706: where

Line 1704: ame_attributes,

1700: select
1701: ame_attributes.attribute_id attribute_id,
1702: ame_attributes.name name
1703: from
1704: ame_attributes,
1705: ame_attribute_usages
1706: where
1707: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1708: ame_attribute_usages.application_id = applicationIdIn and

Line 1707: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

1703: from
1704: ame_attributes,
1705: ame_attribute_usages
1706: where
1707: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1708: ame_attribute_usages.application_id = applicationIdIn and
1709: use_count > 0 and
1710: sysdate between ame_attributes.start_date and
1711: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 1710: sysdate between ame_attributes.start_date and

1706: where
1707: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1708: ame_attribute_usages.application_id = applicationIdIn and
1709: use_count > 0 and
1710: sysdate between ame_attributes.start_date and
1711: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1712: sysdate between ame_attribute_usages.start_date and
1713: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1714: order by name;

Line 1711: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

1707: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1708: ame_attribute_usages.application_id = applicationIdIn and
1709: use_count > 0 and
1710: sysdate between ame_attributes.start_date and
1711: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1712: sysdate between ame_attribute_usages.start_date and
1713: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1714: order by name;
1715: cursor mandatoryAttributeCursor(applicationIdIn in integer) is

Line 1717: ame_attributes.attribute_id attribute_id,

1713: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1714: order by name;
1715: cursor mandatoryAttributeCursor(applicationIdIn in integer) is
1716: select
1717: ame_attributes.attribute_id attribute_id,
1718: ame_attributes.name name
1719: from
1720: ame_attributes,
1721: ame_mandatory_attributes

Line 1718: ame_attributes.name name

1714: order by name;
1715: cursor mandatoryAttributeCursor(applicationIdIn in integer) is
1716: select
1717: ame_attributes.attribute_id attribute_id,
1718: ame_attributes.name name
1719: from
1720: ame_attributes,
1721: ame_mandatory_attributes
1722: where

Line 1720: ame_attributes,

1716: select
1717: ame_attributes.attribute_id attribute_id,
1718: ame_attributes.name name
1719: from
1720: ame_attributes,
1721: ame_mandatory_attributes
1722: where
1723: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1724: ame_mandatory_attributes.action_type_id = -1 and

Line 1723: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

1719: from
1720: ame_attributes,
1721: ame_mandatory_attributes
1722: where
1723: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1724: ame_mandatory_attributes.action_type_id = -1 and
1725: sysdate between ame_attributes.start_date and
1726: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1727: sysdate between ame_mandatory_attributes.start_date and

Line 1725: sysdate between ame_attributes.start_date and

1721: ame_mandatory_attributes
1722: where
1723: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1724: ame_mandatory_attributes.action_type_id = -1 and
1725: sysdate between ame_attributes.start_date and
1726: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1727: sysdate between ame_mandatory_attributes.start_date and
1728: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
1729: order by name;

Line 1726: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

1722: where
1723: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1724: ame_mandatory_attributes.action_type_id = -1 and
1725: sysdate between ame_attributes.start_date and
1726: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1727: sysdate between ame_mandatory_attributes.start_date and
1728: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
1729: order by name;
1730: tempIndex integer;

Line 1761: ame_attributes.attribute_id attribute_id,

1757: attributeNamesOut out nocopy ame_util.stringList) as
1758: cursor activeAttributeCursor(applicationIdIn in integer,
1759: itemClassIdIn in integer) is
1760: select
1761: ame_attributes.attribute_id attribute_id,
1762: ame_attributes.name name
1763: from
1764: ame_attributes,
1765: ame_attribute_usages

Line 1762: ame_attributes.name name

1758: cursor activeAttributeCursor(applicationIdIn in integer,
1759: itemClassIdIn in integer) is
1760: select
1761: ame_attributes.attribute_id attribute_id,
1762: ame_attributes.name name
1763: from
1764: ame_attributes,
1765: ame_attribute_usages
1766: where

Line 1764: ame_attributes,

1760: select
1761: ame_attributes.attribute_id attribute_id,
1762: ame_attributes.name name
1763: from
1764: ame_attributes,
1765: ame_attribute_usages
1766: where
1767: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1768: ame_attribute_usages.application_id = applicationIdIn and

Line 1767: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

1763: from
1764: ame_attributes,
1765: ame_attribute_usages
1766: where
1767: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1768: ame_attribute_usages.application_id = applicationIdIn and
1769: ame_attributes.item_class_id = itemClassIdIn and
1770: use_count > 0 and
1771: sysdate between ame_attributes.start_date and

Line 1769: ame_attributes.item_class_id = itemClassIdIn and

1765: ame_attribute_usages
1766: where
1767: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1768: ame_attribute_usages.application_id = applicationIdIn and
1769: ame_attributes.item_class_id = itemClassIdIn and
1770: use_count > 0 and
1771: sysdate between ame_attributes.start_date and
1772: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1773: sysdate between ame_attribute_usages.start_date and

Line 1771: sysdate between ame_attributes.start_date and

1767: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1768: ame_attribute_usages.application_id = applicationIdIn and
1769: ame_attributes.item_class_id = itemClassIdIn and
1770: use_count > 0 and
1771: sysdate between ame_attributes.start_date and
1772: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1773: sysdate between ame_attribute_usages.start_date and
1774: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1775: order by name;

Line 1772: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

1768: ame_attribute_usages.application_id = applicationIdIn and
1769: ame_attributes.item_class_id = itemClassIdIn and
1770: use_count > 0 and
1771: sysdate between ame_attributes.start_date and
1772: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1773: sysdate between ame_attribute_usages.start_date and
1774: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1775: order by name;
1776: cursor mandatoryAttributeCursor(applicationIdIn in integer,

Line 1779: ame_attributes.attribute_id attribute_id,

1775: order by name;
1776: cursor mandatoryAttributeCursor(applicationIdIn in integer,
1777: itemClassIdIn in integer) is
1778: select
1779: ame_attributes.attribute_id attribute_id,
1780: ame_attributes.name name
1781: from
1782: ame_attributes,
1783: ame_mandatory_attributes

Line 1780: ame_attributes.name name

1776: cursor mandatoryAttributeCursor(applicationIdIn in integer,
1777: itemClassIdIn in integer) is
1778: select
1779: ame_attributes.attribute_id attribute_id,
1780: ame_attributes.name name
1781: from
1782: ame_attributes,
1783: ame_mandatory_attributes
1784: where

Line 1782: ame_attributes,

1778: select
1779: ame_attributes.attribute_id attribute_id,
1780: ame_attributes.name name
1781: from
1782: ame_attributes,
1783: ame_mandatory_attributes
1784: where
1785: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1786: ame_attributes.item_class_id = itemClassIdIn and

Line 1785: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

1781: from
1782: ame_attributes,
1783: ame_mandatory_attributes
1784: where
1785: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1786: ame_attributes.item_class_id = itemClassIdIn and
1787: ame_mandatory_attributes.action_type_id = -1 and
1788: sysdate between ame_attributes.start_date and
1789: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 1786: ame_attributes.item_class_id = itemClassIdIn and

1782: ame_attributes,
1783: ame_mandatory_attributes
1784: where
1785: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1786: ame_attributes.item_class_id = itemClassIdIn and
1787: ame_mandatory_attributes.action_type_id = -1 and
1788: sysdate between ame_attributes.start_date and
1789: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1790: sysdate between ame_mandatory_attributes.start_date and

Line 1788: sysdate between ame_attributes.start_date and

1784: where
1785: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1786: ame_attributes.item_class_id = itemClassIdIn and
1787: ame_mandatory_attributes.action_type_id = -1 and
1788: sysdate between ame_attributes.start_date and
1789: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1790: sysdate between ame_mandatory_attributes.start_date and
1791: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
1792: order by name;

Line 1789: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

1785: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
1786: ame_attributes.item_class_id = itemClassIdIn and
1787: ame_mandatory_attributes.action_type_id = -1 and
1788: sysdate between ame_attributes.start_date and
1789: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1790: sysdate between ame_mandatory_attributes.start_date and
1791: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
1792: order by name;
1793: itemClassId integer;

Line 1827: from ame_attributes

1823: procedure getAllAttributes(attributeIdsOut out nocopy ame_util.stringList,
1824: attributeNamesOut out nocopy ame_util.stringList) as
1825: cursor attributeCursor is
1826: select attribute_id, name
1827: from ame_attributes
1828: where
1829: sysdate between start_date and
1830: nvl(end_date - ame_util.oneSecond, sysdate)
1831: order by name;

Line 1885: ame_attributes.attribute_id id,

1881: attributeIdOut out nocopy ame_util.stringList,
1882: attributeNameOut out nocopy ame_util.stringList) as
1883: cursor attributeCursor(applicationIdIn in integer) is
1884: select
1885: ame_attributes.attribute_id id,
1886: ame_attributes.name name
1887: from
1888: ame_attributes,
1889: ame_attribute_usages

Line 1886: ame_attributes.name name

1882: attributeNameOut out nocopy ame_util.stringList) as
1883: cursor attributeCursor(applicationIdIn in integer) is
1884: select
1885: ame_attributes.attribute_id id,
1886: ame_attributes.name name
1887: from
1888: ame_attributes,
1889: ame_attribute_usages
1890: where

Line 1888: ame_attributes,

1884: select
1885: ame_attributes.attribute_id id,
1886: ame_attributes.name name
1887: from
1888: ame_attributes,
1889: ame_attribute_usages
1890: where
1891: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1892: ame_attributes.item_class_id = itemClassIdIn and

Line 1891: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

1887: from
1888: ame_attributes,
1889: ame_attribute_usages
1890: where
1891: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1892: ame_attributes.item_class_id = itemClassIdIn and
1893: ame_attribute_usages.application_id = applicationIdIn and
1894: ame_attributes.attribute_id not in (select attribute_id
1895: from ame_mandatory_attributes

Line 1892: ame_attributes.item_class_id = itemClassIdIn and

1888: ame_attributes,
1889: ame_attribute_usages
1890: where
1891: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1892: ame_attributes.item_class_id = itemClassIdIn and
1893: ame_attribute_usages.application_id = applicationIdIn and
1894: ame_attributes.attribute_id not in (select attribute_id
1895: from ame_mandatory_attributes
1896: where action_type_id = ame_util.mandAttActionTypeId and

Line 1894: ame_attributes.attribute_id not in (select attribute_id

1890: where
1891: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1892: ame_attributes.item_class_id = itemClassIdIn and
1893: ame_attribute_usages.application_id = applicationIdIn and
1894: ame_attributes.attribute_id not in (select attribute_id
1895: from ame_mandatory_attributes
1896: where action_type_id = ame_util.mandAttActionTypeId and
1897: sysdate between start_date and
1898: nvl(end_date - ame_util.oneSecond, sysdate)) and

Line 1899: sysdate between ame_attributes.start_date and

1895: from ame_mandatory_attributes
1896: where action_type_id = ame_util.mandAttActionTypeId and
1897: sysdate between start_date and
1898: nvl(end_date - ame_util.oneSecond, sysdate)) and
1899: sysdate between ame_attributes.start_date and
1900: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1901: sysdate between ame_attribute_usages.start_date and
1902: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1903: order by name;

Line 1900: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

1896: where action_type_id = ame_util.mandAttActionTypeId and
1897: sysdate between start_date and
1898: nvl(end_date - ame_util.oneSecond, sysdate)) and
1899: sysdate between ame_attributes.start_date and
1900: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1901: sysdate between ame_attribute_usages.start_date and
1902: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1903: order by name;
1904: tempIndex integer;

Line 1932: ame_attributes.attribute_id attribute_id,

1928: attributeIdsOut out nocopy ame_util.stringList,
1929: attributeNamesOut out nocopy ame_util.stringList) as
1930: cursor applicationAttributeCursor(applicationIdIn in integer) is
1931: select
1932: ame_attributes.attribute_id attribute_id,
1933: ame_attributes.name name
1934: from
1935: ame_attributes,
1936: ame_attribute_usages

Line 1933: ame_attributes.name name

1929: attributeNamesOut out nocopy ame_util.stringList) as
1930: cursor applicationAttributeCursor(applicationIdIn in integer) is
1931: select
1932: ame_attributes.attribute_id attribute_id,
1933: ame_attributes.name name
1934: from
1935: ame_attributes,
1936: ame_attribute_usages
1937: where

Line 1935: ame_attributes,

1931: select
1932: ame_attributes.attribute_id attribute_id,
1933: ame_attributes.name name
1934: from
1935: ame_attributes,
1936: ame_attribute_usages
1937: where
1938: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1939: ame_attribute_usages.application_id = applicationIdIn and

Line 1938: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

1934: from
1935: ame_attributes,
1936: ame_attribute_usages
1937: where
1938: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1939: ame_attribute_usages.application_id = applicationIdIn and
1940: ame_attributes.attribute_type = ame_util.stringAttributeType and
1941: sysdate between ame_attributes.start_date and
1942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 1940: ame_attributes.attribute_type = ame_util.stringAttributeType and

1936: ame_attribute_usages
1937: where
1938: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1939: ame_attribute_usages.application_id = applicationIdIn and
1940: ame_attributes.attribute_type = ame_util.stringAttributeType and
1941: sysdate between ame_attributes.start_date and
1942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1943: sysdate between ame_attribute_usages.start_date and
1944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)

Line 1941: sysdate between ame_attributes.start_date and

1937: where
1938: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1939: ame_attribute_usages.application_id = applicationIdIn and
1940: ame_attributes.attribute_type = ame_util.stringAttributeType and
1941: sysdate between ame_attributes.start_date and
1942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1943: sysdate between ame_attribute_usages.start_date and
1944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1945: order by name;

Line 1942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

1938: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
1939: ame_attribute_usages.application_id = applicationIdIn and
1940: ame_attributes.attribute_type = ame_util.stringAttributeType and
1941: sysdate between ame_attributes.start_date and
1942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
1943: sysdate between ame_attribute_usages.start_date and
1944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
1945: order by name;
1946: attributeIdList ame_util.idList;

Line 2030: ame_attributes.attribute_id id,

2026: lineItemIn in varchar2) is
2027: /* the distinct below is necessary to select a distinct list of attribute
2028: attribute names that are used within a condition */
2029: select distinct
2030: ame_attributes.attribute_id id,
2031: ame_attributes.name name
2032: from
2033: ame_attributes,
2034: ame_attribute_usages,

Line 2031: ame_attributes.name name

2027: /* the distinct below is necessary to select a distinct list of attribute
2028: attribute names that are used within a condition */
2029: select distinct
2030: ame_attributes.attribute_id id,
2031: ame_attributes.name name
2032: from
2033: ame_attributes,
2034: ame_attribute_usages,
2035: ame_conditions

Line 2033: ame_attributes,

2029: select distinct
2030: ame_attributes.attribute_id id,
2031: ame_attributes.name name
2032: from
2033: ame_attributes,
2034: ame_attribute_usages,
2035: ame_conditions
2036: where
2037: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

Line 2037: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2033: ame_attributes,
2034: ame_attribute_usages,
2035: ame_conditions
2036: where
2037: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2038: ame_conditions.attribute_id = ame_attributes.attribute_id and
2039: ame_attribute_usages.application_id = applicationIdIn and
2040: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2041: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and

Line 2038: ame_conditions.attribute_id = ame_attributes.attribute_id and

2034: ame_attribute_usages,
2035: ame_conditions
2036: where
2037: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2038: ame_conditions.attribute_id = ame_attributes.attribute_id and
2039: ame_attribute_usages.application_id = applicationIdIn and
2040: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2041: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2042: sysdate between ame_attributes.start_date and

Line 2040: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and

2036: where
2037: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2038: ame_conditions.attribute_id = ame_attributes.attribute_id and
2039: ame_attribute_usages.application_id = applicationIdIn and
2040: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2041: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2042: sysdate between ame_attributes.start_date and
2043: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2044: sysdate between ame_attribute_usages.start_date and

Line 2042: sysdate between ame_attributes.start_date and

2038: ame_conditions.attribute_id = ame_attributes.attribute_id and
2039: ame_attribute_usages.application_id = applicationIdIn and
2040: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2041: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2042: sysdate between ame_attributes.start_date and
2043: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2044: sysdate between ame_attribute_usages.start_date and
2045: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2046: sysdate between ame_conditions.start_date and

Line 2043: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2039: ame_attribute_usages.application_id = applicationIdIn and
2040: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2041: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2042: sysdate between ame_attributes.start_date and
2043: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2044: sysdate between ame_attribute_usages.start_date and
2045: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2046: sysdate between ame_conditions.start_date and
2047: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)

Line 2085: ame_attributes.attribute_id id,

2081: lineItemIn in varchar2) is
2082: /* the distinct below is necessary to select a distinct list of attribute
2083: attribute names that are used within a condition */
2084: select distinct
2085: ame_attributes.attribute_id id,
2086: ame_attributes.name name
2087: from
2088: ame_attributes,
2089: ame_attribute_usages,

Line 2086: ame_attributes.name name

2082: /* the distinct below is necessary to select a distinct list of attribute
2083: attribute names that are used within a condition */
2084: select distinct
2085: ame_attributes.attribute_id id,
2086: ame_attributes.name name
2087: from
2088: ame_attributes,
2089: ame_attribute_usages,
2090: ame_conditions

Line 2088: ame_attributes,

2084: select distinct
2085: ame_attributes.attribute_id id,
2086: ame_attributes.name name
2087: from
2088: ame_attributes,
2089: ame_attribute_usages,
2090: ame_conditions
2091: where
2092: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

Line 2092: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2088: ame_attributes,
2089: ame_attribute_usages,
2090: ame_conditions
2091: where
2092: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2093: ame_conditions.attribute_id = ame_attributes.attribute_id and
2094: ame_attribute_usages.application_id = applicationIdIn and
2095: ame_attributes.item_class_id = itemClassIdIn and
2096: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and

Line 2093: ame_conditions.attribute_id = ame_attributes.attribute_id and

2089: ame_attribute_usages,
2090: ame_conditions
2091: where
2092: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2093: ame_conditions.attribute_id = ame_attributes.attribute_id and
2094: ame_attribute_usages.application_id = applicationIdIn and
2095: ame_attributes.item_class_id = itemClassIdIn and
2096: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2097: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and

Line 2095: ame_attributes.item_class_id = itemClassIdIn and

2091: where
2092: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2093: ame_conditions.attribute_id = ame_attributes.attribute_id and
2094: ame_attribute_usages.application_id = applicationIdIn and
2095: ame_attributes.item_class_id = itemClassIdIn and
2096: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2097: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2098: sysdate between ame_attributes.start_date and
2099: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 2096: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and

2092: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2093: ame_conditions.attribute_id = ame_attributes.attribute_id and
2094: ame_attribute_usages.application_id = applicationIdIn and
2095: ame_attributes.item_class_id = itemClassIdIn and
2096: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2097: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2098: sysdate between ame_attributes.start_date and
2099: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2100: sysdate between ame_attribute_usages.start_date and

Line 2098: sysdate between ame_attributes.start_date and

2094: ame_attribute_usages.application_id = applicationIdIn and
2095: ame_attributes.item_class_id = itemClassIdIn and
2096: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2097: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2098: sysdate between ame_attributes.start_date and
2099: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2100: sysdate between ame_attribute_usages.start_date and
2101: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2102: sysdate between ame_conditions.start_date and

Line 2099: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2095: ame_attributes.item_class_id = itemClassIdIn and
2096: nvl(ame_attributes.line_item, ame_util.booleanFalse) = lineItemIn and
2097: ame_conditions.condition_type = decode(ruleTypeIn, 1, ame_util.ordinaryConditionType, 2, ame_util.exceptionConditionType) and
2098: sysdate between ame_attributes.start_date and
2099: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2100: sysdate between ame_attribute_usages.start_date and
2101: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2102: sysdate between ame_conditions.start_date and
2103: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)

Line 2143: ame_attributes.attribute_id id,

2139: ruleTypeIn in integer) is
2140: /* the distinct below is necessary to select a distinct list of attribute
2141: attribute names that are used within a condition */
2142: select distinct
2143: ame_attributes.attribute_id id,
2144: ame_attributes.name name
2145: from
2146: ame_attributes,
2147: ame_attribute_usages,

Line 2144: ame_attributes.name name

2140: /* the distinct below is necessary to select a distinct list of attribute
2141: attribute names that are used within a condition */
2142: select distinct
2143: ame_attributes.attribute_id id,
2144: ame_attributes.name name
2145: from
2146: ame_attributes,
2147: ame_attribute_usages,
2148: ame_conditions

Line 2146: ame_attributes,

2142: select distinct
2143: ame_attributes.attribute_id id,
2144: ame_attributes.name name
2145: from
2146: ame_attributes,
2147: ame_attribute_usages,
2148: ame_conditions
2149: where
2150: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

Line 2150: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2146: ame_attributes,
2147: ame_attribute_usages,
2148: ame_conditions
2149: where
2150: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2151: ame_conditions.attribute_id = ame_attributes.attribute_id and
2152: ame_attribute_usages.application_id = applicationIdIn and
2153: ame_attributes.item_class_id = itemClassIdIn and
2154: ame_conditions.condition_type = conditionTypeIn and

Line 2151: ame_conditions.attribute_id = ame_attributes.attribute_id and

2147: ame_attribute_usages,
2148: ame_conditions
2149: where
2150: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2151: ame_conditions.attribute_id = ame_attributes.attribute_id and
2152: ame_attribute_usages.application_id = applicationIdIn and
2153: ame_attributes.item_class_id = itemClassIdIn and
2154: ame_conditions.condition_type = conditionTypeIn and
2155: sysdate between ame_attributes.start_date and

Line 2153: ame_attributes.item_class_id = itemClassIdIn and

2149: where
2150: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2151: ame_conditions.attribute_id = ame_attributes.attribute_id and
2152: ame_attribute_usages.application_id = applicationIdIn and
2153: ame_attributes.item_class_id = itemClassIdIn and
2154: ame_conditions.condition_type = conditionTypeIn and
2155: sysdate between ame_attributes.start_date and
2156: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2157: sysdate between ame_attribute_usages.start_date and

Line 2155: sysdate between ame_attributes.start_date and

2151: ame_conditions.attribute_id = ame_attributes.attribute_id and
2152: ame_attribute_usages.application_id = applicationIdIn and
2153: ame_attributes.item_class_id = itemClassIdIn and
2154: ame_conditions.condition_type = conditionTypeIn and
2155: sysdate between ame_attributes.start_date and
2156: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2157: sysdate between ame_attribute_usages.start_date and
2158: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2159: sysdate between ame_conditions.start_date and

Line 2156: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2152: ame_attribute_usages.application_id = applicationIdIn and
2153: ame_attributes.item_class_id = itemClassIdIn and
2154: ame_conditions.condition_type = conditionTypeIn and
2155: sysdate between ame_attributes.start_date and
2156: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2157: sysdate between ame_attribute_usages.start_date and
2158: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2159: sysdate between ame_conditions.start_date and
2160: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate)

Line 2229: ame_attributes.attribute_id,

2225: attributeIdOut out nocopy ame_util.stringList,
2226: attributeNameOut out nocopy ame_util.stringList) as
2227: cursor attributeCursor(actionTypeIdIn in integer) is
2228: select
2229: ame_attributes.attribute_id,
2230: ame_attributes.name
2231: from
2232: ame_attributes
2233: where

Line 2230: ame_attributes.name

2226: attributeNameOut out nocopy ame_util.stringList) as
2227: cursor attributeCursor(actionTypeIdIn in integer) is
2228: select
2229: ame_attributes.attribute_id,
2230: ame_attributes.name
2231: from
2232: ame_attributes
2233: where
2234: ame_attributes.attribute_id not in

Line 2232: ame_attributes

2228: select
2229: ame_attributes.attribute_id,
2230: ame_attributes.name
2231: from
2232: ame_attributes
2233: where
2234: ame_attributes.attribute_id not in
2235: (select attribute_id from ame_mandatory_attributes
2236: where

Line 2234: ame_attributes.attribute_id not in

2230: ame_attributes.name
2231: from
2232: ame_attributes
2233: where
2234: ame_attributes.attribute_id not in
2235: (select attribute_id from ame_mandatory_attributes
2236: where
2237: (action_type_id = actionTypeIdIn or
2238: action_type_id = ame_util.mandAttActionTypeId) and

Line 2241: sysdate between ame_attributes.start_date and

2237: (action_type_id = actionTypeIdIn or
2238: action_type_id = ame_util.mandAttActionTypeId) and
2239: sysdate between ame_mandatory_attributes.start_date and
2240: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)) and
2241: sysdate between ame_attributes.start_date and
2242: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
2243: order by name;
2244: tempIndex integer;
2245: begin

Line 2242: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)

2238: action_type_id = ame_util.mandAttActionTypeId) and
2239: sysdate between ame_mandatory_attributes.start_date and
2240: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)) and
2241: sysdate between ame_attributes.start_date and
2242: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate)
2243: order by name;
2244: tempIndex integer;
2245: begin
2246: tempIndex := 1;

Line 2270: select distinct(ame_attributes.attribute_id),

2266: attributeIdsOut out nocopy ame_util.stringList,
2267: attributeNamesOut out nocopy ame_util.stringList) as
2268: cursor getHeaderICAttributesCursor(applicationIdIn in integer,
2269: headerItemClassIdIn in integer) is
2270: select distinct(ame_attributes.attribute_id),
2271: ame_attributes.name
2272: from
2273: ame_attributes,
2274: ame_attribute_usages

Line 2271: ame_attributes.name

2267: attributeNamesOut out nocopy ame_util.stringList) as
2268: cursor getHeaderICAttributesCursor(applicationIdIn in integer,
2269: headerItemClassIdIn in integer) is
2270: select distinct(ame_attributes.attribute_id),
2271: ame_attributes.name
2272: from
2273: ame_attributes,
2274: ame_attribute_usages
2275: where

Line 2273: ame_attributes,

2269: headerItemClassIdIn in integer) is
2270: select distinct(ame_attributes.attribute_id),
2271: ame_attributes.name
2272: from
2273: ame_attributes,
2274: ame_attribute_usages
2275: where
2276: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2277: ame_attributes.item_class_id = headerItemClassIdIn and

Line 2276: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2272: from
2273: ame_attributes,
2274: ame_attribute_usages
2275: where
2276: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2277: ame_attributes.item_class_id = headerItemClassIdIn and
2278: ame_attribute_usages.application_id = applicationIdIn and
2279: ame_attributes.attribute_id not in
2280: (select attribute_id from ame_mandatory_attributes

Line 2277: ame_attributes.item_class_id = headerItemClassIdIn and

2273: ame_attributes,
2274: ame_attribute_usages
2275: where
2276: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2277: ame_attributes.item_class_id = headerItemClassIdIn and
2278: ame_attribute_usages.application_id = applicationIdIn and
2279: ame_attributes.attribute_id not in
2280: (select attribute_id from ame_mandatory_attributes
2281: where

Line 2279: ame_attributes.attribute_id not in

2275: where
2276: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2277: ame_attributes.item_class_id = headerItemClassIdIn and
2278: ame_attribute_usages.application_id = applicationIdIn and
2279: ame_attributes.attribute_id not in
2280: (select attribute_id from ame_mandatory_attributes
2281: where
2282: action_type_id = -1 and
2283: sysdate between ame_mandatory_attributes.start_date and

Line 2285: sysdate between ame_attributes.start_date and

2281: where
2282: action_type_id = -1 and
2283: sysdate between ame_mandatory_attributes.start_date and
2284: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)) and
2285: sysdate between ame_attributes.start_date and
2286: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2287: sysdate between ame_attribute_usages.start_date and
2288: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2289: order by name;

Line 2286: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2282: action_type_id = -1 and
2283: sysdate between ame_mandatory_attributes.start_date and
2284: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)) and
2285: sysdate between ame_attributes.start_date and
2286: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2287: sysdate between ame_attribute_usages.start_date and
2288: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2289: order by name;
2290: headerItemClassId integer;

Line 2320: ame_attributes.attribute_id,

2316: attributeTypeOut out nocopy ame_util.stringList,
2317: attributeStartDateOut out nocopy ame_util.stringList) as
2318: cursor attributeCursor is
2319: select
2320: ame_attributes.attribute_id,
2321: ame_attributes.attribute_type,
2322: ame_attributes.name,
2323: ame_attributes.start_date
2324: from

Line 2321: ame_attributes.attribute_type,

2317: attributeStartDateOut out nocopy ame_util.stringList) as
2318: cursor attributeCursor is
2319: select
2320: ame_attributes.attribute_id,
2321: ame_attributes.attribute_type,
2322: ame_attributes.name,
2323: ame_attributes.start_date
2324: from
2325: ame_attributes,

Line 2322: ame_attributes.name,

2318: cursor attributeCursor is
2319: select
2320: ame_attributes.attribute_id,
2321: ame_attributes.attribute_type,
2322: ame_attributes.name,
2323: ame_attributes.start_date
2324: from
2325: ame_attributes,
2326: ame_mandatory_attributes

Line 2323: ame_attributes.start_date

2319: select
2320: ame_attributes.attribute_id,
2321: ame_attributes.attribute_type,
2322: ame_attributes.name,
2323: ame_attributes.start_date
2324: from
2325: ame_attributes,
2326: ame_mandatory_attributes
2327: where

Line 2325: ame_attributes,

2321: ame_attributes.attribute_type,
2322: ame_attributes.name,
2323: ame_attributes.start_date
2324: from
2325: ame_attributes,
2326: ame_mandatory_attributes
2327: where
2328: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2329: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and

Line 2328: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

2324: from
2325: ame_attributes,
2326: ame_mandatory_attributes
2327: where
2328: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2329: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2330: sysdate between ame_attributes.start_date and
2331: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2332: sysdate between ame_mandatory_attributes.start_date and

Line 2330: sysdate between ame_attributes.start_date and

2326: ame_mandatory_attributes
2327: where
2328: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2329: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2330: sysdate between ame_attributes.start_date and
2331: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2332: sysdate between ame_mandatory_attributes.start_date and
2333: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2334: order by name;

Line 2331: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2327: where
2328: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2329: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2330: sysdate between ame_attributes.start_date and
2331: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2332: sysdate between ame_mandatory_attributes.start_date and
2333: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2334: order by name;
2335: tempIndex integer;

Line 2361: ame_attributes.attribute_id,

2357: attributeNameOut out nocopy ame_util.stringList,
2358: attributeTypeOut out nocopy ame_util.stringList) as
2359: cursor attributeCursor(applicationIdIn in integer) is
2360: select
2361: ame_attributes.attribute_id,
2362: ame_attributes.attribute_type,
2363: ame_attributes.name
2364: from
2365: ame_attributes,

Line 2362: ame_attributes.attribute_type,

2358: attributeTypeOut out nocopy ame_util.stringList) as
2359: cursor attributeCursor(applicationIdIn in integer) is
2360: select
2361: ame_attributes.attribute_id,
2362: ame_attributes.attribute_type,
2363: ame_attributes.name
2364: from
2365: ame_attributes,
2366: ame_attribute_usages,

Line 2363: ame_attributes.name

2359: cursor attributeCursor(applicationIdIn in integer) is
2360: select
2361: ame_attributes.attribute_id,
2362: ame_attributes.attribute_type,
2363: ame_attributes.name
2364: from
2365: ame_attributes,
2366: ame_attribute_usages,
2367: ame_mandatory_attributes

Line 2365: ame_attributes,

2361: ame_attributes.attribute_id,
2362: ame_attributes.attribute_type,
2363: ame_attributes.name
2364: from
2365: ame_attributes,
2366: ame_attribute_usages,
2367: ame_mandatory_attributes
2368: where
2369: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

Line 2369: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

2365: ame_attributes,
2366: ame_attribute_usages,
2367: ame_mandatory_attributes
2368: where
2369: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2370: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2371: ame_attribute_usages.application_id = applicationIdIn and
2372: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2373: sysdate between ame_attributes.start_date and

Line 2370: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2366: ame_attribute_usages,
2367: ame_mandatory_attributes
2368: where
2369: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2370: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2371: ame_attribute_usages.application_id = applicationIdIn and
2372: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2373: sysdate between ame_attributes.start_date and
2374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 2373: sysdate between ame_attributes.start_date and

2369: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2370: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2371: ame_attribute_usages.application_id = applicationIdIn and
2372: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2373: sysdate between ame_attributes.start_date and
2374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2375: sysdate between ame_attribute_usages.start_date and
2376: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2377: sysdate between ame_mandatory_attributes.start_date and

Line 2374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2370: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2371: ame_attribute_usages.application_id = applicationIdIn and
2372: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2373: sysdate between ame_attributes.start_date and
2374: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2375: sysdate between ame_attribute_usages.start_date and
2376: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2377: sysdate between ame_mandatory_attributes.start_date and
2378: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)

Line 2405: ame_attributes.attribute_id,

2401: attributeTypeOut out nocopy ame_util.stringList,
2402: attributeStartDateOut out nocopy ame_util.stringList) as
2403: cursor attributeCursor is
2404: select
2405: ame_attributes.attribute_id,
2406: ame_attributes.attribute_type,
2407: ame_attributes.name,
2408: ame_attributes.start_date
2409: from

Line 2406: ame_attributes.attribute_type,

2402: attributeStartDateOut out nocopy ame_util.stringList) as
2403: cursor attributeCursor is
2404: select
2405: ame_attributes.attribute_id,
2406: ame_attributes.attribute_type,
2407: ame_attributes.name,
2408: ame_attributes.start_date
2409: from
2410: ame_attributes,

Line 2407: ame_attributes.name,

2403: cursor attributeCursor is
2404: select
2405: ame_attributes.attribute_id,
2406: ame_attributes.attribute_type,
2407: ame_attributes.name,
2408: ame_attributes.start_date
2409: from
2410: ame_attributes,
2411: ame_mandatory_attributes

Line 2408: ame_attributes.start_date

2404: select
2405: ame_attributes.attribute_id,
2406: ame_attributes.attribute_type,
2407: ame_attributes.name,
2408: ame_attributes.start_date
2409: from
2410: ame_attributes,
2411: ame_mandatory_attributes
2412: where

Line 2410: ame_attributes,

2406: ame_attributes.attribute_type,
2407: ame_attributes.name,
2408: ame_attributes.start_date
2409: from
2410: ame_attributes,
2411: ame_mandatory_attributes
2412: where
2413: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2414: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and

Line 2413: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

2409: from
2410: ame_attributes,
2411: ame_mandatory_attributes
2412: where
2413: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2414: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2415: ame_attributes.name not in (ame_util.evalPrioritiesPerItemAttribute,
2416: ame_util.restrictiveItemEvalAttribute) and
2417: sysdate between ame_attributes.start_date and

Line 2415: ame_attributes.name not in (ame_util.evalPrioritiesPerItemAttribute,

2411: ame_mandatory_attributes
2412: where
2413: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2414: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2415: ame_attributes.name not in (ame_util.evalPrioritiesPerItemAttribute,
2416: ame_util.restrictiveItemEvalAttribute) and
2417: sysdate between ame_attributes.start_date and
2418: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2419: sysdate between ame_mandatory_attributes.start_date and

Line 2417: sysdate between ame_attributes.start_date and

2413: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2414: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2415: ame_attributes.name not in (ame_util.evalPrioritiesPerItemAttribute,
2416: ame_util.restrictiveItemEvalAttribute) and
2417: sysdate between ame_attributes.start_date and
2418: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2419: sysdate between ame_mandatory_attributes.start_date and
2420: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2421: order by name;

Line 2418: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2414: ame_mandatory_attributes.action_type_id = ame_util.mandAttActionTypeId and
2415: ame_attributes.name not in (ame_util.evalPrioritiesPerItemAttribute,
2416: ame_util.restrictiveItemEvalAttribute) and
2417: sysdate between ame_attributes.start_date and
2418: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2419: sysdate between ame_mandatory_attributes.start_date and
2420: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2421: order by name;
2422: tempIndex integer;

Line 2449: ame_attributes.attribute_id,

2445: attributeNamesOut out nocopy ame_util.stringList) as
2446: cursor getNonHeaderICAttributesCursor(applicationIdIn in integer,
2447: itemClassIdIn in integer) is
2448: select
2449: ame_attributes.attribute_id,
2450: ame_attributes.name
2451: from
2452: ame_attributes,
2453: ame_attribute_usages

Line 2450: ame_attributes.name

2446: cursor getNonHeaderICAttributesCursor(applicationIdIn in integer,
2447: itemClassIdIn in integer) is
2448: select
2449: ame_attributes.attribute_id,
2450: ame_attributes.name
2451: from
2452: ame_attributes,
2453: ame_attribute_usages
2454: where

Line 2452: ame_attributes,

2448: select
2449: ame_attributes.attribute_id,
2450: ame_attributes.name
2451: from
2452: ame_attributes,
2453: ame_attribute_usages
2454: where
2455: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2456: ame_attributes.item_class_id = itemClassIdIn and

Line 2455: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2451: from
2452: ame_attributes,
2453: ame_attribute_usages
2454: where
2455: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2456: ame_attributes.item_class_id = itemClassIdIn and
2457: ame_attribute_usages.application_id = applicationIdIn and
2458: sysdate between ame_attributes.start_date and
2459: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 2456: ame_attributes.item_class_id = itemClassIdIn and

2452: ame_attributes,
2453: ame_attribute_usages
2454: where
2455: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2456: ame_attributes.item_class_id = itemClassIdIn and
2457: ame_attribute_usages.application_id = applicationIdIn and
2458: sysdate between ame_attributes.start_date and
2459: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2460: sysdate between ame_attribute_usages.start_date and

Line 2458: sysdate between ame_attributes.start_date and

2454: where
2455: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2456: ame_attributes.item_class_id = itemClassIdIn and
2457: ame_attribute_usages.application_id = applicationIdIn and
2458: sysdate between ame_attributes.start_date and
2459: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2460: sysdate between ame_attribute_usages.start_date and
2461: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2462: order by name;

Line 2459: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2455: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2456: ame_attributes.item_class_id = itemClassIdIn and
2457: ame_attribute_usages.application_id = applicationIdIn and
2458: sysdate between ame_attributes.start_date and
2459: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2460: sysdate between ame_attribute_usages.start_date and
2461: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2462: order by name;
2463: tempIndex integer;

Line 2492: ame_attributes.attribute_id,

2488: attributeNamesOut out nocopy ame_util.stringList) as
2489: cursor getNonHeaderICAttributesCursor(applicationIdIn in integer,
2490: itemClassIdIn in integer) is
2491: select
2492: ame_attributes.attribute_id,
2493: ame_attributes.name
2494: from
2495: ame_attributes,
2496: ame_attribute_usages

Line 2493: ame_attributes.name

2489: cursor getNonHeaderICAttributesCursor(applicationIdIn in integer,
2490: itemClassIdIn in integer) is
2491: select
2492: ame_attributes.attribute_id,
2493: ame_attributes.name
2494: from
2495: ame_attributes,
2496: ame_attribute_usages
2497: where

Line 2495: ame_attributes,

2491: select
2492: ame_attributes.attribute_id,
2493: ame_attributes.name
2494: from
2495: ame_attributes,
2496: ame_attribute_usages
2497: where
2498: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2499: ame_attributes.item_class_id = itemClassIdIn and

Line 2498: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2494: from
2495: ame_attributes,
2496: ame_attribute_usages
2497: where
2498: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2499: ame_attributes.item_class_id = itemClassIdIn and
2500: ame_attribute_usages.application_id = applicationIdIn and
2501: sysdate between ame_attributes.start_date and
2502: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 2499: ame_attributes.item_class_id = itemClassIdIn and

2495: ame_attributes,
2496: ame_attribute_usages
2497: where
2498: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2499: ame_attributes.item_class_id = itemClassIdIn and
2500: ame_attribute_usages.application_id = applicationIdIn and
2501: sysdate between ame_attributes.start_date and
2502: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2503: sysdate between ame_attribute_usages.start_date and

Line 2501: sysdate between ame_attributes.start_date and

2497: where
2498: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2499: ame_attributes.item_class_id = itemClassIdIn and
2500: ame_attribute_usages.application_id = applicationIdIn and
2501: sysdate between ame_attributes.start_date and
2502: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2503: sysdate between ame_attribute_usages.start_date and
2504: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2505: order by name;

Line 2502: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2498: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2499: ame_attributes.item_class_id = itemClassIdIn and
2500: ame_attribute_usages.application_id = applicationIdIn and
2501: sysdate between ame_attributes.start_date and
2502: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2503: sysdate between ame_attribute_usages.start_date and
2504: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2505: order by name;
2506: tempIndex integer;

Line 2532: select ame_attributes.attribute_id,

2528: procedure getRequiredAttributes(actionTypeIdIn in integer,
2529: attributeIdOut out nocopy ame_util.stringList,
2530: attributeNameOut out nocopy ame_util.stringList) as
2531: cursor attributeCursor(actionTypeIdIn in integer) is
2532: select ame_attributes.attribute_id,
2533: ame_attributes.name
2534: from ame_attributes,
2535: ame_mandatory_attributes
2536: where

Line 2533: ame_attributes.name

2529: attributeIdOut out nocopy ame_util.stringList,
2530: attributeNameOut out nocopy ame_util.stringList) as
2531: cursor attributeCursor(actionTypeIdIn in integer) is
2532: select ame_attributes.attribute_id,
2533: ame_attributes.name
2534: from ame_attributes,
2535: ame_mandatory_attributes
2536: where
2537: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

Line 2534: from ame_attributes,

2530: attributeNameOut out nocopy ame_util.stringList) as
2531: cursor attributeCursor(actionTypeIdIn in integer) is
2532: select ame_attributes.attribute_id,
2533: ame_attributes.name
2534: from ame_attributes,
2535: ame_mandatory_attributes
2536: where
2537: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2538: ame_mandatory_attributes.action_type_id = actionTypeIdIn and

Line 2537: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and

2533: ame_attributes.name
2534: from ame_attributes,
2535: ame_mandatory_attributes
2536: where
2537: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2538: ame_mandatory_attributes.action_type_id = actionTypeIdIn and
2539: sysdate between ame_attributes.start_date and
2540: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2541: sysdate between ame_mandatory_attributes.start_date and

Line 2539: sysdate between ame_attributes.start_date and

2535: ame_mandatory_attributes
2536: where
2537: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2538: ame_mandatory_attributes.action_type_id = actionTypeIdIn and
2539: sysdate between ame_attributes.start_date and
2540: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2541: sysdate between ame_mandatory_attributes.start_date and
2542: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2543: order by name;

Line 2540: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2536: where
2537: ame_attributes.attribute_id = ame_mandatory_attributes.attribute_id and
2538: ame_mandatory_attributes.action_type_id = actionTypeIdIn and
2539: sysdate between ame_attributes.start_date and
2540: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2541: sysdate between ame_mandatory_attributes.start_date and
2542: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
2543: order by name;
2544: tempIndex integer;

Line 2574: ame_attributes.attribute_id,

2570: attributeNameOut out nocopy ame_util.stringList) as
2571: cursor attributeCursor(applicationIdIn in integer,
2572: isStripingAttributeIn in varchar2) is
2573: select
2574: ame_attributes.attribute_id,
2575: ame_attributes.name
2576: from
2577: ame_attributes,
2578: ame_attribute_usages

Line 2575: ame_attributes.name

2571: cursor attributeCursor(applicationIdIn in integer,
2572: isStripingAttributeIn in varchar2) is
2573: select
2574: ame_attributes.attribute_id,
2575: ame_attributes.name
2576: from
2577: ame_attributes,
2578: ame_attribute_usages
2579: where

Line 2577: ame_attributes,

2573: select
2574: ame_attributes.attribute_id,
2575: ame_attributes.name
2576: from
2577: ame_attributes,
2578: ame_attribute_usages
2579: where
2580: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2581: ame_attribute_usages.application_id = applicationIdIn and

Line 2580: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2576: from
2577: ame_attributes,
2578: ame_attribute_usages
2579: where
2580: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2581: ame_attribute_usages.application_id = applicationIdIn and
2582: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2583: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2584: (ame_attributes.start_date <= sysdate and

Line 2582: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and

2578: ame_attribute_usages
2579: where
2580: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2581: ame_attribute_usages.application_id = applicationIdIn and
2582: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2583: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2584: (ame_attributes.start_date <= sysdate and
2585: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and
2586: (ame_attribute_usages.start_date <= sysdate and

Line 2584: (ame_attributes.start_date <= sysdate and

2580: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2581: ame_attribute_usages.application_id = applicationIdIn and
2582: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2583: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2584: (ame_attributes.start_date <= sysdate and
2585: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and
2586: (ame_attribute_usages.start_date <= sysdate and
2587: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date))
2588: order by name;

Line 2585: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and

2581: ame_attribute_usages.application_id = applicationIdIn and
2582: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2583: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2584: (ame_attributes.start_date <= sysdate and
2585: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and
2586: (ame_attribute_usages.start_date <= sysdate and
2587: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date))
2588: order by name;
2589: tempIndex integer;

Line 2619: ame_attributes.attribute_id,

2615: attributeIdOut out nocopy ame_util.stringList,
2616: attributeNameOut out nocopy ame_util.stringList) as
2617: cursor attributeCursor(applicationIdIn in integer) is
2618: select
2619: ame_attributes.attribute_id,
2620: ame_attributes.name
2621: from
2622: ame_attributes,
2623: ame_attribute_usages

Line 2620: ame_attributes.name

2616: attributeNameOut out nocopy ame_util.stringList) as
2617: cursor attributeCursor(applicationIdIn in integer) is
2618: select
2619: ame_attributes.attribute_id,
2620: ame_attributes.name
2621: from
2622: ame_attributes,
2623: ame_attribute_usages
2624: where

Line 2622: ame_attributes,

2618: select
2619: ame_attributes.attribute_id,
2620: ame_attributes.name
2621: from
2622: ame_attributes,
2623: ame_attribute_usages
2624: where
2625: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2626: ame_attribute_usages.application_id = applicationIdIn and

Line 2625: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2621: from
2622: ame_attributes,
2623: ame_attribute_usages
2624: where
2625: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2626: ame_attribute_usages.application_id = applicationIdIn and
2627: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2628: sysdate between ame_attributes.start_date and
2629: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 2627: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and

2623: ame_attribute_usages
2624: where
2625: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2626: ame_attribute_usages.application_id = applicationIdIn and
2627: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2628: sysdate between ame_attributes.start_date and
2629: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2630: sysdate between ame_attribute_usages.start_date and
2631: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)

Line 2628: sysdate between ame_attributes.start_date and

2624: where
2625: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2626: ame_attribute_usages.application_id = applicationIdIn and
2627: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2628: sysdate between ame_attributes.start_date and
2629: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2630: sysdate between ame_attribute_usages.start_date and
2631: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2632: order by name;

Line 2629: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2625: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2626: ame_attribute_usages.application_id = applicationIdIn and
2627: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2628: sysdate between ame_attributes.start_date and
2629: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2630: sysdate between ame_attribute_usages.start_date and
2631: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2632: order by name;
2633: tempIndex integer;

Line 2659: ame_attributes.attribute_id,

2655: attributeIdOut out nocopy ame_util.stringList,
2656: attributeNameOut out nocopy ame_util.stringList) as
2657: cursor attributeCursor(applicationIdIn in integer) is
2658: select
2659: ame_attributes.attribute_id,
2660: ame_attributes.name
2661: from
2662: ame_attributes,
2663: ame_attribute_usages

Line 2660: ame_attributes.name

2656: attributeNameOut out nocopy ame_util.stringList) as
2657: cursor attributeCursor(applicationIdIn in integer) is
2658: select
2659: ame_attributes.attribute_id,
2660: ame_attributes.name
2661: from
2662: ame_attributes,
2663: ame_attribute_usages
2664: where

Line 2662: ame_attributes,

2658: select
2659: ame_attributes.attribute_id,
2660: ame_attributes.name
2661: from
2662: ame_attributes,
2663: ame_attribute_usages
2664: where
2665: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2666: ame_attribute_usages.application_id = applicationIdIn and

Line 2665: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2661: from
2662: ame_attributes,
2663: ame_attribute_usages
2664: where
2665: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2666: ame_attribute_usages.application_id = applicationIdIn and
2667: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2668: sysdate between ame_attributes.start_date and
2669: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 2667: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and

2663: ame_attribute_usages
2664: where
2665: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2666: ame_attribute_usages.application_id = applicationIdIn and
2667: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2668: sysdate between ame_attributes.start_date and
2669: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2670: sysdate between ame_attribute_usages.start_date and
2671: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)

Line 2668: sysdate between ame_attributes.start_date and

2664: where
2665: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2666: ame_attribute_usages.application_id = applicationIdIn and
2667: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2668: sysdate between ame_attributes.start_date and
2669: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2670: sysdate between ame_attribute_usages.start_date and
2671: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2672: order by name;

Line 2669: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2665: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2666: ame_attribute_usages.application_id = applicationIdIn and
2667: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue and
2668: sysdate between ame_attributes.start_date and
2669: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2670: sysdate between ame_attribute_usages.start_date and
2671: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2672: order by name;
2673: tempIndex integer;

Line 2703: ame_attributes.attribute_id,

2699: attributeNameOut out nocopy ame_util.stringList) as
2700: cursor attributeCursor(applicationIdIn in integer,
2701: isStripingAttributeIn in varchar2) is
2702: select
2703: ame_attributes.attribute_id,
2704: ame_attributes.name
2705: from
2706: ame_attributes,
2707: ame_attribute_usages

Line 2704: ame_attributes.name

2700: cursor attributeCursor(applicationIdIn in integer,
2701: isStripingAttributeIn in varchar2) is
2702: select
2703: ame_attributes.attribute_id,
2704: ame_attributes.name
2705: from
2706: ame_attributes,
2707: ame_attribute_usages
2708: where

Line 2706: ame_attributes,

2702: select
2703: ame_attributes.attribute_id,
2704: ame_attributes.name
2705: from
2706: ame_attributes,
2707: ame_attribute_usages
2708: where
2709: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2710: ame_attribute_usages.application_id = applicationIdIn and

Line 2709: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2705: from
2706: ame_attributes,
2707: ame_attribute_usages
2708: where
2709: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2710: ame_attribute_usages.application_id = applicationIdIn and
2711: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2712: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2713: ame_attributes.attribute_id not in

Line 2711: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and

2707: ame_attribute_usages
2708: where
2709: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2710: ame_attribute_usages.application_id = applicationIdIn and
2711: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2712: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2713: ame_attributes.attribute_id not in
2714: (select attribute_id from ame_mandatory_attributes
2715: where action_type_id = -1 and

Line 2713: ame_attributes.attribute_id not in

2709: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2710: ame_attribute_usages.application_id = applicationIdIn and
2711: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2712: nvl(ame_attribute_usages.is_striping_attribute, ame_util.booleanFalse) = isStripingAttributeIn and
2713: ame_attributes.attribute_id not in
2714: (select attribute_id from ame_mandatory_attributes
2715: where action_type_id = -1 and
2716: (ame_mandatory_attributes.start_date <= sysdate and
2717: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date))) and

Line 2718: (ame_attributes.start_date <= sysdate and

2714: (select attribute_id from ame_mandatory_attributes
2715: where action_type_id = -1 and
2716: (ame_mandatory_attributes.start_date <= sysdate and
2717: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date))) and
2718: (ame_attributes.start_date <= sysdate and
2719: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and
2720: (ame_attribute_usages.start_date <= sysdate and
2721: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date))
2722: order by name;

Line 2719: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and

2715: where action_type_id = -1 and
2716: (ame_mandatory_attributes.start_date <= sysdate and
2717: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date))) and
2718: (ame_attributes.start_date <= sysdate and
2719: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and
2720: (ame_attribute_usages.start_date <= sysdate and
2721: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date))
2722: order by name;
2723: tempIndex integer;

Line 2753: ame_attributes.attribute_id,

2749: attributeIdOut out nocopy ame_util.stringList,
2750: attributeNameOut out nocopy ame_util.stringList) as
2751: cursor attributeCursor(applicationIdIn in integer) is
2752: select
2753: ame_attributes.attribute_id,
2754: ame_attributes.name
2755: from
2756: ame_attributes,
2757: ame_attribute_usages

Line 2754: ame_attributes.name

2750: attributeNameOut out nocopy ame_util.stringList) as
2751: cursor attributeCursor(applicationIdIn in integer) is
2752: select
2753: ame_attributes.attribute_id,
2754: ame_attributes.name
2755: from
2756: ame_attributes,
2757: ame_attribute_usages
2758: where

Line 2756: ame_attributes,

2752: select
2753: ame_attributes.attribute_id,
2754: ame_attributes.name
2755: from
2756: ame_attributes,
2757: ame_attribute_usages
2758: where
2759: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2760: ame_attribute_usages.application_id = applicationIdIn and

Line 2759: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2755: from
2756: ame_attributes,
2757: ame_attribute_usages
2758: where
2759: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2760: ame_attribute_usages.application_id = applicationIdIn and
2761: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2762: ame_attributes.attribute_id not in
2763: (select attribute_id from ame_mandatory_attributes

Line 2761: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and

2757: ame_attribute_usages
2758: where
2759: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2760: ame_attribute_usages.application_id = applicationIdIn and
2761: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2762: ame_attributes.attribute_id not in
2763: (select attribute_id from ame_mandatory_attributes
2764: where action_type_id = -1 and
2765: sysdate between ame_mandatory_attributes.start_date and

Line 2762: ame_attributes.attribute_id not in

2758: where
2759: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2760: ame_attribute_usages.application_id = applicationIdIn and
2761: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2762: ame_attributes.attribute_id not in
2763: (select attribute_id from ame_mandatory_attributes
2764: where action_type_id = -1 and
2765: sysdate between ame_mandatory_attributes.start_date and
2766: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and

Line 2767: sysdate between ame_attributes.start_date and

2763: (select attribute_id from ame_mandatory_attributes
2764: where action_type_id = -1 and
2765: sysdate between ame_mandatory_attributes.start_date and
2766: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
2767: sysdate between ame_attributes.start_date and
2768: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2769: sysdate between ame_attribute_usages.start_date and
2770: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2771: order by name;

Line 2768: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2764: where action_type_id = -1 and
2765: sysdate between ame_mandatory_attributes.start_date and
2766: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
2767: sysdate between ame_attributes.start_date and
2768: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2769: sysdate between ame_attribute_usages.start_date and
2770: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2771: order by name;
2772: tempIndex integer;

Line 2799: ame_attributes.attribute_id,

2795: attributeNameOut out nocopy ame_util.stringList) as
2796: cursor attributeCursor(applicationIdIn in integer,
2797: headerItemClassIdIn in integer) is
2798: select
2799: ame_attributes.attribute_id,
2800: ame_attributes.name
2801: from
2802: ame_attributes,
2803: ame_attribute_usages,

Line 2800: ame_attributes.name

2796: cursor attributeCursor(applicationIdIn in integer,
2797: headerItemClassIdIn in integer) is
2798: select
2799: ame_attributes.attribute_id,
2800: ame_attributes.name
2801: from
2802: ame_attributes,
2803: ame_attribute_usages,
2804: ame_item_classes

Line 2802: ame_attributes,

2798: select
2799: ame_attributes.attribute_id,
2800: ame_attributes.name
2801: from
2802: ame_attributes,
2803: ame_attribute_usages,
2804: ame_item_classes
2805: where
2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

Line 2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2802: ame_attributes,
2803: ame_attribute_usages,
2804: ame_item_classes
2805: where
2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2809: ame_attribute_usages.application_id = applicationIdIn and
2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and

Line 2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and

2803: ame_attribute_usages,
2804: ame_item_classes
2805: where
2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2809: ame_attribute_usages.application_id = applicationIdIn and
2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2811: ame_attributes.attribute_id not in

Line 2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and

2806: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2809: ame_attribute_usages.application_id = applicationIdIn and
2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2811: ame_attributes.attribute_id not in
2812: (select attribute_id from ame_mandatory_attributes
2813: where action_type_id = -1 and
2814: sysdate between ame_mandatory_attributes.start_date and

Line 2811: ame_attributes.attribute_id not in

2807: ame_attributes.item_class_id = ame_item_classes.item_class_id and
2808: ame_item_classes.item_class_id = headerItemClassIdIn and
2809: ame_attribute_usages.application_id = applicationIdIn and
2810: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse and
2811: ame_attributes.attribute_id not in
2812: (select attribute_id from ame_mandatory_attributes
2813: where action_type_id = -1 and
2814: sysdate between ame_mandatory_attributes.start_date and
2815: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and

Line 2816: sysdate between ame_attributes.start_date and

2812: (select attribute_id from ame_mandatory_attributes
2813: where action_type_id = -1 and
2814: sysdate between ame_mandatory_attributes.start_date and
2815: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
2816: sysdate between ame_attributes.start_date and
2817: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2818: sysdate between ame_attribute_usages.start_date and
2819: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2820: sysdate between ame_item_classes.start_date and

Line 2817: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2813: where action_type_id = -1 and
2814: sysdate between ame_mandatory_attributes.start_date and
2815: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) ) and
2816: sysdate between ame_attributes.start_date and
2817: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2818: sysdate between ame_attribute_usages.start_date and
2819: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2820: sysdate between ame_item_classes.start_date and
2821: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)

Line 2822: order by ame_attributes.name;

2818: sysdate between ame_attribute_usages.start_date and
2819: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate) and
2820: sysdate between ame_item_classes.start_date and
2821: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
2822: order by ame_attributes.name;
2823: headerItemClassId integer;
2824: tempIndex integer;
2825: begin
2826: tempIndex := 1;

Line 2854: ame_attributes.attribute_id attribute_id

2850: procedure getRuleStripingAttributes(applicationIdIn in integer,
2851: attributeIdsOut out nocopy ame_util.stringList) as
2852: cursor ruleStripingAttributeCursor(applicationIdIn in integer) is
2853: select
2854: ame_attributes.attribute_id attribute_id
2855: from
2856: ame_attributes,
2857: ame_attribute_usages
2858: where

Line 2856: ame_attributes,

2852: cursor ruleStripingAttributeCursor(applicationIdIn in integer) is
2853: select
2854: ame_attributes.attribute_id attribute_id
2855: from
2856: ame_attributes,
2857: ame_attribute_usages
2858: where
2859: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2860: ame_attribute_usages.application_id = applicationIdIn and

Line 2859: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2855: from
2856: ame_attributes,
2857: ame_attribute_usages
2858: where
2859: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2860: ame_attribute_usages.application_id = applicationIdIn and
2861: ame_attributes.attribute_type = ame_util.stringAttributeType and
2862: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue and
2863: sysdate between ame_attributes.start_date and

Line 2861: ame_attributes.attribute_type = ame_util.stringAttributeType and

2857: ame_attribute_usages
2858: where
2859: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2860: ame_attribute_usages.application_id = applicationIdIn and
2861: ame_attributes.attribute_type = ame_util.stringAttributeType and
2862: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue and
2863: sysdate between ame_attributes.start_date and
2864: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2865: sysdate between ame_attribute_usages.start_date and

Line 2863: sysdate between ame_attributes.start_date and

2859: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2860: ame_attribute_usages.application_id = applicationIdIn and
2861: ame_attributes.attribute_type = ame_util.stringAttributeType and
2862: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue and
2863: sysdate between ame_attributes.start_date and
2864: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2865: sysdate between ame_attribute_usages.start_date and
2866: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2867: order by ame_attributes.attribute_id;

Line 2864: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2860: ame_attribute_usages.application_id = applicationIdIn and
2861: ame_attributes.attribute_type = ame_util.stringAttributeType and
2862: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue and
2863: sysdate between ame_attributes.start_date and
2864: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2865: sysdate between ame_attribute_usages.start_date and
2866: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2867: order by ame_attributes.attribute_id;
2868: tempIndex integer;

Line 2867: order by ame_attributes.attribute_id;

2863: sysdate between ame_attributes.start_date and
2864: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2865: sysdate between ame_attribute_usages.start_date and
2866: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2867: order by ame_attributes.attribute_id;
2868: tempIndex integer;
2869: begin
2870: tempIndex := 1;
2871: for ruleStripingAttributeRec in ruleStripingAttributeCursor(applicationIdIn => applicationIdIn) loop

Line 2895: ame_attributes.attribute_id attribute_id,

2891: attributeNamesOut out nocopy ame_util.stringList) as
2892: cursor unusedAttributeCursor(applicationIdIn in integer,
2893: itemClassIdIn in integer) is
2894: select
2895: ame_attributes.attribute_id attribute_id,
2896: ame_attributes.name name
2897: from
2898: ame_attributes
2899: where

Line 2896: ame_attributes.name name

2892: cursor unusedAttributeCursor(applicationIdIn in integer,
2893: itemClassIdIn in integer) is
2894: select
2895: ame_attributes.attribute_id attribute_id,
2896: ame_attributes.name name
2897: from
2898: ame_attributes
2899: where
2900: item_class_id = itemClassIdIn and

Line 2898: ame_attributes

2894: select
2895: ame_attributes.attribute_id attribute_id,
2896: ame_attributes.name name
2897: from
2898: ame_attributes
2899: where
2900: item_class_id = itemClassIdIn and
2901: (ame_attributes.start_date <= sysdate and
2902: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))

Line 2901: (ame_attributes.start_date <= sysdate and

2897: from
2898: ame_attributes
2899: where
2900: item_class_id = itemClassIdIn and
2901: (ame_attributes.start_date <= sysdate and
2902: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2903: minus
2904: select
2905: ame_attributes.attribute_id attribute_id,

Line 2902: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))

2898: ame_attributes
2899: where
2900: item_class_id = itemClassIdIn and
2901: (ame_attributes.start_date <= sysdate and
2902: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2903: minus
2904: select
2905: ame_attributes.attribute_id attribute_id,
2906: ame_attributes.name name

Line 2905: ame_attributes.attribute_id attribute_id,

2901: (ame_attributes.start_date <= sysdate and
2902: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2903: minus
2904: select
2905: ame_attributes.attribute_id attribute_id,
2906: ame_attributes.name name
2907: from
2908: ame_attributes,
2909: ame_attribute_usages

Line 2906: ame_attributes.name name

2902: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2903: minus
2904: select
2905: ame_attributes.attribute_id attribute_id,
2906: ame_attributes.name name
2907: from
2908: ame_attributes,
2909: ame_attribute_usages
2910: where

Line 2908: ame_attributes,

2904: select
2905: ame_attributes.attribute_id attribute_id,
2906: ame_attributes.name name
2907: from
2908: ame_attributes,
2909: ame_attribute_usages
2910: where
2911: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2912: ame_attribute_usages.application_id = applicationIdIn and

Line 2911: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2907: from
2908: ame_attributes,
2909: ame_attribute_usages
2910: where
2911: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2912: ame_attribute_usages.application_id = applicationIdIn and
2913: sysdate between ame_attributes.start_date and
2914: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2915: sysdate between ame_attribute_usages.start_date and

Line 2913: sysdate between ame_attributes.start_date and

2909: ame_attribute_usages
2910: where
2911: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2912: ame_attribute_usages.application_id = applicationIdIn and
2913: sysdate between ame_attributes.start_date and
2914: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2915: sysdate between ame_attribute_usages.start_date and
2916: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2917: order by name;

Line 2914: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2910: where
2911: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2912: ame_attribute_usages.application_id = applicationIdIn and
2913: sysdate between ame_attributes.start_date and
2914: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2915: sysdate between ame_attribute_usages.start_date and
2916: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2917: order by name;
2918: cursor unusedAttributeCursor2(applicationIdIn in integer,

Line 2923: ame_attributes.attribute_id attribute_id,

2919: itemClassIdIn in integer,
2920: perApproverTypeIdIn in integer,
2921: fndUserApproverTypeIdIn in integer) is
2922: select
2923: ame_attributes.attribute_id attribute_id,
2924: ame_attributes.name name
2925: from
2926: ame_attributes
2927: where

Line 2924: ame_attributes.name name

2920: perApproverTypeIdIn in integer,
2921: fndUserApproverTypeIdIn in integer) is
2922: select
2923: ame_attributes.attribute_id attribute_id,
2924: ame_attributes.name name
2925: from
2926: ame_attributes
2927: where
2928: item_class_id = itemClassIdIn and

Line 2926: ame_attributes

2922: select
2923: ame_attributes.attribute_id attribute_id,
2924: ame_attributes.name name
2925: from
2926: ame_attributes
2927: where
2928: item_class_id = itemClassIdIn and
2929: (ame_attributes.start_date <= sysdate and
2930: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))

Line 2929: (ame_attributes.start_date <= sysdate and

2925: from
2926: ame_attributes
2927: where
2928: item_class_id = itemClassIdIn and
2929: (ame_attributes.start_date <= sysdate and
2930: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2931: minus
2932: select
2933: ame_attributes.attribute_id attribute_id,

Line 2930: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))

2926: ame_attributes
2927: where
2928: item_class_id = itemClassIdIn and
2929: (ame_attributes.start_date <= sysdate and
2930: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2931: minus
2932: select
2933: ame_attributes.attribute_id attribute_id,
2934: ame_attributes.name name

Line 2933: ame_attributes.attribute_id attribute_id,

2929: (ame_attributes.start_date <= sysdate and
2930: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2931: minus
2932: select
2933: ame_attributes.attribute_id attribute_id,
2934: ame_attributes.name name
2935: from
2936: ame_attributes,
2937: ame_attribute_usages

Line 2934: ame_attributes.name name

2930: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2931: minus
2932: select
2933: ame_attributes.attribute_id attribute_id,
2934: ame_attributes.name name
2935: from
2936: ame_attributes,
2937: ame_attribute_usages
2938: where

Line 2936: ame_attributes,

2932: select
2933: ame_attributes.attribute_id attribute_id,
2934: ame_attributes.name name
2935: from
2936: ame_attributes,
2937: ame_attribute_usages
2938: where
2939: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2940: ame_attribute_usages.application_id = applicationIdIn and

Line 2939: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

2935: from
2936: ame_attributes,
2937: ame_attribute_usages
2938: where
2939: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2940: ame_attribute_usages.application_id = applicationIdIn and
2941: sysdate between ame_attributes.start_date and
2942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2943: sysdate between ame_attribute_usages.start_date and

Line 2941: sysdate between ame_attributes.start_date and

2937: ame_attribute_usages
2938: where
2939: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2940: ame_attribute_usages.application_id = applicationIdIn and
2941: sysdate between ame_attributes.start_date and
2942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2943: sysdate between ame_attribute_usages.start_date and
2944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2945: minus

Line 2942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

2938: where
2939: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
2940: ame_attribute_usages.application_id = applicationIdIn and
2941: sysdate between ame_attributes.start_date and
2942: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
2943: sysdate between ame_attribute_usages.start_date and
2944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2945: minus
2946: select

Line 2947: ame_attributes.attribute_id attribute_id,

2943: sysdate between ame_attribute_usages.start_date and
2944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2945: minus
2946: select
2947: ame_attributes.attribute_id attribute_id,
2948: ame_attributes.name name
2949: from
2950: ame_attributes
2951: where

Line 2948: ame_attributes.name name

2944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
2945: minus
2946: select
2947: ame_attributes.attribute_id attribute_id,
2948: ame_attributes.name name
2949: from
2950: ame_attributes
2951: where
2952: approver_type_id not in (perApproverTypeIdIn, fndUserApproverTypeIdIn) and

Line 2950: ame_attributes

2946: select
2947: ame_attributes.attribute_id attribute_id,
2948: ame_attributes.name name
2949: from
2950: ame_attributes
2951: where
2952: approver_type_id not in (perApproverTypeIdIn, fndUserApproverTypeIdIn) and
2953: (ame_attributes.start_date <= sysdate and
2954: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))

Line 2953: (ame_attributes.start_date <= sysdate and

2949: from
2950: ame_attributes
2951: where
2952: approver_type_id not in (perApproverTypeIdIn, fndUserApproverTypeIdIn) and
2953: (ame_attributes.start_date <= sysdate and
2954: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2955: order by name;
2956: allowAllApproverTypes ame_util.stringType;
2957: fndUserApproverTypeId integer;

Line 2954: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))

2950: ame_attributes
2951: where
2952: approver_type_id not in (perApproverTypeIdIn, fndUserApproverTypeIdIn) and
2953: (ame_attributes.start_date <= sysdate and
2954: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date))
2955: order by name;
2956: allowAllApproverTypes ame_util.stringType;
2957: fndUserApproverTypeId integer;
2958: perApproverTypeId integer;

Line 3007: ame_attributes.attribute_id,

3003: attributeNamesOut out nocopy ame_util.stringList) as
3004: cursor attributeCursor(applicationIdIn in integer,
3005: itemClassIdIn in integer) is
3006: select
3007: ame_attributes.attribute_id,
3008: ame_attributes.name
3009: from
3010: ame_attributes,
3011: ame_attribute_usages

Line 3008: ame_attributes.name

3004: cursor attributeCursor(applicationIdIn in integer,
3005: itemClassIdIn in integer) is
3006: select
3007: ame_attributes.attribute_id,
3008: ame_attributes.name
3009: from
3010: ame_attributes,
3011: ame_attribute_usages
3012: where

Line 3010: ame_attributes,

3006: select
3007: ame_attributes.attribute_id,
3008: ame_attributes.name
3009: from
3010: ame_attributes,
3011: ame_attribute_usages
3012: where
3013: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3014: ame_attribute_usages.application_id = applicationIdIn and

Line 3013: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

3009: from
3010: ame_attributes,
3011: ame_attribute_usages
3012: where
3013: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3014: ame_attribute_usages.application_id = applicationIdIn and
3015: ame_attributes.item_class_id = itemClassIdIn and
3016: sysdate between ame_attributes.start_date and
3017: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 3015: ame_attributes.item_class_id = itemClassIdIn and

3011: ame_attribute_usages
3012: where
3013: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3014: ame_attribute_usages.application_id = applicationIdIn and
3015: ame_attributes.item_class_id = itemClassIdIn and
3016: sysdate between ame_attributes.start_date and
3017: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
3018: sysdate between ame_attribute_usages.start_date and
3019: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)

Line 3016: sysdate between ame_attributes.start_date and

3012: where
3013: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3014: ame_attribute_usages.application_id = applicationIdIn and
3015: ame_attributes.item_class_id = itemClassIdIn and
3016: sysdate between ame_attributes.start_date and
3017: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
3018: sysdate between ame_attribute_usages.start_date and
3019: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
3020: order by name;

Line 3017: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

3013: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3014: ame_attribute_usages.application_id = applicationIdIn and
3015: ame_attributes.item_class_id = itemClassIdIn and
3016: sysdate between ame_attributes.start_date and
3017: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
3018: sysdate between ame_attribute_usages.start_date and
3019: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
3020: order by name;
3021: tempIndex integer;

Line 3053: ame_attributes.attribute_id,

3049: attributeTypesOut out nocopy ame_util.stringList) as
3050: cursor attributeCursor(applicationIdIn in integer,
3051: itemClassIdIn in integer) is
3052: select
3053: ame_attributes.attribute_id,
3054: ame_attributes.name,
3055: ame_attributes.attribute_type
3056: from
3057: ame_attributes,

Line 3054: ame_attributes.name,

3050: cursor attributeCursor(applicationIdIn in integer,
3051: itemClassIdIn in integer) is
3052: select
3053: ame_attributes.attribute_id,
3054: ame_attributes.name,
3055: ame_attributes.attribute_type
3056: from
3057: ame_attributes,
3058: ame_attribute_usages

Line 3055: ame_attributes.attribute_type

3051: itemClassIdIn in integer) is
3052: select
3053: ame_attributes.attribute_id,
3054: ame_attributes.name,
3055: ame_attributes.attribute_type
3056: from
3057: ame_attributes,
3058: ame_attribute_usages
3059: where

Line 3057: ame_attributes,

3053: ame_attributes.attribute_id,
3054: ame_attributes.name,
3055: ame_attributes.attribute_type
3056: from
3057: ame_attributes,
3058: ame_attribute_usages
3059: where
3060: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3061: ame_attribute_usages.application_id = applicationIdIn and

Line 3060: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

3056: from
3057: ame_attributes,
3058: ame_attribute_usages
3059: where
3060: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3061: ame_attribute_usages.application_id = applicationIdIn and
3062: ame_attributes.item_class_id = itemClassIdIn and
3063: sysdate between ame_attributes.start_date and
3064: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 3062: ame_attributes.item_class_id = itemClassIdIn and

3058: ame_attribute_usages
3059: where
3060: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3061: ame_attribute_usages.application_id = applicationIdIn and
3062: ame_attributes.item_class_id = itemClassIdIn and
3063: sysdate between ame_attributes.start_date and
3064: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
3065: sysdate between ame_attribute_usages.start_date and
3066: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)

Line 3063: sysdate between ame_attributes.start_date and

3059: where
3060: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3061: ame_attribute_usages.application_id = applicationIdIn and
3062: ame_attributes.item_class_id = itemClassIdIn and
3063: sysdate between ame_attributes.start_date and
3064: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
3065: sysdate between ame_attribute_usages.start_date and
3066: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
3067: order by name;

Line 3064: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and

3060: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
3061: ame_attribute_usages.application_id = applicationIdIn and
3062: ame_attributes.item_class_id = itemClassIdIn and
3063: sysdate between ame_attributes.start_date and
3064: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
3065: sysdate between ame_attribute_usages.start_date and
3066: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
3067: order by name;
3068: tempIndex integer;

Line 3116: from ame_attributes

3112: parentVersionStartDateIn in date default null,
3113: createdByIn in integer default null) as
3114: cursor startDateCursor is
3115: select start_date
3116: from ame_attributes
3117: where
3118: attribute_id = attributeIdIn and
3119: (start_date <= sysdate and
3120: (end_date is null or sysdate < end_date))

Line 3123: attributeDescription ame_attributes.description%type;

3119: (start_date <= sysdate and
3120: (end_date is null or sysdate < end_date))
3121: for update;
3122: approverTypeId integer;
3123: attributeDescription ame_attributes.description%type;
3124: lineItemAttribute varchar2(1);
3125: attributeId ame_attributes.attribute_id%type;
3126: attributeName ame_attributes.name%type;
3127: attributeType ame_attributes.attribute_type%type;

Line 3125: attributeId ame_attributes.attribute_id%type;

3121: for update;
3122: approverTypeId integer;
3123: attributeDescription ame_attributes.description%type;
3124: lineItemAttribute varchar2(1);
3125: attributeId ame_attributes.attribute_id%type;
3126: attributeName ame_attributes.name%type;
3127: attributeType ame_attributes.attribute_type%type;
3128: badCurUsageException exception;
3129: badStaticDateUsageException exception;

Line 3126: attributeName ame_attributes.name%type;

3122: approverTypeId integer;
3123: attributeDescription ame_attributes.description%type;
3124: lineItemAttribute varchar2(1);
3125: attributeId ame_attributes.attribute_id%type;
3126: attributeName ame_attributes.name%type;
3127: attributeType ame_attributes.attribute_type%type;
3128: badCurUsageException exception;
3129: badStaticDateUsageException exception;
3130: booleanException exception;

Line 3127: attributeType ame_attributes.attribute_type%type;

3123: attributeDescription ame_attributes.description%type;
3124: lineItemAttribute varchar2(1);
3125: attributeId ame_attributes.attribute_id%type;
3126: attributeName ame_attributes.name%type;
3127: attributeType ame_attributes.attribute_type%type;
3128: badCurUsageException exception;
3129: badStaticDateUsageException exception;
3130: booleanException exception;
3131: charMonths ame_util.stringList;

Line 3454: update ame_attributes

3450: if(finalizeIn) then
3451: if(updateParentObjectIn) then
3452: attributeDescription := getDescription(attributeIdIn => attributeIdIn);
3453: approverTypeId := getApproverTypeId(attributeIdIn => attributeIdIn);
3454: update ame_attributes
3455: set
3456: last_updated_by = currentUserId,
3457: last_update_date = startDate2,
3458: last_update_login = currentUserId,

Line 3817: attributeType ame_attributes.attribute_type%type;

3813: errorCode integer;
3814: errorMessage ame_util.longestStringType;
3815: inUseException exception;
3816: processingDate date;
3817: attributeType ame_attributes.attribute_type%type;
3818: begin
3819: processingDate := sysdate;
3820: currentUserId := ame_util.getCurrentUserId;
3821: attributeType := getType(attributeIdIn => attributeIdIn);

Line 3848: update ame_attributes

3844: where
3845: attribute_id = attributeIdIn and
3846: processingDate between start_date and
3847: nvl(end_date - ame_util.oneSecond, processingDate) ;
3848: update ame_attributes
3849: set
3850: last_updated_by = currentUserId,
3851: last_update_date = processingDate,
3852: last_update_login = currentUserId,

Line 3927: from ame_attributes

3923: deleteConditionsIn in boolean default false,
3924: itemClassIdIn in integer) as
3925: cursor startDateCursor is
3926: select start_date
3927: from ame_attributes
3928: where
3929: attribute_id = attributeIdIn and
3930: sysdate between start_date and
3931: nvl(end_date - ame_util.oneSecond, sysdate)

Line 3943: attributeId ame_attributes.attribute_id%type;

3939: sysdate between start_date and
3940: nvl(end_date - ame_util.oneSecond, sysdate)
3941: for update;
3942: approverTypeId integer;
3943: attributeId ame_attributes.attribute_id%type;
3944: attributeDescription ame_attributes.description%type;
3945: attributeName ame_attributes.name%type;
3946: attributeType ame_attributes.attribute_type%type;
3947: conditionIdList ame_util.idList;

Line 3944: attributeDescription ame_attributes.description%type;

3940: nvl(end_date - ame_util.oneSecond, sysdate)
3941: for update;
3942: approverTypeId integer;
3943: attributeId ame_attributes.attribute_id%type;
3944: attributeDescription ame_attributes.description%type;
3945: attributeName ame_attributes.name%type;
3946: attributeType ame_attributes.attribute_type%type;
3947: conditionIdList ame_util.idList;
3948: conditionVersionStartDate date;

Line 3945: attributeName ame_attributes.name%type;

3941: for update;
3942: approverTypeId integer;
3943: attributeId ame_attributes.attribute_id%type;
3944: attributeDescription ame_attributes.description%type;
3945: attributeName ame_attributes.name%type;
3946: attributeType ame_attributes.attribute_type%type;
3947: conditionIdList ame_util.idList;
3948: conditionVersionStartDate date;
3949: currentUserId integer;

Line 3946: attributeType ame_attributes.attribute_type%type;

3942: approverTypeId integer;
3943: attributeId ame_attributes.attribute_id%type;
3944: attributeDescription ame_attributes.description%type;
3945: attributeName ame_attributes.name%type;
3946: attributeType ame_attributes.attribute_type%type;
3947: conditionIdList ame_util.idList;
3948: conditionVersionStartDate date;
3949: currentUserId integer;
3950: errorCode integer;

Line 3954: lineItem ame_attributes.line_item%type;

3950: errorCode integer;
3951: errorMessage ame_util.longestStringType;
3952: inUseException exception;
3953: isMandatoryException exception;
3954: lineItem ame_attributes.line_item%type;
3955: objectVersionNoDataException exception;
3956: startDate date;
3957: startDate2 date;
3958: processingDate date;

Line 4030: update ame_attributes

4026: attributeName := getName(attributeIdIn => attributeIdIn);
4027: attributeDescription := getDescription(attributeIdIn => attributeIdIn);
4028: attributeType := getType(attributeIdIn => attributeIdIn);
4029: approverTypeId := getApproverTypeId(attributeIdIn => attributeIdIn);
4030: update ame_attributes
4031: set
4032: last_updated_by = currentUserId,
4033: last_update_date = processingDate,
4034: last_update_login = currentUserId,

Line 4175: ame_attributes.line_item

4171: select ame_attribute_usages.attribute_id,
4172: ame_attribute_usages.is_static,
4173: ame_attribute_usages.query_string,
4174: ame_attribute_usages.end_date,
4175: ame_attributes.line_item
4176: from ame_attributes,
4177: ame_attribute_usages
4178: where
4179: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

Line 4176: from ame_attributes,

4172: ame_attribute_usages.is_static,
4173: ame_attribute_usages.query_string,
4174: ame_attribute_usages.end_date,
4175: ame_attributes.line_item
4176: from ame_attributes,
4177: ame_attribute_usages
4178: where
4179: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4180: ame_attribute_usages.application_id = applicationIdIn and

Line 4179: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and

4175: ame_attributes.line_item
4176: from ame_attributes,
4177: ame_attribute_usages
4178: where
4179: ame_attributes.attribute_id = ame_attribute_usages.attribute_id and
4180: ame_attribute_usages.application_id = applicationIdIn and
4181: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue and
4182: (ame_attribute_usages.start_date <= sysdate and
4183: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date)) and

Line 4184: (ame_attributes.start_date <= sysdate and

4180: ame_attribute_usages.application_id = applicationIdIn and
4181: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue and
4182: (ame_attribute_usages.start_date <= sysdate and
4183: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date)) and
4184: (ame_attributes.start_date <= sysdate and
4185: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date));
4186: endDate date;
4187: oldAttributeCount integer;
4188: startDate varchar2(50);

Line 4185: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date));

4181: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue and
4182: (ame_attribute_usages.start_date <= sysdate and
4183: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date)) and
4184: (ame_attributes.start_date <= sysdate and
4185: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date));
4186: endDate date;
4187: oldAttributeCount integer;
4188: startDate varchar2(50);
4189: stripeSetCount integer;

Line 4251: lineItem ame_attributes.line_item%type;

4247: /*
4248: AME_STRIPING
4249: stripingAttribute ame_attribute_usages.is_striping_attribute%type;
4250: */
4251: lineItem ame_attributes.line_item%type;
4252: nullQueryException exception;
4253: queryString ame_attribute_usages.query_string%type;
4254: result boolean;
4255: staticUsage ame_attribute_usages.is_static%type;