eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IES_SVY_DEPLOYMENT_PVT dependencies on JTF_FM_TEMPLATE_CONTENTS

Line 355: FROM JTF_FM_TEMPLATE_CONTENTS, JTF_FM_AMV_ITEMS_VL

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:

Line 356: WHERE JTF_FM_TEMPLATE_CONTENTS.TEMPLATE_ID = p_template_id

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:
360: CURSOR CEMAILADD IS

Line 357: AND JTF_FM_TEMPLATE_CONTENTS.CONTENT_NUMBER = JTF_FM_AMV_ITEMS_VL.ITEM_ID

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

Line 358: AND JTF_FM_TEMPLATE_CONTENTS.F_DELETEDFLAG IS NULL;

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
362: FROM AMS_LIST_ENTRIES

Line 518: l_Error_Msg := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';

514:
515: END LOOP;
516:
517: IF(CCONTENT%NOTFOUND) AND ( v_count = 0)THEN
518: l_Error_Msg := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
519: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
520: FND_MESSAGE.set_name('JTF', 'IES_SVY_API_CONTENT_NOT_FOUND');
521: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));
522: FND_MSG_PUB.Add;

Line 761: FROM JTF_FM_TEMPLATE_CONTENTS, JTF_FM_AMV_ITEMS_VL

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:

Line 762: WHERE JTF_FM_TEMPLATE_CONTENTS.TEMPLATE_ID = p_template_id

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:
766: CURSOR CEMAILSUBJECTHEADING IS

Line 763: AND JTF_FM_TEMPLATE_CONTENTS.CONTENT_NUMBER = JTF_FM_AMV_ITEMS_VL.ITEM_ID

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

Line 764: AND JTF_FM_TEMPLATE_CONTENTS.F_DELETEDFLAG IS NULL;

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
768: FROM IES_SVY_DEPLYMENTS_ALL

Line 918: l_Error_Msg := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';

914: l_content_xml := l_content_xml || l_content_xml1;
915: END LOOP;
916:
917: IF(CCONTENT%NOTFOUND) AND ( v_count = 0)THEN
918: l_Error_Msg := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('JTF', 'IES_SVY_API_CONTENT_NOT_FOUND');
921: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));
922: FND_MSG_PUB.Add;

Line 924: x_message := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';

920: FND_MESSAGE.set_name('JTF', 'IES_SVY_API_CONTENT_NOT_FOUND');
921: FND_MESSAGE.Set_Token('ARG1', to_char(l_content_no));
922: FND_MSG_PUB.Add;
923: END IF;
924: x_message := 'Could not find content no in JTF_FM_TEMPLATE_CONTENTS';
925: RAISE FND_API.G_EXC_ERROR;
926: END IF;
927: CLOSE CCONTENT;
928: /*