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

Line 23: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

19: PROCEDURE GET_BACKLOG_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
20: x_custom_sql OUT NOCOPY VARCHAR2,
21: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
22: IS
23: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
24: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
25: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
26: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
27: l_comparison_type VARCHAR2(1) ;

Line 24: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

20: x_custom_sql OUT NOCOPY VARCHAR2,
21: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
22: IS
23: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
24: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
25: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
26: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
27: l_comparison_type VARCHAR2(1) ;
28: l_cur_suffix VARCHAR2(2);

Line 25: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

21: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
22: IS
23: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
24: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
25: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
26: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
27: l_comparison_type VARCHAR2(1) ;
28: l_cur_suffix VARCHAR2(2);
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 26: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

22: IS
23: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
24: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
25: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
26: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
27: l_comparison_type VARCHAR2(1) ;
28: l_cur_suffix VARCHAR2(2);
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 31: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

27: l_comparison_type VARCHAR2(1) ;
28: l_cur_suffix VARCHAR2(2);
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
31: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
32: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
33: l_mv_set VARCHAR2(50);
34: l_aggregation_flag NUMBER;
35: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 32: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

28: l_cur_suffix VARCHAR2(2);
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
31: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
32: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
33: l_mv_set VARCHAR2(50);
34: l_aggregation_flag NUMBER;
35: l_custom_rec BIS_QUERY_ATTRIBUTES;
36: l_mv_type VARCHAR2(10);

Line 39: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

35: l_custom_rec BIS_QUERY_ATTRIBUTES;
36: l_mv_type VARCHAR2(10);
37: l_err_stage VARCHAR2(32767);
38: l_debug_mode VARCHAR2(1);
39: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
40: l_last_refresh_date DATE;
41:
42: BEGIN
43: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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

49: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
51:
52: -- get all the query parameters
53: ISC_DEPOT_RPT_UTIL_PKG.process_parameters ( p_param => p_param,
54: x_view_by => l_view_by,
55: x_view_by_col_name => l_view_by_col,
56: x_comparison_type => l_comparison_type,
57: x_xtd => l_xtd,

Line 70: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

66: x_custom_output => x_custom_output);
67:
68: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
69: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
70: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
71: END IF;
72:
73: -- Add measure columns that need to be aggregated
74: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

Line 106: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

102: p_in_join_tables => NULL);
103:
104: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
105: l_err_stage:='The query is : ' || l_query;
106: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
107: END IF;
108:
109: -- prepare output for bind variables
110: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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

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

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

176: IF (p_view_by_dim = 'ITEM+ENI_ITEM') THEN
177: l_description := ' v. description ';
178: END IF;
179: l_sel_clause :=
180: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
181: l_description || ' BIV_ATTRIBUTE1
182: ,BIV_MEASURE1
183: ,BIV_MEASURE11
184: ,BIV_MEASURE2

Line 312: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

308: x_custom_sql OUT NOCOPY VARCHAR2,
309: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
310: IS
311:
312: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
313: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
314: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
315: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
316: l_comparison_type VARCHAR2(1);

Line 313: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

309: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
310: IS
311:
312: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
313: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
314: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
315: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
316: l_comparison_type VARCHAR2(1);
317: l_cur_suffix VARCHAR2(2);

Line 314: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

310: IS
311:
312: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
313: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
314: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
315: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
316: l_comparison_type VARCHAR2(1);
317: l_cur_suffix VARCHAR2(2);
318: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 315: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

311:
312: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
313: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
314: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
315: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
316: l_comparison_type VARCHAR2(1);
317: l_cur_suffix VARCHAR2(2);
318: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
319: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 320: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

316: l_comparison_type VARCHAR2(1);
317: l_cur_suffix VARCHAR2(2);
318: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
319: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
320: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
321: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
322: l_mv_set VARCHAR2(50);
323: l_aggregation_flag NUMBER;
324: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 321: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

317: l_cur_suffix VARCHAR2(2);
318: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
319: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
320: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
321: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
322: l_mv_set VARCHAR2(50);
323: l_aggregation_flag NUMBER;
324: l_custom_rec BIS_QUERY_ATTRIBUTES;
325: l_mv_type VARCHAR2(10);

Line 328: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

324: l_custom_rec BIS_QUERY_ATTRIBUTES;
325: l_mv_type VARCHAR2(10);
326: l_err_stage VARCHAR2(32767);
327: l_debug_mode VARCHAR2(1);
328: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
329:
330: BEGIN
331: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
332: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

336: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
337: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
338:
339: -- get all the query parameters
340: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
341: x_view_by => l_view_by,
342: x_view_by_col_name => l_view_by_col,
343: x_comparison_type => l_comparison_type,
344: x_xtd => l_xtd,

Line 358: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

354:
355:
356: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
357: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
358: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
359: END IF;
360:
361: -- Add measure columns that need to be aggregated
362: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

Line 388: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

384: p_in_join_tables => NULL);
385:
386: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
387: l_err_stage:='The query is : ' || l_query;
388: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
389: END IF;
390:
391: -- prepare output for bind variables
392: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 422: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

418:
419: WHEN OTHERS THEN
420: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
421: l_err_stage:= 'The exception is : ' || SQLERRM;
422: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
423: END IF;
424:
425: END GET_BACKLOG_TRD_SQL;
426:

Line 479: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

475: x_custom_sql OUT NOCOPY VARCHAR2,
476: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
477: IS
478:
479: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
480: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
481: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
482: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
483: l_comparison_type VARCHAR2(1);

Line 480: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

476: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
477: IS
478:
479: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
480: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
481: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
482: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
483: l_comparison_type VARCHAR2(1);
484: l_cur_suffix VARCHAR2(1);

Line 481: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

477: IS
478:
479: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
480: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
481: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
482: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
483: l_comparison_type VARCHAR2(1);
484: l_cur_suffix VARCHAR2(1);
485: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 482: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

478:
479: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
480: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
481: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
482: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
483: l_comparison_type VARCHAR2(1);
484: l_cur_suffix VARCHAR2(1);
485: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
486: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 487: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

483: l_comparison_type VARCHAR2(1);
484: l_cur_suffix VARCHAR2(1);
485: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
486: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
487: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
488: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
489: l_mv_set VARCHAR2(50);
490: l_aggregation_flag NUMBER;
491: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 488: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

484: l_cur_suffix VARCHAR2(1);
485: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
486: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
487: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
488: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
489: l_mv_set VARCHAR2(50);
490: l_aggregation_flag NUMBER;
491: l_custom_rec BIS_QUERY_ATTRIBUTES;
492: l_mv_type VARCHAR2(10);

Line 495: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

491: l_custom_rec BIS_QUERY_ATTRIBUTES;
492: l_mv_type VARCHAR2(10);
493: l_err_stage VARCHAR2(32767);
494: l_debug_mode VARCHAR2(1);
495: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
496:
497: BEGIN
498: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
499: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

502: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
503: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
504:
505: -- get all the query parameters
506: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
507: x_view_by => l_view_by,
508: x_view_by_col_name => l_view_by_col,
509: x_comparison_type => l_comparison_type,
510: x_xtd => l_xtd,

Line 523: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

519: x_custom_output => x_custom_output);
520:
521: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
522: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
523: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
524: END IF;
525:
526: l_query :=
527: 'SELECT

Line 542: ,' || ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || ' || BIV_ATTRIBUTE9 BIV_DYNAMIC_URL2

538: ,BIV_DATE1
539: ,BIV_MEASURE2
540: ,BIV_MEASURE3
541: ,''pFunctionName=CSD_RO_DETAILS&csdInvOrgId=''||BIV_MEASURE3||''&csdRepairLineId=''||BIV_MEASURE2 BIV_DYNAMIC_URL1
542: ,' || ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || ' || BIV_ATTRIBUTE9 BIV_DYNAMIC_URL2
543: FROM (
544: SELECT
545: rank() over (&ORDER_BY_CLAUSE nulls last,BIV_ATTRIBUTE1) - 1 rnk
546: ,BIV_ATTRIBUTE1

Line 592: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

588: ORDER BY rnk' || fnd_global.newline ;
589:
590: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
591: l_err_stage:='The query is : ' || l_query;
592: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
593: END IF;
594:
595: x_custom_sql := l_query;
596: EXCEPTION

Line 601: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

597:
598: WHEN OTHERS THEN
599: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
600: l_err_stage:='The exception is : ' || SQLERRM;
601: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
602: END IF;
603:
604: END get_backlog_dtl_tbl_sql;
605:

Line 611: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

607: x_custom_sql OUT NOCOPY VARCHAR2,
608: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
609: IS
610:
611: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
612: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
613: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
614: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
615: l_comparison_type VARCHAR2(1);

Line 612: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

608: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
609: IS
610:
611: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
612: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
613: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
614: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
615: l_comparison_type VARCHAR2(1);
616: l_cur_suffix VARCHAR2(1);

Line 613: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

609: IS
610:
611: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
612: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
613: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
614: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
615: l_comparison_type VARCHAR2(1);
616: l_cur_suffix VARCHAR2(1);
617: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 614: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

610:
611: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
612: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
613: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
614: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
615: l_comparison_type VARCHAR2(1);
616: l_cur_suffix VARCHAR2(1);
617: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
618: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 619: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

615: l_comparison_type VARCHAR2(1);
616: l_cur_suffix VARCHAR2(1);
617: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
618: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
619: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
620: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
621: l_mv_set VARCHAR2(50);
622: l_aggregation_flag NUMBER;
623: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 620: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

616: l_cur_suffix VARCHAR2(1);
617: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
618: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
619: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
620: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
621: l_mv_set VARCHAR2(50);
622: l_aggregation_flag NUMBER;
623: l_custom_rec BIS_QUERY_ATTRIBUTES;
624: l_mv_type VARCHAR2(10);

Line 627: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

623: l_custom_rec BIS_QUERY_ATTRIBUTES;
624: l_mv_type VARCHAR2(10);
625: l_err_stage VARCHAR2(32767);
626: l_debug_mode VARCHAR2(1);
627: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
628:
629: BEGIN
630: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
631: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

Line 639: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

635: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
636:
637: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
638: l_err_stage:='get past due aging report calling process parameters';
639: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
640: END IF;
641:
642: -- get all the query parameters
643: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,

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

639: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
640: END IF;
641:
642: -- get all the query parameters
643: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
644: x_view_by => l_view_by,
645: x_view_by_col_name => l_view_by_col,
646: x_comparison_type => l_comparison_type,
647: x_xtd => l_xtd,

Line 661: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

657:
658:
659: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
660: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
661: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
662: END IF;
663:
664: l_query :=
665: ' SELECT range_name BIV_ATTRIBUTE1 ' || fnd_global.newline ||

Line 733: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

729: l_query := l_query || ' group by range_name,bucket_number order by bucket_number ) ';
730:
731: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
732: l_err_stage:='The query is : ' || l_query;
733: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
734: END IF;
735: -- prepare output for bind variables
736: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
737: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

Line 757: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

753:
754: WHEN OTHERS THEN
755: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
756: l_err_stage:='The exception is : ' || SQLERRM;
757: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
758: END IF;
759:
760: END GET_PAST_DUE_AGNG_TBL_SQL;
761:

Line 767: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

763: x_custom_sql OUT NOCOPY VARCHAR2,
764: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
765: IS
766:
767: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
768: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
769: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
770: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
771: l_comparison_type VARCHAR2(1);

Line 768: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

764: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
765: IS
766:
767: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
768: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
769: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
770: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
771: l_comparison_type VARCHAR2(1);
772: l_cur_suffix VARCHAR2(1);

Line 769: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

765: IS
766:
767: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
768: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
769: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
770: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
771: l_comparison_type VARCHAR2(1);
772: l_cur_suffix VARCHAR2(1);
773: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 770: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

766:
767: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
768: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
769: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
770: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
771: l_comparison_type VARCHAR2(1);
772: l_cur_suffix VARCHAR2(1);
773: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
774: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 775: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

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

Line 776: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

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

Line 783: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

779: l_custom_rec BIS_QUERY_ATTRIBUTES;
780: l_mv_type VARCHAR2(10);
781: l_err_stage VARCHAR2(32767);
782: l_debug_mode VARCHAR2(1);
783: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
784:
785: BEGIN
786: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
787: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

790: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
791: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
792:
793: -- get all the query parameters
794: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
795: x_view_by => l_view_by,
796: x_view_by_col_name => l_view_by_col,
797: x_comparison_type => l_comparison_type,
798: x_xtd => l_xtd,

Line 812: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

808:
809:
810: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
811: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
812: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
813: END IF;
814:
815: l_query :=
816: 'SELECT

Line 832: ,' || ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || ' || BIV_ATTRIBUTE9 BIV_DYNAMIC_URL2

828: ,BIV_MEASURE2
829: ,BIV_MEASURE3
830: ,BIV_MEASURE4
831: ,''pFunctionName=CSD_RO_DETAILS&csdInvOrgId=''||BIV_MEASURE4||''&csdRepairLineId=''||BIV_MEASURE3 BIV_DYNAMIC_URL1
832: ,' || ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || ' || BIV_ATTRIBUTE9 BIV_DYNAMIC_URL2
833: FROM (
834: SELECT
835: rank() over (&ORDER_BY_CLAUSE nulls last,BIV_ATTRIBUTE1, BIV_MEASURE3) - 1 rnk
836: ,BIV_ATTRIBUTE1

Line 885: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

881: ORDER BY rnk' || fnd_global.newline ;
882:
883: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
884: l_err_stage:='The query is : ' || l_query;
885: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
886: END IF;
887:
888: x_custom_sql := l_query;
889: EXCEPTION

Line 894: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

890:
891: WHEN OTHERS THEN
892: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
893: l_err_stage:='The exception is : ' || SQLERRM;
894: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
895: END IF;
896:
897: END GET_PAST_DUE_DTL_TBL_SQL;
898:

Line 903: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

899: PROCEDURE GET_DAYS_UNTIL_PROM_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
900: x_custom_sql OUT NOCOPY VARCHAR2,
901: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
902: IS
903: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
904: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
905: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
906: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
907: l_comparison_type VARCHAR2(1);

Line 904: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

900: x_custom_sql OUT NOCOPY VARCHAR2,
901: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
902: IS
903: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
904: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
905: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
906: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
907: l_comparison_type VARCHAR2(1);
908: l_cur_suffix VARCHAR2(1);

Line 905: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

901: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
902: IS
903: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
904: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
905: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
906: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
907: l_comparison_type VARCHAR2(1);
908: l_cur_suffix VARCHAR2(1);
909: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 906: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

902: IS
903: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
904: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
905: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
906: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
907: l_comparison_type VARCHAR2(1);
908: l_cur_suffix VARCHAR2(1);
909: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
910: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 911: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

907: l_comparison_type VARCHAR2(1);
908: l_cur_suffix VARCHAR2(1);
909: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
910: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
911: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
912: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
913: l_mv_set VARCHAR2(50);
914: l_custom_rec BIS_QUERY_ATTRIBUTES;
915: l_mv_type VARCHAR2(10);

Line 912: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

908: l_cur_suffix VARCHAR2(1);
909: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
910: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
911: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
912: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
913: l_mv_set VARCHAR2(50);
914: l_custom_rec BIS_QUERY_ATTRIBUTES;
915: l_mv_type VARCHAR2(10);
916: l_err_stage VARCHAR2(32767);

Line 921: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

917: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
918: l_agg_flag_1 NUMBER; -- for isc_dr_curr_02_mv
919: l_agg_flag_2 NUMBER; -- for isc_dr_bklg_01_mv,isc_dr_bklg_02_mv
920: l_debug_mode VARCHAR2(1);
921: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
922:
923: BEGIN
924: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
925: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

930: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
931: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
932:
933: -- get all the query parameters
934: ISC_DEPOT_RPT_UTIL_PKG.process_parameters ( p_param => p_param,
935: x_view_by => l_view_by,
936: x_view_by_col_name => l_view_by_col,
937: x_comparison_type => l_comparison_type,
938: x_xtd => l_xtd,

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

945: p_trend => 'N',
946: p_mv_set => 'BKLDUP1',
947: x_custom_output => x_custom_output);
948:
949: ISC_DEPOT_RPT_UTIL_PKG.process_parameters ( p_param => p_param,
950: x_view_by => l_view_by,
951: x_view_by_col_name => l_view_by_col,
952: x_comparison_type => l_comparison_type,
953: x_xtd => l_xtd,

Line 966: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

962: x_custom_output => x_custom_output);
963:
964: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
965: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
966: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
967: l_err_stage:='l_view_by = ' || l_view_by || 'l_view_by_col = ' || l_view_by_col;
968: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
969: l_err_stage:='l_mv_type = ' || l_mv_type || 'l_where_clause = ' || l_where_clause;
970: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

Line 968: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

964: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
965: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
966: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
967: l_err_stage:='l_view_by = ' || l_view_by || 'l_view_by_col = ' || l_view_by_col;
968: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
969: l_err_stage:='l_mv_type = ' || l_mv_type || 'l_where_clause = ' || l_where_clause;
970: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
971: END IF;
972:

Line 970: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

966: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
967: l_err_stage:='l_view_by = ' || l_view_by || 'l_view_by_col = ' || l_view_by_col;
968: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
969: l_err_stage:='l_mv_type = ' || l_mv_type || 'l_where_clause = ' || l_where_clause;
970: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
971: END IF;
972:
973: l_mv := l_mv || '( SELECT ' || fnd_global.newline;
974: IF ( l_mv_type = 'ROOT' AND l_view_by = 'ITEM+ENI_ITEM_VBH_CAT' ) THEN

Line 1116: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

1112: p_in_join_tables => NULL);
1113:
1114: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1115: l_err_stage:='The query is : ' || l_query;
1116: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1117: END IF;
1118:
1119: -- prepare output for bind variables
1120: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 1148: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

1144: EXCEPTION
1145: WHEN OTHERS THEN
1146: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1147: l_err_stage:='The exception is : ' || SQLERRM;
1148: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1149: END IF;
1150: l_err_stage:='The exception is : ' || SQLERRM;
1151: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1152:

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

1147: l_err_stage:='The exception is : ' || SQLERRM;
1148: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1149: END IF;
1150: l_err_stage:='The exception is : ' || SQLERRM;
1151: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1152:
1153: END GET_DAYS_UNTIL_PROM_tbl_sql;
1154:
1155:

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

1174: IF (p_view_by_dim = 'ITEM+ENI_ITEM') THEN
1175: l_description := ' v. description ';
1176: END IF;
1177: l_sel_clause :=
1178: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
1179: l_description || ' BIV_ATTRIBUTE1 ';
1180:
1181: l_sel_clause := l_sel_clause ||
1182: ',BIV_MEASURE2