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.BIS_RSG_PMV_REPORT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 157: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

153:
154: PROCEDURE request_set_perf_report
155: ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
156: x_custom_sql OUT NOCOPY VARCHAR2,
157: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
158:
159: l_sql_stmt VARCHAR2(32767);
160: l_custom_rec BIS_QUERY_ATTRIBUTES;
161: pname VARCHAR2(2000);

Line 225: x_custom_output := bis_query_attributes_tbl();

221:
222: counter :=1;
223:
224: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
225: x_custom_output := bis_query_attributes_tbl();
226:
227: if (rs_history is not null AND rs_history <> 'All') then
228: l_days_cond := 'and r.last_update_date >= sysdate - :BIND_HISTORY ';
229: l_sql_stmt := l_sql_stmt|| l_days_cond;

Line 374: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

370:
371: PROCEDURE request_set_perf_det_rep
372: ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
373: x_custom_sql OUT NOCOPY VARCHAR2,
374: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
375:
376: l_sql_stmt VARCHAR2(32767);
377: l_custom_rec BIS_QUERY_ATTRIBUTES;
378: pname VARCHAR2(2000);

Line 441: x_custom_output := bis_query_attributes_tbl();

437: AND PHASE_CODE = ''C'' and STATUS_CODE <>''X'' ';
438:
439:
440: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
441: x_custom_output := bis_query_attributes_tbl();
442:
443:
444: if (rs_history is not null AND rs_history <> 'All') then
445: l_sql_stmt:= l_sql_stmt||'and B.last_update_date >= sysdate - :BIND_HISTORY ';

Line 492: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

488:
489: PROCEDURE request_set_sub_req_rep
490: ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
491: x_custom_sql OUT NOCOPY VARCHAR2,
492: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
493:
494: l_sql_stmt VARCHAR2(32767);
495: l_custom_rec BIS_QUERY_ATTRIBUTES;
496: pname VARCHAR2(2000);

Line 580: x_custom_output := bis_query_attributes_tbl();

576:
577: counter := 1;
578:
579: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
580: x_custom_output := bis_query_attributes_tbl();
581:
582:
583: if (rs_type is not null AND rs_type <> 'All') then
584: l_type_cond :='and R.request_set_type= :BIND_TYPE ';

Line 710: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

706:
707: PROCEDURE request_details_report
708: ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
709: x_custom_sql OUT NOCOPY VARCHAR2,
710: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
711:
712: l_sql_stmt VARCHAR2(32767);
713: l_custom_rec BIS_QUERY_ATTRIBUTES;
714: base varchar2(257);

Line 811: x_custom_output := bis_query_attributes_tbl();

807: AND S.REQUEST_ID = P.STAGE_REQUEST_ID
808: AND R.PHASE_CODE = ''C'' ';
809:
810: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
811: x_custom_output := bis_query_attributes_tbl();
812:
813: if (rs_type is not null AND rs_type <> 'All') then
814: l_sql_stmt :=l_sql_stmt||'and R.REQUEST_SET_TYPE= :BIND_TYPE ';
815:

Line 878: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

874:
875: PROCEDURE request_set_space_rep
876: ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
877: x_custom_sql OUT NOCOPY VARCHAR2,
878: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
879:
880: l_sql_stmt VARCHAR2(32767);
881: l_custom_rec BIS_QUERY_ATTRIBUTES;
882: base VARCHAR2(257);

Line 963: x_custom_output := bis_query_attributes_tbl();

959: and P.request_id=O.prog_request_id
960: AND TOTAL_SPACE.TABLESPACE_NAME=O.TABLESPACE_NAME ';
961:
962: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
963: x_custom_output := bis_query_attributes_tbl();
964:
965: if (rs_id is not null AND rs_id <> 'All') then
966: l_sql_stmt :=l_sql_stmt||'and Latestreq.rsid= :BIND_RSID ';
967:

Line 1001: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

997:
998: PROCEDURE tablespace_detail_report
999: ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1000: x_custom_sql OUT NOCOPY VARCHAR2,
1001: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
1002:
1003: l_sql_stmt VARCHAR2(32767);
1004: l_custom_rec BIS_QUERY_ATTRIBUTES;
1005: pname VARCHAR2(2000);

Line 1050: x_custom_output := bis_query_attributes_tbl();

1046: AND total_space.tablespace_name=db_ts.tablespace_name
1047: AND db_ts.contents = ''PERMANENT'' ';
1048:
1049: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
1050: x_custom_output := bis_query_attributes_tbl();
1051:
1052: if (ts_name is not null AND ts_name <> 'All') then
1053: l_sql_stmt :=l_sql_stmt||'and db_ts.tablespace_name= :BIND_NAME ';
1054: