[Home] [Help]
75: tempCount integer;
76: useCount integer;
77: begin
78: /* Due to the placement of this call within newAttributeUsage, the
79: ame_attribute_usages table is not yet updated so we need
80: to verify if striping is on and if so, check whether:
81: 1. It's a striping attribute that has been set to null or
82: (isStripingAttributeChangeIn)
83: 2. It's an attribute that is becoming a striping attribute.
463: function getQueryString(attributeIdIn in integer,
464: applicationIdIn in integer) return varchar2 as
465: errorCode integer;
466: errorMessage ame_util.longestStringType;
467: queryString ame_attribute_usages.query_string%type;
468: begin
469: select query_string
470: into queryString
471: from ame_attribute_usages
467: queryString ame_attribute_usages.query_string%type;
468: begin
469: select query_string
470: into queryString
471: from ame_attribute_usages
472: where
473: attribute_id = attributeIdIn and
474: application_id = applicationIdIn and
475: sysdate between start_date and
530: return(null);
531: end getStartDate;
532: function getStaticUsage(attributeIdIn in integer,
533: applicationIdIn in integer) return varchar2 as
534: staticUsage ame_attribute_usages.is_static%type;
535: begin
536: select is_static
537: into staticUsage
538: from ame_attribute_usages
534: staticUsage ame_attribute_usages.is_static%type;
535: begin
536: select is_static
537: into staticUsage
538: from ame_attribute_usages
539: where attribute_id = attributeIdIn and
540: application_id = applicationIdIn and
541: sysdate between start_date and
542: nvl(end_date - ame_util.oneSecond, sysdate) ;
557: function getUseCount(attributeIdIn in integer,
558: applicationIdIn in integer) return varchar2 as
559: errorCode integer;
560: errorMessage ame_util.longestStringType;
561: useCount ame_attribute_usages.use_count%type;
562: begin
563: select use_count
564: into useCount
565: from ame_attribute_usages
561: useCount ame_attribute_usages.use_count%type;
562: begin
563: select use_count
564: into useCount
565: from ame_attribute_usages
566: where
567: attribute_id = attributeIdIn and
568: application_id = applicationIdIn and
569: sysdate between start_date and
602: function getUserEditable(attributeIdIn in integer,
603: applicationIdIn in integer) return varchar2 as
604: errorCode integer;
605: errorMessage ame_util.longestStringType;
606: userEditable ame_attribute_usages.user_editable%type;
607: begin
608: select user_editable
609: into userEditable
610: from ame_attribute_usages
606: userEditable ame_attribute_usages.user_editable%type;
607: begin
608: select user_editable
609: into userEditable
610: from ame_attribute_usages
611: where
612: attribute_id = attributeIdIn and
613: application_id = applicationIdIn and
614: sysdate between start_date and
650: stringStartDate varchar2(50);
651: begin
652: select start_date
653: into startDate
654: from ame_attribute_usages
655: where
656: attribute_id = attributeIdIn and
657: application_id = applicationIdIn and
658: sysdate between start_date and
798: attributeCount integer;
799: begin
800: select count(*)
801: into attributeCount
802: from ame_attribute_usages
803: where
804: attribute_id = attributeIdIn and
805: application_id <> applicationIdIn and
806: sysdate between start_date and
900: useCount integer;
901: begin
902: select use_count
903: into useCount
904: from ame_attribute_usages
905: where
906: attribute_id = attributeIdIn and
907: application_id = applicationIdIn and
908: sysdate between start_date and
1068: /*
1069: AME_STRIPING
1070: function isStripingAttribute(applicationIdIn in integer,
1071: attributeIdIn in integer) return boolean as
1072: isStripingAttribute ame_attribute_usages.is_striping_attribute%type;
1073: begin
1074: select is_striping_attribute
1075: into isStripingAttribute
1076: from ame_attribute_usages
1072: isStripingAttribute ame_attribute_usages.is_striping_attribute%type;
1073: begin
1074: select is_striping_attribute
1075: into isStripingAttribute
1076: from ame_attribute_usages
1077: where
1078: attribute_id = attributeIdIn and
1079: application_id = applicationIdIn and
1080: (start_date <= sysdate and
1323: return(true);
1324: end if;
1325: select user_editable
1326: into isEditable
1327: from ame_attribute_usages
1328: where attribute_id = attributeIdIn and
1329: application_id = applicationIdIn and
1330: sysdate between start_date and
1331: nvl(end_date - ame_util.oneSecond, sysdate) ;
1413: nvl(end_date - ame_util.oneSecond, sysdate)
1414: for update;
1415: cursor startDateCursor2 is
1416: select start_date
1417: from ame_attribute_usages
1418: where
1419: attribute_id = attributeIdIn and
1420: application_id = applicationIdIn and
1421: sysdate between start_date and
1430: description ame_attributes.description%type;
1431: invalidReferenceException exception;
1432: newStartAndEndDate date;
1433: objectVersionNoDataException exception;
1434: queryString ame_attribute_usages.query_string%type;
1435: startDate date;
1436: startDate2 date;
1437: tempCount integer;
1438: begin
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
1474: ame_attribute_usages.application_id = applicationIdIn 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
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
1478: (attributeType is null or upper(attribute_type) = upper(attributeType)) and
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
1478: (attributeType is null or upper(attribute_type) = upper(attributeType)) and
1479: (descriptionIn is null or description = descriptionIn) and
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
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
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;
1486: end if;
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;
1486: end if;
1487: /* Get current values as necessary for update. */
1616: errorCode integer;
1617: errorMessage ame_util.longestStringType;
1618: firstReturnLocation integer;
1619: loweredQueryString varchar2(4000);
1620: queryString ame_attribute_usages.query_string%type;
1621: queryStringColumnException exception;
1622: tempCount integer;
1623: transactionType ame_calling_apps.application_name%type;
1624: begin
1639: end if;
1640: end if;
1641: end if;
1642: currentUserId := ame_util.getCurrentUserId;
1643: update ame_attribute_usages
1644: set
1645: last_updated_by = currentUserId,
1646: last_update_date = endDateIn,
1647: last_update_login = currentUserId,
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
1709: use_count > 0 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
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
1712: sysdate between ame_attribute_usages.start_date 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
1716: select
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
1716: select
1717: ame_attributes.attribute_id attribute_id,
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
1769: ame_attributes.item_class_id = itemClassIdIn 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
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
1772: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) 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,
1777: itemClassIdIn in integer) is
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,
1777: itemClassIdIn in integer) is
1778: select
1850: procedure getApplicationAttributes(applicationIdIn in integer,
1851: attributeIdOut out nocopy ame_util.idList) as
1852: cursor attributeCursor(applicationIdIn in integer) is
1853: select attribute_id
1854: from ame_attribute_usages
1855: where
1856: application_id = applicationIdIn and
1857: sysdate between start_date and
1858: nvl(end_date - ame_util.oneSecond, sysdate)
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
1893: ame_attribute_usages.application_id = applicationIdIn 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
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
1897: sysdate between start_date 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;
1905: begin
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;
1905: begin
1906: tempIndex := 1;
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
1940: ame_attributes.attribute_type = ame_util.stringAttributeType 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
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
1943: sysdate between ame_attribute_usages.start_date 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;
1947: tempCount integer;
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;
1947: tempCount integer;
1948: tempIndex integer;
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
2038: ame_conditions.attribute_id = ame_attributes.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
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
2043: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) 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)
2048: order by name;
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)
2048: order by name;
2049: tempIndex integer;
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
2093: ame_conditions.attribute_id = ame_attributes.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
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
2098: sysdate between ame_attributes.start_date 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)
2104: order by name;
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)
2104: order by name;
2105: tempIndex integer;
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
2151: ame_conditions.attribute_id = ame_attributes.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
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
2156: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) 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)
2161: order by name;
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)
2161: order by name;
2162: attributeConditionCount integer;
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
2278: ame_attribute_usages.application_id = applicationIdIn 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
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
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;
2291: tempIndex integer;
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;
2291: tempIndex integer;
2292: begin
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
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
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
2375: sysdate between ame_attribute_usages.start_date 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)
2379: order by name;
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)
2379: order by name;
2380: tempIndex integer;
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
2457: ame_attribute_usages.application_id = applicationIdIn 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
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
2461: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
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;
2464: begin
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;
2464: begin
2465: open getNonHeaderICAttributesCursor(applicationIdIn => applicationIdIn,
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
2500: ame_attribute_usages.application_id = applicationIdIn 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
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
2504: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
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;
2507: begin
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;
2507: begin
2508: open getNonHeaderICAttributesCursor(applicationIdIn => applicationIdIn,
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
2582: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue 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
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
2585: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date)) and
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
2587: (ame_attribute_usages.end_date is null or sysdate < ame_attribute_usages.end_date))
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;
2590: begin
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;
2590: begin
2591: tempIndex := 1;
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
2627: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue 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
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
2630: sysdate between ame_attribute_usages.start_date 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;
2634: begin
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;
2634: begin
2635: tempIndex := 1;
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
2667: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanTrue 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
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
2670: sysdate between ame_attribute_usages.start_date 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;
2674: begin
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;
2674: begin
2675: tempIndex := 1;
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
2711: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse 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
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
2714: (select attribute_id from ame_mandatory_attributes
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
2716: (ame_mandatory_attributes.start_date <= sysdate 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;
2724: begin
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;
2724: begin
2725: tempIndex := 1;
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
2761: nvl(ame_attributes.line_item, ame_util.booleanFalse) = ame_util.booleanFalse 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
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
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;
2773: begin
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;
2773: begin
2774: tempIndex := 1;
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
2807: ame_attributes.item_class_id = ame_item_classes.item_class_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
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
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
2821: nvl(ame_item_classes.end_date - ame_util.oneSecond, sysdate)
2822: order by ame_attributes.name;
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)
2822: order by ame_attributes.name;
2823: headerItemClassId integer;
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
2861: ame_attributes.attribute_type = ame_util.stringAttributeType 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
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
2864: nvl(ame_attributes.end_date - ame_util.oneSecond, sysdate) and
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
2866: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
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;
2869: begin
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;
2869: begin
2870: tempIndex := 1;
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
2913: sysdate between ame_attributes.start_date 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
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
2916: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
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,
2919: itemClassIdIn in integer,
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,
2919: itemClassIdIn in integer,
2920: perApproverTypeIdIn in integer,
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
2941: sysdate between ame_attributes.start_date 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
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
2944: nvl(ame_attribute_usages.end_date - ame_util.oneSecond, sysdate)
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
2947: ame_attributes.attribute_id attribute_id,
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
2947: ame_attributes.attribute_id attribute_id,
2948: ame_attributes.name name
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
3015: ame_attributes.item_class_id = itemClassIdIn 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
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
3018: sysdate between ame_attribute_usages.start_date 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;
3022: begin
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;
3022: begin
3023: tempIndex := 1;
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
3062: ame_attributes.item_class_id = itemClassIdIn 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
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
3065: sysdate between ame_attribute_usages.start_date 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;
3069: begin
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;
3069: begin
3070: tempIndex := 1;
3152: numMonths ame_util.stringList;
3153: nullQueryStringException exception;
3154: objectVersionNoDataException exception;
3155: placeholderException exception;
3156: queryString ame_attribute_usages.query_string%type;
3157: queryString1 ame_attribute_usages.query_string%type;
3158: queryStringLengthException exception;
3159: queryStringColumnException exception;
3160: startDate date;
3153: nullQueryStringException exception;
3154: objectVersionNoDataException exception;
3155: placeholderException exception;
3156: queryString ame_attribute_usages.query_string%type;
3157: queryString1 ame_attribute_usages.query_string%type;
3158: queryStringLengthException exception;
3159: queryStringColumnException exception;
3160: startDate date;
3161: startDate2 date;
3168: transactionType ame_calling_apps.application_name%type;
3169: transIdPlaceholderPosition integer;
3170: transIdPlaceholderPosition2 integer;
3171: upperLineItemIdPlaceholder varchar2(100);
3172: upperQueryString ame_attribute_usages.query_string%type;
3173: upperTransIdPlaceholder varchar2(100);
3174: usageExistsException exception;
3175: useCount integer;
3176: processingDate date;
3307: raise badCurUsageException;
3308: end if;
3309: end if;
3310: end if;
3311: if(ame_util.isArgumentTooLong(tableNameIn => 'ame_attribute_usages',
3312: columnNameIn => 'query_string',
3313: argumentIn => queryString)) then
3314: raise queryStringLengthException;
3315: end if;
3314: raise queryStringLengthException;
3315: end if;
3316: select count(*)
3317: into tempCount
3318: from ame_attribute_usages
3319: where
3320: attribute_id = attributeIdIn and
3321: application_id = applicationIdIn and
3322: (start_date <= sysdate and
3325: raise usageExistsException;
3326: end if;
3327: /* Need to check if the striping attribute has been set to null.
3328: If so, need to let calculateUseCount know because it checks
3329: to see if it is a striping attribute before the ame_attribute_usages
3330: gets updated (which is after the call to calculateUseCount below).
3331: calculateUse check to see if striping is on. */
3332: /*
3333: AME_STRIPING
3354: isStripingAttributeChangeIn => isStripingAttributeChange,
3355: isBecomingStripingAttributeIn => isBecomingStripingAttribute);
3356: select count(*)
3357: into tempCount2
3358: from ame_attribute_usages
3359: where
3360: attribute_id = attributeIdIn and
3361: applicationI_id = applicationIdIn and
3362: created_by = ame_util.seededDataCreatedById;
3364: createdBy := ame_util.seededDataCreatedById;
3365: else
3366: createdBy := currentUserId;
3367: end if;
3368: insert into ame_attribute_usages(attribute_id,
3369: application_id,
3370: query_string,
3371: use_count,
3372: is_static,
3408: */
3409: currentUserId := ame_util.getCurrentUserId;
3410: select count(*)
3411: into tempCount2
3412: from ame_attribute_usages
3413: where
3414: attribute_id = attributeIdIn and
3415: application_id = applicationIdIn and
3416: created_by = ame_util.seededDataCreatedById;
3420: createdBy := currentUserId;
3421: else
3422: createdBy := createdByIn;
3423: end if;
3424: insert into ame_attribute_usages(attribute_id,
3425: application_id,
3426: query_string,
3427: use_count,
3428: is_static,
3571: errorMessage :=
3572: ame_util.getMessage(applicationShortNameIn => 'PER',
3573: messageNameIn => 'AME_400163_ATT_USAGE_LONG',
3574: tokenNameOneIn => 'COLUMN_LENGTH',
3575: tokenValueOneIn => ame_util.getColumnLength(tableNameIn => 'ame_attribute_usages',
3576: columnNameIn => 'query_string'));
3577: ame_util.runtimeException(packageNameIn => 'ame_attribute_pkg',
3578: routineNameIn => 'newAttributeUsage',
3579: exceptionNumberIn => errorCode,
3708: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
3709: ame_rule_usages.start_date + ame_util.oneSecond)));
3710: cursor applicationCursor(attributeIdIn in integer) is
3711: select application_id
3712: from ame_attribute_usages
3713: where
3714: attribute_id = attributeIdIn and
3715: sysdate between start_date and
3716: nvl(end_date - ame_util.oneSecond, sysdate) ;
3723: tempIndex integer;
3724: begin
3725: select count(*)
3726: into applicationCount
3727: from ame_attribute_usages
3728: where attribute_id = attributeIdIn and
3729: sysdate between start_date and
3730: nvl(end_date - ame_util.oneSecond, sysdate);
3731: for getAppRec in getApplicationId(actionTypeIdIn => actionTypeIdIn) loop
3732: /* for every application that uses the approval type, make sure an
3733: attribute usage exists for the required attribute */
3734: select count(*)
3735: into tempCount1
3736: from ame_attribute_usages
3737: where
3738: attribute_id = attributeIdIn and
3739: application_id = getAppRec.item_id and
3740: sysdate between start_date and
3874: actionTypeIdIn in integer,
3875: finalizeIn in boolean default true) as
3876: cursor applicationCursor(attributeIdIn in integer) is
3877: select application_id
3878: from ame_attribute_usages
3879: where
3880: attribute_id = attributeIdIn and
3881: sysdate between start_date and
3882: nvl(end_date - ame_util.oneSecond, sysdate) ;
3931: nvl(end_date - ame_util.oneSecond, sysdate)
3932: for update;
3933: cursor startDateCursor2 is
3934: select start_date
3935: from ame_attribute_usages
3936: where
3937: attribute_id = attributeIdIn and
3938: application_id = applicationIdIn and
3939: sysdate between start_date and
4000: end if;
4001: */
4002: currentUserId := ame_util.getCurrentUserId;
4003: /* Not active, either not mandatory or allowed to delete, so delete the usage. */
4004: update ame_attribute_usages
4005: set
4006: last_updated_by = currentUserId,
4007: last_update_date = processingDate,
4008: last_update_login = currentUserId,
4167: procedure setStripingAttributesToNull(applicationIdIn in integer,
4168: oldStripedAttributesIn in ame_util.idList default ame_util.emptyIdList,
4169: lastStripingAttributeIn in boolean default false) as
4170: cursor getStripingAttributesCursor(applicationIdIn in integer) is
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
4168: oldStripedAttributesIn in ame_util.idList default ame_util.emptyIdList,
4169: lastStripingAttributeIn in boolean default false) as
4170: cursor getStripingAttributesCursor(applicationIdIn in integer) is
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,
4169: lastStripingAttributeIn in boolean default false) as
4170: cursor getStripingAttributesCursor(applicationIdIn in integer) is
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
4170: cursor getStripingAttributesCursor(applicationIdIn in integer) is
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
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
4181: ame_attribute_usages.is_striping_attribute = ame_util.booleanTrue 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
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
4184: (ame_attributes.start_date <= sysdate and
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
4184: (ame_attributes.start_date <= sysdate and
4185: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date));
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
4184: (ame_attributes.start_date <= sysdate and
4185: (ame_attributes.end_date is null or sysdate < ame_attributes.end_date));
4186: endDate date;
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
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;
4245: errorCode integer;
4246: errorMessage ame_util.longestStringType;
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;
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;
4256: useCount integer;
4257: processingDate date;
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;
4256: useCount integer;
4257: processingDate date;
4258: begin
4259: processingDate := sysdate;
4276: end if;
4277: currentUserId := ame_util.getCurrentUserId;
4278: useCount := calculateUseCount(attributeIdIn => attributeIdIn,
4279: applicationIdIn => applicationIdIn);
4280: update ame_attribute_usages
4281: set use_count = useCount
4282: where
4283: application_id = applicationIdIn and
4284: attribute_id = attributeIdIn and
4332: upperLimit := attributeIds.count;
4333: for i in 1 .. upperLimit loop
4334: useCount := to_number(getUseCount(attributeIdIn => attributeIds(i),
4335: applicationIdIn => applicationIdIn));
4336: update ame_attribute_usages
4337: set use_count = useCount - 1
4338: where
4339: application_id = applicationIdIn and
4340: attribute_id = attributeIds(i) and