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 327: FND_DSQL.init;

323:
324: --kdass 28-FEB-2006 fixed bug 5059735 - denorm offer's product eligibility to handle all types of product levels
325: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
326:
327: FND_DSQL.init;
328: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, eligibility_id) ');
329: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
330: FND_DSQL.add_text(' FROM ( ');
331:

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

324: --kdass 28-FEB-2006 fixed bug 5059735 - denorm offer's product eligibility to handle all types of product levels
325: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
326:
327: FND_DSQL.init;
328: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, eligibility_id) ');
329: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
330: FND_DSQL.add_text(' FROM ( ');
331:
332: /*kdass 05-MAY-2006 bug 5205721 - use refresh_products() as it considers excluded items

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

325: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
326:
327: FND_DSQL.init;
328: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, eligibility_id) ');
329: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
330: FND_DSQL.add_text(' FROM ( ');
331:
332: /*kdass 05-MAY-2006 bug 5205721 - use refresh_products() as it considers excluded items
333: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql(p_context => 'ITEM'

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

326:
327: FND_DSQL.init;
328: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, eligibility_id) ');
329: FND_DSQL.add_text('(SELECT ''OFFR'', product_id ' );
330: FND_DSQL.add_text(' FROM ( ');
331:
332: /*kdass 05-MAY-2006 bug 5205721 - use refresh_products() as it considers excluded items
333: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql(p_context => 'ITEM'
334: ,p_attribute => p_product_attr

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

354: ,x_product_stmt => l_product_stmt
355: ,p_lline_id => p_list_line_id
356: );
357:
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;

Line 363: FND_DSQL.set_cursor(l_denorm_csr);

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

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

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

Line 366: FND_DSQL.do_binds;

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

Line 2994: FND_DSQL.init;

2990:
2991: write_conc_log ( l_full_name || ' : ' || ' Begin Inserting data into temp table for AdjustmentLineId ' || l_adjusted_line_cur.offer_adjustment_line_id );
2992:
2993:
2994: FND_DSQL.init;
2995: FND_DSQL.add_text('INSERT INTO ozf_adj_temp_eligibility(object_type, eligibility_id, offer_adjustment_line_id) ');
2996: FND_DSQL.add_text('(SELECT ''OFFR'', product_id, ' );
2997: FND_DSQL.add_text(l_adjusted_line_cur.offer_adjustment_line_id );
2998: FND_DSQL.add_text(' FROM ( ');

Line 2995: FND_DSQL.add_text('INSERT INTO ozf_adj_temp_eligibility(object_type, eligibility_id, offer_adjustment_line_id) ');

2991: write_conc_log ( l_full_name || ' : ' || ' Begin Inserting data into temp table for AdjustmentLineId ' || l_adjusted_line_cur.offer_adjustment_line_id );
2992:
2993:
2994: FND_DSQL.init;
2995: FND_DSQL.add_text('INSERT INTO ozf_adj_temp_eligibility(object_type, eligibility_id, offer_adjustment_line_id) ');
2996: FND_DSQL.add_text('(SELECT ''OFFR'', product_id, ' );
2997: FND_DSQL.add_text(l_adjusted_line_cur.offer_adjustment_line_id );
2998: FND_DSQL.add_text(' FROM ( ');
2999:

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

2992:
2993:
2994: FND_DSQL.init;
2995: FND_DSQL.add_text('INSERT INTO ozf_adj_temp_eligibility(object_type, eligibility_id, offer_adjustment_line_id) ');
2996: FND_DSQL.add_text('(SELECT ''OFFR'', product_id, ' );
2997: FND_DSQL.add_text(l_adjusted_line_cur.offer_adjustment_line_id );
2998: FND_DSQL.add_text(' FROM ( ');
2999:
3000: BEGIN

Line 2997: FND_DSQL.add_text(l_adjusted_line_cur.offer_adjustment_line_id );

2993:
2994: FND_DSQL.init;
2995: FND_DSQL.add_text('INSERT INTO ozf_adj_temp_eligibility(object_type, eligibility_id, offer_adjustment_line_id) ');
2996: FND_DSQL.add_text('(SELECT ''OFFR'', product_id, ' );
2997: FND_DSQL.add_text(l_adjusted_line_cur.offer_adjustment_line_id );
2998: FND_DSQL.add_text(' FROM ( ');
2999:
3000: BEGIN
3001: SAVEPOINT refresh_prod;

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

2994: FND_DSQL.init;
2995: FND_DSQL.add_text('INSERT INTO ozf_adj_temp_eligibility(object_type, eligibility_id, offer_adjustment_line_id) ');
2996: FND_DSQL.add_text('(SELECT ''OFFR'', product_id, ' );
2997: FND_DSQL.add_text(l_adjusted_line_cur.offer_adjustment_line_id );
2998: FND_DSQL.add_text(' FROM ( ');
2999:
3000: BEGIN
3001: SAVEPOINT refresh_prod;
3002:

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

3011: ,x_product_stmt => l_product_stmt
3012: ,p_lline_id => l_adjusted_line_cur.to_list_line_id
3013: );
3014:
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;

Line 3020: FND_DSQL.set_cursor(l_denorm_csr);

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

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

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

Line 3023: FND_DSQL.do_binds;

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

Line 6854: FND_DSQL.init;

6850: -- Get all product qualifiers for 'FUND'
6851: FOR product_rec IN c_off_adj_lines
6852: LOOP
6853:
6854: FND_DSQL.init;
6855: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
6856: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
6857: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
6858: FND_DSQL.add_text(' FROM ( ');

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

6851: FOR product_rec IN c_off_adj_lines
6852: LOOP
6853:
6854: FND_DSQL.init;
6855: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
6856: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
6857: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
6858: FND_DSQL.add_text(' FROM ( ');
6859:

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

6852: LOOP
6853:
6854: FND_DSQL.init;
6855: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
6856: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
6857: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
6858: FND_DSQL.add_text(' FROM ( ');
6859:
6860: -- For ALL items do a special processing , we donot eant to populate ozf_temp_wligibility

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

6853:
6854: FND_DSQL.init;
6855: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
6856: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
6857: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
6858: FND_DSQL.add_text(' FROM ( ');
6859:
6860: -- For ALL items do a special processing , we donot eant to populate ozf_temp_wligibility
6861: -- with all items but insert -1 instead

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

6854: FND_DSQL.init;
6855: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id,offer_adjustment_line_id) ');
6856: FND_DSQL.add_text('(SELECT ''FUND'', ''N'', product_id,' );
6857: FND_DSQL.add_text(product_rec.offer_adjustment_line_id );
6858: FND_DSQL.add_text(' FROM ( ');
6859:
6860: -- For ALL items do a special processing , we donot eant to populate ozf_temp_wligibility
6861: -- with all items but insert -1 instead
6862: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);

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

6862: ----DBMS_output.put_line ( 'product_rec.product_attribute ' || product_rec.product_attribute);
6863: ----DBMS_output.put_line ( 'product_rec.product_attr_value ' || product_rec.product_attr_value);
6864: IF product_rec.product_attribute = 'PRICING_ATTRIBUTE3' AND product_rec.product_attr_value = 'ALL' THEN
6865: --l_temp_sql := 'SELECT -1 product_id FROM DUAL';
6866: FND_DSQL.add_text('SELECT -1 product_id FROM DUAL');
6867: ----DBMS_output.put_line (' IN ALL products ');
6868: ELSE
6869: l_temp_sql := ozf_offr_elig_prod_denorm_pvt.get_sql (
6870: p_context=> 'ITEM',

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

6875: p_comparison=> NULL,
6876: p_type=> 'PROD'
6877: );
6878: END IF;
6879: FND_DSQL.add_text('))');
6880: write_conc_log ( l_full_name
6881: || ' : '
6882: || 'Get Sql Returns'
6883: || l_temp_sql);

Line 6895: FND_DSQL.set_cursor(l_denorm_csr);

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

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

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
6899: || ' : '
6900: || 'Insert Sql'

Line 6905: FND_DSQL.do_binds;

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