APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_ACTIVITY_PRODUCTS_TEMP

Line 2741: DELETE FROM ozf_activity_products_temp

2737: DELETE FROM ozf_activity_customers_temp
2738: WHERE object_class = 'OFFR'
2739: and object_id = p_offer_id;
2740:
2741: DELETE FROM ozf_activity_products_temp
2742: WHERE object_class = 'OFFR'
2743: and object_id = p_offer_id;
2744: else
2745: DELETE FROM ozf_activity_customers

Line 2754: DELETE FROM ozf_activity_products_temp

2750:
2751: DELETE FROM ozf_activity_customers_temp
2752: WHERE object_class = 'OFFR';
2753:
2754: DELETE FROM ozf_activity_products_temp
2755: WHERE object_class = 'OFFR';
2756: end if;
2757:
2758: end if;

Line 2776: DELETE FROM ozf_activity_products_temp

2772: DELETE FROM ozf_activity_customers_temp
2773: WHERE object_class = 'OFFR'
2774: AND object_id = i.object_id ;
2775:
2776: DELETE FROM ozf_activity_products_temp
2777: WHERE object_class = 'OFFR'
2778: AND object_id = i.object_id ;
2779:
2780: DELETE FROM ozf_activity_customers

Line 2923: FND_DSQL.add_text('INSERT INTO ozf_activity_products_temp(');

2919: --=========================================================================================--
2920: product_denormed := 'N';
2921: FOR x IN c_list_lines(i.object_id) LOOP
2922: FND_DSQL.init;
2923: FND_DSQL.add_text('INSERT INTO ozf_activity_products_temp(');
2924: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
2925: FND_DSQL.add_text('last_update_login,confidential_flag,custom_setup_id,');
2926: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
2927: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,currency_code,marketing_medium_id,start_date,end_date,');

Line 3091: update ozf_activity_products_temp

3087: end if;
3088: end if;
3089:
3090: -- update offer forecast and offer values.
3091: update ozf_activity_products_temp
3092: set forecast_units = s_forecast_units,
3093: forecast_revenue = s_forecast_revenue,
3094: forecast_costs = s_forecast_costs,
3095: forecast_roi = s_forecast_roi,

Line 4032: FROM ozf_activity_products_temp;

4028: ACTUAL_UOM,
4029: LIST_PRICE,
4030: DISCOUNT,
4031: ITEMS_CATEGORY
4032: FROM ozf_activity_products_temp;
4033:
4034: END IF;
4035: --utl_file.fflush( a );
4036: --utl_file.fclose( a );

Line 4279: update ozf_activity_products_temp

4275: xy_actual_revenue := xy_actual_revenue + y_actual_revenue;
4276: xy_actual_costs := xy_actual_costs + y_actual_costs;
4277:
4278: -- update the actual values for the offer/product
4279: update ozf_activity_products_temp
4280: set actual_product_units = t_conv_actual_units,
4281: actual_product_revenue = l_actual_revenue,
4282: actual_product_costs = l_actual_costs,
4283: actual_product_roi = l_actual_roi,

Line 4470: update ozf_activity_products_temp

4466: xy_forecast_revenue := xy_forecast_revenue + y_forecast_revenue;
4467: xy_forecast_costs := xy_forecast_costs + y_forecast_costs;
4468:
4469: -- update the forecast values for the offer/product
4470: update ozf_activity_products_temp
4471: set forecast_product_units = t_forecast_units,
4472: forecast_product_revenue = l_forecast_revenue,
4473: forecast_product_costs = l_forecast_costs,
4474: forecast_product_roi = l_forecast_roi,