351: l_survey_list_entry_id NUMBER;
352:
353: CURSOR CCONTENT IS
354: SELECT CONTENT_NUMBER, CONTENT_TYPE_ID
355: FROM JTF_FM_TEMPLATE_CONTENTS, JTF_FM_AMV_ITEMS_VL
356: WHERE JTF_FM_TEMPLATE_CONTENTS.TEMPLATE_ID = p_template_id
357: AND JTF_FM_TEMPLATE_CONTENTS.CONTENT_NUMBER = JTF_FM_AMV_ITEMS_VL.ITEM_ID
358: AND JTF_FM_TEMPLATE_CONTENTS.F_DELETEDFLAG IS NULL;
359:
353: CURSOR CCONTENT IS
354: SELECT CONTENT_NUMBER, CONTENT_TYPE_ID
355: FROM JTF_FM_TEMPLATE_CONTENTS, JTF_FM_AMV_ITEMS_VL
356: WHERE JTF_FM_TEMPLATE_CONTENTS.TEMPLATE_ID = p_template_id
357: AND JTF_FM_TEMPLATE_CONTENTS.CONTENT_NUMBER = JTF_FM_AMV_ITEMS_VL.ITEM_ID
358: AND JTF_FM_TEMPLATE_CONTENTS.F_DELETEDFLAG IS NULL;
359:
360: CURSOR CEMAILADD IS
361: SELECT EMAIL_ADDRESS
757: l_query_id NUMBER := 0;
758:
759: CURSOR CCONTENT IS
760: SELECT CONTENT_NUMBER, CONTENT_TYPE_ID
761: FROM JTF_FM_TEMPLATE_CONTENTS, JTF_FM_AMV_ITEMS_VL
762: WHERE JTF_FM_TEMPLATE_CONTENTS.TEMPLATE_ID = p_template_id
763: AND JTF_FM_TEMPLATE_CONTENTS.CONTENT_NUMBER = JTF_FM_AMV_ITEMS_VL.ITEM_ID
764: AND JTF_FM_TEMPLATE_CONTENTS.F_DELETEDFLAG IS NULL;
765:
759: CURSOR CCONTENT IS
760: SELECT CONTENT_NUMBER, CONTENT_TYPE_ID
761: FROM JTF_FM_TEMPLATE_CONTENTS, JTF_FM_AMV_ITEMS_VL
762: WHERE JTF_FM_TEMPLATE_CONTENTS.TEMPLATE_ID = p_template_id
763: AND JTF_FM_TEMPLATE_CONTENTS.CONTENT_NUMBER = JTF_FM_AMV_ITEMS_VL.ITEM_ID
764: AND JTF_FM_TEMPLATE_CONTENTS.F_DELETEDFLAG IS NULL;
765:
766: CURSOR CEMAILSUBJECTHEADING IS
767: SELECT EMAIL_SUBJECT_HEADING