APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on BIC_MEASURE_ATTRIBS

Line 377: x_disable_flag bic_measure_attribs.disable_flag % type;

373: -- prompt, user(mainly programmer) can set g_log_output to any not null value
374: -- in this way log output will be printed via dbms_output.put_line because
375: -- fnd_file.put_line does not work from SQL prompt.
376: function measure_disabled(p_measure_code varchar2) return varchar2 is
377: x_disable_flag bic_measure_attribs.disable_flag % type;
378: begin
379: select disable_flag into x_disable_flag
380: from bic_measure_attribs
381: where measure_code = p_measure_code;

Line 380: from bic_measure_attribs

376: function measure_disabled(p_measure_code varchar2) return varchar2 is
377: x_disable_flag bic_measure_attribs.disable_flag % type;
378: begin
379: select disable_flag into x_disable_flag
380: from bic_measure_attribs
381: where measure_code = p_measure_code;
382:
383: return(nvl(x_disable_flag,'N'));
384:

Line 1102: from bic_measure_attribs

1098: g_proc_name := 'Get_SQL_Sttmnt';
1099: debug('entered +');
1100: select sql_statement, operation_type, nvl(mult_factor,1)
1101: into p_sttmnt, p_operation_type, p_mult_factor
1102: from bic_measure_attribs
1103: where measure_code = p_measure_code
1104: and nvl(disable_flag,'N') <> 'Y';
1105: debug('exited +');
1106: g_proc_name := g_proc_name_old;

Line 1109: bic_summary_extract_pkg.write_log(' Measure Code:'|| p_measure_code || 'might be disabled or there is no entry in Bic_measure_attribs for');

1105: debug('exited +');
1106: g_proc_name := g_proc_name_old;
1107: exception
1108: when no_data_found then
1109: bic_summary_extract_pkg.write_log(' Measure Code:'|| p_measure_code || 'might be disabled or there is no entry in Bic_measure_attribs for');
1110: g_proc_name := g_proc_name_old;
1111: end;
1112: -- This procedure extracts data for SATISFACTION and/or LOYALTY measure codes
1113: procedure extract_proc(p_measure_code varchar2) is

Line 1117: x_mult_factor bic_measure_attribs.mult_factor % type;

1113: procedure extract_proc(p_measure_code varchar2) is
1114:
1115:
1116: x_measure_code bic_measures_all.measure_code % type;
1117: x_mult_factor bic_measure_attribs.mult_factor % type;
1118: x_operation_type bic_measure_attribs.operation_type % type;
1119: x_level number(5);
1120: x_sttmnt varchar2(2000);
1121:

Line 1118: x_operation_type bic_measure_attribs.operation_type % type;

1114:
1115:
1116: x_measure_code bic_measures_all.measure_code % type;
1117: x_mult_factor bic_measure_attribs.mult_factor % type;
1118: x_operation_type bic_measure_attribs.operation_type % type;
1119: x_level number(5);
1120: x_sttmnt varchar2(2000);
1121:
1122:

Line 2500: from bic_measure_attribs

2496: x_stmnt1 varchar2(2000);
2497: x_stmnt2 varchar2(2000);
2498: cursor c_sql_measures is
2499: select sql_statement, measure_code
2500: from bic_measure_attribs
2501: where sql_statement is not null
2502: and nvl(disable_flag,'N') = 'N'
2503: ;
2504:

Line 2512: x_msr_code bic_measure_attribs.measure_code % type;

2508: x_whr_pos number;
2509: x_from_pos number;
2510: x_extra_cond varchar2(60);
2511: x_err varchar2(251);
2512: x_msr_code bic_measure_attribs.measure_code % type;
2513: begin
2514: --x_start_date := to_date('01-jan-2000','dd-mm-yyyy');
2515: --x_end_date := to_date('31-jan-2000','dd-mm-yyyy');
2516: --delete from bic_debug where report_id like 'BIC%SUMM%';