DBA Data[Home] [Help]

SYS.DBMS_WORKLOAD_REPOSITORY dependencies on AWRRPT_HTML_TYPE_TABLE

Line 525: RETURN awrrpt_html_type_table PIPELINED;

521: l_inst_num IN NUMBER,
522: l_bid IN NUMBER,
523: l_eid IN NUMBER,
524: l_options IN NUMBER DEFAULT 0)
525: RETURN awrrpt_html_type_table PIPELINED;
526:
527: -- ***********************************************************
528: -- awr_global_report_text and _html (FUNCTION)
529: -- This is the table function that will display the

Line 565: RETURN awrrpt_html_type_table PIPELINED;

561: l_inst_num IN AWRRPT_INSTANCE_LIST_TYPE,
562: l_bid IN NUMBER,
563: l_eid IN NUMBER,
564: l_options IN NUMBER DEFAULT 0)
565: RETURN awrrpt_html_type_table PIPELINED;
566: --
567: -- This version accepts a comma-separated list of instance numbers
568: -- No leading zeroes are allowed and no more than 1023 characters total
569: --

Line 575: RETURN awrrpt_html_type_table PIPELINED;

571: l_inst_num IN VARCHAR2,
572: l_bid IN NUMBER,
573: l_eid IN NUMBER,
574: l_options IN NUMBER DEFAULT 0)
575: RETURN awrrpt_html_type_table PIPELINED;
576:
577: -- ***********************************************************
578: -- awr_sql_report_text (FUNCTION)
579: -- This is the function that will return the

Line 609: RETURN awrrpt_html_type_table PIPELINED;

605: l_bid IN NUMBER,
606: l_eid IN NUMBER,
607: l_sqlid IN VARCHAR2,
608: l_options IN NUMBER DEFAULT 0)
609: RETURN awrrpt_html_type_table PIPELINED;
610:
611:
612: -- ***********************************************************
613: -- awr_diff_report_text (FUNCTION)

Line 662: RETURN awrrpt_html_type_table PIPELINED;

658: dbid2 IN NUMBER,
659: inst_num2 IN NUMBER,
660: bid2 IN NUMBER,
661: eid2 IN NUMBER)
662: RETURN awrrpt_html_type_table PIPELINED;
663:
664: -- ***********************************************************
665: -- awr_global_diff_report_text (FUNCTION)
666: -- This is the table function that will display the

Line 745: RETURN awrrpt_html_type_table PIPELINED;

741: dbid2 IN NUMBER,
742: inst_num2 IN AWRRPT_INSTANCE_LIST_TYPE,
743: bid2 IN NUMBER,
744: eid2 IN NUMBER)
745: RETURN awrrpt_html_type_table PIPELINED;
746: --
747: -- This version accepts comma-separated lists of instance numbers
748: -- for inst_num1 and inst_num2
749: -- No leading zeroes are allowed and no more than 1023 characters each

Line 759: RETURN awrrpt_html_type_table PIPELINED;

755: dbid2 IN NUMBER,
756: inst_num2 IN VARCHAR2,
757: bid2 IN NUMBER,
758: eid2 IN NUMBER)
759: RETURN awrrpt_html_type_table PIPELINED;
760:
761:
762: -- ***********************************************************
763: -- ash_report_text (FUNCTION)

Line 894: RETURN awrrpt_html_type_table PIPELINED;

890: l_plsql_entry IN VARCHAR2 DEFAULT NULL,
891: l_data_src IN NUMBER DEFAULT 0,
892: l_container IN VARCHAR2 DEFAULT NULL
893: )
894: RETURN awrrpt_html_type_table PIPELINED;
895: FUNCTION ash_global_report_text(l_dbid IN NUMBER,
896: l_inst_num IN VARCHAR2,
897: l_btime IN DATE,
898: l_etime IN DATE,

Line 930: RETURN awrrpt_html_type_table PIPELINED;

926: l_plsql_entry IN VARCHAR2 DEFAULT NULL,
927: l_data_src IN NUMBER DEFAULT 0,
928: l_container IN VARCHAR2 DEFAULT NULL
929: )
930: RETURN awrrpt_html_type_table PIPELINED;
931:
932: -- ***********************************************************
933: -- NAME: ash_report_analytics
934: -- This is the function that will return the