APPS.AME_UTIL dependencies on AME_ATTRIBUTE_USAGES

Line 1530: ,queryStringOut out nocopy ame_attribute_usages.query_string%type

1526: applicationIdIn => applicationIdIn );
1527: end getAttributeId;
1528:
1529: procedure getQueryString(attributeIdIn in varchar2
1530: ,queryStringOut out nocopy ame_attribute_usages.query_string%type
1531: ,transactionIdIn in varchar2
1532: ,applicationIdIn in number) as
1533: temQueryString ame_attribute_usages.query_string%type;
1534: tempLogId number;

Line 1533: temQueryString ame_attribute_usages.query_string%type;

1529: procedure getQueryString(attributeIdIn in varchar2
1530: ,queryStringOut out nocopy ame_attribute_usages.query_string%type
1531: ,transactionIdIn in varchar2
1532: ,applicationIdIn in number) as
1533: temQueryString ame_attribute_usages.query_string%type;
1534: tempLogId number;
1535: begin
1536: select query_string
1537: into temQueryString

Line 1538: from ame_attribute_usages

1534: tempLogId number;
1535: begin
1536: select query_string
1537: into temQueryString
1538: from ame_attribute_usages
1539: where
1540: attribute_id = attributeIdIn and
1541: application_id = applicationIdIn and
1542: sysdate between start_date and

Line 1567: from ame_attribute_usages

1563: tempLogId number;
1564: begin
1565: select is_static
1566: into tempIsSatic
1567: from ame_attribute_usages
1568: where attribute_id = attributeIdIn and
1569: application_id = applicationIdIn and
1570: sysdate between start_date and
1571: nvl(end_date - ame_util.oneSecond, sysdate) ;

Line 1588: attributeUsage ame_attribute_usages.query_string%type;

1584: end checkSaticUsage;
1585: function useWorkflow(transactionIdIn in varchar2 default null,
1586: applicationIdIn in integer) return boolean as
1587: attributeId integer;
1588: attributeUsage ame_attribute_usages.query_string%type;
1589: attributeValue ame_util.attributeValueType;
1590: badUsageException exception;
1591: dynamicCursor integer;
1592: errorCode integer;

Line 3972: from ame_attribute_usages

3968: sysdate between start_date and
3969: nvl(end_date - ame_util.oneSecond, sysdate);
3970: cursor attributeUsageCursor (applicationIdIn integer) is
3971: select attribute_id
3972: from ame_attribute_usages
3973: where
3974: application_id = applicationIdIn and
3975: sysdate between start_date and
3976: nvl(end_date - ame_util.oneSecond, sysdate);