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_MTTR_PKG dependencies on ISC_DEPOT_RPT_UTIL_PKG

Line 19: FUNCTION GET_MTTR_DTL_SEL_CLAUSE(l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type ,l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type)

15:
16: FUNCTION GET_MTTR_DIST_TRD_SEL_CLAUSE(p_view_by_dim IN VARCHAR2, p_bucket_rec IN bis_bucket_pub.bis_bucket_rec_type)
17: RETURN VARCHAR2;
18:
19: FUNCTION GET_MTTR_DTL_SEL_CLAUSE(l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type ,l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type)
20: RETURN VARCHAR2;
21:
22: FUNCTION GET_SRVC_TBL_SEL_CLAUSE(p_view_by_dim IN VARCHAR2,p_view_by_col IN VARCHAR2)
23: RETURN VARCHAR2;

Line 34: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

30: PROCEDURE GET_MTTR_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
31: x_custom_sql OUT NOCOPY VARCHAR2,
32: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
33: IS
34: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
35: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
36: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
37: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
38: l_comparison_type VARCHAR2(1);

Line 35: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

31: x_custom_sql OUT NOCOPY VARCHAR2,
32: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
33: IS
34: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
35: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
36: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
37: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
38: l_comparison_type VARCHAR2(1);
39: l_cur_suffix VARCHAR2(2);

Line 36: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

32: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
33: IS
34: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
35: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
36: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
37: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
38: l_comparison_type VARCHAR2(1);
39: l_cur_suffix VARCHAR2(2);
40: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 37: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

33: IS
34: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
35: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
36: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
37: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
38: l_comparison_type VARCHAR2(1);
39: l_cur_suffix VARCHAR2(2);
40: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
41: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 42: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

38: l_comparison_type VARCHAR2(1);
39: l_cur_suffix VARCHAR2(2);
40: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
41: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
42: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
43: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
44: l_mv_set VARCHAR2(50);
45: l_aggregation_flag NUMBER;
46: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 43: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

39: l_cur_suffix VARCHAR2(2);
40: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
41: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
42: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
43: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
44: l_mv_set VARCHAR2(50);
45: l_aggregation_flag NUMBER;
46: l_custom_rec BIS_QUERY_ATTRIBUTES;
47: l_mv_type VARCHAR2(10);

Line 51: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;

47: l_mv_type VARCHAR2(10);
48: l_err_stage VARCHAR2(32767);
49: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
50: l_debug_mode VARCHAR2(1);
51: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
52:
53: BEGIN
54: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
55: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

Line 62: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

58: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
59: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
60:
61: -- get all the query parameters
62: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
63: x_view_by => l_view_by,
64: x_view_by_col_name => l_view_by_col,
65: x_comparison_type => l_comparison_type,
66: x_xtd => l_xtd,

Line 79: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

75: x_custom_output => x_custom_output);
76:
77: IF (l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%') THEN
78: l_err_stage:='After calling DR_DBI_RPT_UTIL_PKG.process_parameters';
79: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
80: END IF;
81:
82: -- Add measure columns that need to be aggregated
83: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

Line 121: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

117: p_in_join_tables => NULL);
118:
119: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
120: l_err_stage:='The query is : || l_query';
121: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
122: END IF;
123:
124: -- prepare output for bind variables
125: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 147: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

143: WHEN OTHERS THEN
144: l_err_stage := SQLERRM;
145: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
146: l_err_stage:='The exception is : ' || l_err_stage;
147: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
148: END IF;
149:
150: END GET_MTTR_TBL_SQL;
151:

Line 174: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

170:
171: l_drill_down_rep_1 := get_drill_down (p_view_by_dim => p_view_by_dim, p_function_name => 'ISC_DEPOT_MTTR_TBL_REP');
172:
173: l_sel_clause :=
174: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
175: l_description || ' BIV_ATTRIBUTE10 ';
176:
177: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
178: , p_col_name => 'BIV_ATTRIBUTE1'

Line 347: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;

343: x_custom_sql OUT NOCOPY VARCHAR2,
344: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
345: IS
346:
347: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
348: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
349: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
350: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
351: l_comparison_type VARCHAR2(1);

Line 348: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;

344: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
345: IS
346:
347: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
348: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
349: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
350: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
351: l_comparison_type VARCHAR2(1);
352: l_cur_suffix VARCHAR2(2);

Line 349: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;

345: IS
346:
347: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
348: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
349: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
350: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
351: l_comparison_type VARCHAR2(1);
352: l_cur_suffix VARCHAR2(2);
353: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 350: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;

346:
347: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
348: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
349: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
350: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
351: l_comparison_type VARCHAR2(1);
352: l_cur_suffix VARCHAR2(2);
353: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
354: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 355: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;

351: l_comparison_type VARCHAR2(1);
352: l_cur_suffix VARCHAR2(2);
353: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
354: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
355: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
356: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
357: l_mv_set VARCHAR2(50);
358: l_aggregation_flag NUMBER;
359: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 356: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;

352: l_cur_suffix VARCHAR2(2);
353: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
354: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
355: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
356: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
357: l_mv_set VARCHAR2(50);
358: l_aggregation_flag NUMBER;
359: l_custom_rec BIS_QUERY_ATTRIBUTES;
360: l_mv_type VARCHAR2(10);

Line 364: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;

360: l_mv_type VARCHAR2(10);
361: l_err_stage VARCHAR2(32767);
362: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
363: l_debug_mode VARCHAR2(1);
364: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
365:
366: BEGIN
367: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
368: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

Line 375: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

371: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
372: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
373:
374: -- get all the query parameters
375: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
376: x_view_by => l_view_by,
377: x_view_by_col_name => l_view_by_col,
378: x_comparison_type => l_comparison_type,
379: x_xtd => l_xtd,

Line 392: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

388: x_custom_output => x_custom_output);
389:
390: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
391: l_err_stage:='After calling DR_DBI_RPT_UTIL_PKG.process_parameters';
392: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
393: END IF;
394:
395: -- Add measure columns that need to be aggregated
396: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

Line 433: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

429: p_in_join_tables => NULL);
430:
431: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
432: l_err_stage:='The query is : ' || l_query;
433: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
434: END IF;
435:
436: -- prepare output for bind variables
437: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 460: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

456: WHEN OTHERS THEN
457: l_err_stage := SQLERRM;
458: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
459: l_err_stage:='The exception is : ' || l_err_stage;
460: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
461: END IF;
462:
463: END GET_MTTR_TRD_SQL;
464:

Line 510: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;

506: x_custom_sql OUT NOCOPY VARCHAR2,
507: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
508: IS
509:
510: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
511: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
512: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
513: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
514: l_comparison_type VARCHAR2(1);

Line 511: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;

507: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
508: IS
509:
510: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
511: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
512: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
513: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
514: l_comparison_type VARCHAR2(1);
515: l_cur_suffix VARCHAR2(2);

Line 512: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;

508: IS
509:
510: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
511: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
512: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
513: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
514: l_comparison_type VARCHAR2(1);
515: l_cur_suffix VARCHAR2(2);
516: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 513: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;

509:
510: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
511: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
512: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
513: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
514: l_comparison_type VARCHAR2(1);
515: l_cur_suffix VARCHAR2(2);
516: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
517: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 518: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;

514: l_comparison_type VARCHAR2(1);
515: l_cur_suffix VARCHAR2(2);
516: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
517: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
518: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
519: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
520: l_mv_set VARCHAR2(50);
521: l_aggregation_flag NUMBER;
522: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 519: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;

515: l_cur_suffix VARCHAR2(2);
516: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
517: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
518: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
519: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
520: l_mv_set VARCHAR2(50);
521: l_aggregation_flag NUMBER;
522: l_custom_rec BIS_QUERY_ATTRIBUTES;
523: l_mv_type VARCHAR2(10);

Line 526: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;

522: l_custom_rec BIS_QUERY_ATTRIBUTES;
523: l_mv_type VARCHAR2(10);
524: l_err_stage VARCHAR2(32767);
525: l_debug_mode VARCHAR2(1);
526: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
527:
528: BEGIN
529: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
530: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

