user8612301 wrote:use the famous logical statement
I am using Apex Send Email Process.
I have a page where i have check box conditions. ONLY WHEN check box checked as 'Yes', I need to display that field into Email.
field 1-Birthday Card Order YES NO
field 2-Wedding Card Order YES NO
If 1- is checked YES and 2- is checked as NO then I need to insert only
LABEL NAME FOR field 1. like,...
*1-Birthday Card Order*.How? Please advise.
Edited by: user8612301 on Mar 7, 2013 1:47 PM
DECLARE l_label VARCHAR2(200); BEGIN IF v('P1_LABEL') = 'Y' THEN SELECT label INTO l_label FROM apex_application_page_items WHERE application_id = :APP_ID AND page_id = :APP_PAGE_ID WHERE item_name = 'P1_LABEL'; l_html_body := l_label||' extra email text...'; END IF;