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.ISC_DEPOT_COMPLETION_PKG dependencies on POA_DBI_UTIL_PKG

Line 25: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

21: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
22: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
23: l_comparison_type VARCHAR2(1);
24: l_cur_suffix VARCHAR2(2);
25: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
26: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
27: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
28: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
29: l_mv_set VARCHAR2(50);

Line 26: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

22: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
23: l_comparison_type VARCHAR2(1);
24: l_cur_suffix VARCHAR2(2);
25: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
26: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
27: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
28: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
29: l_mv_set VARCHAR2(50);
30: l_aggregation_flag NUMBER;

Line 43: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

39: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
40: l_comparison_type := 'Y';
41:
42: -- clear out the tables.
43: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
44: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
45:
46: -- get all the query parameters
47: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,

Line 44: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

40: l_comparison_type := 'Y';
41:
42: -- clear out the tables.
43: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
44: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
45:
46: -- get all the query parameters
47: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
48: x_view_by => l_view_by,

Line 68: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

64: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
65: END IF;
66:
67: -- Add measure columns that need to be aggregated
68: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
69: p_col_name => 'close_count' ,
70: p_alias_name => 'completed_count',
71: p_grand_total => 'Y',
72: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 72: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

68: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
69: p_col_name => 'close_count' ,
70: p_alias_name => 'completed_count',
71: p_grand_total => 'Y',
72: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
73: p_to_date_type => 'XTD');
74:
75: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
76: p_col_name => 'COMPLETE_WITH_PROMISE_DATE_CNT' ,

Line 75: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

71: p_grand_total => 'Y',
72: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
73: p_to_date_type => 'XTD');
74:
75: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
76: p_col_name => 'COMPLETE_WITH_PROMISE_DATE_CNT' ,
77: p_alias_name => 'cmplt_with_prom_dt',
78: p_grand_total => 'Y',
79: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

Line 79: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

75: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
76: p_col_name => 'COMPLETE_WITH_PROMISE_DATE_CNT' ,
77: p_alias_name => 'cmplt_with_prom_dt',
78: p_grand_total => 'Y',
79: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
80: p_to_date_type => 'XTD');
81:
82: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
83: p_col_name => 'late_complete_count' ,

Line 82: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

78: p_grand_total => 'Y',
79: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
80: p_to_date_type => 'XTD');
81:
82: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
83: p_col_name => 'late_complete_count' ,
84: p_alias_name => 'late_complete_count',
85: p_grand_total => 'Y',
86: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 86: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

82: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
83: p_col_name => 'late_complete_count' ,
84: p_alias_name => 'late_complete_count',
85: p_grand_total => 'Y',
86: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
87: p_to_date_type => 'XTD');
88:
89: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
90: p_col_name => 'days_late' ,

Line 89: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

85: p_grand_total => 'Y',
86: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
87: p_to_date_type => 'XTD');
88:
89: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
90: p_col_name => 'days_late' ,
91: p_alias_name => 'days_late',
92: p_grand_total => 'Y',
93: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 93: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

89: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
90: p_col_name => 'days_late' ,
91: p_alias_name => 'days_late',
92: p_grand_total => 'Y',
93: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
94: p_to_date_type => 'XTD');
95:
96:
97:

Line 122: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

118: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
119: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
120:
121: -- set the basic bind variables for the status SQL
122: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
123:
124: -- Passing AGGREGATION_LEVEL_FLAG to PMV
125: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
126: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 238: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'

234: ' FROM ( SELECT ' || fnd_global.newline ||
235: p_view_by_col || fnd_global.newline ||
236: ',' || 'NVL(c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
237: ',' || 'NVL(p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
238: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
239: ,prior_col => 'p_completed_count'
240: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
241: || ' BIV_MEASURE2' || fnd_global.newline ||
242: ',' || 'NVL(c_cmplt_with_prom_dt,0) BIV_MEASURE3 ' || fnd_global.newline ||

Line 244: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'