Line 537: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

533: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
534: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
535:
536: -- get all the query parameters
537: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
538: x_view_by => l_view_by,
539: x_view_by_col_name => l_view_by_col,
540: x_comparison_type => l_comparison_type,
541: x_xtd => l_xtd,

Line 554: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DTL_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

550: x_custom_output => x_custom_output);
551:
552: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
553: l_err_stage:='After calling DR_DBI_RPT_UTIL_PKG.process_parameters';
554: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DTL_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
555: END IF;
556:
557: l_query := GET_MTTR_DTL_SEL_CLAUSE(l_mv,l_where_clause);
558:

Line 561: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DTL_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

557: l_query := GET_MTTR_DTL_SEL_CLAUSE(l_mv,l_where_clause);
558:
559: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
560: l_err_stage:='The query is : ' || l_query;
561: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DTL_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
562: END IF;
563:
564: x_custom_sql := l_query;
565:

Line 572: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DTL_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

568: WHEN OTHERS THEN
569: l_err_stage := SQLERRM;
570: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
571: l_err_stage:='The exception is : ' || l_err_stage;
572: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DTL_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
573: END IF;
574:
575: END GET_MTTR_DTL_TBL_SQL;
576:

Line 577: FUNCTION GET_MTTR_DTL_SEL_CLAUSE(l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type ,l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type)

573: END IF;
574:
575: END GET_MTTR_DTL_TBL_SQL;
576:
577: FUNCTION GET_MTTR_DTL_SEL_CLAUSE(l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type ,l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type)
578: RETURN VARCHAR2
579: IS
580:
581: l_sel_clause VARCHAR2(8000);

Line 603: ,' || ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || '|| BIV_ATTRIBUTE8 BIV_DYNAMIC_URL2

