APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_ACTIVITY_CUSTOMERS_TEMP

Line 2737: DELETE FROM ozf_activity_customers_temp

2733: DELETE FROM ozf_activity_products
2734: WHERE object_class = 'OFFR'
2735: and object_id = p_offer_id;
2736:
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

Line 2751: DELETE FROM ozf_activity_customers_temp

2747:
2748: DELETE FROM ozf_activity_products
2749: WHERE object_class = 'OFFR';
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';

Line 2772: DELETE FROM ozf_activity_customers_temp

2768: -- denorm parties
2769:
2770: ozf_utility_pvt.write_conc_log('-- Deleting Temp and Denorm Tables --');
2771: /*
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

Line 2803: FND_DSQL.add_text('INSERT INTO ozf_activity_customers_temp(');

2799: if z.qnum = -99 AND l_group_count > 0 then
2800: goto GROUP_END1;
2801: end if;
2802: FND_DSQL.init;
2803: FND_DSQL.add_text('INSERT INTO ozf_activity_customers_temp(');
2804: FND_DSQL.add_text('creation_date,created_by,last_update_date,last_updated_by,last_update_login,');
2805: FND_DSQL.add_text('confidential_flag,custom_setup_id,');
2806: FND_DSQL.add_text('object_id,object_type,object_status,object_class,object_desc,');
2807: FND_DSQL.add_text('parent_id,parent_class,parent_desc,');

Line 3106: update ozf_activity_customers_temp

3102: where object_id = i.object_id
3103: and object_class = 'OFFR';
3104:
3105: -- update offer forecast and offer values.
3106: update ozf_activity_customers_temp
3107: set forecast_units = s_forecast_units,
3108: forecast_revenue = s_forecast_revenue,
3109: forecast_costs = s_forecast_costs,
3110: forecast_roi = s_forecast_roi,

Line 3937: FROM ozf_activity_customers_temp;

3933: CONFIDENTIAL_FLAG,
3934: CUSTOM_SETUP_ID,
3935: QP_QUALIFIER_ID,
3936: QP_QUALIFIER_GROUP
3937: FROM ozf_activity_customers_temp;
3938:
3939: ozf_utility_pvt.write_conc_log('-- Populating ozf_activity_products -- ');
3940:
3941: INSERT INTO ozf_activity_products