eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FORECAST_UTIL_PVT dependencies on DBMS_SQL

Line 1153: l_denorm_csr := DBMS_SQL.open_cursor;

1149: END IF;
1150: */
1151: FND_DSQL.add_text(') a');
1152:
1153: l_denorm_csr := DBMS_SQL.open_cursor;
1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1157: FND_DSQL.do_binds;

Line 1156: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

1152:
1153: l_denorm_csr := DBMS_SQL.open_cursor;
1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1157: FND_DSQL.do_binds;
1158: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1159: dbms_sql.close_cursor(l_denorm_csr);
1160:

Line 1158: l_ignore := DBMS_SQL.execute(l_denorm_csr);

1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1157: FND_DSQL.do_binds;
1158: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1159: dbms_sql.close_cursor(l_denorm_csr);
1160:
1161: <>
1162: NULL;

Line 1159: dbms_sql.close_cursor(l_denorm_csr);

1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1157: FND_DSQL.do_binds;
1158: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1159: dbms_sql.close_cursor(l_denorm_csr);
1160:
1161: <>
1162: NULL;
1163: END LOOP;

Line 1432: l_denorm_csr := DBMS_SQL.open_cursor;

1428: THEN
1429: GOTO NEXT_GROUP ;
1430: END IF;
1431:
1432: l_denorm_csr := DBMS_SQL.open_cursor;
1433: FND_DSQL.set_cursor(l_denorm_csr);
1434: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1435: ams_utility_pvt.debug_message('stmt ' || l_stmt_denorm);
1436: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 1436: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

1432: l_denorm_csr := DBMS_SQL.open_cursor;
1433: FND_DSQL.set_cursor(l_denorm_csr);
1434: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1435: ams_utility_pvt.debug_message('stmt ' || l_stmt_denorm);
1436: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1437: FND_DSQL.do_binds;
1438: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1439: dbms_sql.close_cursor(l_denorm_csr);
1440:

Line 1438: l_ignore := DBMS_SQL.execute(l_denorm_csr);

1434: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1435: ams_utility_pvt.debug_message('stmt ' || l_stmt_denorm);
1436: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1437: FND_DSQL.do_binds;
1438: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1439: dbms_sql.close_cursor(l_denorm_csr);
1440:
1441: <>
1442: NULL;

Line 1439: dbms_sql.close_cursor(l_denorm_csr);

1435: ams_utility_pvt.debug_message('stmt ' || l_stmt_denorm);
1436: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1437: FND_DSQL.do_binds;
1438: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1439: dbms_sql.close_cursor(l_denorm_csr);
1440:
1441: <>
1442: NULL;
1443: