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_CHECK_DUP_PROD_PVT dependencies on DBMS_SQL

Line 223: l_denorm_csr := DBMS_SQL.open_cursor;

219: IF l_stmt_temp IS NULL THEN
220: EXIT;
221: END IF;
222:
223: l_denorm_csr := DBMS_SQL.open_cursor;
224: FND_DSQL.set_cursor(l_denorm_csr);
225: l_stmt_denorm := FND_DSQL.get_text(FALSE);
226:
227: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

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

223: l_denorm_csr := DBMS_SQL.open_cursor;
224: FND_DSQL.set_cursor(l_denorm_csr);
225: l_stmt_denorm := FND_DSQL.get_text(FALSE);
226:
227: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
228: FND_DSQL.do_binds;
229: l_ignore := DBMS_SQL.execute(l_denorm_csr);
230: dbms_sql.close_cursor(l_denorm_csr);
231: END LOOP;

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

225: l_stmt_denorm := FND_DSQL.get_text(FALSE);
226:
227: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
228: FND_DSQL.do_binds;
229: l_ignore := DBMS_SQL.execute(l_denorm_csr);
230: dbms_sql.close_cursor(l_denorm_csr);
231: END LOOP;
232: /*
233: OPEN c_products_count(l_pbh_line.offer_discount_line_id, 'Y');

Line 230: dbms_sql.close_cursor(l_denorm_csr);

226:
227: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
228: FND_DSQL.do_binds;
229: l_ignore := DBMS_SQL.execute(l_denorm_csr);
230: dbms_sql.close_cursor(l_denorm_csr);
231: END LOOP;
232: /*
233: OPEN c_products_count(l_pbh_line.offer_discount_line_id, 'Y');
234: FETCH c_products_count INTO l_products_count;

Line 363: l_denorm_csr := DBMS_SQL.open_cursor;

359: FND_DSQL.add_text(')');
360:
361: ozf_utility_pvt.debug_message ('Denorm STMT status: ' || x_return_status);
362:
363: l_denorm_csr := DBMS_SQL.open_cursor;
364: FND_DSQL.set_cursor(l_denorm_csr);
365: l_stmt_denorm := FND_DSQL.get_text(FALSE);
366: ozf_utility_pvt.debug_message ('start STMT--------------------------------------------');
367: ozf_utility_pvt.debug_message (SUBSTR(l_stmt_denorm, 1, 250));

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

372: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
373: RAISE FND_API.g_exc_unexpected_error;
374: END IF;
375:
376: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
377: FND_DSQL.do_binds;
378: l_ignore := DBMS_SQL.execute(l_denorm_csr);
379: dbms_sql.close_cursor(l_denorm_csr);
380: */

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

374: END IF;
375:
376: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
377: FND_DSQL.do_binds;
378: l_ignore := DBMS_SQL.execute(l_denorm_csr);
379: dbms_sql.close_cursor(l_denorm_csr);
380: */
381: OPEN c_duplicate_prod_exists;
382: FETCH c_duplicate_prod_exists INTO l_duplicate_prod_exists;

Line 379: dbms_sql.close_cursor(l_denorm_csr);

375:
376: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
377: FND_DSQL.do_binds;
378: l_ignore := DBMS_SQL.execute(l_denorm_csr);
379: dbms_sql.close_cursor(l_denorm_csr);
380: */
381: OPEN c_duplicate_prod_exists;
382: FETCH c_duplicate_prod_exists INTO l_duplicate_prod_exists;
383: CLOSE c_duplicate_prod_exists;