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

Line 2896: l_denorm_csr := DBMS_SQL.open_cursor;

2892: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'',''ORDER'') ');
2893: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
2894: FND_DSQL.add_text(')');
2895:
2896: l_denorm_csr := DBMS_SQL.open_cursor;
2897: FND_DSQL.set_cursor(l_denorm_csr);
2898: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2899: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2900: FND_DSQL.do_binds;

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

2895:
2896: l_denorm_csr := DBMS_SQL.open_cursor;
2897: FND_DSQL.set_cursor(l_denorm_csr);
2898: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2899: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2900: FND_DSQL.do_binds;
2901: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2902: dbms_sql.close_cursor(l_denorm_csr);
2903:

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

2897: FND_DSQL.set_cursor(l_denorm_csr);
2898: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2899: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2900: FND_DSQL.do_binds;
2901: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2902: dbms_sql.close_cursor(l_denorm_csr);
2903:
2904: UPDATE ozf_offers
2905: SET qualifier_deleted = 'N'

Line 2902: dbms_sql.close_cursor(l_denorm_csr);

2898: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2899: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2900: FND_DSQL.do_binds;
2901: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2902: dbms_sql.close_cursor(l_denorm_csr);
2903:
2904: UPDATE ozf_offers
2905: SET qualifier_deleted = 'N'
2906: WHERE qp_list_header_id = i.object_id;

Line 2996: l_denorm_csr := DBMS_SQL.open_cursor;

2992: FND_DSQL.add_text(' AND list_line_id = ');
2993: FND_DSQL.add_bind(x.lline_id);
2994: FND_DSQL.add_text(' and product_attribute <> ''PRICING_ATTRIBUTE1'' AND excluder_flag = ''N'')');
2995:
2996: l_denorm_csr := DBMS_SQL.open_cursor;
2997: FND_DSQL.set_cursor(l_denorm_csr);
2998: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2999:
3000: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

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

2996: l_denorm_csr := DBMS_SQL.open_cursor;
2997: FND_DSQL.set_cursor(l_denorm_csr);
2998: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2999:
3000: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3001: FND_DSQL.do_binds;
3002: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3003: dbms_sql.close_cursor(l_denorm_csr);
3004: END IF;

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

2998: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2999:
3000: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3001: FND_DSQL.do_binds;
3002: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3003: dbms_sql.close_cursor(l_denorm_csr);
3004: END IF;
3005: END LOOP; -- one list line processed
3006:

Line 3003: dbms_sql.close_cursor(l_denorm_csr);

2999:
3000: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3001: FND_DSQL.do_binds;
3002: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3003: dbms_sql.close_cursor(l_denorm_csr);
3004: END IF;
3005: END LOOP; -- one list line processed
3006:
3007: -- Maintain a counter for offers processed and check if any products were denormed, if so, have an if condition to do the forecast.

Line 3249: l_denorm_csr := DBMS_SQL.open_cursor;

3245: /*
3246: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed
3247: WHERE object_id = i.object_id and object_class = 'OFFR';
3248: */
3249: l_denorm_csr := DBMS_SQL.open_cursor;
3250: FND_DSQL.set_cursor(l_denorm_csr);
3251: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3252: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3253: FND_DSQL.do_binds;

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

3248: */
3249: l_denorm_csr := DBMS_SQL.open_cursor;
3250: FND_DSQL.set_cursor(l_denorm_csr);
3251: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3252: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3253: FND_DSQL.do_binds;
3254: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3255: dbms_sql.close_cursor(l_denorm_csr);
3256:

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

3250: FND_DSQL.set_cursor(l_denorm_csr);
3251: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3252: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3253: FND_DSQL.do_binds;
3254: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3255: dbms_sql.close_cursor(l_denorm_csr);
3256:
3257: UPDATE ozf_offers
3258: SET qualifier_deleted = 'N'

Line 3255: dbms_sql.close_cursor(l_denorm_csr);

3251: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3252: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3253: FND_DSQL.do_binds;
3254: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3255: dbms_sql.close_cursor(l_denorm_csr);
3256:
3257: UPDATE ozf_offers
3258: SET qualifier_deleted = 'N'
3259: WHERE qp_list_header_id = i.object_id;

Line 3349: l_denorm_csr := DBMS_SQL.open_cursor;

