Question on calling stored procedure inside stored procedure

I have a procedure myproc6 which calls another procedure SEND_EMAIL_WITH_TXT_ATTACH within. Procedure myproc6 created and compiled successfully

When I execute myproc6, I do not see the expected results of SEND_EMAIL_WITH_TXT_ATTACH

When I execute semd_email_with_txt_attach separately it works and sends me email as expected. Can someone please provide your feedback as to what could be missing.

create or replace procedure myproc6 as 

cursor c1 is

select A.table_name tname,A.row_count amrowcount, W.row_count wprowcount,C.row_count clrowcount

from CARE_TBLROWCOUNT@am_prd_link A, CARE_TBLROWCOUNT@wp_prd_link W, CARE_TBLROWCOUNT@cl_prd_link C