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_PMV_PARAMETERS_PUB

Line 224: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

220: END LOOP;
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 ';

Line 232: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

228: l_days_cond := 'and r.last_update_date >= sysdate - :BIND_HISTORY ';
229: l_sql_stmt := l_sql_stmt|| l_days_cond;
230: l_custom_rec.attribute_name := ':BIND_HISTORY';
231: l_custom_rec.attribute_value := rs_history;
232: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
233: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
234: x_custom_output.extend;
235: x_custom_output(counter) := l_custom_rec;
236: counter:= counter+1;

Line 233: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

229: l_sql_stmt := l_sql_stmt|| l_days_cond;
230: l_custom_rec.attribute_name := ':BIND_HISTORY';
231: l_custom_rec.attribute_value := rs_history;
232: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
233: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
234: x_custom_output.extend;
235: x_custom_output(counter) := l_custom_rec;
236: counter:= counter+1;
237: end if;

Line 245: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

241: l_sql_stmt := l_sql_stmt || l_type_cond;
242:
243: l_custom_rec.attribute_name := ':BIND_TYPE';
244: l_custom_rec.attribute_value := rs_type;
245: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
246: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
247: x_custom_output.extend;
248: x_custom_output(counter) := l_custom_rec;
249: end if;

Line 246: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

242:
243: l_custom_rec.attribute_name := ':BIND_TYPE';
244: l_custom_rec.attribute_value := rs_type;
245: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
246: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
247: x_custom_output.extend;
248: x_custom_output(counter) := l_custom_rec;
249: end if;
250:

Line 440: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

436: where F.request_set_id = B.request_set_id
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

Line 448: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

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 ';
446: l_custom_rec.attribute_name := ':BIND_HISTORY';
447: l_custom_rec.attribute_value := rs_history;
448: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
449: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
450: x_custom_output.extend;
451: x_custom_output(counter) := l_custom_rec;
452: counter:= counter+1;

Line 449: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

445: l_sql_stmt:= l_sql_stmt||'and B.last_update_date >= sysdate - :BIND_HISTORY ';
446: l_custom_rec.attribute_name := ':BIND_HISTORY';
447: l_custom_rec.attribute_value := rs_history;
448: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
449: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
450: x_custom_output.extend;
451: x_custom_output(counter) := l_custom_rec;
452: counter:= counter+1;
453: end if;

Line 460: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

456: l_sql_stmt := l_sql_stmt || 'and B.request_set_type= :BIND_TYPE ';
457:
458: l_custom_rec.attribute_name := ':BIND_TYPE';
459: l_custom_rec.attribute_value := rs_type;
460: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
461: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
462: x_custom_output.extend;
463: x_custom_output(counter) := l_custom_rec;
464: counter:= counter+1;

Line 461: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

457:
458: l_custom_rec.attribute_name := ':BIND_TYPE';
459: l_custom_rec.attribute_value := rs_type;
460: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
461: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
462: x_custom_output.extend;
463: x_custom_output(counter) := l_custom_rec;
464: counter:= counter+1;
465: end if;

Line 472: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

468: l_sql_stmt := l_sql_stmt || 'and f.request_set_id= :BIND_RSID ';
469:
470: l_custom_rec.attribute_name := ':BIND_RSID';
471: l_custom_rec.attribute_value := rs_id;
472: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
473: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
474: x_custom_output.extend;
475: x_custom_output(counter) := l_custom_rec;
476: end if;

Line 473: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

469:
470: l_custom_rec.attribute_name := ':BIND_RSID';
471: l_custom_rec.attribute_value := rs_id;
472: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
473: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
474: x_custom_output.extend;
475: x_custom_output(counter) := l_custom_rec;
476: end if;
477:

Line 579: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

575: END LOOP;
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

Line 588: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

584: l_type_cond :='and R.request_set_type= :BIND_TYPE ';
585:
586: l_custom_rec.attribute_name := ':BIND_TYPE';
587: l_custom_rec.attribute_value := rs_type;
588: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
589: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
590: x_custom_output.extend;
591: x_custom_output(counter) := l_custom_rec;
592: counter:= counter+1;

Line 589: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

585:
586: l_custom_rec.attribute_name := ':BIND_TYPE';
587: l_custom_rec.attribute_value := rs_type;
588: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
589: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
590: x_custom_output.extend;
591: x_custom_output(counter) := l_custom_rec;
592: counter:= counter+1;
593: end if;

Line 601: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

597: l_setid_cond:= 'and R.request_set_id= :BIND_RSID ';
598:
599: l_custom_rec.attribute_name := ':BIND_RSID';
600: l_custom_rec.attribute_value := rs_id;
601: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
602: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
603: x_custom_output.extend;
604: x_custom_output(counter) := l_custom_rec;
605: counter:=counter+1;

Line 602: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

598:
599: l_custom_rec.attribute_name := ':BIND_RSID';
600: l_custom_rec.attribute_value := rs_id;
601: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
602: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
603: x_custom_output.extend;
604: x_custom_output(counter) := l_custom_rec;
605: counter:=counter+1;
606: end if;

Line 614: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

610: l_runid_cond2 := 'and B.set_request_id= :BIND_RUNID ';
611:
612: l_custom_rec.attribute_name := ':BIND_RUNID';
613: l_custom_rec.attribute_value := rs_run_id;
614: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
615: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
616: x_custom_output.extend;
617: x_custom_output(counter) := l_custom_rec;
618: counter:=counter+1;

Line 615: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

611:
612: l_custom_rec.attribute_name := ':BIND_RUNID';
613: l_custom_rec.attribute_value := rs_run_id;
614: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
615: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
616: x_custom_output.extend;
617: x_custom_output(counter) := l_custom_rec;
618: counter:=counter+1;
619: end if;

Line 629: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

625: l_stage_cond2 := 'and B.STAGE_REQUEST_ID = :BIND_STAGEID ';
626:
627: l_custom_rec.attribute_name := ':BIND_STAGEID';
628: l_custom_rec.attribute_value := rs_stage_req;
629: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
630: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
631: x_custom_output.extend;
632: x_custom_output(counter) := l_custom_rec;
633: end if;

Line 630: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

626:
627: l_custom_rec.attribute_name := ':BIND_STAGEID';
628: l_custom_rec.attribute_value := rs_stage_req;
629: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
630: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
631: x_custom_output.extend;
632: x_custom_output(counter) := l_custom_rec;
633: end if;
634:

Line 810: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

806: AND R.REQUEST_ID = S.SET_REQUEST_ID
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 ';

Line 818: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

814: l_sql_stmt :=l_sql_stmt||'and R.REQUEST_SET_TYPE= :BIND_TYPE ';
815:
816: l_custom_rec.attribute_name := ':BIND_TYPE';
817: l_custom_rec.attribute_value := rs_type;
818: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
819: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
820: x_custom_output.extend;
821: x_custom_output(counter) := l_custom_rec;
822: counter:= counter+1;

Line 819: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

815:
816: l_custom_rec.attribute_name := ':BIND_TYPE';
817: l_custom_rec.attribute_value := rs_type;
818: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
819: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
820: x_custom_output.extend;
821: x_custom_output(counter) := l_custom_rec;
822: counter:= counter+1;
823: end if;

Line 830: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

826: if (rs_id is not null AND rs_id <> 'All') then
827: l_sql_stmt :=l_sql_stmt||'and R.REQUEST_SET_ID= :BIND_RSID ';
828: l_custom_rec.attribute_name := ':BIND_RSID';
829: l_custom_rec.attribute_value := rs_id;
830: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
831: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
832: x_custom_output.extend;
833: x_custom_output(counter) := l_custom_rec;
834: counter:=counter+1;

Line 831: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

827: l_sql_stmt :=l_sql_stmt||'and R.REQUEST_SET_ID= :BIND_RSID ';
828: l_custom_rec.attribute_name := ':BIND_RSID';
829: l_custom_rec.attribute_value := rs_id;
830: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
831: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
832: x_custom_output.extend;
833: x_custom_output(counter) := l_custom_rec;
834: counter:=counter+1;
835: end if;