240: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
241: || ' BIV_MEASURE2' || fnd_global.newline ||
242: ',' || 'NVL(c_cmplt_with_prom_dt,0) BIV_MEASURE3 ' || fnd_global.newline ||
243: ',' || 'NVL(c_late_complete_count,0) BIV_MEASURE4 ' || fnd_global.newline ||
244: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
245: ,denominator => 'c_completed_count'
246: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
247: || 'BIV_MEASURE5' || fnd_global.newline ||
248: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'

Line 248: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'

244: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
245: ,denominator => 'c_completed_count'
246: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
247: || 'BIV_MEASURE5' || fnd_global.newline ||
248: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
249: ,denominator => 'p_completed_count'
250: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
251: || ' BIV_MEASURE12' || fnd_global.newline ||
252: ',' || OPI_DBI_RPT_UTIL_PKG.change_pct_str(p_new_numerator => 'c_late_complete_count',

Line 258: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'

254: p_old_numerator => 'p_late_complete_count',
255: p_old_denominator => 'p_completed_count',
256: p_measure_name => 'BIV_MEASURE6')
257: || fnd_global.newline ||
258: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
259: ,denominator => 'c_late_complete_count'
260: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
261: || ' BIV_MEASURE7' || fnd_global.newline ||
262: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'

Line 262: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'

258: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
259: ,denominator => 'c_late_complete_count'
260: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
261: || ' BIV_MEASURE7' || fnd_global.newline ||
262: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
263: ,denominator => 'p_late_complete_count'
264: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
265: || ' BIV_MEASURE13' || fnd_global.newline ||
266: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'

Line 266: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'

262: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
263: ,denominator => 'p_late_complete_count'
264: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
265: || ' BIV_MEASURE13' || fnd_global.newline ||
266: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
267: ,denominator => 'c_late_complete_count'
268: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
269: || ' - '
270: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'

Line 270: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'

266: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
267: ,denominator => 'c_late_complete_count'
268: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
269: || ' - '
270: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
271: ,denominator => 'p_late_complete_count'
272: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
273: || ' BIV_MEASURE8' || fnd_global.newline ||
274: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||

Line 275: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count_total'

271: ,denominator => 'p_late_complete_count'
272: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
273: || ' BIV_MEASURE8' || fnd_global.newline ||
274: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
275: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count_total'
276: ,prior_col => 'p_completed_count_total'
277: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
278: || 'BIV_MEASURE22' || fnd_global.newline ||
279: ',' || 'NVL(c_cmplt_with_prom_dt_total,0) BIV_MEASURE23 ' || fnd_global.newline ||

Line 281: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'

277: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
278: || 'BIV_MEASURE22' || fnd_global.newline ||
279: ',' || 'NVL(c_cmplt_with_prom_dt_total,0) BIV_MEASURE23 ' || fnd_global.newline ||
280: ',' || 'NVL(c_late_complete_count_total,0) BIV_MEASURE24 ' || fnd_global.newline ||
281: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'
282: ,denominator => 'c_completed_count_total'
283: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
284: || 'BIV_MEASURE25' || fnd_global.newline ||
285: ',' || OPI_DBI_RPT_UTIL_PKG.change_pct_str(p_new_numerator => 'c_late_complete_count_total',

Line 291: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'

287: p_old_numerator => 'p_late_complete_count_total',
288: p_old_denominator => 'p_completed_count_total',
289: p_measure_name => 'BIV_MEASURE26')
290: || fnd_global.newline ||
291: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'
292: ,denominator => 'c_late_complete_count_total'
293: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
294: || ' BIV_MEASURE27' || fnd_global.newline ||
295: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'

Line 295: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'

291: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'
292: ,denominator => 'c_late_complete_count_total'
293: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
294: || ' BIV_MEASURE27' || fnd_global.newline ||
295: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'
296: ,denominator => 'c_late_complete_count_total'
297: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
298: || ' - '
299: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late_total'

Line 299: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late_total'

295: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'
296: ,denominator => 'c_late_complete_count_total'
297: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
298: || ' - '
299: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late_total'
300: ,denominator => 'p_late_complete_count_total'
301: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
302: || ' BIV_MEASURE28' || fnd_global.newline ||
303: ',' || 'NVL(c_completed_count,0) BIV_MEASURE29 ' || fnd_global.newline ||

Line 307: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'

