eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_ACQ_PKG dependencies on BIM_CAMP_ACQU_SUMM_TEMP

Line 44: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

40: l_sql_upd_stmt varchar2(5000);
41:
42: BEGIN
43:
44: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';
45:
46: l_sql_insert_stm := l_sql_insert_stm
47: || ' SELECT ' ;
48:

Line 278: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp

274: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
275:
276: /************************************************************************************************************/
277:
278: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp
279: set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0)
280: from bim_customer_rev_summ a, bim_campaigns_denorm b, bim_dimv_campaigns d ' ;
281:
282: l_sql_where := l_sql_where || ' and a.first_order_date >= :p_start_date and a.first_order_date <= :p_end_date ';

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

365: END IF;
366:
367: /******************/
368:
369: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;
370:
371: v_num_rows_updated := SQL%ROWCOUNT;
372: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );
373:

Line 419: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

415: l_sql_upd_stmt varchar2(5000);
416:
417: BEGIN
418:
419: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';
420:
421: l_sql_insert_stm := l_sql_insert_stm
422: || ' SELECT ' ;
423:

Line 639: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a, bim_campaigns_denorm b ' ;

635: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
636:
637: /************************************************************************************************************/
638:
639: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a, bim_campaigns_denorm b ' ;
640:
641: l_sql_where := l_sql_where || ' and a.first_order_date >= :p_start_date and a.first_order_date <= :p_end_date ';
642:
643: l_sql_where := l_sql_where || ' and tmp.view_by_name = ' || v_view_by || ' ) ' ;

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

718: END IF;
719:
720: /******************/
721:
722: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;
723:
724:
725: v_num_rows_updated := SQL%ROWCOUNT;
726: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );

Line 773: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

769: l_sql_upd_stmt varchar2(5000);
770:
771: BEGIN
772:
773: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';
774:
775: l_sql_insert_stm := l_sql_insert_stm
776: || ' SELECT ' ;
777:

Line 984: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a ' ;

980: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
981:
982: /*****************************************************************************************/
983:
984: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a ' ;
985:
986: l_sql_where := l_sql_where || ' and a.first_order_date >= :p_start_date and a.first_order_date <= :p_end_date ';
987:
988: l_sql_where := l_sql_where || 'and tmp.view_by_name = ' || v_view_by || ' ) ' ;

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

1061: p_end_date;
1062: END IF;
1063:
1064: /******************/
1065: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;
1066:
1067: v_num_rows_updated := SQL%ROWCOUNT;
1068: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );
1069:

Line 1115: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

1111:
1112: BEGIN
1113:
1114:
1115: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';
1116:
1117: l_sql_insert_stm := l_sql_insert_stm
1118: || ' SELECT ' ;
1119:

Line 1335: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a, bim_dimv_media med ' ;

1331: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
1332:
1333: /************************************************************************************************************/
1334:
1335: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a, bim_dimv_media med ' ;
1336:
1337: l_sql_where := l_sql_where || ' and a.first_order_date >= :p_start_date and a.first_order_date <= :p_end_date ';
1338:
1339: l_sql_where := l_sql_where || ' and tmp.subject_name = med.media_name and tmp.view_by_name = ' || v_view_by || ' ) ' ;

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

1420:
1421:
1422: /******************/
1423:
1424: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;
1425:
1426: v_num_rows_updated := SQL%ROWCOUNT;
1427: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );
1428:

Line 1477: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

1473: l_sql_upd_stmt varchar2(5000);
1474:
1475: BEGIN
1476:
1477: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';
1478:
1479: l_sql_insert_stm := l_sql_insert_stm
1480: || ' SELECT ' ;
1481:

Line 1687: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a ' ;

1683: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
1684:
1685: /************************************************************************************************************/
1686:
1687: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a ' ;
1688:
1689: l_sql_where := l_sql_where || ' and a.first_order_date >= :p_start_date and a.first_order_date <= :p_end_date ';
1690:
1691: l_sql_where := l_sql_where || ' and tmp.view_by_name = ' || v_view_by || ' ) ' ;

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

1763: p_end_date;
1764: END IF;
1765:
1766: /******************/
1767: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;
1768:
1769: v_num_rows_updated := SQL%ROWCOUNT;
1770: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );
1771:

Line 1817: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';

1813:
1814: BEGIN
1815:
1816:
1817: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure3, subject_name, view_by_name)';
1818:
1819: l_sql_insert_stm := l_sql_insert_stm
1820: || ' SELECT ' ;
1821:

Line 2037: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a, bim_dimv_channels chn ' ;

2033: -- dbms_output.put_line ( 'Number of rows inserted in temp table is : ' || v_num_rows_inserted );
2034:
2035: /************************************************************************************************************/
2036:
2037: l_sql_update_stm := 'UPDATE bim_camp_acqu_summ_temp tmp set tmp.measure4 = (select nvl(sum(a.initiated_revenue),0) from bim_customer_rev_summ a, bim_dimv_channels chn ' ;
2038:
2039: l_sql_where := l_sql_where || ' and a.first_order_date >= :p_start_date and a.first_order_date <= :p_end_date ';
2040:
2041: l_sql_where := l_sql_where || ' and tmp.subject_name = chn.channel_name and tmp.view_by_name = ' || v_view_by || ' ) ' ;

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

2121: /******************/
2122:
2123:
2124:
2125: UPDATE bim_camp_acqu_summ_temp SET measure2 = measure4*100/measure3;
2126:
2127: v_num_rows_updated := SQL%ROWCOUNT;
2128: -- dbms_output.put_line ( 'Number of rows updated in temp table is : ' || v_num_rows_updated );
2129: