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

Line 20: isc_fs_rpt_util_pkg.get_detail_drill_down

16: begin
17:
18: return
19: -- R12 resource type
20: isc_fs_rpt_util_pkg.get_detail_drill_down
21: ( p_view_by => p_view_by
22: , p_function_name => g_detail_rep_func
23: , p_check_column_name => 'ISC_MEASURE_4_B' || p_column
24: , p_extra_params => '&BIV_FS_BACKLOG_STATUS=' || p_column

Line 46: if nvl(isc_fs_rpt_util_pkg.get_parameter_value

42: l_district_leaf_node varchar2(1);
43:
44: begin
45:
46: if nvl(isc_fs_rpt_util_pkg.get_parameter_value
47: ( p_param
48: , isc_fs_rpt_util_pkg.G_CATEGORY
49: ),'All') = 'All' then
50: l_top_node := 'Y';

Line 48: , isc_fs_rpt_util_pkg.G_CATEGORY

44: begin
45:
46: if nvl(isc_fs_rpt_util_pkg.get_parameter_value
47: ( p_param
48: , isc_fs_rpt_util_pkg.G_CATEGORY
49: ),'All') = 'All' then
50: l_top_node := 'Y';
51: else
52: l_top_node := 'N';

Line 57: l_district_leaf_node := isc_fs_rpt_util_pkg.is_district_leaf_node

53: end if;
54:
55: if p_report_type = 'TASK_BACKLOG_STATUS' then
56:
57: l_district_leaf_node := isc_fs_rpt_util_pkg.is_district_leaf_node
58: ( p_param );
59:
60: isc_fs_rpt_util_pkg.bind_group_id
61: ( p_dim_bmap

Line 60: isc_fs_rpt_util_pkg.bind_group_id

56:
57: l_district_leaf_node := isc_fs_rpt_util_pkg.is_district_leaf_node
58: ( p_param );
59:
60: isc_fs_rpt_util_pkg.bind_group_id
61: ( p_dim_bmap
62: , p_custom_output
63: , isc_fs_rpt_util_pkg.G_CATEGORY
64: , isc_fs_rpt_util_pkg.G_PRODUCT

Line 63: , isc_fs_rpt_util_pkg.G_CATEGORY

59:
60: isc_fs_rpt_util_pkg.bind_group_id
61: ( p_dim_bmap
62: , p_custom_output
63: , isc_fs_rpt_util_pkg.G_CATEGORY
64: , isc_fs_rpt_util_pkg.G_PRODUCT
65: , isc_fs_rpt_util_pkg.G_CUSTOMER
66: );
67:

Line 64: , isc_fs_rpt_util_pkg.G_PRODUCT

60: isc_fs_rpt_util_pkg.bind_group_id
61: ( p_dim_bmap
62: , p_custom_output
63: , isc_fs_rpt_util_pkg.G_CATEGORY
64: , isc_fs_rpt_util_pkg.G_PRODUCT
65: , isc_fs_rpt_util_pkg.G_CUSTOMER
66: );
67:
68: if bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then

Line 65: , isc_fs_rpt_util_pkg.G_CUSTOMER

61: ( p_dim_bmap
62: , p_custom_output
63: , isc_fs_rpt_util_pkg.G_CATEGORY
64: , isc_fs_rpt_util_pkg.G_PRODUCT
65: , isc_fs_rpt_util_pkg.G_CUSTOMER
66: );
67:
68: if bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then
69:

Line 68: if bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then

64: , isc_fs_rpt_util_pkg.G_PRODUCT
65: , isc_fs_rpt_util_pkg.G_CUSTOMER
66: );
67:
68: if bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then
69:
70: return '(
71: select
72: v.top_node_flag vbh_top_node_flag

Line 123: elsif bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_PRODUCT_BMAP) = isc_fs_rpt_util_pkg.G_PRODUCT_BMAP or

119: when l_top_node = 'Y' then '
120: and v.top_node_flag = ''Y''' end || '
121: )';
122:
123: elsif bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_PRODUCT_BMAP) = isc_fs_rpt_util_pkg.G_PRODUCT_BMAP or
124: bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CUSTOMER_BMAP) = isc_fs_rpt_util_pkg.G_CUSTOMER_BMAP or
125: bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_TASK_TYPE_BMAP) = isc_fs_rpt_util_pkg.G_TASK_TYPE_BMAP then
126:
127: return '(

Line 124: bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CUSTOMER_BMAP) = isc_fs_rpt_util_pkg.G_CUSTOMER_BMAP or

120: and v.top_node_flag = ''Y''' end || '
121: )';
122:
123: elsif bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_PRODUCT_BMAP) = isc_fs_rpt_util_pkg.G_PRODUCT_BMAP or
124: bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CUSTOMER_BMAP) = isc_fs_rpt_util_pkg.G_CUSTOMER_BMAP or
125: bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_TASK_TYPE_BMAP) = isc_fs_rpt_util_pkg.G_TASK_TYPE_BMAP then
126:
127: return '(
128: select

