APPS.OPI_DBI_CURR_PROD_DEL_RPT_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 47: opi_dbi_rpt_util_pkg.process_parameters (

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

Line 166: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

162: l_view_by_fact_col VARCHAR2(400);
163: BEGIN
164: l_description := 'null';
165: l_uom := 'null';
166: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
167: (p_view_by_dim);
168: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
169: (p_join_tbl);
170:

Line 168: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

164: l_description := 'null';
165: l_uom := 'null';
166: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
167: (p_view_by_dim);
168: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
169: (p_join_tbl);
170:
171: opi_dbi_rpt_util_pkg.get_viewby_item_columns (p_view_by_dim, l_description, l_uom);
172:

Line 171: opi_dbi_rpt_util_pkg.get_viewby_item_columns (p_view_by_dim, l_description, l_uom);

167: (p_view_by_dim);
168: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
169: (p_join_tbl);
170:
171: opi_dbi_rpt_util_pkg.get_viewby_item_columns (p_view_by_dim, l_description, l_uom);
172:
173:
174: l_sel_clause :=
175: 'SELECT

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

172:
173:
174: l_sel_clause :=
175: 'SELECT
176: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
177: l_description || ' OPI_ATTRIBUTE1,
178: ' || l_uom || ' OPI_ATTRIBUTE2';
179:
180: l_sel_clause := l_sel_clause ||

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

216:
217: l_sel_clause := l_sel_clause ||
218: 'FROM ( SELECT ' || fnd_global.newline ||
219: l_view_by_fact_col || fnd_global.newline ||
220: ',' || opi_dbi_rpt_util_pkg.nvl_str (
221: p_str => 'c_late_jobs_cnt',
222: p_default_val => 0) || ' OPI_MEASURE1, '|| fnd_global.newline;
223:
224: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN

Line 227: opi_dbi_rpt_util_pkg.nvl_str (

223:
224: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN
225: --{
226: l_sel_clause := l_sel_clause ||
227: opi_dbi_rpt_util_pkg.nvl_str (
228: p_str => 'c_late_jobs_qty',
229: p_default_val => 0) || ' OPI_MEASURE2, '|| fnd_global.newline;
230: --}
231: ELSE

Line 238: opi_dbi_rpt_util_pkg.nvl_str (

234: --}
235: END IF;
236:
237: l_sel_clause := l_sel_clause ||
238: opi_dbi_rpt_util_pkg.nvl_str (
239: p_str => 'c_late_jobs_val',
240: p_default_val => 0) || ' OPI_MEASURE3,
241: ' || opi_dbi_rpt_util_pkg.nvl_str (
242: p_str => 'c_open_jobs_cnt',

Line 241: ' || opi_dbi_rpt_util_pkg.nvl_str (

237: l_sel_clause := l_sel_clause ||
238: opi_dbi_rpt_util_pkg.nvl_str (
239: p_str => 'c_late_jobs_val',
240: p_default_val => 0) || ' OPI_MEASURE3,
241: ' || opi_dbi_rpt_util_pkg.nvl_str (
242: p_str => 'c_open_jobs_cnt',
243: p_default_val => 0) || ' OPI_MEASURE4,'|| fnd_global.newline;
244:
245: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN

Line 248: opi_dbi_rpt_util_pkg.nvl_str (

244:
245: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN
246: --{
247: l_sel_clause := l_sel_clause ||
248: opi_dbi_rpt_util_pkg.nvl_str (
249: p_str => 'c_open_jobs_qty',
250: p_default_val => 0) || ' OPI_MEASURE5,'|| fnd_global.newline;
251: --}
252: ELSE

Line 259: opi_dbi_rpt_util_pkg.nvl_str (

255: --}
256: END IF;
257:
258: l_sel_clause := l_sel_clause ||
259: opi_dbi_rpt_util_pkg.nvl_str (
260: p_str => 'c_open_jobs_val',
261: p_default_val => 0) || ' OPI_MEASURE6,
262: ' || opi_dbi_rpt_util_pkg.percent_str(
263: p_numerator => 'c_late_jobs_cnt',

Line 262: ' || opi_dbi_rpt_util_pkg.percent_str(

258: l_sel_clause := l_sel_clause ||
259: opi_dbi_rpt_util_pkg.nvl_str (
260: p_str => 'c_open_jobs_val',
261: p_default_val => 0) || ' OPI_MEASURE6,
262: ' || opi_dbi_rpt_util_pkg.percent_str(
263: p_numerator => 'c_late_jobs_cnt',
264: p_denominator => 'c_open_jobs_cnt',
265: p_measure_name => 'OPI_MEASURE7') || ',
266: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 266: ' || opi_dbi_rpt_util_pkg.percent_str(

262: ' || opi_dbi_rpt_util_pkg.percent_str(
263: p_numerator => 'c_late_jobs_cnt',
264: p_denominator => 'c_open_jobs_cnt',
265: p_measure_name => 'OPI_MEASURE7') || ',
266: ' || opi_dbi_rpt_util_pkg.percent_str(
267: p_numerator => 'c_late_jobs_val',
268: p_denominator => 'c_open_jobs_val',
269: p_measure_name => 'OPI_MEASURE8') || ',
270: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 270: ' || opi_dbi_rpt_util_pkg.nvl_str (

266: ' || opi_dbi_rpt_util_pkg.percent_str(
267: p_numerator => 'c_late_jobs_val',
268: p_denominator => 'c_open_jobs_val',
269: p_measure_name => 'OPI_MEASURE8') || ',
270: ' || opi_dbi_rpt_util_pkg.nvl_str (
271: p_str => 'c_late_jobs_cnt_total',
272: p_default_val => 0) || ' OPI_MEASURE11,
273: ' || opi_dbi_rpt_util_pkg.nvl_str (
274: p_str => 'c_late_jobs_val_total',

Line 273: ' || opi_dbi_rpt_util_pkg.nvl_str (

269: p_measure_name => 'OPI_MEASURE8') || ',
270: ' || opi_dbi_rpt_util_pkg.nvl_str (
271: p_str => 'c_late_jobs_cnt_total',
272: p_default_val => 0) || ' OPI_MEASURE11,
273: ' || opi_dbi_rpt_util_pkg.nvl_str (
274: p_str => 'c_late_jobs_val_total',
275: p_default_val => 0) || ' OPI_MEASURE12,
276: ' || opi_dbi_rpt_util_pkg.nvl_str (
277: p_str => 'c_open_jobs_cnt_total',

Line 276: ' || opi_dbi_rpt_util_pkg.nvl_str (

272: p_default_val => 0) || ' OPI_MEASURE11,
273: ' || opi_dbi_rpt_util_pkg.nvl_str (
274: p_str => 'c_late_jobs_val_total',
275: p_default_val => 0) || ' OPI_MEASURE12,
276: ' || opi_dbi_rpt_util_pkg.nvl_str (
277: p_str => 'c_open_jobs_cnt_total',
278: p_default_val => 0) || ' OPI_MEASURE13,
279: ' || opi_dbi_rpt_util_pkg.nvl_str (
280: p_str => 'c_open_jobs_val_total',

Line 279: ' || opi_dbi_rpt_util_pkg.nvl_str (

275: p_default_val => 0) || ' OPI_MEASURE12,
276: ' || opi_dbi_rpt_util_pkg.nvl_str (
277: p_str => 'c_open_jobs_cnt_total',
278: p_default_val => 0) || ' OPI_MEASURE13,
279: ' || opi_dbi_rpt_util_pkg.nvl_str (
280: p_str => 'c_open_jobs_val_total',
281: p_default_val => 0) || ' OPI_MEASURE14,
282: ' || opi_dbi_rpt_util_pkg.percent_str(
283: p_numerator => 'c_late_jobs_cnt_total',

Line 282: ' || opi_dbi_rpt_util_pkg.percent_str(

278: p_default_val => 0) || ' OPI_MEASURE13,
279: ' || opi_dbi_rpt_util_pkg.nvl_str (
280: p_str => 'c_open_jobs_val_total',
281: p_default_val => 0) || ' OPI_MEASURE14,
282: ' || opi_dbi_rpt_util_pkg.percent_str(
283: p_numerator => 'c_late_jobs_cnt_total',
284: p_denominator => 'c_open_jobs_cnt_total',
285: p_measure_name => 'OPI_MEASURE15') || ',
286: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 286: ' || opi_dbi_rpt_util_pkg.percent_str(

282: ' || opi_dbi_rpt_util_pkg.percent_str(
283: p_numerator => 'c_late_jobs_cnt_total',
284: p_denominator => 'c_open_jobs_cnt_total',
285: p_measure_name => 'OPI_MEASURE15') || ',
286: ' || opi_dbi_rpt_util_pkg.percent_str(
287: p_numerator => 'c_late_jobs_val_total',
288: p_denominator => 'c_open_jobs_val_total',
289: p_measure_name => 'OPI_MEASURE16') ;
290: