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 FND_DSQL

Line 286: FND_DSQL.init;

282:
283: --kdass 28-FEB-2006 fixed bug 5059735 - denorm offer's product eligibility to handle all types of product levels
284: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
285:
286: FND_DSQL.init;
287: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, eligibility_id) ');
288: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
289: FND_DSQL.add_text(' FROM ( ');
290:

Line 287: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, eligibility_id) ');

283: --kdass 28-FEB-2006 fixed bug 5059735 - denorm offer's product eligibility to handle all types of product levels
284: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
285:
286: FND_DSQL.init;
287: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, eligibility_id) ');
288: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
289: FND_DSQL.add_text(' FROM ( ');
290:
291: /*kdass 05-MAY-2006 bug 5205721 - use refresh_products() as it considers excluded items

Line 288: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );

284: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
285:
286: FND_DSQL.init;
287: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, eligibility_id) ');
288: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
289: FND_DSQL.add_text(' FROM ( ');
290:
291: /*kdass 05-MAY-2006 bug 5205721 - use refresh_products() as it considers excluded items
292: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql(p_context => 'ITEM'

Line 289: FND_DSQL.add_text(' FROM ( ');

285:
286: FND_DSQL.init;
287: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, eligibility_id) ');
288: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
289: FND_DSQL.add_text(' FROM ( ');
290:
291: /*kdass 05-MAY-2006 bug 5205721 - use refresh_products() as it considers excluded items
292: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql(p_context => 'ITEM'
293: ,p_attribute => p_product_attr

Line 317: FND_DSQL.add_text('))');

313: ,x_product_stmt => l_product_stmt
314: ,p_lline_id => p_list_line_id
315: );
316:
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;

Line 322: FND_DSQL.set_cursor(l_denorm_csr);

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;
326: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 323: l_stmt_denorm := FND_DSQL.get_text(FALSE);

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;
326: l_ignore := DBMS_SQL.execute(l_denorm_csr);
327:

Line 325: FND_DSQL.do_binds;

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
329: WHEN OTHERS THEN

Line 2826: FND_DSQL.init;

2822: -- Get all product qualifiers for 'FUND'
2823: FOR product_rec IN c_off_adj_lines
2824: LOOP
2825:
2826: FND_DSQL.init;
2827: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
2828: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
2829: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
2830: FND_DSQL.add_text(' FROM ( ');

Line 2827: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');

2823: FOR product_rec IN c_off_adj_lines
2824: LOOP
2825:
2826: FND_DSQL.init;
2827: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
2828: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
2829: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
2830: FND_DSQL.add_text(' FROM ( ');
2831:

Line 2828: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );

2824: LOOP
2825:
2826: FND_DSQL.init;
2827: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
2828: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
2829: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
2830: FND_DSQL.add_text(' FROM ( ');
2831:
2832: -- For ALL items do a special processing , we donot eant to populate ozf_temp_wligibility

Line 2829: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );

2825:
2826: FND_DSQL.init;
2827: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
2828: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
2829: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
2830: FND_DSQL.add_text(' FROM ( ');
2831:
2832: -- For ALL items do a special processing , we donot eant to populate ozf_temp_wligibility
2833: -- with all items but insert -1 instead

Line 2830: FND_DSQL.add_text(' FROM ( ');

2826: FND_DSQL.init;
2827: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
2828: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
2829: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
2830: FND_DSQL.add_text(' FROM ( ');
2831:
2832: -- For ALL items do a special processing , we donot eant to populate ozf_temp_wligibility
2833: -- with all items but insert -1 instead
2834: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);

Line 2838: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');

2834: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);
2835: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);
2836: IF product_rec.product_attribute = 'PRICING_ATTRIBUTE3' AND product_rec.product_attr_value = 'ALL' THEN
2837: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
2838: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
2839: ----DBMS_output.put_line (' IN ALL products ');
2840: ELSE
2841: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (
2842: p_context=> 'ITEM',

Line 2851: FND_DSQL.add_text('))');

2847: p_comparison=> NULL,
2848: p_type=> 'PROD'
2849: );
2850: END IF;
2851: FND_DSQL.add_text('))');
2852: write_conc_log ( l_full_name
2853: || ' : '
2854: || 'Get Sql Returns'
2855: || l_temp_sql);

Line 2867: FND_DSQL.set_cursor(l_denorm_csr);

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
2871: || ' : '

Line 2868: l_stmt_denorm := FND_DSQL.get_text(FALSE);

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
2871: || ' : '
2872: || 'Insert Sql'

Line 2877: FND_DSQL.do_binds;

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;
2881: EXCEPTION