APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_ACTIVITY_PRODUCTS_TEMP

Line 2798: DELETE FROM ozf_activity_products_temp

2794: DELETE FROM ozf_activity_customers_temp
2795: WHERE object_class = 'OFFR'
2796: and object_id = p_offer_id;
2797:
2798: DELETE FROM ozf_activity_products_temp
2799: WHERE object_class = 'OFFR'
2800: and object_id = p_offer_id;
2801: else
2802: DELETE FROM ozf_activity_customers

Line 2811: DELETE FROM ozf_activity_products_temp

2807:
2808: DELETE FROM ozf_activity_customers_temp
2809: WHERE object_class = 'OFFR';
2810:
2811: DELETE FROM ozf_activity_products_temp
2812: WHERE object_class = 'OFFR';
2813: end if;
2814:
2815: end if;

Line 2833: DELETE FROM ozf_activity_products_temp

2829: DELETE FROM ozf_activity_customers_temp
2830: WHERE object_class = 'OFFR'
2831: AND object_id = i.object_id ;
2832:
2833: DELETE FROM ozf_activity_products_temp
2834: WHERE object_class = 'OFFR'
2835: AND object_id = i.object_id ;
2836:
2837: DELETE FROM ozf_activity_customers

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

2978: --=========================================================================================--
2979: product_denormed := 'N';
2980: FOR x IN c_list_lines(i.object_id) LOOP
2981: FND_DSQL.init;
2982: FND_DSQL.add_text('INSERT INTO ozf_activity_products_temp(');
2983: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,');
2984: FND_DSQL.add_text('last_update_login,confidential_flag,custom_setup_id,');
2985: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,parent_id,parent_class,');
2986: FND_DSQL.add_text('parent_desc,ask_for_flag,active_flag,source_code,currency_code,marketing_medium_id,start_date,end_date,');

Line 3151: update ozf_activity_products_temp

3147: end if;
3148: end if;
3149:
3150: -- update offer forecast and offer values.
3151: update ozf_activity_products_temp
3152: set forecast_units = s_forecast_units,
3153: forecast_revenue = s_forecast_revenue,
3154: forecast_costs = s_forecast_costs,
3155: forecast_roi = s_forecast_roi,

Line 4092: FROM ozf_activity_products_temp;

4088: ACTUAL_UOM,
4089: LIST_PRICE,
4090: DISCOUNT,
4091: ITEMS_CATEGORY
4092: FROM ozf_activity_products_temp;
4093:
4094: END IF;
4095: --utl_file.fflush( a );
4096: --utl_file.fclose( a );

Line 4342: update ozf_activity_products_temp

4338: xy_actual_revenue := xy_actual_revenue + y_actual_revenue;
4339: xy_actual_costs := xy_actual_costs + y_actual_costs;
4340:
4341: -- update the actual values for the offer/product
4342: update ozf_activity_products_temp
4343: set actual_product_units = t_conv_actual_units,
4344: actual_product_revenue = l_actual_revenue,
4345: actual_product_costs = l_actual_costs,
4346: actual_product_roi = l_actual_roi,

Line 4533: update ozf_activity_products_temp

4529: xy_forecast_revenue := xy_forecast_revenue + y_forecast_revenue;
4530: xy_forecast_costs := xy_forecast_costs + y_forecast_costs;
4531:
4532: -- update the forecast values for the offer/product
4533: update ozf_activity_products_temp
4534: set forecast_product_units = t_forecast_units,
4535: forecast_product_revenue = l_forecast_revenue,
4536: forecast_product_costs = l_forecast_costs,
4537: forecast_product_roi = l_forecast_roi,