APPS.BIM_SLCHN_CMPR_TEMP_PVT dependencies on BIM_CAMP_ACQU_SUMM_TEMP

Line 62: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp

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

Line 115: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp

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

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

157: p_geography_code;
158:
159: -- changed on 8/14 to fix bug: 1361701
160:
161: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure2*100/measure3;
162:
163: UPDATE bim_camp_acqu_summ_temp SET measure3 = measure3/measure1;
164:
165:

Line 163: UPDATE bim_camp_acqu_summ_temp SET measure3 = measure3/measure1;

159: -- changed on 8/14 to fix bug: 1361701
160:
161: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure2*100/measure3;
162:
163: UPDATE bim_camp_acqu_summ_temp SET measure3 = measure3/measure1;
164:
165:
166: v_num_rows_updated := SQL%ROWCOUNT;
167: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );

Line 210: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp

206: where_clause := where_clause || ' and cperf.campaign_id = cmp.campaign_id ' ||
207: ' and cmp.campaign_id = nvl(:p_campaign_id, cmp.campaign_id ) ';
208: END IF;
209:
210: EXECUTE IMMEDIATE ' INSERT INTO bim_camp_acqu_summ_temp
211: ( subject_name,
212: view_by_name,
213: rank_by,
214: measure1,

Line 269: EXECUTE IMMEDIATE 'UPDATE bim_camp_acqu_summ_temp tmp

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