69: as
70:
71: begin
72:
73: return (wfa_html.conv_special_url_chars(P_APPLICATION_SHORT_NAME||
74: ':'||P_QUESTION_CODE||':'||P_QUESTION));
75:
76: exception
77: when others then
129:
130: l_question := substrb(l_temp_str, l_colon+1);
131:
132:
133: return (wfa_html.base_url||'/icx_questions_admin.display_questions'||
134: '?p_application_short_name='||wfa_html.conv_special_url_chars(l_application_short_name)||
135: '&p_question_code='||wfa_html.conv_special_url_chars(l_question_code)||
136: '&p_question='||wfa_html.conv_special_url_chars(l_question));
137:
130: l_question := substrb(l_temp_str, l_colon+1);
131:
132:
133: return (wfa_html.base_url||'/icx_questions_admin.display_questions'||
134: '?p_application_short_name='||wfa_html.conv_special_url_chars(l_application_short_name)||
135: '&p_question_code='||wfa_html.conv_special_url_chars(l_question_code)||
136: '&p_question='||wfa_html.conv_special_url_chars(l_question));
137:
138: exception
131:
132:
133: return (wfa_html.base_url||'/icx_questions_admin.display_questions'||
134: '?p_application_short_name='||wfa_html.conv_special_url_chars(l_application_short_name)||
135: '&p_question_code='||wfa_html.conv_special_url_chars(l_question_code)||
136: '&p_question='||wfa_html.conv_special_url_chars(l_question));
137:
138: exception
139: when others then
132:
133: return (wfa_html.base_url||'/icx_questions_admin.display_questions'||
134: '?p_application_short_name='||wfa_html.conv_special_url_chars(l_application_short_name)||
135: '&p_question_code='||wfa_html.conv_special_url_chars(l_question_code)||
136: '&p_question='||wfa_html.conv_special_url_chars(l_question));
137:
138: exception
139: when others then
140: raise;
149:
150: IS
151:
152: l_username varchar2(80);
153: l_media varchar2(240) := wfa_html.image_loc;
154: l_icon varchar2(30) := 'FNDILOV.gif';
155: l_text varchar2(30) := '';
156: l_onmouseover varchar2(30) := wf_core.translate ('WFPREF_LOV');
157: l_url varchar2(4000);
165: -- Set page title
166: htp.htmlOpen;
167: htp.headOpen;
168: htp.title(wf_core.translate('ICX_FIND_QUESTIONS_TITLE'));
169: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
170: fnd_document_management.get_open_dm_display_window;
171: wf_lov.OpenLovWinHtml;
172:
173: htp.headClose;
236: htp.tableRowOpen;
237:
238: htp.p('
238: htp.p('
278:
279: l_error_msg varchar2(240);
280:
281: l_url varchar2(240);
282: l_media varchar2(240) := wfa_html.image_loc;
283: l_icon varchar2(30);
284: l_text varchar2(30);
285: l_onmouseover varchar2(30);
286:
322: htp.htmlOpen;
323: htp.headOpen;
324: htp.p('
325: htp.title(wf_core.translate('ICX_QUESTIONS_TITLE'));
326: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
327: htp.headClose;
328: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_QUESTIONS_TITLE'), FALSE);
329: htp.br;
330:
358:
359: htp.tableData(questions.application_short_name, 'left');
360:
361: htp.tableData(htf.anchor2(
362: curl=>wfa_html.base_url||
363: '/icx_questions_admin.edit_question'||
364: '?p_application_id='||questions.application_id||
365: '&p_question_code='||wfa_html.conv_special_url_chars(questions.question_code)||
366: '&p_insert=FALSE'||
361: htp.tableData(htf.anchor2(
362: curl=>wfa_html.base_url||
363: '/icx_questions_admin.edit_question'||
364: '?p_application_id='||questions.application_id||
365: '&p_question_code='||wfa_html.conv_special_url_chars(questions.question_code)||
366: '&p_insert=FALSE'||
367: '&p_find_criteria='||l_find_criteria,
368: ctext=>questions.question_code, ctarget=>'_top'),
369: 'Left');
369: 'Left');
370:
371: htp.tableData(questions.question, 'left');
372:
373: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
374: '/icx_questions_admin.display_functions'||
375: '?p_question_code='||wfa_html.conv_special_url_chars(questions.question_code)||
376: '&p_find_criteria='||l_find_criteria,
377: ctext=>''),
371: htp.tableData(questions.question, 'left');
372:
373: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
374: '/icx_questions_admin.display_functions'||
375: '?p_question_code='||wfa_html.conv_special_url_chars(questions.question_code)||
376: '&p_find_criteria='||l_find_criteria,
377: ctext=>''),
378: 'center', cattributes=>'valign="MIDDLE"');
379:
373: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
374: '/icx_questions_admin.display_functions'||
375: '?p_question_code='||wfa_html.conv_special_url_chars(questions.question_code)||
376: '&p_find_criteria='||l_find_criteria,
377: ctext=>''),
378: 'center', cattributes=>'valign="MIDDLE"');
379:
380: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
381: '/icx_questions_admin.question_confirm_delete'||
376: '&p_find_criteria='||l_find_criteria,
377: ctext=>''),
378: 'center', cattributes=>'valign="MIDDLE"');
379:
380: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
381: '/icx_questions_admin.question_confirm_delete'||
382: '?p_application_id='||questions.application_id||
383: '&p_question_code='||wfa_html.conv_special_url_chars(questions.question_code)||
384: '&p_find_criteria='||l_find_criteria,
379:
380: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
381: '/icx_questions_admin.question_confirm_delete'||
382: '?p_application_id='||questions.application_id||
383: '&p_question_code='||wfa_html.conv_special_url_chars(questions.question_code)||
384: '&p_find_criteria='||l_find_criteria,
385: ctext=>''),
386: 'center', cattributes=>'valign="MIDDLE"');
387:
381: '/icx_questions_admin.question_confirm_delete'||
382: '?p_application_id='||questions.application_id||
383: '&p_question_code='||wfa_html.conv_special_url_chars(questions.question_code)||
384: '&p_find_criteria='||l_find_criteria,
385: ctext=>''),
386: 'center', cattributes=>'valign="MIDDLE"');
387:
388: end loop;
389:
395:
396: --Add new node Button
397: htp.tableRowOpen;
398:
399: l_url := wfa_html.base_url||'/icx_questions_admin.edit_question'||
400: '?p_insert=TRUE'||
401: '&p_find_criteria='||l_find_criteria;
402: l_icon := 'FNDADD11.gif';
403: l_text := wf_core.translate ('WFDM_CREATE');
443: L_QUESTION_CODE VARCHAR2(30) := NULL;
444: L_QUESTION VARCHAR2(4000) := NULL;
445:
446: l_username varchar2(80);
447: l_media varchar2(240) := wfa_html.image_loc;
448: l_icon varchar2(30) := 'FNDILOV.gif';
449: l_text varchar2(30) := '';
450: l_onmouseover varchar2(30) := wf_core.translate ('WFPREF_LOV');
451: l_url varchar2(4000);
484: -- Set page title
485: htp.htmlOpen;
486: htp.headOpen;
487: htp.title(wf_core.translate('ICX_EDIT_QUESTION_TITLE'));
488: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
489: fnd_document_management.get_open_dm_display_window;
490: wf_lov.OpenLovWinHtml;
491:
492: htp.headClose;
684:
685:
686: if (l_error_msg IS NOT NULL) THEN
687:
688: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_question'||
689: '?p_application_id='||p_application_id||
690: '&p_error_message='||l_error_msg||
691: '&p_application_short_name='||UPPER(p_application_short_name)||
692: '&p_question_code='||wfa_html.conv_special_url_chars(UPPER(p_question_code))||
688: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_question'||
689: '?p_application_id='||p_application_id||
690: '&p_error_message='||l_error_msg||
691: '&p_application_short_name='||UPPER(p_application_short_name)||
692: '&p_question_code='||wfa_html.conv_special_url_chars(UPPER(p_question_code))||
693: '&p_insert=TRUE'||
694: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria)||
695: '&p_question='||wfa_html.conv_special_url_chars(p_question),
696: bclose_header=>TRUE);
690: '&p_error_message='||l_error_msg||
691: '&p_application_short_name='||UPPER(p_application_short_name)||
692: '&p_question_code='||wfa_html.conv_special_url_chars(UPPER(p_question_code))||
693: '&p_insert=TRUE'||
694: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria)||
695: '&p_question='||wfa_html.conv_special_url_chars(p_question),
696: bclose_header=>TRUE);
697:
698: else
691: '&p_application_short_name='||UPPER(p_application_short_name)||
692: '&p_question_code='||wfa_html.conv_special_url_chars(UPPER(p_question_code))||
693: '&p_insert=TRUE'||
694: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria)||
695: '&p_question='||wfa_html.conv_special_url_chars(p_question),
696: bclose_header=>TRUE);
697:
698: else
699:
767:
768:
769: if (l_error_msg IS NOT NULL) THEN
770:
771: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_question'||
772: '?p_application_id='||p_application_id||
773: '&p_error_message='||l_error_msg||
774: '&p_application_short_name='||UPPER(p_application_short_name)||
775: '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
771: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_question'||
772: '?p_application_id='||p_application_id||
773: '&p_error_message='||l_error_msg||
774: '&p_application_short_name='||UPPER(p_application_short_name)||
775: '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
776: '&p_insert=FALSE'||
777: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria)||
778: '&p_question='||wfa_html.conv_special_url_chars(p_question),
779: bclose_header=>TRUE);
773: '&p_error_message='||l_error_msg||
774: '&p_application_short_name='||UPPER(p_application_short_name)||
775: '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
776: '&p_insert=FALSE'||
777: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria)||
778: '&p_question='||wfa_html.conv_special_url_chars(p_question),
779: bclose_header=>TRUE);
780:
781: else
774: '&p_application_short_name='||UPPER(p_application_short_name)||
775: '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
776: '&p_insert=FALSE'||
777: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria)||
778: '&p_question='||wfa_html.conv_special_url_chars(p_question),
779: bclose_header=>TRUE);
780:
781: else
782:
816: )
817: IS
818: username varchar2(240);
819: l_url varchar2(240);
820: l_media varchar2(240) := wfa_html.image_loc;
821: l_icon varchar2(30);
822: l_text varchar2(30);
823: l_onmouseover varchar2(30);
824: l_error_msg varchar2(2000);
831: htp.htmlOpen;
832: htp.headOpen;
833: htp.p('
834: htp.title(wf_core.translate('ICX_CONFIRMTITLE'));
835: wfa_html.create_help_function('wf/links/dmn.htm?DMND');
836: htp.headClose;
837: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_CONFIRMTITLE'), FALSE);
838: htp.br;
839:
839:
840: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
841: htp.tableOpen(calign=>'CENTER');
842: htp.tableRowOpen;
843: htp.tabledata('');
844: htp.tabledata(wf_core.translate('ICX_CONFIRM_DELETE_MESSAGE') || ': ' ||
845: ''||p_question_code||'');
846: htp.tableRowClose;
847: htp.tableClose;
848: htp.br;
849: htp.tableopen(calign=>'CENTER');
850: --Submit Button
851: htp.tableRowOpen;
852: l_url := wfa_html.base_url||'/icx_questions_admin.delete_question'||
853: '?p_application_id='||p_application_id||
854: '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
855: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
856: l_icon := 'FNDJLFOK.gif';
850: --Submit Button
851: htp.tableRowOpen;
852: l_url := wfa_html.base_url||'/icx_questions_admin.delete_question'||
853: '?p_application_id='||p_application_id||
854: '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
855: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
856: l_icon := 'FNDJLFOK.gif';
857: l_text := wf_core.translate ('WFMON_OK');
858: l_onmouseover := wf_core.translate ('WFMON_OK');
851: htp.tableRowOpen;
852: l_url := wfa_html.base_url||'/icx_questions_admin.delete_question'||
853: '?p_application_id='||p_application_id||
854: '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
855: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
856: l_icon := 'FNDJLFOK.gif';
857: l_text := wf_core.translate ('WFMON_OK');
858: l_onmouseover := wf_core.translate ('WFMON_OK');
859:
1008:
1009: exception
1010: when others then
1011: rollback;
1012: wf_core.context('Wfa_Html', 'wf_user_val');
1013: raise;
1014: end application_lov;
1015:
1016: --
1028:
1029: l_error_msg varchar2(240);
1030:
1031: l_url varchar2(240);
1032: l_media varchar2(240) := wfa_html.image_loc;
1033: l_icon varchar2(30);
1034: l_text varchar2(30);
1035: l_onmouseover varchar2(30);
1036:
1056: htp.htmlOpen;
1057: htp.headOpen;
1058: htp.p('
1059: htp.title(wf_core.translate('ICX_FUNCTIONS_TITLE'));
1060: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1061: htp.headClose;
1062: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_FUNCTIONS_TITLE'), FALSE);
1063: htp.br;
1064:
1089:
1090: htp.tableData(p_question_code, 'left');
1091:
1092: htp.tableData(htf.anchor2(
1093: curl=>wfa_html.base_url||
1094: '/icx_questions_admin.edit_function'||
1095: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1096: '&p_function_id='||functions.function_id||
1097: '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
1091:
1092: htp.tableData(htf.anchor2(
1093: curl=>wfa_html.base_url||
1094: '/icx_questions_admin.edit_function'||
1095: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1096: '&p_function_id='||functions.function_id||
1097: '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
1098: '&p_insert=FALSE'||
1099: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1093: curl=>wfa_html.base_url||
1094: '/icx_questions_admin.edit_function'||
1095: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1096: '&p_function_id='||functions.function_id||
1097: '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
1098: '&p_insert=FALSE'||
1099: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1100: ctext=>functions.function_name, ctarget=>'_top'),
1101: 'Left');
1095: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1096: '&p_function_id='||functions.function_id||
1097: '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
1098: '&p_insert=FALSE'||
1099: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1100: ctext=>functions.function_name, ctarget=>'_top'),
1101: 'Left');
1102:
1103: htp.tableData(functions.user_function_name, 'left');
1101: 'Left');
1102:
1103: htp.tableData(functions.user_function_name, 'left');
1104:
1105: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1106: '/icx_questions_admin.delete_function'||
1107: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1108: '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
1109: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1103: htp.tableData(functions.user_function_name, 'left');
1104:
1105: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1106: '/icx_questions_admin.delete_function'||
1107: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1108: '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
1109: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1110: ctext=>''),
1111: 'center', cattributes=>'valign="MIDDLE"');
1104:
1105: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1106: '/icx_questions_admin.delete_function'||
1107: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1108: '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
1109: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1110: ctext=>''),
1111: 'center', cattributes=>'valign="MIDDLE"');
1112:
1105: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1106: '/icx_questions_admin.delete_function'||
1107: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1108: '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
1109: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1110: ctext=>''),
1111: 'center', cattributes=>'valign="MIDDLE"');
1112:
1113: end loop;
1106: '/icx_questions_admin.delete_function'||
1107: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1108: '&p_function_name='||wfa_html.conv_special_url_chars(functions.function_name)||
1109: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1110: ctext=>''),
1111: 'center', cattributes=>'valign="MIDDLE"');
1112:
1113: end loop;
1114:
1120:
1121: --Add new node Button
1122: htp.tableRowOpen;
1123:
1124: l_url := wfa_html.base_url||'/icx_questions_admin.edit_function'||
1125: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1126: '&p_insert=TRUE'||
1127: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1128: l_icon := 'FNDADD11.gif';
1121: --Add new node Button
1122: htp.tableRowOpen;
1123:
1124: l_url := wfa_html.base_url||'/icx_questions_admin.edit_function'||
1125: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1126: '&p_insert=TRUE'||
1127: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1128: l_icon := 'FNDADD11.gif';
1129: l_text := wf_core.translate ('WFDM_CREATE');
1123:
1124: l_url := wfa_html.base_url||'/icx_questions_admin.edit_function'||
1125: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1126: '&p_insert=TRUE'||
1127: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1128: l_icon := 'FNDADD11.gif';
1129: l_text := wf_core.translate ('WFDM_CREATE');
1130: l_onmouseover := wf_core.translate ('WFDM_CREATE');
1131:
1179: L_FUNCTION_NAME VARCHAR2(30) := NULL;
1180: L_USER_FUNCTION_NAME VARCHAR2(80) := NULL;
1181:
1182: l_username varchar2(80);
1183: l_media varchar2(240) := wfa_html.image_loc;
1184: l_icon varchar2(30) := 'FNDILOV.gif';
1185: l_text varchar2(30) := '';
1186: l_onmouseover varchar2(30) := wf_core.translate ('WFPREF_LOV');
1187: l_url varchar2(4000);
1213: -- Set page title
1214: htp.htmlOpen;
1215: htp.headOpen;
1216: htp.title(wf_core.translate('ICX_EDIT_FUNCTION_TITLE'));
1217: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1218: fnd_document_management.get_open_dm_display_window;
1219: wf_lov.OpenLovWinHtml;
1220:
1221: htp.headClose;
1317: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
1318:
1319: htp.p('');
1320:
1321: l_url := wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1322: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1323: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1324: l_icon := 'FNDJLFCN.gif';
1325: l_text := wf_core.translate ('CANCEL');
1318:
1319: htp.p('');
1320:
1321: l_url := wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1322: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1323: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1324: l_icon := 'FNDJLFCN.gif';
1325: l_text := wf_core.translate ('CANCEL');
1326: l_onmouseover := wf_core.translate ('CANCEL');
1319: htp.p('');
1320:
1321: l_url := wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1322: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1323: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1324: l_icon := 'FNDJLFCN.gif';
1325: l_text := wf_core.translate ('CANCEL');
1326: l_onmouseover := wf_core.translate ('CANCEL');
1327:
1443:
1444: exception
1445: when others then
1446: rollback;
1447: wf_core.context('Wfa_Html', 'wf_user_val');
1448: raise;
1449: end function_lov;
1450:
1451:
1495:
1496:
1497: if (l_error_msg IS NOT NULL) THEN
1498:
1499: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_function'||
1500: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1501: '&p_function_id='||p_function_id||
1502: '&p_function_name='||wfa_html.conv_special_url_chars(p_function_name)||
1503: '&p_insert=TRUE'||
1496:
1497: if (l_error_msg IS NOT NULL) THEN
1498:
1499: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_function'||
1500: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1501: '&p_function_id='||p_function_id||
1502: '&p_function_name='||wfa_html.conv_special_url_chars(p_function_name)||
1503: '&p_insert=TRUE'||
1504: '&p_error_message='||l_error_msg||
1498:
1499: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_function'||
1500: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1501: '&p_function_id='||p_function_id||
1502: '&p_function_name='||wfa_html.conv_special_url_chars(p_function_name)||
1503: '&p_insert=TRUE'||
1504: '&p_error_message='||l_error_msg||
1505: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1506: bclose_header=>TRUE);
1501: '&p_function_id='||p_function_id||
1502: '&p_function_name='||wfa_html.conv_special_url_chars(p_function_name)||
1503: '&p_insert=TRUE'||
1504: '&p_error_message='||l_error_msg||
1505: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1506: bclose_header=>TRUE);
1507:
1508: else
1509:
1524: 1
1525: );
1526:
1527: -- use owa_util.redirect_url to redirect the URL to the home page
1528: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1529: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1530: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1531: bclose_header=>TRUE);
1532:
1525: );
1526:
1527: -- use owa_util.redirect_url to redirect the URL to the home page
1528: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1529: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1530: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1531: bclose_header=>TRUE);
1532:
1533: end if;
1526:
1527: -- use owa_util.redirect_url to redirect the URL to the home page
1528: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1529: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1530: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1531: bclose_header=>TRUE);
1532:
1533: end if;
1534:
1584: end if;
1585:
1586: if (l_error_msg IS NOT NULL) THEN
1587:
1588: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_function'||
1589: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1590: '&p_function_id='||p_function_id||
1591: '&p_function_name='||wfa_html.conv_special_url_chars(p_function_name)||
1592: '&p_insert=TRUE'||
1585:
1586: if (l_error_msg IS NOT NULL) THEN
1587:
1588: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_function'||
1589: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1590: '&p_function_id='||p_function_id||
1591: '&p_function_name='||wfa_html.conv_special_url_chars(p_function_name)||
1592: '&p_insert=TRUE'||
1593: '&p_error_message='||l_error_msg||
1587:
1588: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.edit_function'||
1589: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1590: '&p_function_id='||p_function_id||
1591: '&p_function_name='||wfa_html.conv_special_url_chars(p_function_name)||
1592: '&p_insert=TRUE'||
1593: '&p_error_message='||l_error_msg||
1594: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1595: bclose_header=>TRUE);
1590: '&p_function_id='||p_function_id||
1591: '&p_function_name='||wfa_html.conv_special_url_chars(p_function_name)||
1592: '&p_insert=TRUE'||
1593: '&p_error_message='||l_error_msg||
1594: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1595: bclose_header=>TRUE);
1596:
1597: else
1598:
1605: AND FUNCTION_NAME = P_OLD_FUNCTION_NAME;
1606:
1607: -- use owa_util.redirect_url to redirect the URL to the home page
1608:
1609: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1610: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1611: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1612: bclose_header=>TRUE);
1613:
1606:
1607: -- use owa_util.redirect_url to redirect the URL to the home page
1608:
1609: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1610: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1611: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1612: bclose_header=>TRUE);
1613:
1614: end if;
1607: -- use owa_util.redirect_url to redirect the URL to the home page
1608:
1609: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1610: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1611: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1612: bclose_header=>TRUE);
1613:
1614: end if;
1615:
1642: WHERE QUESTION_CODE = P_QUESTION_CODE
1643: AND FUNCTION_NAME = P_FUNCTION_NAME;
1644:
1645: -- use owa_util.redirect_url to redirect the URL to the home page
1646: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1647: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1648: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1649: bclose_header=>TRUE);
1650:
1643: AND FUNCTION_NAME = P_FUNCTION_NAME;
1644:
1645: -- use owa_util.redirect_url to redirect the URL to the home page
1646: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1647: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1648: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1649: bclose_header=>TRUE);
1650:
1651: exception
1644:
1645: -- use owa_util.redirect_url to redirect the URL to the home page
1646: owa_util.redirect_url(curl=>wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1647: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1648: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria),
1649: bclose_header=>TRUE);
1650:
1651: exception
1652: when others then