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_REQ_CMPL_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 6: ( p_custom_output in out nocopy bis_query_attributes_tbl

2: /* $Header: iscmaintreqcmrpb.pls 120.2 2006/02/03 03:24:59 nbhamidi noship $ */
3: as
4:
5: procedure bind_request_id
6: ( p_custom_output in out nocopy bis_query_attributes_tbl
7: , p_param in bis_pmv_page_parameter_tbl
8: ) is
9:
10: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 15: p_custom_output := bis_query_attributes_tbl();

11:
12: begin
13:
14: if p_custom_output is null then
15: p_custom_output := bis_query_attributes_tbl();
16: end if;
17:
18: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
19:

Line 36: , p_custom_output in out nocopy bis_query_attributes_tbl

32: function get_fact_mv_name
33: ( p_report_type in varchar2
34: , p_param in bis_pmv_page_parameter_tbl
35: , p_dim_bmap in number
36: , p_custom_output in out nocopy bis_query_attributes_tbl
37: )
38: return varchar2
39: is
40:

Line 236: , x_custom_output out nocopy bis_query_attributes_tbl

232:
233: procedure get_tbl_sql
234: ( p_param in bis_pmv_page_parameter_tbl
235: , x_custom_sql out nocopy varchar2
236: , x_custom_output out nocopy bis_query_attributes_tbl
237: )
238: is
239:
240: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 242: l_custom_output bis_query_attributes_tbl;

238: is
239:
240: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
241: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
242: l_custom_output bis_query_attributes_tbl;
243: l_curr_suffix varchar2(3);
244: l_where_clause varchar2(10000);
245: l_viewby_select varchar2(200);
246: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 488: , x_custom_output out nocopy bis_query_attributes_tbl

484:
485: procedure get_trd_sql
486: ( p_param in bis_pmv_page_parameter_tbl
487: , x_custom_sql out nocopy varchar2
488: , x_custom_output out nocopy bis_query_attributes_tbl
489: )
490: is
491:
492: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 494: l_custom_output bis_query_attributes_tbl;

490: is
491:
492: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
493: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
494: l_custom_output bis_query_attributes_tbl;
495: l_curr_suffix varchar2(3);
496: l_where_clause varchar2(10000);
497: l_viewby_select varchar2(200);
498: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 659: , x_custom_output out nocopy bis_query_attributes_tbl

655:
656: procedure get_dbn_tbl_sql
657: ( p_param in bis_pmv_page_parameter_tbl
658: , x_custom_sql out nocopy varchar2
659: , x_custom_output out nocopy bis_query_attributes_tbl
660: )
661: as
662:
663: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 665: l_custom_output bis_query_attributes_tbl;

661: as
662:
663: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
664: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
665: l_custom_output bis_query_attributes_tbl;
666: l_curr_suffix varchar2(3);
667: l_where_clause varchar2(10000);
668: l_viewby_select varchar2(200);
669: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 790: , x_custom_output out nocopy bis_query_attributes_tbl

786:
787: procedure get_dtl_rpt_sql
788: ( p_param in bis_pmv_page_parameter_tbl
789: , x_custom_sql out nocopy varchar2
790: , x_custom_output out nocopy bis_query_attributes_tbl
791: )
792: as
793:
794: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 796: l_custom_output bis_query_attributes_tbl;

792: as
793:
794: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
795: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
796: l_custom_output bis_query_attributes_tbl;
797: l_curr_suffix varchar2(3);
798: l_where_clause varchar2(10000);
799: l_viewby_select varchar2(200);
800: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 1011: , x_custom_output out nocopy bis_query_attributes_tbl

1007:
1008: procedure get_wo_dtl_rpt_sql
1009: ( p_param in bis_pmv_page_parameter_tbl
1010: , x_custom_sql out nocopy varchar2
1011: , x_custom_output out nocopy bis_query_attributes_tbl
1012: )
1013: as
1014:
1015: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

Line 1017: l_custom_output bis_query_attributes_tbl;

1013: as
1014:
1015: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1016: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1017: l_custom_output bis_query_attributes_tbl;
1018: l_curr_suffix varchar2(3);
1019: l_where_clause varchar2(10000);
1020: l_viewby_select varchar2(200);
1021: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;