Line 841: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

837: if (rs_stage_req is not null AND rs_stage_req <> 'All') then
838: l_sql_stmt :=l_sql_stmt|| 'and S.request_id = :BIND_STAGEID ';
839: l_custom_rec.attribute_name := ':BIND_STAGEID';
840: l_custom_rec.attribute_value := rs_stage_req;
841: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
842: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
843: x_custom_output.extend;
844: x_custom_output(counter) := l_custom_rec;
845: counter:=counter+1;

Line 842: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

838: l_sql_stmt :=l_sql_stmt|| 'and S.request_id = :BIND_STAGEID ';
839: l_custom_rec.attribute_name := ':BIND_STAGEID';
840: l_custom_rec.attribute_value := rs_stage_req;
841: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
842: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
843: x_custom_output.extend;
844: x_custom_output(counter) := l_custom_rec;
845: counter:=counter+1;
846: end if;

Line 857: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

853: l_sql_stmt :=l_sql_stmt||'and R.request_id= :BIND_RUNID ';
854:
855: l_custom_rec.attribute_name := ':BIND_RUNID';
856: l_custom_rec.attribute_value := rs_run_id;
857: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
858: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
859: x_custom_output.extend;
860: x_custom_output(counter) := l_custom_rec;
861: end if;

Line 858: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

854:
855: l_custom_rec.attribute_name := ':BIND_RUNID';
856: l_custom_rec.attribute_value := rs_run_id;
857: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
858: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
859: x_custom_output.extend;
860: x_custom_output(counter) := l_custom_rec;
861: end if;
862:

Line 962: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

958: and S.request_id= P.stage_request_id
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 ';

Line 970: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

966: l_sql_stmt :=l_sql_stmt||'and Latestreq.rsid= :BIND_RSID ';
967:
968: l_custom_rec.attribute_name := ':BIND_RSID';
969: l_custom_rec.attribute_value := rs_id;
970: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
971: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
972: x_custom_output.extend;
973: x_custom_output(counter) := l_custom_rec;
974: counter:=counter+1;

Line 971: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

967:
968: l_custom_rec.attribute_name := ':BIND_RSID';
969: l_custom_rec.attribute_value := rs_id;
970: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
971: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
972: x_custom_output.extend;
973: x_custom_output(counter) := l_custom_rec;
974: counter:=counter+1;
975: end if;

Line 981: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

977: if (rs_stage_req is not null AND rs_stage_req <> 'All') then
978: l_sql_stmt :=l_sql_stmt|| 'and S.request_id = :BIND_STAGEID ';
979: l_custom_rec.attribute_name := ':BIND_STAGEID';
980: l_custom_rec.attribute_value := rs_stage_req;
981: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
982: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
983: x_custom_output.extend;
984: x_custom_output(counter) := l_custom_rec;
985: end if;

Line 982: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

978: l_sql_stmt :=l_sql_stmt|| 'and S.request_id = :BIND_STAGEID ';
979: l_custom_rec.attribute_name := ':BIND_STAGEID';
980: l_custom_rec.attribute_value := rs_stage_req;
981: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
982: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
983: x_custom_output.extend;
984: x_custom_output(counter) := l_custom_rec;
985: end if;
986:

Line 1049: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

1045: WHERE free_space.tablespace_name=db_ts.tablespace_name
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 ';

Line 1057: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1053: l_sql_stmt :=l_sql_stmt||'and db_ts.tablespace_name= :BIND_NAME ';
1054:
1055: l_custom_rec.attribute_name := ':BIND_NAME';
1056: l_custom_rec.attribute_value := ts_name;
1057: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1058: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1059: x_custom_output.extend;
1060: x_custom_output(1) := l_custom_rec;
1061: end if;

Line 1058: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;

1054:
1055: l_custom_rec.attribute_name := ':BIND_NAME';
1056: l_custom_rec.attribute_value := ts_name;
1057: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1058: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.varchar2_bind;
1059: x_custom_output.extend;
1060: x_custom_output(1) := l_custom_rec;
1061: end if;
1062: