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

Line 362: l_denorm_csr := DBMS_SQL.open_cursor;

358: FND_DSQL.add_text('))');
359:
360: write_conc_log ('l_product_stmt: ' || l_product_stmt);
361:
362: l_denorm_csr := DBMS_SQL.open_cursor;
363: FND_DSQL.set_cursor(l_denorm_csr);
364: l_stmt_denorm := FND_DSQL.get_text(FALSE);
365: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
366: FND_DSQL.do_binds;

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

361:
362: l_denorm_csr := DBMS_SQL.open_cursor;
363: FND_DSQL.set_cursor(l_denorm_csr);
364: l_stmt_denorm := FND_DSQL.get_text(FALSE);
365: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
366: FND_DSQL.do_binds;
367: l_ignore := DBMS_SQL.execute(l_denorm_csr);
368:
369: EXCEPTION

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

363: FND_DSQL.set_cursor(l_denorm_csr);
364: l_stmt_denorm := FND_DSQL.get_text(FALSE);
365: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
366: FND_DSQL.do_binds;
367: l_ignore := DBMS_SQL.execute(l_denorm_csr);
368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: ROLLBACK TO refresh_prod;

Line 3019: l_denorm_csr := DBMS_SQL.open_cursor;

3015: FND_DSQL.add_text('))');
3016:
3017: write_conc_log ('l_product_stmt1: ' || l_product_stmt);
3018:
3019: l_denorm_csr := DBMS_SQL.open_cursor;
3020: FND_DSQL.set_cursor(l_denorm_csr);
3021: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3022: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3023: FND_DSQL.do_binds;

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

3018:
3019: l_denorm_csr := DBMS_SQL.open_cursor;
3020: FND_DSQL.set_cursor(l_denorm_csr);
3021: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3022: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3023: FND_DSQL.do_binds;
3024: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3025:
3026: EXCEPTION

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

3020: FND_DSQL.set_cursor(l_denorm_csr);
3021: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3022: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3023: FND_DSQL.do_binds;
3024: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3025:
3026: EXCEPTION
3027: WHEN OTHERS THEN
3028: ROLLBACK TO refresh_prod;

Line 6894: l_denorm_csr := DBMS_SQL.open_cursor;

6890: || l_temp_sql
6891: || '))';
6892: */
6893:
6894: l_denorm_csr := DBMS_SQL.open_cursor;
6895: FND_DSQL.set_cursor(l_denorm_csr);
6896: l_stmt_denorm := FND_DSQL.get_text(FALSE);
6897: --ozf_utility_pvt.debug_message('offer query: '|| l_stmt_denorm);
6898: write_conc_log ( l_full_name

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

6900: || 'Insert Sql'
6901: || l_stmt_denorm);
6902: ----DBMS_output.put_line ( 'sql' || l_adjustment_product_sql);
6903: --EXECUTE IMMEDIATE l_adjustment_product_sql;
6904: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
6905: FND_DSQL.do_binds;
6906: l_ignore := DBMS_SQL.execute(l_denorm_csr);
6907:
6908: END LOOP;

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

6902: ----DBMS_output.put_line ( 'sql' || l_adjustment_product_sql);
6903: --EXECUTE IMMEDIATE l_adjustment_product_sql;
6904: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
6905: FND_DSQL.do_binds;
6906: l_ignore := DBMS_SQL.execute(l_denorm_csr);
6907:
6908: END LOOP;
6909: EXCEPTION
6910: WHEN OTHERS THEN