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

Line 46: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

42: x_custom_sql OUT NOCOPY VARCHAR2,
43: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
44: ) IS
45:
46: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
47: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
48: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
49: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
50: l_comparison_type VARCHAR2(1);

Line 47: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

43: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
44: ) IS
45:
46: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
47: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
48: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
49: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
50: l_comparison_type VARCHAR2(1);
51: l_cur_suffix VARCHAR2(2);

Line 48: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

44: ) IS
45:
46: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
47: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
48: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
49: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
50: l_comparison_type VARCHAR2(1);
51: l_cur_suffix VARCHAR2(2);
52: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 49: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

45:
46: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
47: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
48: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
49: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
50: l_comparison_type VARCHAR2(1);
51: l_cur_suffix VARCHAR2(2);
52: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
53: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 54: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

50: l_comparison_type VARCHAR2(1);
51: l_cur_suffix VARCHAR2(2);
52: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
53: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
54: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
55: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
56: l_mv_set VARCHAR2(50);
57: l_aggregation_flag NUMBER;
58: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 55: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

51: l_cur_suffix VARCHAR2(2);
52: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
53: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
54: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
55: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
56: l_mv_set VARCHAR2(50);
57: l_aggregation_flag NUMBER;
58: l_custom_rec BIS_QUERY_ATTRIBUTES;
59: l_mv_type VARCHAR2(10);

Line 62: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

58: l_custom_rec BIS_QUERY_ATTRIBUTES;
59: l_mv_type VARCHAR2(10);
60: l_err_stage VARCHAR2(500);
61: l_debug_mode VARCHAR2(1);
62: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
63:
64: BEGIN
65: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
66: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

69: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
70: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
71:
72: -- get all the query parameters
73: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
74: x_view_by => l_view_by,
75: x_view_by_col_name => l_view_by_col,
76: x_comparison_type => l_comparison_type,
77: x_xtd => l_xtd,

Line 143: ISC_DEPOT_RPT_UTIL_PKG.write('get_ro_mrg_tbl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

139: l_err_stage := SQLERRM;
140:
141: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
142: l_err_stage:='The exception is : ';
143: ISC_DEPOT_RPT_UTIL_PKG.write('get_ro_mrg_tbl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
144: END IF;
145:
146: END get_ro_mrg_tbl_sql;
147:

Line 191: ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

187: END IF;
188:
189: l_sel_clause :=
190: ' SELECT ' ||
191: ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
192: l_description || ' BIV_ATTRIBUTE1 ' || fnd_global.newline || ', ' ||
193: 'BIV_MEASURE1 ' || fnd_global.newline || ', ' ||
194: 'BIV_MEASURE2 ' || fnd_global.newline || ', ' ||
195: 'BIV_MEASURE3 ' || fnd_global.newline || ', ' ||

Line 280: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

276: PROCEDURE get_ro_mrg_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
277: x_custom_sql OUT NOCOPY VARCHAR2,
278: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
279: IS
280: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
281: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
282: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
283: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
284: l_comparison_type VARCHAR2(1);

Line 281: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

277: x_custom_sql OUT NOCOPY VARCHAR2,
278: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
279: IS
280: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
281: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
282: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
283: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
284: l_comparison_type VARCHAR2(1);
285: l_cur_suffix VARCHAR2(2);

Line 282: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

278: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
279: IS
280: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
281: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
282: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
283: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
284: l_comparison_type VARCHAR2(1);
285: l_cur_suffix VARCHAR2(2);
286: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 283: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

279: IS
280: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
281: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
282: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
283: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
284: l_comparison_type VARCHAR2(1);
285: l_cur_suffix VARCHAR2(2);
286: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
287: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 288: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

284: l_comparison_type VARCHAR2(1);
285: l_cur_suffix VARCHAR2(2);
286: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
287: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
288: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
289: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
290: l_mv_set VARCHAR2(50);
291: l_aggregation_flag NUMBER;
292: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 289: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

285: l_cur_suffix VARCHAR2(2);
286: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
287: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
288: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
289: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
290: l_mv_set VARCHAR2(50);
291: l_aggregation_flag NUMBER;
292: l_custom_rec BIS_QUERY_ATTRIBUTES;
293: l_mv_type VARCHAR2(10);

Line 296: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

292: l_custom_rec BIS_QUERY_ATTRIBUTES;
293: l_mv_type VARCHAR2(10);
294: l_err_stage VARCHAR2(500);
295: l_debug_mode VARCHAR2(1);
296: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
297:
298: BEGIN
299: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
300: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

303: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
304: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
305:
306: -- get all the query parameters
307: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
308: x_view_by => l_view_by,
309: x_view_by_col_name => l_view_by_col,
310: x_comparison_type => l_comparison_type,
311: x_xtd => l_xtd,

Line 375: ISC_DEPOT_RPT_UTIL_PKG.write('get_ro_mrg_trd_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

371: l_err_stage := SQLERRM;
372:
373: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
374: l_err_stage:='The exception is : ';
375: ISC_DEPOT_RPT_UTIL_PKG.write('get_ro_mrg_trd_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
376: END IF;
377: END get_ro_mrg_trd_sql;
378:
379:

Line 428: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

424: x_custom_sql OUT NOCOPY VARCHAR2,
425: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
426: ) IS
427:
428: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
429: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
430: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
431: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
432: l_comparison_type VARCHAR2(1);

Line 429: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

425: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
426: ) IS
427:
428: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
429: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
430: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
431: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
432: l_comparison_type VARCHAR2(1);
433: l_cur_suffix VARCHAR2(2);

Line 430: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

426: ) IS
427:
428: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
429: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
430: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
431: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
432: l_comparison_type VARCHAR2(1);
433: l_cur_suffix VARCHAR2(2);
434: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 431: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

427:
428: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
429: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
430: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
431: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
432: l_comparison_type VARCHAR2(1);
433: l_cur_suffix VARCHAR2(2);
434: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
435: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 436: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

432: l_comparison_type VARCHAR2(1);
433: l_cur_suffix VARCHAR2(2);
434: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
435: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
436: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
437: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
438: l_mv_set VARCHAR2(50);
439: l_aggregation_flag NUMBER;
440: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 437: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

433: l_cur_suffix VARCHAR2(2);
434: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
435: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
436: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
437: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
438: l_mv_set VARCHAR2(50);
439: l_aggregation_flag NUMBER;
440: l_custom_rec BIS_QUERY_ATTRIBUTES;
441: l_mv_type VARCHAR2(10);

Line 444: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

440: l_custom_rec BIS_QUERY_ATTRIBUTES;
441: l_mv_type VARCHAR2(10);
442: l_err_stage VARCHAR2(500);
443: l_debug_mode VARCHAR2(1);
444: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
445:
446: BEGIN
447: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
448: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

451: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
452: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
453:
454: -- get all the query parameters
455: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
456: x_view_by => l_view_by,
457: x_view_by_col_name => l_view_by_col,
458: x_comparison_type => l_comparison_type,
459: x_xtd => l_xtd,

Line 527: ISC_DEPOT_RPT_UTIL_PKG.write('get_chg_summ_tbl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

523: l_err_stage := SQLERRM;
524:
525: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
526: l_err_stage:='The exception is : ';
527: ISC_DEPOT_RPT_UTIL_PKG.write('get_chg_summ_tbl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
528: END IF;
529:
530: END get_chg_summ_tbl_sql;
531:

Line 565: ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

561: END IF;
562:
563: l_sel_clause :=
564: ' SELECT ' ||
565: ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
566: l_description || ' BIV_ATTRIBUTE1 ' || fnd_global.newline || ',' ||
567: 'BIV_MEASURE1 ' || fnd_global.newline || ',' ||
568: 'BIV_MEASURE2 ' || fnd_global.newline || ',' ||
569: 'BIV_MEASURE3 ' || fnd_global.newline || ',' ||

Line 636: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

632: PROCEDURE get_chg_summ_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
633: x_custom_sql OUT NOCOPY VARCHAR2,
634: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
635: IS
636: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
637: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
638: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
639: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
640: l_comparison_type VARCHAR2(1);

Line 637: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

633: x_custom_sql OUT NOCOPY VARCHAR2,
634: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
635: IS
636: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
637: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
638: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
639: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
640: l_comparison_type VARCHAR2(1);
641: l_cur_suffix VARCHAR2(2);

Line 638: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

634: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
635: IS
636: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
637: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
638: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
639: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
640: l_comparison_type VARCHAR2(1);
641: l_cur_suffix VARCHAR2(2);
642: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 639: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

635: IS
636: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
637: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
638: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
639: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
640: l_comparison_type VARCHAR2(1);
641: l_cur_suffix VARCHAR2(2);
642: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
643: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 644: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

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

Line 645: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

641: l_cur_suffix VARCHAR2(2);
642: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
643: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
644: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
645: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
646: l_mv_set VARCHAR2(50);
647: l_aggregation_flag NUMBER;
648: l_custom_rec BIS_QUERY_ATTRIBUTES;
649: l_mv_type VARCHAR2(10);

Line 652: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

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

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

659: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
660: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
661:
662: -- get all the query parameters
663: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
664: x_view_by => l_view_by,
665: x_view_by_col_name => l_view_by_col,
666: x_comparison_type => l_comparison_type,
667: x_xtd => l_xtd,

Line 734: ISC_DEPOT_RPT_UTIL_PKG.write('get_chg_summ_trd_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

730: l_err_stage := SQLERRM;
731:
732: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
733: l_err_stage:='The exception is : ';
734: ISC_DEPOT_RPT_UTIL_PKG.write('get_chg_summ_trd_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
735: END IF;
736:
737: END get_chg_summ_trd_sql;
738:

Line 781: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

777: x_custom_sql OUT NOCOPY VARCHAR2,
778: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
779: ) IS
780:
781: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
782: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
783: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
784: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
785: l_comparison_type VARCHAR2(1);

Line 782: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

778: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
779: ) IS
780:
781: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
782: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
783: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
784: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
785: l_comparison_type VARCHAR2(1);
786: l_cur_suffix VARCHAR2(2);

Line 783: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

779: ) IS
780:
781: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
782: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
783: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
784: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
785: l_comparison_type VARCHAR2(1);
786: l_cur_suffix VARCHAR2(2);
787: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 784: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

780:
781: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
782: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
783: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
784: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
785: l_comparison_type VARCHAR2(1);
786: l_cur_suffix VARCHAR2(2);
787: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
788: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 789: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

785: l_comparison_type VARCHAR2(1);
786: l_cur_suffix VARCHAR2(2);
787: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
788: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
789: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
790: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
791: l_mv_set VARCHAR2(50);
792: l_aggregation_flag NUMBER;
793: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 790: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

786: l_cur_suffix VARCHAR2(2);
787: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
788: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
789: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
790: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
791: l_mv_set VARCHAR2(50);
792: l_aggregation_flag NUMBER;
793: l_custom_rec BIS_QUERY_ATTRIBUTES;
794: l_mv_type VARCHAR2(10);

Line 797: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

793: l_custom_rec BIS_QUERY_ATTRIBUTES;
794: l_mv_type VARCHAR2(10);
795: l_err_stage VARCHAR2(500);
796: l_debug_mode VARCHAR2(1);
797: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
798:
799: BEGIN
800: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
801: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

805: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
806: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
807:
808: -- get all the query parameters
809: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
810: x_view_by => l_view_by,
811: x_view_by_col_name => l_view_by_col,
812: x_comparison_type => l_comparison_type,
813: x_xtd => l_xtd,

Line 880: ISC_DEPOT_RPT_UTIL_PKG.write('get_cst_summ_tbl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

876: l_err_stage := SQLERRM;
877:
878: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
879: l_err_stage:='The exception is : ';
880: ISC_DEPOT_RPT_UTIL_PKG.write('get_cst_summ_tbl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
881: END IF;
882:
883: END get_cst_summ_tbl_sql;
884:

Line 918: ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

914: END IF;
915:
916: l_sel_clause :=
917: ' SELECT ' ||
918: ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
919: l_description || ' BIV_ATTRIBUTE1 ' || fnd_global.newline || ',' ||
920: 'BIV_MEASURE1 ' || fnd_global.newline || ',' ||
921: 'BIV_MEASURE2 ' || fnd_global.newline || ',' ||
922: 'BIV_MEASURE3 ' || fnd_global.newline || ',' ||

Line 988: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

984: PROCEDURE get_cst_summ_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
985: x_custom_sql OUT NOCOPY VARCHAR2,
986: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
987: IS
988: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
989: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
990: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
991: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
992: l_comparison_type VARCHAR2(1);

Line 989: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

985: x_custom_sql OUT NOCOPY VARCHAR2,
986: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
987: IS
988: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
989: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
990: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
991: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
992: l_comparison_type VARCHAR2(1);
993: l_cur_suffix VARCHAR2(2);

Line 990: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

986: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
987: IS
988: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
989: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
990: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
991: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
992: l_comparison_type VARCHAR2(1);
993: l_cur_suffix VARCHAR2(2);
994: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 991: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

987: IS
988: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
989: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
990: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
991: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
992: l_comparison_type VARCHAR2(1);
993: l_cur_suffix VARCHAR2(2);
994: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
995: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 996: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

992: l_comparison_type VARCHAR2(1);
993: l_cur_suffix VARCHAR2(2);
994: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
995: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
996: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
997: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
998: l_mv_set VARCHAR2(50);
999: l_aggregation_flag NUMBER;
1000: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 997: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

993: l_cur_suffix VARCHAR2(2);
994: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
995: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
996: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
997: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
998: l_mv_set VARCHAR2(50);
999: l_aggregation_flag NUMBER;
1000: l_custom_rec BIS_QUERY_ATTRIBUTES;
1001: l_mv_type VARCHAR2(10);

Line 1004: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

1000: l_custom_rec BIS_QUERY_ATTRIBUTES;
1001: l_mv_type VARCHAR2(10);
1002: l_err_stage VARCHAR2(500);
1003: l_debug_mode VARCHAR2(1);
1004: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1005:
1006: BEGIN
1007: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1008: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

1011: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1012: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1013:
1014: -- get all the query parameters
1015: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
1016: x_view_by => l_view_by,
1017: x_view_by_col_name => l_view_by_col,
1018: x_comparison_type => l_comparison_type,
1019: x_xtd => l_xtd,

Line 1085: ISC_DEPOT_RPT_UTIL_PKG.write('get_cst_summ_trd_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

1081: l_err_stage := SQLERRM;
1082:
1083: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1084: l_err_stage:='The exception is : ';
1085: ISC_DEPOT_RPT_UTIL_PKG.write('get_cst_summ_trd_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1086: END IF;
1087:
1088: END get_cst_summ_trd_sql;
1089:

Line 1132: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

1128: x_custom_sql OUT NOCOPY VARCHAR2,
1129: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
1130: ) IS
1131:
1132: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1133: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1134: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1135: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1136: l_comparison_type VARCHAR2(1);

Line 1133: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

1129: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
1130: ) IS
1131:
1132: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1133: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1134: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1135: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1136: l_comparison_type VARCHAR2(1);
1137: l_cur_suffix VARCHAR2(2);

Line 1134: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

1130: ) IS
1131:
1132: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1133: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1134: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1135: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1136: l_comparison_type VARCHAR2(1);
1137: l_cur_suffix VARCHAR2(2);
1138: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 1135: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

1131:
1132: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1133: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1134: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1135: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1136: l_comparison_type VARCHAR2(1);
1137: l_cur_suffix VARCHAR2(2);
1138: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1139: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 1140: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

1136: l_comparison_type VARCHAR2(1);
1137: l_cur_suffix VARCHAR2(2);
1138: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1139: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1140: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
1141: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
1142: l_mv_set VARCHAR2(50);
1143: l_aggregation_flag NUMBER;
1144: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1141: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

1137: l_cur_suffix VARCHAR2(2);
1138: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1139: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1140: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
1141: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
1142: l_mv_set VARCHAR2(50);
1143: l_aggregation_flag NUMBER;
1144: l_custom_rec BIS_QUERY_ATTRIBUTES;
1145: l_mv_type VARCHAR2(10);

Line 1148: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

1144: l_custom_rec BIS_QUERY_ATTRIBUTES;
1145: l_mv_type VARCHAR2(10);
1146: l_err_stage VARCHAR2(500);
1147: l_debug_mode VARCHAR2(1);
1148: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1149: l_supress VARCHAR2 (200);
1150:
1151: BEGIN
1152: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

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

1157: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1158: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1159:
1160: -- get all the query parameters
1161: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
1162: x_view_by => l_view_by,
1163: x_view_by_col_name => l_view_by_col,
1164: x_comparison_type => l_comparison_type,
1165: x_xtd => l_xtd,

Line 1240: ISC_DEPOT_RPT_UTIL_PKG.write('get_mrg_summ_tbl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

1236: l_err_stage := SQLERRM;
1237:
1238: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1239: l_err_stage:='The exception is : ';
1240: ISC_DEPOT_RPT_UTIL_PKG.write('get_mrg_summ_tbl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1241: END IF;
1242:
1243: END get_mrg_summ_tbl_sql;
1244:

Line 1278: ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

1274: END IF;
1275:
1276: l_sel_clause :=
1277: ' SELECT ' ||
1278: ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
1279: l_description || ' BIV_ATTRIBUTE1 ' || fnd_global.newline || ',' ||
1280: 'BIV_MEASURE1 ' || fnd_global.newline || ',' ||
1281: 'BIV_MEASURE2 ' || fnd_global.newline || ',' ||
1282: 'BIV_MEASURE3 ' || fnd_global.newline || ',' ||

Line 1349: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

1345: PROCEDURE get_mrg_summ_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1346: x_custom_sql OUT NOCOPY VARCHAR2,
1347: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1348: IS
1349: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1350: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1351: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1352: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1353: l_comparison_type VARCHAR2(1);

Line 1350: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

1346: x_custom_sql OUT NOCOPY VARCHAR2,
1347: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1348: IS
1349: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1350: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1351: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1352: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1353: l_comparison_type VARCHAR2(1);
1354: l_cur_suffix VARCHAR2(2);

Line 1351: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

1347: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1348: IS
1349: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1350: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1351: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1352: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1353: l_comparison_type VARCHAR2(1);
1354: l_cur_suffix VARCHAR2(2);
1355: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 1352: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

1348: IS
1349: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1350: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1351: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1352: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1353: l_comparison_type VARCHAR2(1);
1354: l_cur_suffix VARCHAR2(2);
1355: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1356: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 1357: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

1353: l_comparison_type VARCHAR2(1);
1354: l_cur_suffix VARCHAR2(2);
1355: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1356: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1357: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
1358: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
1359: l_mv_set VARCHAR2(50);
1360: l_aggregation_flag NUMBER;
1361: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1358: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

1354: l_cur_suffix VARCHAR2(2);
1355: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1356: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1357: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
1358: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
1359: l_mv_set VARCHAR2(50);
1360: l_aggregation_flag NUMBER;
1361: l_custom_rec BIS_QUERY_ATTRIBUTES;
1362: l_mv_type VARCHAR2(10);

Line 1365: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

1361: l_custom_rec BIS_QUERY_ATTRIBUTES;
1362: l_mv_type VARCHAR2(10);
1363: l_err_stage VARCHAR2(500);
1364: l_debug_mode VARCHAR2(1);
1365: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1366:
1367: BEGIN
1368: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1369: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

1372: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1373: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1374:
1375: -- get all the query parameters
1376: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
1377: x_view_by => l_view_by,
1378: x_view_by_col_name => l_view_by_col,
1379: x_comparison_type => l_comparison_type,
1380: x_xtd => l_xtd,

Line 1450: ISC_DEPOT_RPT_UTIL_PKG.write('get_mrg_summ_trd_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

1446: l_err_stage := SQLERRM;
1447:
1448: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1449: l_err_stage:='The exception is : ';
1450: ISC_DEPOT_RPT_UTIL_PKG.write('get_mrg_summ_trd_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1451: END IF;
1452:
1453: END get_mrg_summ_trd_sql;
1454:

Line 1497: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;

1493: x_custom_sql OUT NOCOPY VARCHAR2,
1494: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
1495: ) IS
1496:
1497: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1498: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1499: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1500: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1501: l_comparison_type VARCHAR2(1);

Line 1498: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;

1494: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
1495: ) IS
1496:
1497: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1498: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1499: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1500: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1501: l_comparison_type VARCHAR2(1);
1502: l_cur_suffix VARCHAR2(2);

Line 1499: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;

1495: ) IS
1496:
1497: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1498: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1499: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1500: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1501: l_comparison_type VARCHAR2(1);
1502: l_cur_suffix VARCHAR2(2);
1503: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

Line 1500: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;

1496:
1497: l_query ISC_DEPOT_RPT_UTIL_PKG.g_query_typ%type;
1498: l_view_by ISC_DEPOT_RPT_UTIL_PKG.g_view_by_typ%type;
1499: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
1500: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
1501: l_comparison_type VARCHAR2(1);
1502: l_cur_suffix VARCHAR2(2);
1503: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1504: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

Line 1505: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;

1501: l_comparison_type VARCHAR2(1);
1502: l_cur_suffix VARCHAR2(2);
1503: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1504: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1505: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
1506: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
1507: l_mv_set VARCHAR2(50);
1508: l_aggregation_flag NUMBER;
1509: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1506: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;

1502: l_cur_suffix VARCHAR2(2);
1503: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1504: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1505: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
1506: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
1507: l_mv_set VARCHAR2(50);
1508: l_aggregation_flag NUMBER;
1509: l_custom_rec BIS_QUERY_ATTRIBUTES;
1510: l_mv_type VARCHAR2(10);

Line 1513: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;

1509: l_custom_rec BIS_QUERY_ATTRIBUTES;
1510: l_mv_type VARCHAR2(10);
1511: l_err_stage VARCHAR2(500);
1512: l_debug_mode VARCHAR2(1);
1513: l_module_name ISC_DEPOT_RPT_UTIL_PKG.g_module_name_typ%type;
1514:
1515: BEGIN
1516: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1517: l_module_name := FND_PROFILE.value('AFLOG_MODULE');

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

1520: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1521: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1522:
1523: -- get all the query parameters
1524: ISC_DEPOT_RPT_UTIL_PKG.process_parameters (p_param => p_param,
1525: x_view_by => l_view_by,
1526: x_view_by_col_name => l_view_by_col,
1527: x_comparison_type => l_comparison_type,
1528: x_xtd => l_xtd,

Line 1569: ISC_DEPOT_RPT_UTIL_PKG.write('get_mrg_dtl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

1565: l_err_stage := SQLERRM;
1566:
1567: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1568: l_err_stage:='The exception is : ';
1569: ISC_DEPOT_RPT_UTIL_PKG.write('get_mrg_dtl_sql : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
1570: END IF;
1571: END get_mrg_dtl_tbl_sql;
1572:
1573: FUNCTION get_mrg_dtl_sel_clause (p_curr_suffix IN VARCHAR2)

Line 1649: ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || '|| BIV_ATTRIBUTE5 BIV_DYNAMIC_URL2 '||

1645: 'BIV_MEASURE28 ' || fnd_global.newline || ', ' ||
1646: 'BIV_MEASURE29 ' || fnd_global.newline || ', ' ||
1647: 'BIV_MEASURE30 ' || fnd_global.newline || ', ' ||
1648: '''pFunctionName=CSD_RO_DETAILS&csdInvOrgId=''||BIV_MEASURE30||''&csdRepairLineId=''||BIV_MEASURE29 BIV_DYNAMIC_URL1'|| ', '||
1649: ISC_DEPOT_RPT_UTIL_PKG.get_service_request_url || '|| BIV_ATTRIBUTE5 BIV_DYNAMIC_URL2 '||
1650: ' FROM ( ' || fnd_global.newline ||
1651: 'SELECT ' || fnd_global.newline ||
1652: 'rank() over (&ORDER_BY_CLAUSE nulls last ,BIV_ATTRIBUTE1) - 1 rnk ' || fnd_global.newline || ', ' ||
1653: 'BIV_ATTRIBUTE1 ' || fnd_global.newline || ', ' ||