303: ',' || 'NVL(c_completed_count,0) BIV_MEASURE29 ' || fnd_global.newline ||
304: ',' || 'NVL(p_completed_count,0) BIV_MEASURE30 ' || fnd_global.newline ||
305: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE31 ' || fnd_global.newline ||
306: ',' || 'NVL(p_completed_count_total,0) BIV_MEASURE32 ' || fnd_global.newline ||
307: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
308: ,denominator => 'c_completed_count'
309: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
310: || 'BIV_MEASURE33' || fnd_global.newline ||
311: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'

Line 311: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'

307: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
308: ,denominator => 'c_completed_count'
309: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
310: || 'BIV_MEASURE33' || fnd_global.newline ||
311: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
312: ,denominator => 'p_completed_count'
313: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
314: || 'BIV_MEASURE34' || fnd_global.newline ||
315: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'

Line 315: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'

311: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
312: ,denominator => 'p_completed_count'
313: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
314: || 'BIV_MEASURE34' || fnd_global.newline ||
315: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'
316: ,denominator => 'c_completed_count_total'
317: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
318: || 'BIV_MEASURE35' || fnd_global.newline ||
319: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count_total'

Line 319: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count_total'

315: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'
316: ,denominator => 'c_completed_count_total'
317: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
318: || 'BIV_MEASURE35' || fnd_global.newline ||
319: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count_total'
320: ,denominator => 'p_completed_count_total'
321: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
322: || 'BIV_MEASURE36' || fnd_global.newline ||
323: ',' || l_drill_across_rep_2 || ' BIV_DYNAMIC_URL_2 ' || fnd_global.newline;

Line 339: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

335: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
336: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
337: l_comparison_type VARCHAR2(1);
338: l_cur_suffix VARCHAR2(2);
339: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
340: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
341: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
342: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
343: l_mv_set VARCHAR2(50);

Line 340: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

336: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
337: l_comparison_type VARCHAR2(1);
338: l_cur_suffix VARCHAR2(2);
339: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
340: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
341: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
342: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
343: l_mv_set VARCHAR2(50);
344: l_aggregation_flag NUMBER;

Line 357: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

353: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
354: l_comparison_type := 'Y';
355:
356: -- clear out the tables.
357: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
358: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
359:
360: -- get all the query parameters
361: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,

Line 358: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

354: l_comparison_type := 'Y';
355:
356: -- clear out the tables.
357: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
358: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
359:
360: -- get all the query parameters
361: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
362: x_view_by => l_view_by,

Line 383: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

379: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
380: END IF;
381:
382: -- Add measure columns that need to be aggregated
383: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
384: p_col_name => 'close_count' ,
385: p_alias_name => 'completed_count',
386: p_grand_total => 'N',
387: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 387: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

383: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
384: p_col_name => 'close_count' ,
385: p_alias_name => 'completed_count',
386: p_grand_total => 'N',
387: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
388: p_to_date_type => 'XTD');
389:
390: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
391: p_col_name => 'late_complete_count' ,

Line 390: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

386: p_grand_total => 'N',
387: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
388: p_to_date_type => 'XTD');
389:
390: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
391: p_col_name => 'late_complete_count' ,
392: p_alias_name => 'late_complete_count',
393: p_grand_total => 'N',
394: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 394: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

390: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
391: p_col_name => 'late_complete_count' ,
392: p_alias_name => 'late_complete_count',
393: p_grand_total => 'N',
394: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
395: p_to_date_type => 'XTD');
396:
397: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
398: p_col_name => 'days_late' ,

Line 397: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

393: p_grand_total => 'N',
394: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
395: p_to_date_type => 'XTD');
396:
397: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
398: p_col_name => 'days_late' ,
399: p_alias_name => 'days_late',
400: p_grand_total => 'N',
401: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 401: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

397: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
398: p_col_name => 'days_late' ,
399: p_alias_name => 'days_late',
400: p_grand_total => 'N',
401: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
402: p_to_date_type => 'XTD');
403:
404: l_query := GET_COMPLETION_TRD_SEL_CLAUSE (l_view_by)
405: || ' from

Line 424: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,

420: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
421: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
422:
423: -- set the basic bind variables for the status SQL
424: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
425: p_comparison_type => l_comparison_type,
426: x_custom_output => x_custom_output);
427:
428: -- Passing AGGREGATION_LEVEL_FLAG to PMV

Line 462: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'

458: l_sel_clause :=
459: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
460: ',' || 'NVL(iset.c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
461: ',' || 'NVL(iset.p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
462: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
463: ,prior_col => 'p_completed_count'
464: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
465: || ' BIV_MEASURE2' || fnd_global.newline ||
466: ',' || 'NVL(iset.c_late_complete_count,0) BIV_MEASURE3 ' || fnd_global.newline ||

Line 467: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'

463: ,prior_col => 'p_completed_count'
464: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
465: || ' BIV_MEASURE2' || fnd_global.newline ||
466: ',' || 'NVL(iset.c_late_complete_count,0) BIV_MEASURE3 ' || fnd_global.newline ||
467: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
468: ,denominator => 'c_completed_count'
469: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
470: || 'BIV_MEASURE4' || fnd_global.newline ||
471: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'

Line 471: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'

467: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
468: ,denominator => 'c_completed_count'
469: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
470: || 'BIV_MEASURE4' || fnd_global.newline ||
471: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
472: ,denominator => 'p_completed_count'
473: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
474: || ' BIV_MEASURE12' || fnd_global.newline ||
475: ',' || OPI_DBI_RPT_UTIL_PKG.change_pct_str(p_new_numerator => 'c_late_complete_count',

Line 481: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'

477: p_old_numerator => 'p_late_complete_count',
478: p_old_denominator => 'p_completed_count',
479: p_measure_name => 'BIV_MEASURE5')
480: || fnd_global.newline ||
481: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
482: ,denominator => 'c_late_complete_count'
483: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
484: || ' BIV_MEASURE6' || fnd_global.newline ||
485: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'

Line 485: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'

481: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
482: ,denominator => 'c_late_complete_count'
483: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
484: || ' BIV_MEASURE6' || fnd_global.newline ||
485: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
486: ,denominator => 'p_late_complete_count'
487: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
488: || ' BIV_MEASURE13' || fnd_global.newline ||
489: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'

Line 489: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'

485: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
486: ,denominator => 'p_late_complete_count'
487: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
488: || ' BIV_MEASURE13' || fnd_global.newline ||
489: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
490: ,denominator => 'c_late_complete_count'
491: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
492: || ' - '
493: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'

Line 493: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'

489: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
490: ,denominator => 'c_late_complete_count'
491: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
492: || ' - '
493: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
494: ,denominator => 'p_late_complete_count'
495: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
496: || ' BIV_MEASURE7' || fnd_global.newline;
497: RETURN l_sel_clause;

Line 513: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

509: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
510: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
511: l_comparison_type VARCHAR2(1);
512: l_cur_suffix VARCHAR2(1);
513: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
514: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
515: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
516: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
517: l_mv_set VARCHAR2(50);

Line 514: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

510: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
511: l_comparison_type VARCHAR2(1);
512: l_cur_suffix VARCHAR2(1);
513: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
514: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
515: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
516: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
517: l_mv_set VARCHAR2(50);
518: l_aggregation_flag NUMBER;

Line 530: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

526: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
527: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
528:
529: -- clear out the tables.
530: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
531: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
532:
533: -- get all the query parameters
534: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,

Line 531: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

527: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
528:
529: -- clear out the tables.
530: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
531: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
532:
533: -- get all the query parameters
534: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
535: x_view_by => l_view_by,

Line 643: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

639: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
640: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
641: l_comparison_type VARCHAR2(1);
642: l_cur_suffix VARCHAR2(1);
643: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
644: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
645: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
646: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
647: l_mv_set VARCHAR2(50);

Line 644: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

640: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
641: l_comparison_type VARCHAR2(1);
642: l_cur_suffix VARCHAR2(1);
643: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
644: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
645: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
646: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
647: l_mv_set VARCHAR2(50);
648: l_aggregation_flag NUMBER;

Line 660: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

656: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
657: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
658:
659: -- clear out the tables.
660: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
661: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
662:
663: -- get all the query parameters
664: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,

Line 661: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

657: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
658:
659: -- clear out the tables.
660: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
661: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
662:
663: -- get all the query parameters
664: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
665: x_view_by => l_view_by,

Line 775: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

771: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
772: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
773: l_comparison_type VARCHAR2(1);
774: l_cur_suffix VARCHAR2(1);
775: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
776: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
777: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
778: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
779: l_mv_set VARCHAR2(50);

Line 776: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

772: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
773: l_comparison_type VARCHAR2(1);
774: l_cur_suffix VARCHAR2(1);
775: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
776: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
777: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
778: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
779: l_mv_set VARCHAR2(50);
780: l_aggregation_flag NUMBER;

Line 793: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

789: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
790: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
791:
792: -- clear out the tables.
793: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
794: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
795:
796: -- get all the query parameters
797: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,

Line 794: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

790: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
791:
792: -- clear out the tables.
793: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
794: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
795:
796: -- get all the query parameters
797: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
798: x_view_by => l_view_by,

Line 820: ' ,' || poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT'

816:
817: l_query := ' SELECT range_name BIV_ATTRIBUTE1 ' || fnd_global.newline ||
818: ' ,nvl(c_LATE_COMPLETE_COUNT,0) BIV_MEASURE1 ' || fnd_global.newline ||
819: ' ,nvl(p_LATE_COMPLETE_COUNT,0) BIV_MEASURE11 ' || fnd_global.newline ||
820: ' ,' || poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT'
821: ,prior_col => 'p_LATE_COMPLETE_COUNT'
822: ,change_type => 'NP') || 'BIV_MEASURE2' || fnd_global.newline ||
823: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT'
824: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'

Line 823: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT'

819: ' ,nvl(p_LATE_COMPLETE_COUNT,0) BIV_MEASURE11 ' || fnd_global.newline ||
820: ' ,' || poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT'
821: ,prior_col => 'p_LATE_COMPLETE_COUNT'
822: ,change_type => 'NP') || 'BIV_MEASURE2' || fnd_global.newline ||
823: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT'
824: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
825: ,rate_type => 'P') || 'BIV_MEASURE3' || fnd_global.newline ||
826: ' ,nvl(c_LATE_COMPLETE_COUNT_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
827: ' ,'|| poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT_total'

Line 827: ' ,'|| poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT_total'

823: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT'
824: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
825: ,rate_type => 'P') || 'BIV_MEASURE3' || fnd_global.newline ||
826: ' ,nvl(c_LATE_COMPLETE_COUNT_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
827: ' ,'|| poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT_total'
828: ,prior_col => 'p_LATE_COMPLETE_COUNT_total'
829: ,change_type => 'NP') || 'BIV_MEASURE22' || fnd_global.newline ||
830: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT_TOTAL'
831: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'

Line 830: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT_TOTAL'

826: ' ,nvl(c_LATE_COMPLETE_COUNT_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
827: ' ,'|| poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT_total'
828: ,prior_col => 'p_LATE_COMPLETE_COUNT_total'
829: ,change_type => 'NP') || 'BIV_MEASURE22' || fnd_global.newline ||
830: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT_TOTAL'
831: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
832: ,rate_type => 'P') || 'BIV_MEASURE23' || fnd_global.newline ||
833: -- ',' || 'ISC_DEPOT_COMPLETION_PKG.GET_BUCKET_DRILL_ACROSS_URL(''ISC_DEPOT_LAT_COMP_DTL_TBL_REP'', bucket_number)' || ' BIV_DYNAMIC_URL1 ' ||
834: ',' || '''pFunctionName=ISC_DEPOT_LAT_COMP_DTL_TBL_REP&pParamIds=Y&BIV_ATTRIBUTE1=-1&BIV_DR_BACKLOG_BUCKET+BIV_DR_BACKLOG_BUCKET=''|| bucket_number ||''''' || ' BIV_DYNAMIC_URL1 ' ||

Line 924: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

920: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
921: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
922:
923: -- set the basic bind variables for the status SQL
924: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
925: -- Passing AGGREGATION_LEVEL_FLAG to PMV
926: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
927: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
928: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;