599: ,BIV_MEASURE2
600: ,BIV_MEASURE3
601: ,BIV_MEASURE4
602: ,''pFunctionName=CSD_RO_DETAILS&csdInvOrgId=''||BIV_MEASURE4||''&csdRepairLineId=''||BIV_MEASURE3 BIV_DYNAMIC_URL1
603: ,' || ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || '|| BIV_ATTRIBUTE8 BIV_DYNAMIC_URL2
604: FROM (
605: SELECT
606: rank() over (&ORDER_BY_CLAUSE nulls last,repair_line_id ) - 1 rnk
607: ,BIV_ATTRIBUTE1

Line 661: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;

657: PROCEDURE GET_MTTR_DIST_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
658: x_custom_sql OUT NOCOPY VARCHAR2,
659: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
660: IS
661: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
662: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
663: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
664: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
665: l_comparison_type VARCHAR2(1);

Line 662: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;

658: x_custom_sql OUT NOCOPY VARCHAR2,
659: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
660: IS
661: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
662: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
663: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
664: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
665: l_comparison_type VARCHAR2(1);
666: l_cur_suffix VARCHAR2(2);

Line 663: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;

659: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
660: IS
661: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
662: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
663: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
664: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
665: l_comparison_type VARCHAR2(1);
666: l_cur_suffix VARCHAR2(2);
667: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 664: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;

660: IS
661: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
662: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
663: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
664: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
665: l_comparison_type VARCHAR2(1);
666: l_cur_suffix VARCHAR2(2);
667: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
668: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 669: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;

665: l_comparison_type VARCHAR2(1);
666: l_cur_suffix VARCHAR2(2);
667: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
668: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
669: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
670: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
671: l_mv_set VARCHAR2(50);
672: l_aggregation_flag NUMBER;
673: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 670: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;

666: l_cur_suffix VARCHAR2(2);
667: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
668: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
669: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
670: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
671: l_mv_set VARCHAR2(50);
672: l_aggregation_flag NUMBER;
673: l_custom_rec BIS_QUERY_ATTRIBUTES;
674: l_mv_type VARCHAR2(10);

Line 678: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;

674: l_mv_type VARCHAR2(10);
675: l_err_stage VARCHAR2(32767);
676: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
677: l_debug_mode VARCHAR2(1);
678: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
679:
680: BEGIN
681: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
682: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

Line 689: ISC_DEPOT_RPT_UTIL_PKG .process_parameters ( p_param => p_param,

685: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
686: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
687:
688: -- get all the query parameters
689: ISC_DEPOT_RPT_UTIL_PKG .process_parameters ( p_param => p_param,
690: x_view_by => l_view_by,
691: x_view_by_col_name => l_view_by_col,
692: x_comparison_type => l_comparison_type,
693: x_xtd => l_xtd,

Line 706: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

702: x_custom_output => x_custom_output);
703:
704: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
705: l_err_stage:='After calling DR_DBI_RPT_UTIL_PKG.process_parameters';
706: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
707: END IF;
708:
709: -- Add measure columns that need to be aggregated
710: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

Line 749: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

745: p_in_join_tables => NULL);
746:
747: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
748: l_err_stage:='The query is : ' || l_query;
749: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
750: END IF;
751:
752: -- prepare output for bind variables
753: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 775: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

771: WHEN OTHERS THEN
772: l_err_stage := SQLERRM;
773: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
774: l_err_stage:='The exception is : ';
775: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
776: END IF;
777:
778: END GET_MTTR_DIST_TBL_SQL;
779:

Line 801: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

797:
798: l_drill_down_rep_1 := get_drill_down (p_view_by_dim => p_view_by_dim, p_function_name =>'ISC_DEPOT_MTTR_DIST_TBL_REP');
799:
800: l_sel_clause :=
801: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
802: l_description || ' BIV_ATTRIBUTE10
803: ,BIV_MEASURE11
804: ,BIV_MEASURE1
805: ,BIV_MEASURE2

Line 915: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;

911: x_custom_sql OUT NOCOPY VARCHAR2,
912: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
913: IS
914:
915: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
916: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
917: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
918: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
919: l_comparison_type VARCHAR2(1);

Line 916: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;

912: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
913: IS
914:
915: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
916: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
917: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
918: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
919: l_comparison_type VARCHAR2(1);
920: l_cur_suffix VARCHAR2(2);

Line 917: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;

913: IS
914:
915: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
916: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
917: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
918: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
919: l_comparison_type VARCHAR2(1);
920: l_cur_suffix VARCHAR2(2);
921: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 918: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;

914:
915: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
916: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
917: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
918: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
919: l_comparison_type VARCHAR2(1);
920: l_cur_suffix VARCHAR2(2);
921: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
922: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 923: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;

919: l_comparison_type VARCHAR2(1);
920: l_cur_suffix VARCHAR2(2);
921: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
922: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
923: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
924: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
925: l_mv_set VARCHAR2(50);
926: l_aggregation_flag NUMBER;
927: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 924: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;

920: l_cur_suffix VARCHAR2(2);
921: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
922: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
923: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
924: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
925: l_mv_set VARCHAR2(50);
926: l_aggregation_flag NUMBER;
927: l_custom_rec BIS_QUERY_ATTRIBUTES;
928: l_mv_type VARCHAR2(10);

Line 932: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;

928: l_mv_type VARCHAR2(10);
929: l_err_stage VARCHAR2(32767);
930: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
931: l_debug_mode VARCHAR2(1);
932: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
933:
934: BEGIN
935: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
936: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

Line 943: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

939: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
940: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
941:
942: -- get all the query parameters
943: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
944: x_view_by => l_view_by,
945: x_view_by_col_name => l_view_by_col,
946: x_comparison_type => l_comparison_type,
947: x_xtd => l_xtd,

Line 960: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

956: x_custom_output => x_custom_output);
957:
958: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
959: l_err_stage:='After calling DR_DBI_RPT_UTIL_PKG.process_parameters';
960: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
961: END IF;
962:
963: -- Add measure columns that need to be aggregated
964: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

Line 1000: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

996: p_in_join_tables => NULL);
997:
998: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
999: l_err_stage:='The query is : ' || l_query;
1000: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
1001: END IF;
1002:
1003: -- prepare output for bind variables
1004: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 1026: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

1022: WHEN OTHERS THEN
1023: l_err_stage := SQLERRM;
1024: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1025: l_err_stage:='The exception is : ' || l_err_stage;
1026: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
1027: END IF;
1028:
1029:
1030: END GET_MTTR_DIST_TRD_SQL;

Line 1075: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;

1071: PROCEDURE GET_SRVC_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1072: x_custom_sql OUT NOCOPY VARCHAR2,
1073: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1074: IS
1075: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
1076: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
1077: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
1078: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
1079: l_comparison_type VARCHAR2(1);

Line 1076: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;

1072: x_custom_sql OUT NOCOPY VARCHAR2,
1073: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1074: IS
1075: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
1076: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
1077: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
1078: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
1079: l_comparison_type VARCHAR2(1);
1080: l_cur_suffix VARCHAR2(2);

Line 1077: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;

1073: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1074: IS
1075: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
1076: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
1077: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
1078: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
1079: l_comparison_type VARCHAR2(1);
1080: l_cur_suffix VARCHAR2(2);
1081: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 1078: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;

1074: IS
1075: l_query ISC_DEPOT_RPT_UTIL_PKG .g_query_typ%type;
1076: l_view_by ISC_DEPOT_RPT_UTIL_PKG .g_view_by_typ%type;
1077: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
1078: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
1079: l_comparison_type VARCHAR2(1);
1080: l_cur_suffix VARCHAR2(2);
1081: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1082: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 1083: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;

1079: l_comparison_type VARCHAR2(1);
1080: l_cur_suffix VARCHAR2(2);
1081: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1082: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1083: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
1084: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
1085: l_mv_set VARCHAR2(50);
1086: l_aggregation_flag NUMBER;
1087: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1084: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;

1080: l_cur_suffix VARCHAR2(2);
1081: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1082: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1083: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
1084: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
1085: l_mv_set VARCHAR2(50);
1086: l_aggregation_flag NUMBER;
1087: l_custom_rec BIS_QUERY_ATTRIBUTES;
1088: l_mv_type VARCHAR2(10);

Line 1091: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;

1087: l_custom_rec BIS_QUERY_ATTRIBUTES;
1088: l_mv_type VARCHAR2(10);
1089: l_err_stage VARCHAR2(32767);
1090: l_debug_mode VARCHAR2(1);
1091: l_module_name ISC_DEPOT_RPT_UTIL_PKG .g_module_name_typ%type;
1092:
1093: BEGIN
1094: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1095: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

Line 1102: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

1098: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1099: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1100:
1101: -- get all the query parameters
1102: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
1103: x_view_by => l_view_by,
1104: x_view_by_col_name => l_view_by_col,
1105: x_comparison_type => l_comparison_type,
1106: x_xtd => l_xtd,

Line 1119: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

1115: x_custom_output => x_custom_output);
1116:
1117: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1118: l_err_stage:='After calling DR_DBI_RPT_UTIL_PKG.process_parameters';
1119: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
1120: END IF;
1121:
1122: -- Add measure columns that need to be aggregated
1123: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

Line 1132: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

1128: p_to_date_type => 'XTD');
1129:
1130: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1131: l_err_stage:='After initializing';
1132: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
1133: END IF;
1134:
1135:
1136: l_query := GET_SRVC_TBL_SEL_CLAUSE(l_view_by,l_view_by_col)

Line 1151: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

1147: p_in_join_tables => NULL);
1148:
1149: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1150: l_err_stage:='The query is : ' || l_query;
1151: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
1152: END IF;
1153:
1154: -- prepare output for bind variables
1155: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 1176: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);

1172: WHEN OTHERS THEN
1173: l_err_stage := SQLERRM;
1174: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1175: l_err_stage:='The exception is : ' ||l_err_stage;
1176: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
1177: END IF;
1178:
1179: END GET_SRVC_TBL_SQL;
1180:

Line 1195: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

1191: l_percent_total := '(c_ro_count_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) * 100';
1192:
1193:
1194: l_sel_clause :=
1195: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
1196: ' v.description BIV_ATTRIBUTE6 ' || fnd_global.newline ||
1197: ',BIV_MEASURE11
1198: ,BIV_MEASURE1
1199: ,BIV_MEASURE2