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 ISC_DEPOT_RPT_UTIL_PKG

Line 19: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

15: PROCEDURE GET_COMPLETION_TBL_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
16: x_custom_sql OUT NOCOPY VARCHAR2,
17: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
18: IS
19: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
20: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 20: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

16: x_custom_sql OUT NOCOPY VARCHAR2,
17: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
18: IS
19: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
20: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 21: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

17: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
18: IS
19: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
20: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 22: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

18: IS
19: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
20: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 27: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_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;
31: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 28: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

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;
31: l_custom_rec BIS_QUERY_ATTRIBUTES;
32: l_mv_type VARCHAR2(10);

Line 35: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

31: l_custom_rec BIS_QUERY_ATTRIBUTES;
32: l_mv_type VARCHAR2(10);
33: l_err_stage VARCHAR2(32767);
34: l_debug_mode VARCHAR2(1);
35: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
36:
37: BEGIN
38: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
39: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

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,
49: x_view_by_col_name => l_view_by_col,
50: x_comparison_type => l_comparison_type,
51: x_xtd => l_xtd,

Line 64: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

60: x_custom_output => x_custom_output);
61:
62: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
63: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
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,

Line 114: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

110: p_in_join_tables => NULL);
111:
112: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
113: l_err_stage:='The query is : ' || l_query;
114: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
115: END IF;
116:
117: -- prepare output for bind variables
118: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 139: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

135:
136: WHEN OTHERS THEN
137: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
138: l_err_stage:='The exception is : ' || SQLERRM;
139: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
140: END IF;
141:
142: END GET_COMPLETION_TBL_SQL;
143:

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

168: l_drill_across_rep_2 := '''pFunctionName=ISC_DEPOT_COMP_DTL_TBL_REP&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=ITEM+ENI_ITEM&pParamIds=Y''';
169: END IF;
170:
171: l_sel_clause :=
172: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
173: l_description || ' BIV_ATTRIBUTE1
174: ,BIV_MEASURE1
175: ,BIV_MEASURE11
176: ,BIV_MEASURE2

Line 333: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

329: x_custom_sql OUT NOCOPY VARCHAR2,
330: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
331: IS
332:
333: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
334: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 334: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

330: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
331: IS
332:
333: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
334: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 335: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

331: IS
332:
333: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
334: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 336: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

332:
333: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
334: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 341: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_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;
345: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 342: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

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;
345: l_custom_rec BIS_QUERY_ATTRIBUTES;
346: l_mv_type VARCHAR2(10);

Line 349: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

345: l_custom_rec BIS_QUERY_ATTRIBUTES;
346: l_mv_type VARCHAR2(10);
347: l_err_stage VARCHAR2(32767);
348: l_debug_mode VARCHAR2(1);
349: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
350:
351: BEGIN
352: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
353: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

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,
363: x_view_by_col_name => l_view_by_col,
364: x_comparison_type => l_comparison_type,
365: x_xtd => l_xtd,

Line 379: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

375:
376:
377: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
378: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
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,

Line 416: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

412: p_in_join_tables => NULL);
413:
414: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
415: l_err_stage:='The query is : ' || l_query;
416: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
417: END IF;
418:
419: -- prepare output for bind variables
420: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 442: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

438:
439: WHEN OTHERS THEN
440: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
441: l_err_stage:='The exception is : ' || SQLERRM;
442: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TRD : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
443: END IF;
444:
445: END GET_COMPLETION_TRD_SQL;
446:

Line 507: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

503: x_custom_sql OUT NOCOPY VARCHAR2,
504: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
505: IS
506:
507: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
508: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 508: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

504: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
505: IS
506:
507: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
508: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 509: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

505: IS
506:
507: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
508: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 510: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

506:
507: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
508: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 515: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_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;
519: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 516: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

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;
519: l_custom_rec BIS_QUERY_ATTRIBUTES;
520: l_mv_type VARCHAR2(10);

Line 523: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

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

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

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,
536: x_view_by_col_name => l_view_by_col,
537: x_comparison_type => l_comparison_type,
538: x_xtd => l_xtd,

Line 551: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

547: x_custom_output => x_custom_output);
548:
549: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
550: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
551: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
552: END IF;
553:
554: l_query :=
555: 'SELECT

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

566: ,BIV_DATE2
567: ,BIV_MEASURE2
568: ,BIV_MEASURE3
569: ,''pFunctionName=CSD_RO_DETAILS&csdInvOrgId=''||BIV_MEASURE3||''&csdRepairLineId=''||BIV_MEASURE2 BIV_DYNAMIC_URL1
570: ,' || ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || ' || BIV_ATTRIBUTE8 BIV_DYNAMIC_URL2
571: FROM (
572: SELECT
573: rank() over (&ORDER_BY_CLAUSE nulls last,BIV_ATTRIBUTE1) - 1 rnk
574: ,BIV_ATTRIBUTE1

Line 618: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

614: ORDER BY rnk' || fnd_global.newline ;
615:
616: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
617: l_err_stage:='The query is : ' || l_query;
618: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
619: END IF;
620: x_custom_sql := l_query;
621:
622: EXCEPTION

Line 627: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

623:
624: WHEN OTHERS THEN
625: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
626: l_err_stage:='The exception is : ' || SQLERRM;
627: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
628: END IF;
629:
630: END GET_COMPLETION_DTL_TBL_SQL;
631:

Line 637: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

633: x_custom_sql OUT NOCOPY VARCHAR2,
634: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
635: IS
636:
637: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
638: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 638: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

634: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
635: IS
636:
637: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
638: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 639: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

635: IS
636:
637: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
638: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 640: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

636:
637: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
638: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 645: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_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;
649: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 646: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

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;
649: l_custom_rec BIS_QUERY_ATTRIBUTES;
650: l_mv_type VARCHAR2(10);

Line 653: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

649: l_custom_rec BIS_QUERY_ATTRIBUTES;
650: l_mv_type VARCHAR2(10);
651: l_err_stage VARCHAR2(32767);
652: l_debug_mode VARCHAR2(1);
653: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
654:
655: BEGIN
656: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
657: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

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,
666: x_view_by_col_name => l_view_by_col,
667: x_comparison_type => l_comparison_type,
668: x_xtd => l_xtd,

Line 681: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_LAT_COMP_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

677: x_custom_output => x_custom_output);
678:
679: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
680: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
681: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_LAT_COMP_DTL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
682: END IF;
683:
684: l_query :=
685: 'SELECT

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

697: ,BIV_MEASURE2
698: ,BIV_MEASURE3
699: ,BIV_MEASURE4
700: ,''pFunctionName=CSD_RO_DETAILS&csdInvOrgId=''||BIV_MEASURE4||''&csdRepairLineId=''||BIV_MEASURE3 BIV_DYNAMIC_URL1
701: ,' || ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || ' || BIV_ATTRIBUTE8 BIV_DYNAMIC_URL2
702: FROM (
703: SELECT
704: rank() over (&ORDER_BY_CLAUSE nulls last,BIV_ATTRIBUTE1 ) - 1 rnk
705: ,BIV_ATTRIBUTE1

Line 751: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_LAT_COMP_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

747: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
748: ORDER BY rnk' || fnd_global.newline ;
749: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
750: l_err_stage:='The query is : ' || l_query;
751: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_LAT_COMP_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
752: END IF;
753: x_custom_sql := l_query;
754:
755: EXCEPTION

Line 759: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_LAT_COMP_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

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

Line 769: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

765: x_custom_sql OUT NOCOPY VARCHAR2,
766: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
767: IS
768:
769: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
770: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 770: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

766: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
767: IS
768:
769: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
770: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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);

Line 771: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

767: IS
768:
769: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
770: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 772: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

768:
769: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
770: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
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;

Line 777: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_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;
781: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 778: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

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;
781: l_custom_rec BIS_QUERY_ATTRIBUTES;
782: l_mv_type VARCHAR2(10);

Line 786: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;

782: l_mv_type VARCHAR2(10);
783: l_err_stage VARCHAR2(32767);
784: l_function_name VARCHAR2(30);
785: l_debug_mode VARCHAR2(1);
786: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type ;
787:
788: BEGIN
789: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
790: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

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,
799: x_view_by_col_name => l_view_by_col,
800: x_comparison_type => l_comparison_type,
801: x_xtd => l_xtd,

Line 814: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

810: x_custom_output => x_custom_output);
811:
812: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
813: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
814: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
815: END IF;
816:
817: l_query := ' SELECT range_name BIV_ATTRIBUTE1 ' || fnd_global.newline ||
818: ' ,nvl(c_LATE_COMPLETE_COUNT,0) BIV_MEASURE1 ' || fnd_global.newline ||

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

936:
937: WHEN OTHERS THEN
938: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
939: l_err_stage:='The exception is : ' || SQLERRM;
940: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_BACKLOG_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
941: END IF;
942:
943: END GET_LAT_COMP_AGNG_TBL_SQL;
944: