APPS.AME_UTIL dependencies on DBMS_SQL

Line 1640: dynamicCursor := dbms_sql.open_cursor;

1636: /* Check/execute the usage. */
1637: if( tempIsstaticUsage = ame_util.booleanTrue) then
1638: attributeValue := attributeUsage;
1639: elsif(transactionIdIn is not null) then
1640: dynamicCursor := dbms_sql.open_cursor;
1641: dbms_sql.parse(dynamicCursor,
1642: ame_util.removeReturns(stringIn => attributeUsage,
1643: replaceWithSpaces => true),
1644: dbms_sql.native);

Line 1641: dbms_sql.parse(dynamicCursor,

1637: if( tempIsstaticUsage = ame_util.booleanTrue) then
1638: attributeValue := attributeUsage;
1639: elsif(transactionIdIn is not null) then
1640: dynamicCursor := dbms_sql.open_cursor;
1641: dbms_sql.parse(dynamicCursor,
1642: ame_util.removeReturns(stringIn => attributeUsage,
1643: replaceWithSpaces => true),
1644: dbms_sql.native);
1645: dbms_sql.define_column(dynamicCursor,

Line 1644: dbms_sql.native);

1640: dynamicCursor := dbms_sql.open_cursor;
1641: dbms_sql.parse(dynamicCursor,
1642: ame_util.removeReturns(stringIn => attributeUsage,
1643: replaceWithSpaces => true),
1644: dbms_sql.native);
1645: dbms_sql.define_column(dynamicCursor,
1646: 1,
1647: attributeValue,
1648: ame_util.attributeValueTypeLength);

Line 1645: dbms_sql.define_column(dynamicCursor,

1641: dbms_sql.parse(dynamicCursor,
1642: ame_util.removeReturns(stringIn => attributeUsage,
1643: replaceWithSpaces => true),
1644: dbms_sql.native);
1645: dbms_sql.define_column(dynamicCursor,
1646: 1,
1647: attributeValue,
1648: ame_util.attributeValueTypeLength);
1649: if(instrb(attributeUsage, ame_util.transactionIdPlaceholder) > 0) then

Line 1650: dbms_sql.bind_variable(dynamicCursor,

1646: 1,
1647: attributeValue,
1648: ame_util.attributeValueTypeLength);
1649: if(instrb(attributeUsage, ame_util.transactionIdPlaceholder) > 0) then
1650: dbms_sql.bind_variable(dynamicCursor,
1651: ame_util.transactionIdPlaceholder,
1652: transactionIdIn);
1653: end if;
1654: ignoreMe := dbms_sql.execute(dynamicCursor);

Line 1654: ignoreMe := dbms_sql.execute(dynamicCursor);

1650: dbms_sql.bind_variable(dynamicCursor,
1651: ame_util.transactionIdPlaceholder,
1652: transactionIdIn);
1653: end if;
1654: ignoreMe := dbms_sql.execute(dynamicCursor);
1655: if(dbms_sql.fetch_rows(dynamicCursor) > 0) then
1656: /*
1657: Don't raise an exception if the fetch returns no rows, because we can't log the
1658: exception (see below); just silently use the default attributeValue value.

Line 1655: if(dbms_sql.fetch_rows(dynamicCursor) > 0) then

1651: ame_util.transactionIdPlaceholder,
1652: transactionIdIn);
1653: end if;
1654: ignoreMe := dbms_sql.execute(dynamicCursor);
1655: if(dbms_sql.fetch_rows(dynamicCursor) > 0) then
1656: /*
1657: Don't raise an exception if the fetch returns no rows, because we can't log the
1658: exception (see below); just silently use the default attributeValue value.
1659: */

Line 1660: dbms_sql.column_value(dynamicCursor,

1656: /*
1657: Don't raise an exception if the fetch returns no rows, because we can't log the
1658: exception (see below); just silently use the default attributeValue value.
1659: */
1660: dbms_sql.column_value(dynamicCursor,
1661: 1,
1662: attributeValue);
1663: end if;
1664: dbms_sql.close_cursor(dynamicCursor);

Line 1664: dbms_sql.close_cursor(dynamicCursor);

1660: dbms_sql.column_value(dynamicCursor,
1661: 1,
1662: attributeValue);
1663: end if;
1664: dbms_sql.close_cursor(dynamicCursor);
1665: end if;
1666: if(attributeValue = ame_util.booleanAttributeTrue) then
1667: return(true);
1668: end if;

Line 2325: keywords(15) := 'dbms_sql';

2321: keywords(11) := 'alter';
2322: keywords(12) := 'commit';
2323: keywords(13) := 'connect';
2324: keywords(14) := 'rollback';
2325: keywords(15) := 'dbms_sql';
2326: keywords(16) := 'dbms_output';
2327: keywords(17) := 'htp';
2328: keywords(18) := 'htf';
2329: keywords(19) := 'owa_util';