APPS.OPI_DBI_SCRAP_REASON_RPT_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 48: opi_dbi_rpt_util_pkg.process_parameters (

44: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
45: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
46:
47: -- get all the query parameters
48: opi_dbi_rpt_util_pkg.process_parameters (
49: p_param => p_param,
50: p_view_by => l_view_by,
51: p_view_by_col_name => l_view_by_col,
52: p_comparison_type => l_comparison_type,

Line 123: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

119: l_sel_clause VARCHAR2(15000);
120: l_view_by_col_name VARCHAR2(120);
121: l_view_by_fact_col VARCHAR2(400);
122: BEGIN
123: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
124: (p_view_by_dim);
125: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
126: (p_join_tbl);
127: l_sel_clause :=

Line 125: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

121: l_view_by_fact_col VARCHAR2(400);
122: BEGIN
123: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
124: (p_view_by_dim);
125: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
126: (p_join_tbl);
127: l_sel_clause :=
128: 'SELECT
129: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline;

Line 129: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline;

125: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
126: (p_join_tbl);
127: l_sel_clause :=
128: 'SELECT
129: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline;
130:
131: l_sel_clause := l_sel_clause ||
132: ' OPI_MEASURE1
133: ,OPI_MEASURE2

Line 157: ',' || opi_dbi_rpt_util_pkg.nvl_str (

153:
154: l_sel_clause := l_sel_clause ||
155: 'FROM ( SELECT ' || fnd_global.newline ||
156: l_view_by_fact_col || fnd_global.newline ||
157: ',' || opi_dbi_rpt_util_pkg.nvl_str (
158: p_str => 'p_scrap_val',
159: p_default_val => 0) || ' OPI_MEASURE1,
160: ' || opi_dbi_rpt_util_pkg.nvl_str (
161: p_str => 'c_scrap_val',

Line 160: ' || opi_dbi_rpt_util_pkg.nvl_str (

156: l_view_by_fact_col || fnd_global.newline ||
157: ',' || opi_dbi_rpt_util_pkg.nvl_str (
158: p_str => 'p_scrap_val',
159: p_default_val => 0) || ' OPI_MEASURE1,
160: ' || opi_dbi_rpt_util_pkg.nvl_str (
161: p_str => 'c_scrap_val',
162: p_default_val => 0) || ' OPI_MEASURE2,
163: ' || opi_dbi_rpt_util_pkg.change_str (
164: p_new_numerator => 'c_scrap_val',

Line 163: ' || opi_dbi_rpt_util_pkg.change_str (

159: p_default_val => 0) || ' OPI_MEASURE1,
160: ' || opi_dbi_rpt_util_pkg.nvl_str (
161: p_str => 'c_scrap_val',
162: p_default_val => 0) || ' OPI_MEASURE2,
163: ' || opi_dbi_rpt_util_pkg.change_str (
164: p_new_numerator => 'c_scrap_val',
165: p_old_numerator => 'p_scrap_val',
166: p_denominator => 'p_scrap_val',
167: p_measure_name => 'OPI_MEASURE3')|| ',

Line 168: ' || opi_dbi_rpt_util_pkg.percent_str(

164: p_new_numerator => 'c_scrap_val',
165: p_old_numerator => 'p_scrap_val',
166: p_denominator => 'p_scrap_val',
167: p_measure_name => 'OPI_MEASURE3')|| ',
168: ' || opi_dbi_rpt_util_pkg.percent_str(
169: p_numerator => 'c_scrap_val',
170: p_denominator => 'c_scrap_val_total',
171: p_measure_name => 'OPI_MEASURE4')|| ',
172: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 172: ' || opi_dbi_rpt_util_pkg.nvl_str (

168: ' || opi_dbi_rpt_util_pkg.percent_str(
169: p_numerator => 'c_scrap_val',
170: p_denominator => 'c_scrap_val_total',
171: p_measure_name => 'OPI_MEASURE4')|| ',
172: ' || opi_dbi_rpt_util_pkg.nvl_str (
173: p_str => 'c_scrap_val_total',
174: p_default_val => 0) || ' OPI_MEASURE5,
175: ' || opi_dbi_rpt_util_pkg.change_str (
176: p_new_numerator => 'c_scrap_val_total',

Line 175: ' || opi_dbi_rpt_util_pkg.change_str (

171: p_measure_name => 'OPI_MEASURE4')|| ',
172: ' || opi_dbi_rpt_util_pkg.nvl_str (
173: p_str => 'c_scrap_val_total',
174: p_default_val => 0) || ' OPI_MEASURE5,
175: ' || opi_dbi_rpt_util_pkg.change_str (
176: p_new_numerator => 'c_scrap_val_total',
177: p_old_numerator => 'p_scrap_val_total',
178: p_denominator => 'p_scrap_val_total',
179: p_measure_name => 'OPI_MEASURE6')|| ',

Line 180: ' || opi_dbi_rpt_util_pkg.percent_str(

176: p_new_numerator => 'c_scrap_val_total',
177: p_old_numerator => 'p_scrap_val_total',
178: p_denominator => 'p_scrap_val_total',
179: p_measure_name => 'OPI_MEASURE6')|| ',
180: ' || opi_dbi_rpt_util_pkg.percent_str(
181: p_numerator => 'c_scrap_val_total',
182: p_denominator => 'c_scrap_val_total',
183: p_measure_name => 'OPI_MEASURE7');
184: