[Home] [Help]
2790: DELETE FROM ozf_activity_products
2791: WHERE object_class = 'OFFR'
2792: and object_id = p_offer_id;
2793:
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
2804:
2805: DELETE FROM ozf_activity_products
2806: WHERE object_class = 'OFFR';
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';
2825: -- denorm parties
2826:
2827: ozf_utility_pvt.write_conc_log('-- Deleting Temp and Denorm Tables --');
2828: /*
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
2856: if z.qnum = -99 AND l_group_count > 0 then
2857: goto GROUP_END1;
2858: end if;
2859: FND_DSQL.init;
2860: FND_DSQL.add_text('INSERT INTO ozf_activity_customers_temp(');
2861: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,last_update_login,');
2862: FND_DSQL.add_text('confidential_flag,custom_setup_id,');
2863: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,');
2864: FND_DSQL.add_text('parent_id,parent_class,parent_desc,');
3162: where object_id = i.object_id
3163: and object_class = 'OFFR';
3164:
3165: -- update offer forecast and offer values.
3166: update ozf_activity_customers_temp
3167: set forecast_units = s_forecast_units,
3168: forecast_revenue = s_forecast_revenue,
3169: forecast_costs = s_forecast_costs,
3170: forecast_roi = s_forecast_roi,
3993: CONFIDENTIAL_FLAG,
3994: CUSTOM_SETUP_ID,
3995: QP_QUALIFIER_ID,
3996: QP_QUALIFIER_GROUP
3997: FROM ozf_activity_customers_temp;
3998:
3999: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_products -- ');
4000:
4001: INSERT INTO ozf_activity_products