APPS.BIM_CMPACQ_IND_TEMP_PVT dependencies on BIM_CAMP_ACQU_SUMM_TEMP

Line 64: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp

60: from_clause := from_clause || ',bim_dimv_market_sgmts mkt' ;
61: where_clause := where_clause || ' and cperf.market_segment_id = mkt.market_segment_id';
62: END IF;
63:
64: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp
65: ( subject_name,
66: view_by_name,
67: rank_by,
68: measure1,

Line 116: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp

112: v_num_rows_inserted := SQL%ROWCOUNT;
113: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
114:
115:
116: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp
117: set tmp.measure4 =
118: ( select nvl(sum(cperf.initiated_revenue),0)
119: from bim_customer_rev_summ cperf,
120: bim_campaigns_denorm dnm,

Line 166: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;

162: -- measure4 => New Customer Revenue
163: -- measure3 => Total Revenue
164: -- measure2 => % of sales from new customer
165:
166: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;
167:
168: v_num_rows_updated := SQL%ROWCOUNT;
169: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );
170:

Line 213: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp

209: where_clause := where_clause || ' and cmp.campaign_id = :p_campaign_id ' ;
210: END IF;
211:
212:
213: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp
214: ( subject_name,
215: view_by_name,
216: rank_by,
217: measure1,

Line 271: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp

267: v_num_rows_inserted := SQL%ROWCOUNT;
268: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
269:
270:
271: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp
272: set tmp.measure4 =
273: ( select nvl(sum(cperf.initiated_revenue),0)
274: from bim_customer_rev_summ cperf,
275: bim_campaigns_denorm dnm,

Line 325: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;

321: -- measure4 => New Customer Revenue
322: -- measure3 => Total Revenue
323: -- measure2 => % of sales from new customer
324:
325: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;
326:
327: v_num_rows_updated := SQL%ROWCOUNT;
328: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );
329: