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 2953: l_denorm_csr := DBMS_SQL.open_cursor;

2949: FND_DSQL.add_text(' and qualifier_context not in (''MODLIST'',''ORDER'') ');
2950: FND_DSQL.add_text(' and qualifier_attribute < ''A'' ');
2951: FND_DSQL.add_text(')');
2952:
2953: l_denorm_csr := DBMS_SQL.open_cursor;
2954: FND_DSQL.set_cursor(l_denorm_csr);
2955: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2956:
2957:

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

2954: FND_DSQL.set_cursor(l_denorm_csr);
2955: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2956:
2957:
2958: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2959: FND_DSQL.do_binds;
2960: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2961: dbms_sql.close_cursor(l_denorm_csr);
2962:

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

2956:
2957:
2958: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2959: FND_DSQL.do_binds;
2960: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2961: dbms_sql.close_cursor(l_denorm_csr);
2962:
2963: UPDATE ozf_offers
2964: SET qualifier_deleted = 'N'

Line 2961: dbms_sql.close_cursor(l_denorm_csr);

2957:
2958: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2959: FND_DSQL.do_binds;
2960: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2961: dbms_sql.close_cursor(l_denorm_csr);
2962:
2963: UPDATE ozf_offers
2964: SET qualifier_deleted = 'N'
2965: WHERE qp_list_header_id = i.object_id;

Line 3055: l_denorm_csr := DBMS_SQL.open_cursor;

3051: FND_DSQL.add_text(' AND list_line_id = ');
3052: FND_DSQL.add_bind(x.lline_id);
3053: FND_DSQL.add_text(' and product_attribute <> ''PRICING_ATTRIBUTE1'' AND excluder_flag = ''N'')');
3054:
3055: l_denorm_csr := DBMS_SQL.open_cursor;
3056: FND_DSQL.set_cursor(l_denorm_csr);
3057: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3058:
3059: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

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

3055: l_denorm_csr := DBMS_SQL.open_cursor;
3056: FND_DSQL.set_cursor(l_denorm_csr);
3057: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3058:
3059: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3060: FND_DSQL.do_binds;
3061: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3062: dbms_sql.close_cursor(l_denorm_csr);
3063: END IF;

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

3057: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3058:
3059: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3060: FND_DSQL.do_binds;
3061: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3062: dbms_sql.close_cursor(l_denorm_csr);
3063: END IF;
3064: END LOOP; -- one list line processed
3065:

Line 3062: dbms_sql.close_cursor(l_denorm_csr);

3058:
3059: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3060: FND_DSQL.do_binds;
3061: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3062: dbms_sql.close_cursor(l_denorm_csr);
3063: END IF;
3064: END LOOP; -- one list line processed
3065:
3066: -- Maintain a counter for offers processed and check if any products were denormed, if so, have an if condition to do the forecast.

Line 3309: l_denorm_csr := DBMS_SQL.open_cursor;

3305: /*
3306: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed
3307: WHERE object_id = i.object_id and object_class = 'OFFR';
3308: */
3309: l_denorm_csr := DBMS_SQL.open_cursor;
3310: FND_DSQL.set_cursor(l_denorm_csr);
3311: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3312: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3313: FND_DSQL.do_binds;

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

3308: */
3309: l_denorm_csr := DBMS_SQL.open_cursor;
3310: FND_DSQL.set_cursor(l_denorm_csr);
3311: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3312: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3313: FND_DSQL.do_binds;
3314: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3315: dbms_sql.close_cursor(l_denorm_csr);
3316:

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

3310: FND_DSQL.set_cursor(l_denorm_csr);
3311: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3312: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3313: FND_DSQL.do_binds;
3314: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3315: dbms_sql.close_cursor(l_denorm_csr);
3316:
3317: UPDATE ozf_offers
3318: SET qualifier_deleted = 'N'

Line 3315: dbms_sql.close_cursor(l_denorm_csr);

3311: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3312: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3313: FND_DSQL.do_binds;
3314: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3315: dbms_sql.close_cursor(l_denorm_csr);
3316:
3317: UPDATE ozf_offers
3318: SET qualifier_deleted = 'N'
3319: WHERE qp_list_header_id = i.object_id;

Line 3409: l_denorm_csr := DBMS_SQL.open_cursor;

3405: DELETE FROM ozf_activity_products -- delete rows that will be refreshed
3406: WHERE object_id = i.object_id and object_class = 'OFFR';
3407: */
3408:
3409: l_denorm_csr := DBMS_SQL.open_cursor;
3410: FND_DSQL.set_cursor(l_denorm_csr);
3411: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3412: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3413: FND_DSQL.do_binds;

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

3408:
3409: l_denorm_csr := DBMS_SQL.open_cursor;
3410: FND_DSQL.set_cursor(l_denorm_csr);
3411: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3412: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3413: FND_DSQL.do_binds;
3414: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3415: --write_log('four');
3416: dbms_sql.close_cursor(l_denorm_csr);

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

3410: FND_DSQL.set_cursor(l_denorm_csr);
3411: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3412: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3413: FND_DSQL.do_binds;
3414: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3415: --write_log('four');
3416: dbms_sql.close_cursor(l_denorm_csr);
3417: END IF;
3418: END LOOP;

Line 3416: dbms_sql.close_cursor(l_denorm_csr);

3412: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3413: FND_DSQL.do_binds;
3414: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3415: --write_log('four');
3416: dbms_sql.close_cursor(l_denorm_csr);
3417: END IF;
3418: END LOOP;
3419: ELSE -- offer not changed, denorm party and/or product
3420: --write_log('Offer Id: '|| i.object_id || ' has not changed.');

Line 3520: l_denorm_csr := DBMS_SQL.open_cursor;

3516: /*
3517: DELETE FROM ozf_activity_customers -- delete rows that will be refreshed
3518: WHERE object_id = i.object_id and object_class = 'OFFR';
3519: */
3520: l_denorm_csr := DBMS_SQL.open_cursor;
3521: FND_DSQL.set_cursor(l_denorm_csr);
3522: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3523: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3524: FND_DSQL.do_binds;

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

3519: */
3520: l_denorm_csr := DBMS_SQL.open_cursor;
3521: FND_DSQL.set_cursor(l_denorm_csr);
3522: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3523: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3524: FND_DSQL.do_binds;
3525: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3526: dbms_sql.close_cursor(l_denorm_csr);
3527: END IF;

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

3521: FND_DSQL.set_cursor(l_denorm_csr);
3522: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3523: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3524: FND_DSQL.do_binds;
3525: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3526: dbms_sql.close_cursor(l_denorm_csr);
3527: END IF;
3528: l_group_count := l_group_count + 1;
3529: << GROUP_END3 >>

Line 3526: dbms_sql.close_cursor(l_denorm_csr);

3522: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3523: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3524: FND_DSQL.do_binds;
3525: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3526: dbms_sql.close_cursor(l_denorm_csr);
3527: END IF;
3528: l_group_count := l_group_count + 1;
3529: << GROUP_END3 >>
3530: write_conc_log('end insert party changed qualifier: ' || z.qnum);

Line 3624: l_denorm_csr := DBMS_SQL.open_cursor;

3620:
3621: DELETE FROM ozf_activity_products -- delete rows that will be refreshed
3622: WHERE object_id = i.object_id and object_class = 'OFFR';
3623:
3624: l_denorm_csr := DBMS_SQL.open_cursor;
3625: FND_DSQL.set_cursor(l_denorm_csr);
3626: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3627: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3628: FND_DSQL.do_binds;

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

3623:
3624: l_denorm_csr := DBMS_SQL.open_cursor;
3625: FND_DSQL.set_cursor(l_denorm_csr);
3626: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3627: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3628: FND_DSQL.do_binds;
3629: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3630: dbms_sql.close_cursor(l_denorm_csr);
3631: END IF;

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

3625: FND_DSQL.set_cursor(l_denorm_csr);
3626: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3627: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3628: FND_DSQL.do_binds;
3629: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3630: dbms_sql.close_cursor(l_denorm_csr);
3631: END IF;
3632: END LOOP;
3633: END IF; -- l_dummy <> 'Y', product not denormed yet

Line 3630: dbms_sql.close_cursor(l_denorm_csr);

3626: l_stmt_denorm := FND_DSQL.get_text(FALSE);
3627: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
3628: FND_DSQL.do_binds;
3629: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3630: dbms_sql.close_cursor(l_denorm_csr);
3631: END IF;
3632: END LOOP;
3633: END IF; -- l_dummy <> 'Y', product not denormed yet
3634: END IF; -- product changed