3345: DELETE FROM ozf_activity_products -- delete rows that will be refreshed
3346: WHERE object_id = i.object_id and object_class = 'OFFR';
3347: */
3348:
3349: l_denorm_csr := DBMS_SQL.open_cursor;
3350: FND_DSQL.set_cursor(l_denorm_csr);
3351: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3352: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3353: FND_DSQL.do_binds;

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

3348:
3349: l_denorm_csr := DBMS_SQL.open_cursor;
3350: FND_DSQL.set_cursor(l_denorm_csr);
3351: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3352: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3353: FND_DSQL.do_binds;
3354: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3355: --write_log('four');
3356: dbms_sql.close_cursor(l_denorm_csr);

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

3350: FND_DSQL.set_cursor(l_denorm_csr);
3351: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3352: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3353: FND_DSQL.do_binds;
3354: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3355: --write_log('four');
3356: dbms_sql.close_cursor(l_denorm_csr);
3357: END IF;
3358: END LOOP;

Line 3356: dbms_sql.close_cursor(l_denorm_csr);

3352: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3353: FND_DSQL.do_binds;
3354: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3355: --write_log('four');
3356: dbms_sql.close_cursor(l_denorm_csr);
3357: END IF;
3358: END LOOP;
3359: ELSE -- offer not changed, denorm party and/or product
3360: --write_log('Offer Id: '|| i.object_id || ' has not changed.');

Line 3460: l_denorm_csr := DBMS_SQL.open_cursor;

3456: /*
3457: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed
3458: WHERE object_id = i.object_id and object_class = 'OFFR';
3459: */
3460: l_denorm_csr := DBMS_SQL.open_cursor;
3461: FND_DSQL.set_cursor(l_denorm_csr);
3462: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3463: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3464: FND_DSQL.do_binds;

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

3459: */
3460: l_denorm_csr := DBMS_SQL.open_cursor;
3461: FND_DSQL.set_cursor(l_denorm_csr);
3462: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3463: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3464: FND_DSQL.do_binds;
3465: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3466: dbms_sql.close_cursor(l_denorm_csr);
3467: END IF;

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

3461: FND_DSQL.set_cursor(l_denorm_csr);
3462: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3463: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3464: FND_DSQL.do_binds;
3465: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3466: dbms_sql.close_cursor(l_denorm_csr);
3467: END IF;
3468: l_group_count := l_group_count + 1;
3469: << GROUP_END3 >>

Line 3466: dbms_sql.close_cursor(l_denorm_csr);

3462: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3463: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3464: FND_DSQL.do_binds;
3465: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3466: dbms_sql.close_cursor(l_denorm_csr);
3467: END IF;
3468: l_group_count := l_group_count + 1;
3469: << GROUP_END3 >>
3470: write_conc_log('end insert party changed qualifier: ' || z.qnum);

Line 3564: l_denorm_csr := DBMS_SQL.open_cursor;

3560:
3561: DELETE FROM ozf_activity_products -- delete rows that will be refreshed
3562: WHERE object_id = i.object_id and object_class = 'OFFR';
3563:
3564: l_denorm_csr := DBMS_SQL.open_cursor;
3565: FND_DSQL.set_cursor(l_denorm_csr);
3566: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3567: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3568: FND_DSQL.do_binds;

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

3563:
3564: l_denorm_csr := DBMS_SQL.open_cursor;
3565: FND_DSQL.set_cursor(l_denorm_csr);
3566: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3567: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3568: FND_DSQL.do_binds;
3569: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3570: dbms_sql.close_cursor(l_denorm_csr);
3571: END IF;

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

3565: FND_DSQL.set_cursor(l_denorm_csr);
3566: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3567: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3568: FND_DSQL.do_binds;
3569: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3570: dbms_sql.close_cursor(l_denorm_csr);
3571: END IF;
3572: END LOOP;
3573: END IF; -- l_dummy <> 'Y', product not denormed yet

Line 3570: dbms_sql.close_cursor(l_denorm_csr);

3566: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3567: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3568: FND_DSQL.do_binds;
3569: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3570: dbms_sql.close_cursor(l_denorm_csr);
3571: END IF;
3572: END LOOP;
3573: END IF; -- l_dummy <> 'Y', product not denormed yet
3574: END IF; -- product changed