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_CHECK_DUP_PROD_PVT dependencies on OZF_VO_PRODUCTS_TEMP

Line 114: -- Refreshes volume offer product denorm table ozf_vo_products_temp.

110: -- PROCEDURE
111: -- denorm_vo_products
112: --
113: -- PURPOSE
114: -- Refreshes volume offer product denorm table ozf_vo_products_temp.
115: --
116: -- PARAMETERS
117: -- p_offer_id: identifier of the offer.
118: --

Line 203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');

199: FOR l_pbh_line IN c_pbh_lines LOOP
200: FOR l_product IN c_products(l_pbh_line.offer_discount_line_id, 'N') LOOP
201: l_stmt_temp := NULL;
202: FND_DSQL.init;
203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

Line 207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

203: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
204: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
205: FND_DSQL.add_text('last_updated_by,last_update_login,');
206: FND_DSQL.add_text('product_id,product_type) ');
207: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
208: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
209: FND_DSQL.add_text('product_id,product_type');
210: FND_DSQL.add_text(' FROM (');
211:

Line 316: FROM ozf_vo_products_temp

312: CURSOR c_duplicate_prod_exists IS
313: SELECT 'Y' FROM DUAL
314: WHERE EXISTS(
315: SELECT 1
316: FROM ozf_vo_products_temp
317: HAVING COUNT(product_id) > 1
318: GROUP BY product_id
319: );
320: BEGIN

Line 321: DELETE FROM ozf_vo_products_temp;

317: HAVING COUNT(product_id) > 1
318: GROUP BY product_id
319: );
320: BEGIN
321: DELETE FROM ozf_vo_products_temp;
322:
323: SAVEPOINT check_dup_prod;
324:
325: x_return_status := Fnd_Api.g_ret_sts_success;

Line 341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');

337: RAISE FND_API.g_exc_unexpected_error;
338: END IF;
339: /*
340: FND_DSQL.init;
341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

Line 345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');

341: FND_DSQL.add_text('INSERT INTO ozf_vo_products_temp(');
342: FND_DSQL.add_text('vo_products_temp_id,creation_date,created_by,last_update_date,');
343: FND_DSQL.add_text('last_updated_by,last_update_login,');
344: FND_DSQL.add_text('product_id,product_type) ');
345: FND_DSQL.add_text('SELECT ozf_vo_products_temp_s.NEXTVAL,SYSDATE,FND_GLOBAL.user_id,SYSDATE,');
346: FND_DSQL.add_text('FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id,');
347: FND_DSQL.add_text('product_id,product_type');
348: FND_DSQL.add_text(' FROM (');
349: */