step4

CREATE OR REPLACE FUNCTION get_table_activity_report
    RETURN SYS_REFCURSOR
AS
    l_cursor SYS_REFCURSOR;

    TYPE t_table_stats IS RECORD (
        table_name_col     VARCHAR2(40),
        rows_last_45_days  NUMBER,
        total_rows_approx  NUMBER,
        percentage_change  NUMBER
    );
    TYPE t_table_stats_tab IS TABLE OF t_table_stats INDEX BY PLS_INTEGER;
    l_results t_table_stats_tab;
    v_idx PLS_INTEGER := 0;

BEGIN
    -- ... (Your loop and logic remains the same, populating l_results)
    FOR r IN (
        SELECT table_name
        FROM   user_tab_columns
        WHERE  column_name = 'INTERNTIMESTAMP'
          AND  data_type LIKE 'TIMESTAMP%'
        ORDER BY table_name
    )
    LOOP
        -- ... (The inner DECLARE/BEGIN/END block populating v_cnt and v_total)

        -- Store the results in the collection
        -- ... (Store to l_results(v_idx))
    END LOOP;

    -- Open the cursor and return it
    OPEN l_cursor FOR 
        SELECT
            t.table_name_col AS TABLE_NAME,
            t.rows_last_45_days AS ROWS_LAST_45_DAYS,
            t.total_rows_approx AS TOTAL_ROWS_APPROX,
            t.percentage_change AS PCT
        FROM TABLE(CAST(l_results AS t_table_stats_tab)) t;

    RETURN l_cursor;
EXCEPTION
    WHEN OTHERS THEN
        -- Handle global errors if needed
        RAISE;
END get_table_activity_report;
/