APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on DBMS_SQL

Line 321: l_denorm_csr := DBMS_SQL.open_cursor;

317: FND_DSQL.add_text('))');
318:
319: write_conc_log ('l_product_stmt: ' || l_product_stmt);
320:
321: l_denorm_csr := DBMS_SQL.open_cursor;
322: FND_DSQL.set_cursor(l_denorm_csr);
323: l_stmt_denorm := FND_DSQL.get_text(FALSE);
324: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
325: FND_DSQL.do_binds;

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

320:
321: l_denorm_csr := DBMS_SQL.open_cursor;
322: FND_DSQL.set_cursor(l_denorm_csr);
323: l_stmt_denorm := FND_DSQL.get_text(FALSE);
324: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
325: FND_DSQL.do_binds;
326: l_ignore := DBMS_SQL.execute(l_denorm_csr);
327:
328: EXCEPTION

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

322: FND_DSQL.set_cursor(l_denorm_csr);
323: l_stmt_denorm := FND_DSQL.get_text(FALSE);
324: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
325: FND_DSQL.do_binds;
326: l_ignore := DBMS_SQL.execute(l_denorm_csr);
327:
328: EXCEPTION
329: WHEN OTHERS THEN
330: ROLLBACK TO refresh_prod;

Line 2866: l_denorm_csr := DBMS_SQL.open_cursor;

2862: || l_temp_sql
2863: || '))';
2864: */
2865:
2866: l_denorm_csr := DBMS_SQL.open_cursor;
2867: FND_DSQL.set_cursor(l_denorm_csr);
2868: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2869: --ozf_utility_pvt.debug_message('offer query: '|| l_stmt_denorm);
2870: write_conc_log ( l_full_name

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

2872: || 'Insert Sql'
2873: || l_stmt_denorm);
2874: ----DBMS_output.put_line ( 'sql' || l_adjustment_product_sql);
2875: --EXECUTE IMMEDIATE l_adjustment_product_sql;
2876: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2877: FND_DSQL.do_binds;
2878: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2879:
2880: END LOOP;

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

2874: ----DBMS_output.put_line ( 'sql' || l_adjustment_product_sql);
2875: --EXECUTE IMMEDIATE l_adjustment_product_sql;
2876: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2877: FND_DSQL.do_binds;
2878: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2879:
2880: END LOOP;
2881: EXCEPTION
2882: WHEN OTHERS THEN