Line 125: bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_TASK_TYPE_BMAP) = isc_fs_rpt_util_pkg.G_TASK_TYPE_BMAP then

121: )';
122:
123: elsif bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_PRODUCT_BMAP) = isc_fs_rpt_util_pkg.G_PRODUCT_BMAP or
124: bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CUSTOMER_BMAP) = isc_fs_rpt_util_pkg.G_CUSTOMER_BMAP or
125: bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_TASK_TYPE_BMAP) = isc_fs_rpt_util_pkg.G_TASK_TYPE_BMAP then
126:
127: return '(
128: select
129: c.report_date ' || case

Line 194: if isc_fs_rpt_util_pkg.get_parameter_id

190: end if;
191:
192: elsif p_report_type = 'TASK_BACKLOG_DETAIL' then
193:
194: if isc_fs_rpt_util_pkg.get_parameter_id
195: ( p_param
196: , isc_fs_rpt_util_pkg.G_DISTRICT
197: ) like '%.%' then
198: l_resource := 'Y';

Line 196: , isc_fs_rpt_util_pkg.G_DISTRICT

192: elsif p_report_type = 'TASK_BACKLOG_DETAIL' then
193:
194: if isc_fs_rpt_util_pkg.get_parameter_id
195: ( p_param
196: , isc_fs_rpt_util_pkg.G_DISTRICT
197: ) like '%.%' then
198: l_resource := 'Y';
199: else
200: l_resource := 'N';

Line 231: when bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then

227: , t.incident_date
228: , t.customer_id
229: , nvl(s.master_id,s.id) product_id ' ||
230: case
231: when bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then
232: '
233: , v.top_node_flag vbh_top_node_flag
234: , v.parent_id vbh_parent_category_id
235: , v.imm_child_id vbh_child_category_id'

Line 242: when bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then

238: isc_fs_tasks_f t
239: , isc_fs_task_backlog_f b
240: , eni_oltp_item_star s' ||
241: case
242: when bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then
243: '
244: , eni_denorm_hierarchies v
245: , mtl_default_category_sets m'
246: end ||

Line 259: when bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then

255: and t.deleted_flag = ''N''
256: and t.inventory_item_id = s.inventory_item_id
257: and t.inv_organization_id = s.organization_id' ||
258: case
259: when bitand(p_dim_bmap,isc_fs_rpt_util_pkg.G_CATEGORY_BMAP) = isc_fs_rpt_util_pkg.G_CATEGORY_BMAP then
260: '
261: and m.functional_area_id = 11
262: and v.object_id = m.category_set_id
263: and v.dbi_flag = ''Y''

Line 288: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

284: , x_custom_output out nocopy bis_query_attributes_tbl
285: )
286: is
287:
288: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
289: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
290: l_custom_output bis_query_attributes_tbl;
291: l_curr_suffix varchar2(3);
292: l_where_clause varchar2(10000);

Line 307: isc_fs_rpt_util_pkg.register_dimension_levels

303: l_to_date_type varchar2(200);
304:
305: begin
306:
307: isc_fs_rpt_util_pkg.register_dimension_levels
308: ( l_dimension_tbl
309: , l_dim_filter_map
310: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
311: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'

Line 310: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'

306:
307: isc_fs_rpt_util_pkg.register_dimension_levels
308: ( l_dimension_tbl
309: , l_dim_filter_map
310: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
311: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
312: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
313: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
314: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

Line 311: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'

307: isc_fs_rpt_util_pkg.register_dimension_levels
308: ( l_dimension_tbl
309: , l_dim_filter_map
310: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
311: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
312: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
313: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
314: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
315: );

Line 312: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'

308: ( l_dimension_tbl
309: , l_dim_filter_map
310: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
311: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
312: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
313: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
314: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
315: );
316:

Line 313: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'

309: , l_dim_filter_map
310: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
311: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
312: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
313: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
314: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
315: );
316:
317: isc_fs_rpt_util_pkg.process_parameters

Line 314: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

310: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
311: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
312: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
313: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
314: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
315: );
316:
317: isc_fs_rpt_util_pkg.process_parameters
318: ( p_param => p_param

Line 317: isc_fs_rpt_util_pkg.process_parameters

313: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
314: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
315: );
316:
317: isc_fs_rpt_util_pkg.process_parameters
318: ( p_param => p_param
319: , p_dimension_tbl => l_dimension_tbl
320: , p_dim_filter_map => l_dim_filter_map
321: , p_trend => 'N'

Line 338: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value

334: else
335: l_to_date_type := 'RLX';
336: end if;
337:
338: l_view_by := isc_fs_rpt_util_pkg.get_parameter_value
339: ( p_param
340: , 'VIEW_BY'
341: );
342:

Line 343: if l_view_by = isc_fs_rpt_util_pkg.G_PRODUCT then

339: ( p_param
340: , 'VIEW_BY'
341: );
342:
343: if l_view_by = isc_fs_rpt_util_pkg.G_PRODUCT then
344: l_product := 'v4.description ISC_ATTRIBUTE_1';
345: else
346: l_product := 'null ISC_ATTRIBUTE_1';
347: end if;

Line 418: , ' || isc_fs_rpt_util_pkg.get_district_drill_down

414: , ISC_MEASURE_24_B3
415: , ISC_MEASURE_24_B4
416: , ISC_MEASURE_24_B5
417: , ' || l_product || '
418: , ' || isc_fs_rpt_util_pkg.get_district_drill_down
419: ( l_view_by
420: , g_task_rep_func
421: , 'ISC_ATTRIBUTE_2' ) || '
422: , ' || isc_fs_rpt_util_pkg.get_category_drill_down

Line 422: , ' || isc_fs_rpt_util_pkg.get_category_drill_down

418: , ' || isc_fs_rpt_util_pkg.get_district_drill_down
419: ( l_view_by
420: , g_task_rep_func
421: , 'ISC_ATTRIBUTE_2' ) || '
422: , ' || isc_fs_rpt_util_pkg.get_category_drill_down
423: ( l_view_by
424: , g_task_rep_func
425: , 'ISC_ATTRIBUTE_3' ) || '
426: , ' || get_detail_drill( l_view_by, '1', 'ISC_ATTRIBUTE_4' ) || '

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

429: , ' || get_detail_drill( l_view_by, '4', 'ISC_ATTRIBUTE_4' ) || '
430: , ' || get_detail_drill( l_view_by, '5', 'ISC_ATTRIBUTE_4' ) || '
431: from (
432: select
433: row_number() over(&ORDER_BY_CLAUSE nulls last, '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
434: , iset.*
435: from ( select * from (
436: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
437: , nvl(p_backlog,0) ISC_MEASURE_1

Line 436: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '

432: select
433: row_number() over(&ORDER_BY_CLAUSE nulls last, '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
434: , iset.*
435: from ( select * from (
436: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
437: , nvl(p_backlog,0) ISC_MEASURE_1
438: , nvl(c_backlog,0) ISC_MEASURE_2
439: , ' || isc_fs_rpt_util_pkg.change_column
440: ( 'c_backlog'

Line 439: , ' || isc_fs_rpt_util_pkg.change_column

435: from ( select * from (
436: select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
437: , nvl(p_backlog,0) ISC_MEASURE_1
438: , nvl(c_backlog,0) ISC_MEASURE_2
439: , ' || isc_fs_rpt_util_pkg.change_column
440: ( 'c_backlog'
441: , 'p_backlog'
442: , 'ISC_MEASURE_3' ) || '
443: , ' || isc_fs_rpt_util_pkg.rate_column

Line 443: , ' || isc_fs_rpt_util_pkg.rate_column

439: , ' || isc_fs_rpt_util_pkg.change_column
440: ( 'c_backlog'
441: , 'p_backlog'
442: , 'ISC_MEASURE_3' ) || '
443: , ' || isc_fs_rpt_util_pkg.rate_column
444: ( 'c_in_planning'
445: , 'c_backlog'
446: , 'ISC_MEASURE_4_B1'
447: ) || '

Line 448: , ' || isc_fs_rpt_util_pkg.rate_column

444: ( 'c_in_planning'
445: , 'c_backlog'
446: , 'ISC_MEASURE_4_B1'
447: ) || '
448: , ' || isc_fs_rpt_util_pkg.rate_column
449: ( 'c_assigned'
450: , 'c_backlog'
451: , 'ISC_MEASURE_4_B2'
452: ) || '

Line 453: , ' || isc_fs_rpt_util_pkg.rate_column

449: ( 'c_assigned'
450: , 'c_backlog'
451: , 'ISC_MEASURE_4_B2'
452: ) || '
453: , ' || isc_fs_rpt_util_pkg.rate_column
454: ( 'c_working'
455: , 'c_backlog'
456: , 'ISC_MEASURE_4_B3'
457: ) || '

Line 458: , ' || isc_fs_rpt_util_pkg.rate_column

454: ( 'c_working'
455: , 'c_backlog'
456: , 'ISC_MEASURE_4_B3'
457: ) || '
458: , ' || isc_fs_rpt_util_pkg.rate_column
459: ( 'c_completed'
460: , 'c_backlog'
461: , 'ISC_MEASURE_4_B4'
462: ) || '

Line 463: , ' || isc_fs_rpt_util_pkg.rate_column

459: ( 'c_completed'
460: , 'c_backlog'
461: , 'ISC_MEASURE_4_B4'
462: ) || '
463: , ' || isc_fs_rpt_util_pkg.rate_column
464: ( 'c_other'
465: , 'c_backlog'
466: , 'ISC_MEASURE_4_B5'
467: ) || '

Line 470: , ' || isc_fs_rpt_util_pkg.change_column

466: , 'ISC_MEASURE_4_B5'
467: ) || '
468: , nvl(p_backlog_total,0) ISC_MEASURE_21
469: , nvl(c_backlog_total,0) ISC_MEASURE_22
470: , ' || isc_fs_rpt_util_pkg.change_column
471: ( 'c_backlog_total'
472: , 'p_backlog_total'
473: , 'ISC_MEASURE_23' ) || '
474: , ' || isc_fs_rpt_util_pkg.rate_column

Line 474: , ' || isc_fs_rpt_util_pkg.rate_column

470: , ' || isc_fs_rpt_util_pkg.change_column
471: ( 'c_backlog_total'
472: , 'p_backlog_total'
473: , 'ISC_MEASURE_23' ) || '
474: , ' || isc_fs_rpt_util_pkg.rate_column
475: ( 'c_in_planning_total'
476: , 'c_backlog_total'
477: , 'ISC_MEASURE_24_B1'
478: ) || '

Line 479: , ' || isc_fs_rpt_util_pkg.rate_column

475: ( 'c_in_planning_total'
476: , 'c_backlog_total'
477: , 'ISC_MEASURE_24_B1'
478: ) || '
479: , ' || isc_fs_rpt_util_pkg.rate_column
480: ( 'c_assigned_total'
481: , 'c_backlog_total'
482: , 'ISC_MEASURE_24_B2'
483: ) || '

Line 484: , ' || isc_fs_rpt_util_pkg.rate_column

480: ( 'c_assigned_total'
481: , 'c_backlog_total'
482: , 'ISC_MEASURE_24_B2'
483: ) || '
484: , ' || isc_fs_rpt_util_pkg.rate_column
485: ( 'c_working_total'
486: , 'c_backlog_total'
487: , 'ISC_MEASURE_24_B3'
488: ) || '

Line 489: , ' || isc_fs_rpt_util_pkg.rate_column

485: ( 'c_working_total'
486: , 'c_backlog_total'
487: , 'ISC_MEASURE_24_B3'
488: ) || '
489: , ' || isc_fs_rpt_util_pkg.rate_column
490: ( 'c_completed_total'
491: , 'c_backlog_total'
492: , 'ISC_MEASURE_24_B4'
493: ) || '

Line 494: , ' || isc_fs_rpt_util_pkg.rate_column

490: ( 'c_completed_total'
491: , 'c_backlog_total'
492: , 'ISC_MEASURE_24_B4'
493: ) || '
494: , ' || isc_fs_rpt_util_pkg.rate_column
495: ( 'c_other_total'
496: , 'c_backlog_total'
497: , 'ISC_MEASURE_24_B5'
498: ) || '

Line 517: isc_fs_rpt_util_pkg.enhance_time_join

513: , p_balance_fact => isc_fs_task_act_bac_etl_pkg.g_object_name
514: , p_xtd => l_xtd
515: );
516:
517: isc_fs_rpt_util_pkg.enhance_time_join
518: ( l_stmt
519: , 'N'
520: );
521:

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

519: , 'N'
520: );
521:
522: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
523: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
524:
525: x_custom_output := l_custom_output;
526:
527: x_custom_sql := l_stmt;

Line 538: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;

534: , x_custom_output out nocopy bis_query_attributes_tbl
535: )
536: as
537:
538: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
539: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
540: l_custom_output bis_query_attributes_tbl;
541: l_curr_suffix varchar2(3);
542: l_where_clause varchar2(10000);

Line 553: l_detail_col_tbl isc_fs_rpt_util_pkg.t_detail_column_tbl;

549: l_cost_element varchar2(200);
550: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
551: l_stmt varchar2(32767);
552: l_rank_order varchar2(200);
553: l_detail_col_tbl isc_fs_rpt_util_pkg.t_detail_column_tbl;
554: l_order_by varchar2(200);
555: l_asc_desc varchar2(100);
556:
557: begin

Line 559: isc_fs_rpt_util_pkg.register_dimension_levels

555: l_asc_desc varchar2(100);
556:
557: begin
558:
559: isc_fs_rpt_util_pkg.register_dimension_levels
560: ( l_dimension_tbl
561: , l_dim_filter_map
562: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
563: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'

Line 562: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'

558:
559: isc_fs_rpt_util_pkg.register_dimension_levels
560: ( l_dimension_tbl
561: , l_dim_filter_map
562: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
563: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
564: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
565: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
566: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

Line 563: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'

559: isc_fs_rpt_util_pkg.register_dimension_levels
560: ( l_dimension_tbl
561: , l_dim_filter_map
562: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
563: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
564: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
565: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
566: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
567: , isc_fs_rpt_util_pkg.G_TASK_OWNER, 'N'

Line 564: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'

560: ( l_dimension_tbl
561: , l_dim_filter_map
562: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
563: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
564: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
565: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
566: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
567: , isc_fs_rpt_util_pkg.G_TASK_OWNER, 'N'
568: , isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE, 'N'

Line 565: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'

561: , l_dim_filter_map
562: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
563: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
564: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
565: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
566: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
567: , isc_fs_rpt_util_pkg.G_TASK_OWNER, 'N'
568: , isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE, 'N'
569: , isc_fs_rpt_util_pkg.G_BACKLOG_STATUS, 'Y'

Line 566: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'

562: , isc_fs_rpt_util_pkg.G_CATEGORY, 'Y'
563: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
564: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
565: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
566: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
567: , isc_fs_rpt_util_pkg.G_TASK_OWNER, 'N'
568: , isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE, 'N'
569: , isc_fs_rpt_util_pkg.G_BACKLOG_STATUS, 'Y'
570: );

Line 567: , isc_fs_rpt_util_pkg.G_TASK_OWNER, 'N'

563: , isc_fs_rpt_util_pkg.G_PRODUCT, 'Y'
564: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
565: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
566: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
567: , isc_fs_rpt_util_pkg.G_TASK_OWNER, 'N'
568: , isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE, 'N'
569: , isc_fs_rpt_util_pkg.G_BACKLOG_STATUS, 'Y'
570: );
571:

Line 568: , isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE, 'N'

564: , isc_fs_rpt_util_pkg.G_CUSTOMER, 'Y'
565: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
566: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
567: , isc_fs_rpt_util_pkg.G_TASK_OWNER, 'N'
568: , isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE, 'N'
569: , isc_fs_rpt_util_pkg.G_BACKLOG_STATUS, 'Y'
570: );
571:
572: isc_fs_rpt_util_pkg.process_parameters

Line 569: , isc_fs_rpt_util_pkg.G_BACKLOG_STATUS, 'Y'

565: , isc_fs_rpt_util_pkg.G_DISTRICT, 'Y'
566: , isc_fs_rpt_util_pkg.G_TASK_TYPE, 'Y'
567: , isc_fs_rpt_util_pkg.G_TASK_OWNER, 'N'
568: , isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE, 'N'
569: , isc_fs_rpt_util_pkg.G_BACKLOG_STATUS, 'Y'
570: );
571:
572: isc_fs_rpt_util_pkg.process_parameters
573: ( p_param => p_param

Line 572: isc_fs_rpt_util_pkg.process_parameters

568: , isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE, 'N'
569: , isc_fs_rpt_util_pkg.G_BACKLOG_STATUS, 'Y'
570: );
571:
572: isc_fs_rpt_util_pkg.process_parameters
573: ( p_param => p_param
574: , p_dimension_tbl => l_dimension_tbl
575: , p_dim_filter_map => l_dim_filter_map
576: , p_trend => 'D'

Line 594: l_order_by := isc_fs_rpt_util_pkg.get_parameter_value

590: , l_dim_bmap
591: , l_custom_output
592: );
593:
594: l_order_by := isc_fs_rpt_util_pkg.get_parameter_value
595: ( p_param
596: , 'ORDERBY'
597: );
598:

Line 619: isc_fs_rpt_util_pkg.add_detail_column

615: end ||
616: l_asc_desc ||
617: 'nulls last, task_id';
618:
619: isc_fs_rpt_util_pkg.add_detail_column
620: ( p_detail_col_tbl => l_detail_col_tbl
621: , p_dimension_tbl => l_dimension_tbl
622: , p_fact_col_name => 'task_number'
623: , p_fact_col_total => 'N'

Line 627: isc_fs_rpt_util_pkg.add_detail_column

623: , p_fact_col_total => 'N'
624: , p_column_key => 'task_number'
625: );
626:
627: isc_fs_rpt_util_pkg.add_detail_column
628: ( p_detail_col_tbl => l_detail_col_tbl
629: , p_dimension_tbl => l_dimension_tbl
630: , p_fact_col_name => 'task_id'
631: , p_fact_col_total => 'N'

Line 635: isc_fs_rpt_util_pkg.add_detail_column

631: , p_fact_col_total => 'N'
632: , p_column_key => 'task_id'
633: );
634:
635: isc_fs_rpt_util_pkg.add_detail_column
636: ( p_detail_col_tbl => l_detail_col_tbl
637: , p_dimension_tbl => l_dimension_tbl
638: , p_dimension_level => isc_fs_rpt_util_pkg.G_BACKLOG_STATUS
639: , p_column_key => 'task_status'

Line 638: , p_dimension_level => isc_fs_rpt_util_pkg.G_BACKLOG_STATUS

634:
635: isc_fs_rpt_util_pkg.add_detail_column
636: ( p_detail_col_tbl => l_detail_col_tbl
637: , p_dimension_tbl => l_dimension_tbl
638: , p_dimension_level => isc_fs_rpt_util_pkg.G_BACKLOG_STATUS
639: , p_column_key => 'task_status'
640: );
641:
642: isc_fs_rpt_util_pkg.add_detail_column

Line 642: isc_fs_rpt_util_pkg.add_detail_column

638: , p_dimension_level => isc_fs_rpt_util_pkg.G_BACKLOG_STATUS
639: , p_column_key => 'task_status'
640: );
641:
642: isc_fs_rpt_util_pkg.add_detail_column
643: ( p_detail_col_tbl => l_detail_col_tbl
644: , p_dimension_tbl => l_dimension_tbl
645: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_TYPE
646: , p_column_key => 'task_type'

Line 645: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_TYPE

641:
642: isc_fs_rpt_util_pkg.add_detail_column
643: ( p_detail_col_tbl => l_detail_col_tbl
644: , p_dimension_tbl => l_dimension_tbl
645: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_TYPE
646: , p_column_key => 'task_type'
647: );
648:
649: isc_fs_rpt_util_pkg.add_detail_column

Line 649: isc_fs_rpt_util_pkg.add_detail_column

645: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_TYPE
646: , p_column_key => 'task_type'
647: );
648:
649: isc_fs_rpt_util_pkg.add_detail_column
650: ( p_detail_col_tbl => l_detail_col_tbl
651: , p_dimension_tbl => l_dimension_tbl
652: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_OWNER
653: , p_column_key => 'task_owner'

Line 652: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_OWNER

648:
649: isc_fs_rpt_util_pkg.add_detail_column
650: ( p_detail_col_tbl => l_detail_col_tbl
651: , p_dimension_tbl => l_dimension_tbl
652: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_OWNER
653: , p_column_key => 'task_owner'
654: );
655:
656: isc_fs_rpt_util_pkg.add_detail_column

Line 656: isc_fs_rpt_util_pkg.add_detail_column

652: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_OWNER
653: , p_column_key => 'task_owner'
654: );
655:
656: isc_fs_rpt_util_pkg.add_detail_column
657: ( p_detail_col_tbl => l_detail_col_tbl
658: , p_dimension_tbl => l_dimension_tbl
659: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE
660: , p_column_key => 'task_assignee'

Line 659: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE

655:
656: isc_fs_rpt_util_pkg.add_detail_column
657: ( p_detail_col_tbl => l_detail_col_tbl
658: , p_dimension_tbl => l_dimension_tbl
659: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE
660: , p_column_key => 'task_assignee'
661: );
662:
663: isc_fs_rpt_util_pkg.add_detail_column

Line 663: isc_fs_rpt_util_pkg.add_detail_column

659: , p_dimension_level => isc_fs_rpt_util_pkg.G_TASK_ASSIGNEE
660: , p_column_key => 'task_assignee'
661: );
662:
663: isc_fs_rpt_util_pkg.add_detail_column
664: ( p_detail_col_tbl => l_detail_col_tbl
665: , p_dimension_tbl => l_dimension_tbl
666: , p_fact_col_name => 'actual_start_date'
667: , p_fact_col_total => 'N'

Line 671: isc_fs_rpt_util_pkg.add_detail_column

667: , p_fact_col_total => 'N'
668: , p_column_key => 'actual_start_date'
669: );
670:
671: isc_fs_rpt_util_pkg.add_detail_column
672: ( p_detail_col_tbl => l_detail_col_tbl
673: , p_dimension_tbl => l_dimension_tbl
674: , p_fact_col_name => 'actual_end_date'
675: , p_fact_col_total => 'N'

Line 679: isc_fs_rpt_util_pkg.add_detail_column

675: , p_fact_col_total => 'N'
676: , p_column_key => 'actual_end_date'
677: );
678:
679: isc_fs_rpt_util_pkg.add_detail_column
680: ( p_detail_col_tbl => l_detail_col_tbl
681: , p_dimension_tbl => l_dimension_tbl
682: , p_fact_col_name => 'planned_start_date'
683: , p_fact_col_total => 'N'

Line 687: isc_fs_rpt_util_pkg.add_detail_column

683: , p_fact_col_total => 'N'
684: , p_column_key => 'planned_start_date'
685: );
686:
687: isc_fs_rpt_util_pkg.add_detail_column
688: ( p_detail_col_tbl => l_detail_col_tbl
689: , p_dimension_tbl => l_dimension_tbl
690: , p_fact_col_name => 'source_object_name'
691: , p_fact_col_total => 'N'

Line 695: isc_fs_rpt_util_pkg.add_detail_column

691: , p_fact_col_total => 'N'
692: , p_column_key => 'source_object_name'
693: );
694:
695: isc_fs_rpt_util_pkg.add_detail_column
696: ( p_detail_col_tbl => l_detail_col_tbl
697: , p_dimension_tbl => l_dimension_tbl
698: , p_fact_col_name => 'incident_date'
699: , p_fact_col_total => 'N'

Line 703: isc_fs_rpt_util_pkg.add_detail_column

699: , p_fact_col_total => 'N'
700: , p_column_key => 'incident_date'
701: );
702:
703: isc_fs_rpt_util_pkg.add_detail_column
704: ( p_detail_col_tbl => l_detail_col_tbl
705: , p_dimension_tbl => l_dimension_tbl
706: , p_fact_col_name => 'source_object_id'
707: , p_fact_col_total => 'N'

Line 711: isc_fs_rpt_util_pkg.add_detail_column

707: , p_fact_col_total => 'N'
708: , p_column_key => 'source_object_id'
709: );
710:
711: isc_fs_rpt_util_pkg.add_detail_column
712: ( p_detail_col_tbl => l_detail_col_tbl
713: , p_dimension_tbl => l_dimension_tbl
714: , p_dimension_level => isc_fs_rpt_util_pkg.G_CUSTOMER
715: , p_column_key => 'customer'

Line 714: , p_dimension_level => isc_fs_rpt_util_pkg.G_CUSTOMER

710:
711: isc_fs_rpt_util_pkg.add_detail_column
712: ( p_detail_col_tbl => l_detail_col_tbl
713: , p_dimension_tbl => l_dimension_tbl
714: , p_dimension_level => isc_fs_rpt_util_pkg.G_CUSTOMER
715: , p_column_key => 'customer'
716: );
717:
718: isc_fs_rpt_util_pkg.add_detail_column

Line 718: isc_fs_rpt_util_pkg.add_detail_column

714: , p_dimension_level => isc_fs_rpt_util_pkg.G_CUSTOMER
715: , p_column_key => 'customer'
716: );
717:
718: isc_fs_rpt_util_pkg.add_detail_column
719: ( p_detail_col_tbl => l_detail_col_tbl
720: , p_dimension_tbl => l_dimension_tbl
721: , p_dimension_level => isc_fs_rpt_util_pkg.G_PRODUCT
722: , p_column_key => 'product'

Line 721: , p_dimension_level => isc_fs_rpt_util_pkg.G_PRODUCT

717:
718: isc_fs_rpt_util_pkg.add_detail_column
719: ( p_detail_col_tbl => l_detail_col_tbl
720: , p_dimension_tbl => l_dimension_tbl
721: , p_dimension_level => isc_fs_rpt_util_pkg.G_PRODUCT
722: , p_column_key => 'product'
723: );
724:
725: l_stmt := 'select

Line 727: , ' || isc_fs_rpt_util_pkg.get_detail_column

723: );
724:
725: l_stmt := 'select
726: oset.task_number ISC_ATTRIBUTE_1
727: , ' || isc_fs_rpt_util_pkg.get_detail_column
728: (l_detail_col_tbl,'task_status','ISC_ATTRIBUTE_2') || '
729: , ' || isc_fs_rpt_util_pkg.get_detail_column
730: (l_detail_col_tbl,'task_type','ISC_ATTRIBUTE_3') || '
731: , ' || isc_fs_rpt_util_pkg.get_detail_column

Line 729: , ' || isc_fs_rpt_util_pkg.get_detail_column

725: l_stmt := 'select
726: oset.task_number ISC_ATTRIBUTE_1
727: , ' || isc_fs_rpt_util_pkg.get_detail_column
728: (l_detail_col_tbl,'task_status','ISC_ATTRIBUTE_2') || '
729: , ' || isc_fs_rpt_util_pkg.get_detail_column
730: (l_detail_col_tbl,'task_type','ISC_ATTRIBUTE_3') || '
731: , ' || isc_fs_rpt_util_pkg.get_detail_column
732: (l_detail_col_tbl,'task_owner','ISC_ATTRIBUTE_4') || '
733: , ' || isc_fs_rpt_util_pkg.get_detail_column

Line 731: , ' || isc_fs_rpt_util_pkg.get_detail_column

727: , ' || isc_fs_rpt_util_pkg.get_detail_column
728: (l_detail_col_tbl,'task_status','ISC_ATTRIBUTE_2') || '
729: , ' || isc_fs_rpt_util_pkg.get_detail_column
730: (l_detail_col_tbl,'task_type','ISC_ATTRIBUTE_3') || '
731: , ' || isc_fs_rpt_util_pkg.get_detail_column
732: (l_detail_col_tbl,'task_owner','ISC_ATTRIBUTE_4') || '
733: , ' || isc_fs_rpt_util_pkg.get_detail_column
734: (l_detail_col_tbl,'task_assignee','ISC_ATTRIBUTE_5') || '
735: , oset.actual_start_date ISC_MEASURE_1

Line 733: , ' || isc_fs_rpt_util_pkg.get_detail_column

729: , ' || isc_fs_rpt_util_pkg.get_detail_column
730: (l_detail_col_tbl,'task_type','ISC_ATTRIBUTE_3') || '
731: , ' || isc_fs_rpt_util_pkg.get_detail_column
732: (l_detail_col_tbl,'task_owner','ISC_ATTRIBUTE_4') || '
733: , ' || isc_fs_rpt_util_pkg.get_detail_column
734: (l_detail_col_tbl,'task_assignee','ISC_ATTRIBUTE_5') || '
735: , oset.actual_start_date ISC_MEASURE_1
736: , oset.actual_end_date ISC_MEASURE_2
737: , oset.planned_start_date ISC_MEASURE_3

Line 740: , ' || isc_fs_rpt_util_pkg.get_detail_column

736: , oset.actual_end_date ISC_MEASURE_2
737: , oset.planned_start_date ISC_MEASURE_3
738: , oset.source_object_name ISC_ATTRIBUTE_6
739: , oset.incident_date ISC_MEASURE_4
740: , ' || isc_fs_rpt_util_pkg.get_detail_column
741: (l_detail_col_tbl,'customer','ISC_ATTRIBUTE_7') || '
742: , ' || isc_fs_rpt_util_pkg.get_detail_column
743: (l_detail_col_tbl,'product','ISC_ATTRIBUTE_8') || '
744: , ' || isc_fs_rpt_util_pkg.get_sr_detail_page_function('oset.source_object_id') || ' ISC_ATTRIBUTE_9

Line 742: , ' || isc_fs_rpt_util_pkg.get_detail_column

738: , oset.source_object_name ISC_ATTRIBUTE_6
739: , oset.incident_date ISC_MEASURE_4
740: , ' || isc_fs_rpt_util_pkg.get_detail_column
741: (l_detail_col_tbl,'customer','ISC_ATTRIBUTE_7') || '
742: , ' || isc_fs_rpt_util_pkg.get_detail_column
743: (l_detail_col_tbl,'product','ISC_ATTRIBUTE_8') || '
744: , ' || isc_fs_rpt_util_pkg.get_sr_detail_page_function('oset.source_object_id') || ' ISC_ATTRIBUTE_9
745: , null ISC_ATTRIBUTE_10'
746: -- above is needed to associate bucket set with report

Line 744: , ' || isc_fs_rpt_util_pkg.get_sr_detail_page_function('oset.source_object_id') || ' ISC_ATTRIBUTE_9

740: , ' || isc_fs_rpt_util_pkg.get_detail_column
741: (l_detail_col_tbl,'customer','ISC_ATTRIBUTE_7') || '
742: , ' || isc_fs_rpt_util_pkg.get_detail_column
743: (l_detail_col_tbl,'product','ISC_ATTRIBUTE_8') || '
744: , ' || isc_fs_rpt_util_pkg.get_sr_detail_page_function('oset.source_object_id') || ' ISC_ATTRIBUTE_9
745: , null ISC_ATTRIBUTE_10'
746: -- above is needed to associate bucket set with report
747: || '
748: , ' || isc_fs_rpt_util_pkg.get_task_detail_page_function('oset.task_id') || ' ISC_ATTRIBUTE_11

Line 748: , ' || isc_fs_rpt_util_pkg.get_task_detail_page_function('oset.task_id') || ' ISC_ATTRIBUTE_11

744: , ' || isc_fs_rpt_util_pkg.get_sr_detail_page_function('oset.source_object_id') || ' ISC_ATTRIBUTE_9
745: , null ISC_ATTRIBUTE_10'
746: -- above is needed to associate bucket set with report
747: || '
748: , ' || isc_fs_rpt_util_pkg.get_task_detail_page_function('oset.task_id') || ' ISC_ATTRIBUTE_11
749: from
750: ' || isc_fs_rpt_util_pkg.detail_sql
751: ( p_detail_col_tbl => l_detail_col_tbl
752: , p_dimension_tbl => l_dimension_tbl

Line 750: ' || isc_fs_rpt_util_pkg.detail_sql

746: -- above is needed to associate bucket set with report
747: || '
748: , ' || isc_fs_rpt_util_pkg.get_task_detail_page_function('oset.task_id') || ' ISC_ATTRIBUTE_11
749: from
750: ' || isc_fs_rpt_util_pkg.detail_sql
751: ( p_detail_col_tbl => l_detail_col_tbl
752: , p_dimension_tbl => l_dimension_tbl
753: , p_mv_name => l_mv
754: , p_where_clause => l_where_clause

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

762: , p_xtd => l_xtd
763: );
764:
765: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
766: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
767:
768: x_custom_sql := l_stmt;
769:
770: x_custom_output := l_custom_output;