PL/SQL functions or procedure, need help or advice

See more:

SQL

hi guys.
im new on PL/SQL. i need help or advice on how to solve a problem.
i have functions 1 and 2 with a input who simply returns count(*),
now the problem is when i wane write a third function or procedure and call this 2.
i want the third function or procedure to select the table and call the functions to see how many rows with the specific id has so i can later do some validation.
is this possible DOTO:?

/* function 1 */
CREATE OR REPLACE FUNCTION total_SV_rows(val number)
RETURN number IS
   total number := 0;
BEGIN

   SELECT DISTINCT count(*) into total
   FROM TMP_SV TSV
   WHERE TSV.CODE_LABEL = '47' || val;
   RETURN total;
   
END;
/

/* function 2 */
CREATE OR REPLACE FUNCTION total_IRIS_rows(val number)
RETURN number IS
   total number := 0;
BEGIN

   SELECT DISTINCT count(*) into total
   FROM TMP_SUBPRODUCT_IRIS TSI
   WHERE TSI.MSISDN = val;
   RETURN total;
END;
/



/* wane call function 1 and 2 here  */
create or replace PROCEDURE get_TMP_SUBPRODUCT_IRIS AS

BEGIN
   for i IN   (
        select TSI.MSISDN msisdn, TSI.PRODUCT_NAME p_name, TSI.EXT_ID_REF ref_id,                TSI.ACTIVATION_DATE act_date
        from TMP_SUBPRODUCT_IRIS TSI
        where MSISDN = 97198252
   )
   LOOP
        DBMS_OUTPUT.PUT_LINE ('write output');
   end loop;

END get_TMP_SUBPRODUCT_IRIS;