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_MAINT_WO_BACKLOG_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 219: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

215: )
216: is
217:
218: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
219: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
220: l_dim_bmap number;
221:
222: l_comparison_type varchar2(200);
223: l_xtd varchar2(200);

Line 228: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

224: l_where_clause varchar2(10000);
225: l_mv varchar2(10000);
226: l_stmt varchar2(32767);
227:
228: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
229: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
230:
231: l_custom_output bis_query_attributes_tbl;
232:

Line 229: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

225: l_mv varchar2(10000);
226: l_stmt varchar2(32767);
227:
228: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
229: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
230:
231: l_custom_output bis_query_attributes_tbl;
232:
233: l_cost_element varchar2(200);

Line 247: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

243: l_asset_grp_column varchar2(200);
244: begin
245:
246: -- clear out the tables.
247: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
248: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
249:
250: isc_maint_rpt_util_pkg.register_dimension_levels
251: ( l_dimension_tbl

Line 248: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

244: begin
245:
246: -- clear out the tables.
247: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
248: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
249:
250: isc_maint_rpt_util_pkg.register_dimension_levels
251: ( l_dimension_tbl
252: , l_dim_filter_map

Line 284: poa_dbi_util_pkg.add_column (l_col_tbl,

280:
281: -- The measure columns that need to be aggregated are
282: -- Num_created, Num_Completion, Num_Past_Due, Num_Past_Due_Cmpl
283:
284: poa_dbi_util_pkg.add_column (l_col_tbl,
285: 'Num_created',
286: 'Num_created'
287: );
288:

Line 289: poa_dbi_util_pkg.add_column (l_col_tbl,

285: 'Num_created',
286: 'Num_created'
287: );
288:
289: poa_dbi_util_pkg.add_column (l_col_tbl,
290: 'Num_Completion',
291: 'Num_Completion'
292: );
293:

Line 294: poa_dbi_util_pkg.add_column (l_col_tbl,

290: 'Num_Completion',
291: 'Num_Completion'
292: );
293:
294: poa_dbi_util_pkg.add_column (l_col_tbl,
295: 'Num_Past_Due_Cmpl',
296: 'Num_Past_Due_Cmpl'
297: );
298:

Line 299: poa_dbi_util_pkg.add_column (l_col_tbl,

295: 'Num_Past_Due_Cmpl',
296: 'Num_Past_Due_Cmpl'
297: );
298:
299: poa_dbi_util_pkg.add_column (l_col_tbl,
300: 'Num_Past_Due',
301: 'Num_Past_Due'
302: );
303:

Line 476: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

472: )
473: is
474:
475: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
476: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
477: l_dim_bmap number;
478: l_comparison_type varchar2(200);
479: l_xtd varchar2(200);
480: l_where_clause varchar2(10000);

Line 484: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

480: l_where_clause varchar2(10000);
481: l_mv varchar2(10000);
482: l_stmt varchar2(32767);
483:
484: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
485: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
486:
487: l_custom_output bis_query_attributes_tbl;
488:

Line 485: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

481: l_mv varchar2(10000);
482: l_stmt varchar2(32767);
483:
484: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
485: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
486:
487: l_custom_output bis_query_attributes_tbl;
488:
489: l_cost_element varchar2(200);

Line 497: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

493:
494: begin
495:
496: -- clear out the tables.
497: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
498: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
499:
500: isc_maint_rpt_util_pkg.register_dimension_levels
501: ( l_dimension_tbl

Line 498: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

494: begin
495:
496: -- clear out the tables.
497: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
498: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
499:
500: isc_maint_rpt_util_pkg.register_dimension_levels
501: ( l_dimension_tbl
502: , l_dim_filter_map

Line 535: poa_dbi_util_pkg.add_column (l_col_tbl,

531: -- The measure columns that need to be aggregated are
532: -- Num_created, Num_Completion, Num_past_due, Num_Past_Due_Cmpl
533: -- No Grand totals required.
534:
535: poa_dbi_util_pkg.add_column (l_col_tbl,
536: 'Num_created',
537: 'Num_created',
538: 'N'
539: );

Line 541: poa_dbi_util_pkg.add_column (l_col_tbl,

537: 'Num_created',
538: 'N'
539: );
540:
541: poa_dbi_util_pkg.add_column (l_col_tbl,
542: 'Num_Completion',
543: 'Num_Completion',
544: 'N'
545: );

Line 547: poa_dbi_util_pkg.add_column (l_col_tbl,

543: 'Num_Completion',
544: 'N'
545: );
546:
547: poa_dbi_util_pkg.add_column (l_col_tbl,
548: 'Num_Past_Due_Cmpl',
549: 'Num_Past_Due_Cmpl',
550: 'N'
551: );

Line 553: poa_dbi_util_pkg.add_column (l_col_tbl,

549: 'Num_Past_Due_Cmpl',
550: 'N'
551: );
552:
553: poa_dbi_util_pkg.add_column (l_col_tbl,
554: 'Num_past_due',
555: 'Num_past_due',
556: 'N'
557: );

Line 621: poa_dbi_util_pkg.get_custom_trend_binds

617: x_custom_sql := l_stmt;
618:
619: x_custom_output := l_custom_output;
620:
621: poa_dbi_util_pkg.get_custom_trend_binds
622: ( x_custom_output => l_custom_output
623: , p_xtd => l_xtd
624: , p_comparison_type => l_comparison_type
625: );

Line 644: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

640: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
641: IS
642:
643: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
644: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
645: l_dim_bmap number;
646: l_comparison_type varchar2(200);
647: l_xtd varchar2(200);
648: l_where_clause varchar2(10000);

Line 652: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

648: l_where_clause varchar2(10000);
649: l_mv varchar2(10000);
650: l_stmt varchar2(32767);
651:
652: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
653: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
654:
655: l_custom_output bis_query_attributes_tbl;
656:

Line 653: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

649: l_mv varchar2(10000);
650: l_stmt varchar2(32767);
651:
652: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
653: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
654:
655: l_custom_output bis_query_attributes_tbl;
656:
657: l_curr_suffix varchar2(2);

Line 671: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

667:
668: begin
669:
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_maint_rpt_util_pkg.register_dimension_levels
675: ( l_dimension_tbl

Line 672: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

668: begin
669:
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_maint_rpt_util_pkg.register_dimension_levels
675: ( l_dimension_tbl
676: , l_dim_filter_map

Line 872: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

868: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
869: is
870:
871: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
872: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
873: l_dim_bmap number;
874:
875: l_comparison_type varchar2(200);
876: l_xtd varchar2(200);

Line 881: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

877: l_where_clause varchar2(10000);
878: l_mv varchar2(10000);
879: l_stmt varchar2(32767);
880:
881: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
882: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
883:
884: l_custom_output bis_query_attributes_tbl;
885:

Line 882: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

878: l_mv varchar2(10000);
879: l_stmt varchar2(32767);
880:
881: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
882: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
883:
884: l_custom_output bis_query_attributes_tbl;
885:
886: l_curr_suffix varchar2(2);

Line 899: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

895:
896: begin
897:
898: -- clear out the tables.
899: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
900: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
901:
902: isc_maint_rpt_util_pkg.register_dimension_levels
903: ( l_dimension_tbl

Line 900: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

896: begin
897:
898: -- clear out the tables.
899: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
900: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
901:
902: isc_maint_rpt_util_pkg.register_dimension_levels
903: ( l_dimension_tbl
904: , l_dim_filter_map

Line 1082: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

1078: , x_custom_output out nocopy bis_query_attributes_tbl
1079: )
1080: as
1081: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1082: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1083: l_dim_bmap number;
1084: l_comparison_type varchar2(200);
1085: l_xtd varchar2(200);
1086: l_where_clause varchar2(10000);

Line 1090: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1086: l_where_clause varchar2(10000);
1087: l_mv varchar2(10000);
1088: l_stmt varchar2(32767);
1089:
1090: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1091: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1092:
1093: l_custom_output bis_query_attributes_tbl;
1094:

Line 1091: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1087: l_mv varchar2(10000);
1088: l_stmt varchar2(32767);
1089:
1090: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1091: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1092:
1093: l_custom_output bis_query_attributes_tbl;
1094:
1095: l_curr_suffix varchar2(2);

Line 1108: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

1104:
1105: begin
1106:
1107: -- clear out the tables.
1108: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1109: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1110:
1111: isc_maint_rpt_util_pkg.register_dimension_levels
1112: ( l_dimension_tbl

Line 1109: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

1105: begin
1106:
1107: -- clear out the tables.
1108: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1109: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1110:
1111: isc_maint_rpt_util_pkg.register_dimension_levels
1112: ( l_dimension_tbl
1113: , l_dim_filter_map