APPS.BIM_CMP_PKG dependencies on BIM_CAMP_ACQU_SUMM_TEMP

Line 31: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, subject_name, view_by_name)';

27:
28: begin
29: l_jtf_bis_util := 'jtf_bis_util.profileValue(''CRMBIS:PERIOD_SET_NAME'')';
30:
31: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, subject_name, view_by_name)';
32:
33: l_sql_insert_stm := l_sql_insert_stm
34: || ' SELECT ' ;
35:

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

175: l_subject_name varchar2(2000);
176:
177: begin
178:
179: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, measure3, measure4, subject_name, view_by_name)';
180:
181: l_sql_insert_stm := l_sql_insert_stm
182: || ' SELECT ' ;
183:

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

292: l_subject_name varchar2(2000);
293:
294: begin
295:
296: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, measure3, measure4, subject_name, view_by_name)';
297:
298: l_sql_insert_stm := l_sql_insert_stm
299: || ' SELECT ' ;
300:

Line 420: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, subject_name, view_by_name)';

416: BEGIN
417:
418: /***************/
419:
420: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, subject_name, view_by_name)';
421:
422: l_sql_insert_stm := l_sql_insert_stm
423: || ' SELECT ' ;
424:

Line 674: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, subject_name, view_by_name)';

670: BEGIN
671:
672: /***************/
673:
674: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, subject_name, view_by_name)';
675:
676: l_sql_insert_stm := l_sql_insert_stm
677: || ' SELECT ' ;
678:

Line 836: delete bim_camp_acqu_summ_temp;

832: end;
833: */
834:
835: /******************/
836: delete bim_camp_acqu_summ_temp;
837:
838: -- dbms_output.put_line('COMPLETED THE SQL STATEMENT ');
839:
840: IF (p_view_by = 'PER') THEN

Line 916: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, subject_name, view_by_name)';

912: begin
913:
914: l_jtf_bis_util := 'jtf_bis_util.profileValue(''CRMBIS:PERIOD_SET_NAME'')';
915:
916: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, subject_name, view_by_name)';
917:
918: l_sql_insert_stm := l_sql_insert_stm
919: || ' SELECT ' ;
920: l_sql_insert_stm := l_sql_insert_stm || ' Sum(nvl(BSCR.num_responded,0)),';

Line 1114: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, measure3, subject_name )';

1110: l_view_by varchar2(2000);
1111: l_subject_name varchar2(2000);
1112:
1113: begin
1114: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, measure3, subject_name )';
1115:
1116: l_sql_insert_stm := l_sql_insert_stm
1117: || ' SELECT ' ;
1118:

Line 1185: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, measure3, subject_name )';

1181: l_view_by varchar2(2000);
1182: l_subject_name varchar2(2000);
1183:
1184: begin
1185: l_sql_insert_stm := 'INSERT INTO bim_camp_acqu_summ_temp (measure1, measure2, measure3, subject_name )';
1186:
1187: l_sql_insert_stm := l_sql_insert_stm
1188: || ' SELECT ' ;
1189: