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_FS_TRV_TIM_DIS_VAR_RPT_PKG dependencies on ISC_FS_RPT_UTIL_PKG

Line 91: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

87: , x_custom_output out nocopy bis_query_attributes_tbl
88: )
89: is
90:
91: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
92: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
93: l_custom_output bis_query_attributes_tbl;
94: l_curr_suffix varchar2(3);
95: l_where_clause varchar2(10000);

Line 116: isc_fs_rpt_util_pkg.register_dimension_levels

112:
113: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
114: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
115:
116: isc_fs_rpt_util_pkg.register_dimension_levels
117: ( l_dimension_tbl
118: , l_dim_filter_map
119: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
120: );

Line 119: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'

115:
116: isc_fs_rpt_util_pkg.register_dimension_levels
117: ( l_dimension_tbl
118: , l_dim_filter_map
119: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
120: );
121:
122: isc_fs_rpt_util_pkg.process_parameters
123: ( p_param => p_param

Line 122: isc_fs_rpt_util_pkg.process_parameters

118: , l_dim_filter_map
119: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
120: );
121:
122: isc_fs_rpt_util_pkg.process_parameters
123: ( p_param => p_param
124: , p_dimension_tbl => l_dimension_tbl
125: , p_dim_filter_map => l_dim_filter_map
126: , p_trend => 'N'

Line 180: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value

176: , p_to_date_type => l_to_date_type
177: , x_bucket_rec => l_bucket_rec
178: );
179:
180: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value
181: ( p_param
182: , 'VIEW_BY'
183: );
184:

Line 187: , ' || isc_fs_rpt_util_pkg.get_district_drill_down

183: );
184:
185: l_stmt := 'select
186: ' || l_viewby_select || '
187: , ' || isc_fs_rpt_util_pkg.get_district_drill_down
188: ( l_view_by
189: , g_task_tim_var_tbl_func
190: , 'ISC_ATTRIBUTE_2'
191: ) || '

Line 192: , ' || isc_fs_rpt_util_pkg.get_detail_drill_down

188: ( l_view_by
189: , g_task_tim_var_tbl_func
190: , 'ISC_ATTRIBUTE_2'
191: ) || '
192: , ' || isc_fs_rpt_util_pkg.get_detail_drill_down
193: ( p_view_by => l_view_by
194: , p_function_name => g_task_tim_var_dtr_tbl_func
195: , p_check_column_name => 'ISC_MEASURE_4'
196: , p_column_alias => 'ISC_ATTRIBUTE_3'

Line 199: , ' || isc_fs_rpt_util_pkg.get_bucket_drill_down

195: , p_check_column_name => 'ISC_MEASURE_4'
196: , p_column_alias => 'ISC_ATTRIBUTE_3'
197: , p_check_resource => 'Y'
198: ) || '
199: , ' || isc_fs_rpt_util_pkg.get_bucket_drill_down
200: ( p_bucket_rec => l_bucket_rec
201: , p_view_by => l_view_by
202: , p_function_name => g_task_tim_dtl_func
203: , p_check_column_name => 'ISC_MEASURE_5'

Line 227: else ' || isc_fs_rpt_util_pkg.change_column

223: , ISC_MEASURE_21
224: , ISC_MEASURE_22
225: , case nvl(isc_measure_22,0) * nvl(isc_measure_21,0)
226: when 0 then null
227: else ' || isc_fs_rpt_util_pkg.change_column
228: ( 'abs(isc_measure_22 - isc_measure_21)'
229: , 'prior_diff_total'
230: , null
231: , 'Y'

Line 246: row_number() over(&ORDER_BY_CLAUSE nulls last , '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk

242: ) || '
243: , abs( isc_measure_22 - isc_measure_21) ISC_MEASURE_26
244: from (
245: select
246: row_number() over(&ORDER_BY_CLAUSE nulls last , '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
247: ,iset.* from ( select * from (
248: select
249: record_type
250: , district_id

Line 252: , ' || isc_fs_rpt_util_pkg.rate_column

248: select
249: record_type
250: , district_id
251: , district_id_c
252: , ' || isc_fs_rpt_util_pkg.rate_column
253: ( 'c_tot_trv_dur_min_sch'
254: , 'c_count_dur_task'
255: , 'ISC_MEASURE_1'
256: , 'N'

Line 258: , ' || isc_fs_rpt_util_pkg.rate_column

254: , 'c_count_dur_task'
255: , 'ISC_MEASURE_1'
256: , 'N'
257: ) || '
258: , ' || isc_fs_rpt_util_pkg.rate_column
259: ( 'c_tot_trv_dur_min_act'
260: , 'c_count_dur_task'
261: , 'ISC_MEASURE_2'
262: , 'N'

Line 264: , ' || isc_fs_rpt_util_pkg.rate_column

260: , 'c_count_dur_task'
261: , 'ISC_MEASURE_2'
262: , 'N'
263: ) || '
264: , ' || isc_fs_rpt_util_pkg.rate_column
265: ( 'abs(p_tot_trv_dur_min_act - p_tot_trv_dur_min_sch)'
266: , 'p_count_dur_task'
267: , 'ISC_MEASURE_13'
268: , 'N'

Line 270: , ' || isc_fs_rpt_util_pkg.rate_column

266: , 'p_count_dur_task'
267: , 'ISC_MEASURE_13'
268: , 'N'
269: ) || '
270: , ' || isc_fs_rpt_util_pkg.rate_column
271: ( 'abs(c_tot_trv_dur_min_act - c_tot_trv_dur_min_sch)'
272: , 'c_count_dur_task'
273: , 'ISC_MEASURE_3'
274: , 'N'

Line 278: else ' || isc_fs_rpt_util_pkg.change_column

274: , 'N'
275: ) || '
276: , case nvl(c_tot_trv_dur_min_act,0) * nvl(c_tot_trv_dur_min_sch,0)
277: when 0 then null
278: else ' || isc_fs_rpt_util_pkg.change_column
279: ( isc_fs_rpt_util_pkg.rate_column
280: ( 'abs(c_tot_trv_dur_min_act - c_tot_trv_dur_min_sch )'
281: , 'c_count_dur_task'
282: , null

Line 279: ( isc_fs_rpt_util_pkg.rate_column

275: ) || '
276: , case nvl(c_tot_trv_dur_min_act,0) * nvl(c_tot_trv_dur_min_sch,0)
277: when 0 then null
278: else ' || isc_fs_rpt_util_pkg.change_column
279: ( isc_fs_rpt_util_pkg.rate_column
280: ( 'abs(c_tot_trv_dur_min_act - c_tot_trv_dur_min_sch )'
281: , 'c_count_dur_task'
282: , null
283: , 'N'

Line 285: , isc_fs_rpt_util_pkg.rate_column

281: , 'c_count_dur_task'
282: , null
283: , 'N'
284: )
285: , isc_fs_rpt_util_pkg.rate_column
286: ( 'abs(p_tot_trv_dur_min_act - p_tot_trv_dur_min_sch )'
287: , 'p_count_dur_task'
288: , null
289: , 'N'

Line 304: , ' || isc_fs_rpt_util_pkg.rate_column

300: , p_prefix => 'c_'
301: , p_suffix => '/abs(decode(nvl(c_count_dur_task,0),0,1,c_count_dur_task))*100'
302: , p_total_flag => 'N'
303: ) ||'
304: , ' || isc_fs_rpt_util_pkg.rate_column
305: ( 'c_tot_trv_dur_min_sch_total'
306: , 'c_count_dur_task_total'
307: , 'ISC_MEASURE_21'
308: , 'N'

Line 310: , ' || isc_fs_rpt_util_pkg.rate_column

306: , 'c_count_dur_task_total'
307: , 'ISC_MEASURE_21'
308: , 'N'
309: ) || '
310: , ' || isc_fs_rpt_util_pkg.rate_column
311: ( 'c_tot_trv_dur_min_act_total'
312: , 'c_count_dur_task_total'
313: , 'ISC_MEASURE_22'
314: , 'N'

Line 316: , ' || isc_fs_rpt_util_pkg.rate_column

312: , 'c_count_dur_task_total'
313: , 'ISC_MEASURE_22'
314: , 'N'
315: ) || '
316: , ' || isc_fs_rpt_util_pkg.rate_column
317: ( 'abs(p_tot_trv_dur_min_act_total - p_tot_trv_dur_min_sch_total) '
318: , 'p_count_dur_task_total'
319: , 'prior_diff_total'
320: , 'N'

Line 343: --l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);

339: , p_filter_where => '1=1 ) iset '
340: , p_generate_viewby => 'Y'
341: );
342:
343: --l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
344:
345: poa_dbi_util_pkg.get_custom_rolling_binds
346: ( p_custom_output => l_custom_output
347: , p_xtd => l_xtd

Line 350: isc_fs_rpt_util_pkg.enhance_time_join

346: ( p_custom_output => l_custom_output
347: , p_xtd => l_xtd
348: );
349:
350: isc_fs_rpt_util_pkg.enhance_time_join
351: ( p_query => l_stmt
352: , p_trend => 'N'
353: );
354:

Line 367: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

363: , x_custom_output out nocopy bis_query_attributes_tbl
364: )
365: is
366:
367: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
368: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
369: l_custom_output bis_query_attributes_tbl;
370: l_curr_suffix varchar2(3);
371: l_where_clause varchar2(10000);

Line 392: isc_fs_rpt_util_pkg.register_dimension_levels

388:
389: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
390: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
391:
392: isc_fs_rpt_util_pkg.register_dimension_levels
393: ( l_dimension_tbl
394: , l_dim_filter_map
395: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
396: );

Line 395: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'

391:
392: isc_fs_rpt_util_pkg.register_dimension_levels
393: ( l_dimension_tbl
394: , l_dim_filter_map
395: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
396: );
397:
398: isc_fs_rpt_util_pkg.process_parameters
399: ( p_param => p_param

Line 398: isc_fs_rpt_util_pkg.process_parameters

394: , l_dim_filter_map
395: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
396: );
397:
398: isc_fs_rpt_util_pkg.process_parameters
399: ( p_param => p_param
400: , p_dimension_tbl => l_dimension_tbl
401: , p_dim_filter_map => l_dim_filter_map
402: , p_trend => 'N'

Line 457: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value

453: , p_to_date_type => l_to_date_type
454: , x_bucket_rec => l_bucket_rec
455: );
456:
457: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value
458: ( p_param
459: , 'VIEW_BY'
460: );
461:

Line 464: , ' || isc_fs_rpt_util_pkg.get_district_drill_down

460: );
461:
462: l_stmt := 'select
463: ' || l_viewby_select || '
464: , ' || isc_fs_rpt_util_pkg.get_district_drill_down
465: ( l_view_by
466: , g_task_dis_var_tbl_func
467: , 'ISC_ATTRIBUTE_2'
468: ) || '

Line 469: , ' || isc_fs_rpt_util_pkg.get_detail_drill_down

465: ( l_view_by
466: , g_task_dis_var_tbl_func
467: , 'ISC_ATTRIBUTE_2'
468: ) || '
469: , ' || isc_fs_rpt_util_pkg.get_detail_drill_down
470: ( p_view_by => l_view_by
471: , p_function_name => g_task_dis_var_dtr_tbl_func
472: , p_check_column_name => 'ISC_MEASURE_4'
473: , p_column_alias => 'ISC_ATTRIBUTE_3'

Line 476: , ' || isc_fs_rpt_util_pkg.get_bucket_drill_down

472: , p_check_column_name => 'ISC_MEASURE_4'
473: , p_column_alias => 'ISC_ATTRIBUTE_3'
474: , p_check_resource => 'Y'
475: ) || '
476: , ' || isc_fs_rpt_util_pkg.get_bucket_drill_down
477: ( p_bucket_rec => l_bucket_rec
478: , p_view_by => l_view_by
479: , p_function_name => g_task_tim_dtl_func
480: , p_check_column_name => 'ISC_MEASURE_5'

Line 504: else ' || isc_fs_rpt_util_pkg.change_column

500: , ISC_MEASURE_21
501: , ISC_MEASURE_22
502: , case nvl(isc_measure_22,0) * nvl(isc_measure_21,0)
503: when 0 then null
504: else ' || isc_fs_rpt_util_pkg.change_column
505: ( 'abs(isc_measure_22 - isc_measure_21)'
506: , 'prior_diff_total'
507: , null
508: , 'Y'

Line 523: row_number() over(&ORDER_BY_CLAUSE nulls last , '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk

519: ) || '
520: , abs( isc_measure_22 - isc_measure_21 ) ISC_MEASURE_26
521: from (
522: select
523: row_number() over(&ORDER_BY_CLAUSE nulls last , '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
524: , iset.* from ( select * from (
525: select
526: record_type
527: , district_id

Line 529: , ' || isc_fs_rpt_util_pkg.rate_column

525: select
526: record_type
527: , district_id
528: , district_id_c
529: , ' || isc_fs_rpt_util_pkg.rate_column
530: ( 'c_tot_trv_dist_sch'
531: , 'c_count_dist_task'
532: , 'ISC_MEASURE_1'
533: , 'N'

Line 535: , ' || isc_fs_rpt_util_pkg.rate_column

531: , 'c_count_dist_task'
532: , 'ISC_MEASURE_1'
533: , 'N'
534: ) || '
535: , ' || isc_fs_rpt_util_pkg.rate_column
536: ( 'c_tot_trv_dist_act'
537: , 'c_count_dist_task'
538: , 'ISC_MEASURE_2'
539: , 'N'

Line 541: , ' || isc_fs_rpt_util_pkg.rate_column

537: , 'c_count_dist_task'
538: , 'ISC_MEASURE_2'
539: , 'N'
540: ) || '
541: , ' || isc_fs_rpt_util_pkg.rate_column
542: ( 'abs(p_tot_trv_dist_act - p_tot_trv_dist_sch)'
543: , 'p_count_dist_task'
544: , 'ISC_MEASURE_13'
545: , 'N'

Line 547: , ' || isc_fs_rpt_util_pkg.rate_column

543: , 'p_count_dist_task'
544: , 'ISC_MEASURE_13'
545: , 'N'
546: ) || '
547: , ' || isc_fs_rpt_util_pkg.rate_column
548: ( 'abs(c_tot_trv_dist_act - c_tot_trv_dist_sch)'
549: , 'c_count_dist_task'
550: , 'ISC_MEASURE_3'
551: , 'N'

Line 555: else ' || isc_fs_rpt_util_pkg.change_column

551: , 'N'
552: ) || '
553: , case nvl(c_tot_trv_dist_act,0) * nvl(p_tot_trv_dist_sch,0)
554: when 0 then NULL
555: else ' || isc_fs_rpt_util_pkg.change_column
556: ( isc_fs_rpt_util_pkg.rate_column
557: ( 'abs(c_tot_trv_dist_act - c_tot_trv_dist_sch)'
558: , 'c_count_dist_task'
559: , null

Line 556: ( isc_fs_rpt_util_pkg.rate_column

552: ) || '
553: , case nvl(c_tot_trv_dist_act,0) * nvl(p_tot_trv_dist_sch,0)
554: when 0 then NULL
555: else ' || isc_fs_rpt_util_pkg.change_column
556: ( isc_fs_rpt_util_pkg.rate_column
557: ( 'abs(c_tot_trv_dist_act - c_tot_trv_dist_sch)'
558: , 'c_count_dist_task'
559: , null
560: , 'N'

Line 562: , isc_fs_rpt_util_pkg.rate_column

558: , 'c_count_dist_task'
559: , null
560: , 'N'
561: )
562: , isc_fs_rpt_util_pkg.rate_column
563: ( 'abs(p_tot_trv_dist_act - p_tot_trv_dist_sch)'
564: , 'p_count_dist_task'
565: , null
566: , 'N'

Line 581: , ' || isc_fs_rpt_util_pkg.rate_column

577: , p_prefix => 'c_'
578: , p_suffix => '/abs(decode(nvl(c_count_dist_task,0),0,1,c_count_dist_task))*100'
579: , p_total_flag => 'N'
580: ) || '
581: , ' || isc_fs_rpt_util_pkg.rate_column
582: ( 'c_tot_trv_dist_sch_total'
583: , 'c_count_dist_task_total'
584: , 'ISC_MEASURE_21'
585: , 'N'

Line 587: , ' || isc_fs_rpt_util_pkg.rate_column

583: , 'c_count_dist_task_total'
584: , 'ISC_MEASURE_21'
585: , 'N'
586: ) || '
587: , ' || isc_fs_rpt_util_pkg.rate_column
588: ( 'c_tot_trv_dist_act_total'
589: , 'c_count_dist_task_total'
590: , 'ISC_MEASURE_22'
591: , 'N'

Line 593: , ' || isc_fs_rpt_util_pkg.rate_column

589: , 'c_count_dist_task_total'
590: , 'ISC_MEASURE_22'
591: , 'N'
592: ) || '
593: , ' || isc_fs_rpt_util_pkg.rate_column
594: ( 'abs(p_tot_trv_dist_act_total-p_tot_trv_dist_sch_total)'
595: , 'p_count_dist_task_total'
596: , 'prior_diff_total'
597: , 'N'

Line 620: --l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);

616: , p_filter_where => '1=1 ) iset '
617: , p_generate_viewby => 'Y'
618: );
619:
620: --l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
621:
622: poa_dbi_util_pkg.get_custom_rolling_binds
623: ( p_custom_output => l_custom_output
624: , p_xtd => l_xtd

Line 627: isc_fs_rpt_util_pkg.enhance_time_join

623: ( p_custom_output => l_custom_output
624: , p_xtd => l_xtd
625: );
626:
627: isc_fs_rpt_util_pkg.enhance_time_join
628: ( p_query => l_stmt
629: , p_trend => 'N'
630: );
631:

Line 644: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

640: , x_custom_output out nocopy bis_query_attributes_tbl
641: )
642: is
643:
644: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
645: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
646: l_dim_bmap number;
647: l_comparison_type varchar2(200);
648: l_xtd varchar2(200);

Line 666: l_detail_col_tbl isc_fs_rpt_util_pkg.t_detail_column_tbl;

662: l_viewby_select varchar2(400); -- needed to be increased from 200
663:
664: l_orderby varchar2(40);
665: l_to_date_type varchar2(200);
666: l_detail_col_tbl isc_fs_rpt_util_pkg.t_detail_column_tbl;
667:
668: begin
669:
670: -- clear out the tables.

Line 674: isc_fs_rpt_util_pkg.register_dimension_levels

670: -- clear out the tables.
671: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
672: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
673:
674: isc_fs_rpt_util_pkg.register_dimension_levels
675: ( l_dimension_tbl
676: , l_dim_filter_map
677: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
678: , isc_fs_rpt_util_pkg.G_TRVL_TIME_VAR_DISTRIB, 'N'

Line 677: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'

673:
674: isc_fs_rpt_util_pkg.register_dimension_levels
675: ( l_dimension_tbl
676: , l_dim_filter_map
677: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
678: , isc_fs_rpt_util_pkg.G_TRVL_TIME_VAR_DISTRIB, 'N'
679: );
680:
681: isc_fs_rpt_util_pkg.process_parameters

Line 678: , isc_fs_rpt_util_pkg.G_TRVL_TIME_VAR_DISTRIB, 'N'

674: isc_fs_rpt_util_pkg.register_dimension_levels
675: ( l_dimension_tbl
676: , l_dim_filter_map
677: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
678: , isc_fs_rpt_util_pkg.G_TRVL_TIME_VAR_DISTRIB, 'N'
679: );
680:
681: isc_fs_rpt_util_pkg.process_parameters
682: ( p_param => p_param

Line 681: isc_fs_rpt_util_pkg.process_parameters

677: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
678: , isc_fs_rpt_util_pkg.G_TRVL_TIME_VAR_DISTRIB, 'N'
679: );
680:
681: isc_fs_rpt_util_pkg.process_parameters
682: ( p_param => p_param
683: , p_dimension_tbl => l_dimension_tbl
684: , p_dim_filter_map => l_dim_filter_map
685: , p_trend => 'N'

Line 720: else ' || isc_fs_rpt_util_pkg.change_column

716: ' || l_viewby_select || '
717: , nvl(oset.c_count_dur_task,0) ISC_MEASURE_1
718: , case avg(oset.c_count_dur_task_total) over() * avg(oset.p_count_dur_task_total) over()
719: when 0 then NULL
720: else ' || isc_fs_rpt_util_pkg.change_column
721: ( isc_fs_rpt_util_pkg.rate_column
722: ( 'nvl(oset.c_count_dur_task,0)*100'
723: , 'avg(oset.c_count_dur_task_total) over()'
724: , NULL

Line 721: ( isc_fs_rpt_util_pkg.rate_column

717: , nvl(oset.c_count_dur_task,0) ISC_MEASURE_1
718: , case avg(oset.c_count_dur_task_total) over() * avg(oset.p_count_dur_task_total) over()
719: when 0 then NULL
720: else ' || isc_fs_rpt_util_pkg.change_column
721: ( isc_fs_rpt_util_pkg.rate_column
722: ( 'nvl(oset.c_count_dur_task,0)*100'
723: , 'avg(oset.c_count_dur_task_total) over()'
724: , NULL
725: , 'N'

Line 727: , isc_fs_rpt_util_pkg.rate_column

723: , 'avg(oset.c_count_dur_task_total) over()'
724: , NULL
725: , 'N'
726: )
727: , isc_fs_rpt_util_pkg.rate_column
728: ( 'nvl(oset.p_count_dur_task,0)*100'
729: , 'avg(oset.p_count_dur_task_total) over()'
730: , NULL
731: , 'N' )

Line 736: , ' || isc_fs_rpt_util_pkg.rate_column

732: , NULL
733: , 'N'
734: ) || '
735: end ISC_MEASURE_3
736: , ' || isc_fs_rpt_util_pkg.rate_column
737: ( 'oset.c_count_dur_task'
738: , 'avg(oset.c_count_dur_task_total) over()'
739: , 'ISC_MEASURE_2'
740: , 'Y' ) || '

Line 762: --l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);

758: , '&ORDER_BY_CLAUSE'
759: , 'ORDER BY NLSSORT(VIEWBYID,''NLS_SORT=BINARY'') ASC '
760: );
761:
762: --l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
763:
764: poa_dbi_util_pkg.get_custom_rolling_binds
765: ( p_custom_output => l_custom_output
766: , p_xtd => l_xtd

Line 769: isc_fs_rpt_util_pkg.enhance_time_join

765: ( p_custom_output => l_custom_output
766: , p_xtd => l_xtd
767: );
768:
769: isc_fs_rpt_util_pkg.enhance_time_join
770: ( p_query => l_stmt
771: , p_trend => 'N'
772: );
773:

Line 785: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

781: , x_custom_sql out nocopy varchar2
782: , x_custom_output out nocopy bis_query_attributes_tbl
783: )
784: is
785: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
786: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
787: l_dim_bmap number;
788: l_comparison_type varchar2(200);
789: l_xtd varchar2(200);

Line 807: l_detail_col_tbl isc_fs_rpt_util_pkg.t_detail_column_tbl;

803: l_viewby_select varchar2(400); -- needed to be increased from 200
804:
805: l_orderby varchar2(40);
806: l_to_date_type varchar2(200);
807: l_detail_col_tbl isc_fs_rpt_util_pkg.t_detail_column_tbl;
808:
809: begin
810:
811: -- clear out the tables.

Line 815: isc_fs_rpt_util_pkg.register_dimension_levels

811: -- clear out the tables.
812: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
813: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
814:
815: isc_fs_rpt_util_pkg.register_dimension_levels
816: ( l_dimension_tbl
817: , l_dim_filter_map
818: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
819: , isc_fs_rpt_util_pkg.G_TRVL_DIST_VAR_DISTRIB, 'N'

Line 818: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'

814:
815: isc_fs_rpt_util_pkg.register_dimension_levels
816: ( l_dimension_tbl
817: , l_dim_filter_map
818: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
819: , isc_fs_rpt_util_pkg.G_TRVL_DIST_VAR_DISTRIB, 'N'
820: );
821:
822: isc_fs_rpt_util_pkg.process_parameters

Line 819: , isc_fs_rpt_util_pkg.G_TRVL_DIST_VAR_DISTRIB, 'N'

815: isc_fs_rpt_util_pkg.register_dimension_levels
816: ( l_dimension_tbl
817: , l_dim_filter_map
818: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
819: , isc_fs_rpt_util_pkg.G_TRVL_DIST_VAR_DISTRIB, 'N'
820: );
821:
822: isc_fs_rpt_util_pkg.process_parameters
823: ( p_param => p_param

Line 822: isc_fs_rpt_util_pkg.process_parameters

818: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
819: , isc_fs_rpt_util_pkg.G_TRVL_DIST_VAR_DISTRIB, 'N'
820: );
821:
822: isc_fs_rpt_util_pkg.process_parameters
823: ( p_param => p_param
824: , p_dimension_tbl => l_dimension_tbl
825: , p_dim_filter_map => l_dim_filter_map
826: , p_trend => 'N'

Line 861: else ' || isc_fs_rpt_util_pkg.change_column

857: ' || l_viewby_select || '
858: , nvl(oset.c_count_dist_task,0) ISC_MEASURE_1
859: , case avg(oset.p_count_dist_task_total) over () * avg(oset.p_count_dist_task_total) over ()
860: when 0 then NULL
861: else ' || isc_fs_rpt_util_pkg.change_column
862: ( isc_fs_rpt_util_pkg.rate_column
863: ( 'nvl(oset.c_count_dist_task,0)*100'
864: , 'avg(oset.c_count_dist_task_total) over()'
865: , NULL

Line 862: ( isc_fs_rpt_util_pkg.rate_column

858: , nvl(oset.c_count_dist_task,0) ISC_MEASURE_1
859: , case avg(oset.p_count_dist_task_total) over () * avg(oset.p_count_dist_task_total) over ()
860: when 0 then NULL
861: else ' || isc_fs_rpt_util_pkg.change_column
862: ( isc_fs_rpt_util_pkg.rate_column
863: ( 'nvl(oset.c_count_dist_task,0)*100'
864: , 'avg(oset.c_count_dist_task_total) over()'
865: , NULL
866: , 'N'

Line 868: , isc_fs_rpt_util_pkg.rate_column

864: , 'avg(oset.c_count_dist_task_total) over()'
865: , NULL
866: , 'N'
867: )
868: , isc_fs_rpt_util_pkg.rate_column
869: ( 'nvl(oset.p_count_dist_task,0)*100'
870: , 'avg(oset.p_count_dist_task_total) over()'
871: , NULL
872: , 'N'

Line 878: , ' || isc_fs_rpt_util_pkg.rate_column

874: , null
875: , 'N'
876: ) || '
877: end ISC_MEASURE_3
878: , ' || isc_fs_rpt_util_pkg.rate_column
879: ( 'oset.c_count_dist_task'
880: , 'avg(oset.c_count_dist_task_total) over()'
881: , 'ISC_MEASURE_2'
882: ,'Y'

Line 910: --l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);

906: ( p_custom_output => l_custom_output
907: , p_xtd => l_xtd
908: );
909:
910: --l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
911:
912: isc_fs_rpt_util_pkg.enhance_time_join
913: ( p_query => l_stmt
914: , p_trend => 'N'

Line 912: isc_fs_rpt_util_pkg.enhance_time_join

908: );
909:
910: --l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
911:
912: isc_fs_rpt_util_pkg.enhance_time_join
913: ( p_query => l_stmt
914: , p_trend => 'N'
915: );
916: