623:
624:
625: cursor c_rtf_data(c_template_name in varchar2) is
626: Select application_short_name,template_code,default_language,default_territory 627: from xdo_templates_vl 628: where template_name =c_template_name
629: and application_id=8303;
630:
631: CURSOR c_rep_id (c_exception_report_id IN VARCHAR2