21: error_name varchar2(30);
22: error_message varchar2(2000);
23: error_stack varchar2(32000);
24: begin
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title(wf_core.translate('ERROR'));
28: htp.headClose;
29:
22: error_message varchar2(2000);
23: error_stack varchar2(32000);
24: begin
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title(wf_core.translate('ERROR'));
28: htp.headClose;
29:
30: begin
23: error_stack varchar2(32000);
24: begin
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title(wf_core.translate('ERROR'));
28: htp.headClose;
29:
30: begin
31: wfa_sec.Header(background_only=>TRUE);
24: begin
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title(wf_core.translate('ERROR'));
28: htp.headClose;
29:
30: begin
31: wfa_sec.Header(background_only=>TRUE);
32: exception
30: begin
31: wfa_sec.Header(background_only=>TRUE);
32: exception
33: when others then
34: htp.bodyOpen;
35: end;
36:
37: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
38:
33: when others then
34: htp.bodyOpen;
35: end;
36:
37: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
38:
39: wf_core.get_error(error_name, error_message, error_stack);
40:
41: if (error_name is not null) then
38:
39: wf_core.get_error(error_name, error_message, error_stack);
40:
41: if (error_name is not null) then
42: htp.p(error_message);
43: else
44: htp.p(sqlerrm);
45: end if;
46:
40:
41: if (error_name is not null) then
42: htp.p(error_message);
43: else
44: htp.p(sqlerrm);
45: end if;
46:
47: htp.hr;
48: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
43: else
44: htp.p(sqlerrm);
45: end if;
46:
47: htp.hr;
48: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
49: htp.br;
50: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
51: replace(error_stack,wf_core.newline,'
'));
44: htp.p(sqlerrm);
45: end if;
46:
47: htp.hr;
48: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
49: htp.br;
50: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
51: replace(error_stack,wf_core.newline,'
'));
52:
45: end if;
46:
47: htp.hr;
48: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
49: htp.br;
50: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
51: replace(error_stack,wf_core.newline,'
'));
52:
53: wfa_sec.Footer;
46:
47: htp.hr;
48: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
49: htp.br;
50: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
51: replace(error_stack,wf_core.newline,'
'));
52:
53: wfa_sec.Footer;
54: htp.htmlClose;
50: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
51: replace(error_stack,wf_core.newline,'
'));
52:
53: wfa_sec.Footer;
54: htp.htmlClose;
55:
56: end Error;
57:
58: --
162: -- Check current user has admin authority
163: wfa_sec.GetSession(l_username);
164:
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;
163: wfa_sec.GetSession(l_username);
164:
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;
164:
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:
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;
174:
175: -- Page header
176: wfa_sec.Header(FALSE, '', wf_core.translate('ICX_FIND_QUESTIONS_TITLE'), TRUE);
177:
174:
175: -- Page header
176: wfa_sec.Header(FALSE, '', wf_core.translate('ICX_FIND_QUESTIONS_TITLE'), TRUE);
177:
178: htp.tableopen(calign=>'CENTER');
179:
180: htp.p('
180: htp.p('
195: '&p_current_value=top.opener.document.ICX_FIND_QUESTIONS.p_application_short_name.value'||
196: '&p_dest_display_field=top.opener.document.ICX_FIND_QUESTIONS.p_application_short_name.value',
197: ' ', '%20')||''''||',400,500)';
198:
199: htp.tableData(htf.formText(cname=>'p_application_short_name', csize=>'25',
200: cvalue=>null, cmaxlength=>'50')||
201: ''||
202: '');
201: ''||
202: '');
204:
205: htp.tablerowclose;
206:
207:
208: -- Question Code
209: htp.tableRowOpen;
205: htp.tablerowclose;
206:
207:
208: -- Question Code
209: htp.tableRowOpen;
210: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
211: calign=>'right');
212:
213: htp.tableData(htf.formText(cname=>'p_question_code', csize=>'25',
206:
207:
208: -- Question Code
209: htp.tableRowOpen;
210: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
211: calign=>'right');
212:
213: htp.tableData(htf.formText(cname=>'p_question_code', csize=>'25',
214: cvalue=>null, cmaxlength=>'30'));
209: htp.tableRowOpen;
210: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
211: calign=>'right');
212:
213: htp.tableData(htf.formText(cname=>'p_question_code', csize=>'25',
214: cvalue=>null, cmaxlength=>'30'));
215:
216: htp.tableRowClose;
217:
212:
213: htp.tableData(htf.formText(cname=>'p_question_code', csize=>'25',
214: cvalue=>null, cmaxlength=>'30'));
215:
216: htp.tableRowClose;
217:
218: -- Question
219: htp.tableRowOpen;
220: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
215:
216: htp.tableRowClose;
217:
218: -- Question
219: htp.tableRowOpen;
220: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
221: calign=>'right');
222:
223: htp.tableData(htf.formText(cname=>'p_question', csize=>'50',
216: htp.tableRowClose;
217:
218: -- Question
219: htp.tableRowOpen;
220: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
221: calign=>'right');
222:
223: htp.tableData(htf.formText(cname=>'p_question', csize=>'50',
224: cvalue=>null, cmaxlength=>'240'));
219: htp.tableRowOpen;
220: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
221: calign=>'right');
222:
223: htp.tableData(htf.formText(cname=>'p_question', csize=>'50',
224: cvalue=>null, cmaxlength=>'240'));
225:
226: htp.tableRowClose;
227:
222:
223: htp.tableData(htf.formText(cname=>'p_question', csize=>'50',
224: cvalue=>null, cmaxlength=>'240'));
225:
226: htp.tableRowClose;
227:
228: htp.tableclose;
229:
230: htp.br;
224: cvalue=>null, cmaxlength=>'240'));
225:
226: htp.tableRowClose;
227:
228: htp.tableclose;
229:
230: htp.br;
231:
232: htp.tableopen(calign=>'CENTER');
226: htp.tableRowClose;
227:
228: htp.tableclose;
229:
230: htp.br;
231:
232: htp.tableopen(calign=>'CENTER');
233:
234: --Submit Button
228: htp.tableclose;
229:
230: htp.br;
231:
232: htp.tableopen(calign=>'CENTER');
233:
234: --Submit Button
235:
236: htp.tableRowOpen;
232: htp.tableopen(calign=>'CENTER');
233:
234: --Submit Button
235:
236: htp.tableRowOpen;
237:
238: htp.p('
234: --Submit Button
235:
236: htp.tableRowOpen;
237:
238: htp.p('
242: wfa_html.image_loc,
243: 'fndfind.gif',
244: wf_core.translate ('FIND'));
245:
246: htp.p('
244: wf_core.translate ('FIND'));
245:
246: htp.p('');
247:
248: htp.tableRowClose;
249:
250: htp.tableclose;
251:
252: htp.formClose;
246: htp.p('');
247:
248: htp.tableRowClose;
249:
250: htp.tableclose;
251:
252: htp.formClose;
253:
254: wfa_sec.Footer;
248: htp.tableRowClose;
249:
250: htp.tableclose;
251:
252: htp.formClose;
253:
254: wfa_sec.Footer;
255: htp.htmlClose;
256:
251:
252: htp.formClose;
253:
254: wfa_sec.Footer;
255: htp.htmlClose;
256:
257:
258: exception
259: when others then
318: -- Check current user has admin authority
319: wfa_sec.GetSession(username);
320:
321: -- Set page title
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');
319: wfa_sec.GetSession(username);
320:
321: -- Set page title
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;
320:
321: -- Set page title
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);
321: -- Set page title
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;
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:
331: -- Column headers
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:
331: -- Column headers
332: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
333: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
328: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_QUESTIONS_TITLE'), FALSE);
329: htp.br;
330:
331: -- Column headers
332: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
333: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
334:
335: htp.tableHeader(cvalue=>''||
336: wf_core.translate('ICX_APPLICATION')||'',
329: htp.br;
330:
331: -- Column headers
332: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
333: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
334:
335: htp.tableHeader(cvalue=>''||
336: wf_core.translate('ICX_APPLICATION')||'',
337: calign=>'Center');
331: -- Column headers
332: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
333: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
334:
335: htp.tableHeader(cvalue=>''||
336: wf_core.translate('ICX_APPLICATION')||'',
337: calign=>'Center');
338: htp.tableHeader(cvalue=>''||
339: wf_core.translate('ICX_QUESTION_CODE')||'',
334:
335: htp.tableHeader(cvalue=>''||
336: wf_core.translate('ICX_APPLICATION')||'',
337: calign=>'Center');
338: htp.tableHeader(cvalue=>''||
339: wf_core.translate('ICX_QUESTION_CODE')||'',
340: calign=>'Center');
341: htp.tableHeader(cvalue=>''||
342: wf_core.translate('ICX_QUESTION')||'',
337: calign=>'Center');
338: htp.tableHeader(cvalue=>''||
339: wf_core.translate('ICX_QUESTION_CODE')||'',
340: calign=>'Center');
341: htp.tableHeader(cvalue=>''||
342: wf_core.translate('ICX_QUESTION')||'',
343: calign=>'Center');
344: htp.tableHeader(cvalue=>''||
345: wf_core.translate('ICX_EDIT_FUNCTIONS')||'',
340: calign=>'Center');
341: htp.tableHeader(cvalue=>''||
342: wf_core.translate('ICX_QUESTION')||'',
343: calign=>'Center');
344: htp.tableHeader(cvalue=>''||
345: wf_core.translate('ICX_EDIT_FUNCTIONS')||'',
346: calign=>'Center');
347: htp.tableHeader(cvalue=>''||
348: wf_core.translate('DELETE')||'',
343: calign=>'Center');
344: htp.tableHeader(cvalue=>''||
345: wf_core.translate('ICX_EDIT_FUNCTIONS')||'',
346: calign=>'Center');
347: htp.tableHeader(cvalue=>''||
348: wf_core.translate('DELETE')||'',
349: calign=>'Center');
350: htp.tableRowClose;
351: htp.tableRowOpen;
346: calign=>'Center');
347: htp.tableHeader(cvalue=>''||
348: wf_core.translate('DELETE')||'',
349: calign=>'Center');
350: htp.tableRowClose;
351: htp.tableRowOpen;
352: htp.tableRowClose;
353:
354: -- Show all nodes
347: htp.tableHeader(cvalue=>''||
348: wf_core.translate('DELETE')||'',
349: calign=>'Center');
350: htp.tableRowClose;
351: htp.tableRowOpen;
352: htp.tableRowClose;
353:
354: -- Show all nodes
355: for questions in quest_cursor loop
348: wf_core.translate('DELETE')||'',
349: calign=>'Center');
350: htp.tableRowClose;
351: htp.tableRowOpen;
352: htp.tableRowClose;
353:
354: -- Show all nodes
355: for questions in quest_cursor loop
356:
353:
354: -- Show all nodes
355: for questions in quest_cursor loop
356:
357: htp.tableRowOpen(null, 'TOP');
358:
359: htp.tableData(questions.application_short_name, 'left');
360:
361: htp.tableData(htf.anchor2(
355: for questions in quest_cursor loop
356:
357: htp.tableRowOpen(null, 'TOP');
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'||
357: htp.tableRowOpen(null, 'TOP');
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)||
367: '&p_find_criteria='||l_find_criteria,
368: ctext=>questions.question_code, ctarget=>'_top'),
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)||
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=>''),
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,
386: 'center', cattributes=>'valign="MIDDLE"');
387:
388: end loop;
389:
390: htp.tableclose;
391:
392: htp.br;
393:
394: htp.tableopen(calign=>'CENTER');
388: end loop;
389:
390: htp.tableclose;
391:
392: htp.br;
393:
394: htp.tableopen(calign=>'CENTER');
395:
396: --Add new node Button
390: htp.tableclose;
391:
392: htp.br;
393:
394: htp.tableopen(calign=>'CENTER');
395:
396: --Add new node Button
397: htp.tableRowOpen;
398:
393:
394: htp.tableopen(calign=>'CENTER');
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');
404: l_onmouseover := wf_core.translate ('WFDM_CREATE');
405:
406: htp.p('
406: htp.p('
408: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
409:
410: htp.p('');
411:
412: htp.tableRowClose;
413:
414: htp.tableclose;
415:
416: wfa_sec.Footer;
410: htp.p('');
411:
412: htp.tableRowClose;
413:
414: htp.tableclose;
415:
416: wfa_sec.Footer;
417: htp.htmlClose;
418:
413:
414: htp.tableclose;
415:
416: wfa_sec.Footer;
417: htp.htmlClose;
418:
419: exception
420: when others then
421: wf_core.context('icx_questions_admin', 'DISPLAY_QUESTIONS');
481:
482: end if;
483:
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;
482: end if;
483:
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;
483:
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:
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;
493:
494: -- Page header
495: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions', wf_core.translate('ICX_EDIT_QUESTION_TITLE'), TRUE);
496:
496:
497: -- Print the error message if there is one
498: if (P_ERROR_MESSAGE IS NOT NULL) THEN
499:
500: htp.br;
501: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');
502: htp.br;
503:
504: end if;
497: -- Print the error message if there is one
498: if (P_ERROR_MESSAGE IS NOT NULL) THEN
499:
500: htp.br;
501: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');
502: htp.br;
503:
504: end if;
505:
498: if (P_ERROR_MESSAGE IS NOT NULL) THEN
499:
500: htp.br;
501: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');
502: htp.br;
503:
504: end if;
505:
506: htp.tableopen(calign=>'CENTER');
502: htp.br;
503:
504: end if;
505:
506: htp.tableopen(calign=>'CENTER');
507:
508: if (P_INSERT = 'FALSE') THEN
509:
510: htp.p('
506: htp.tableopen(calign=>'CENTER');
507:
508: if (P_INSERT = 'FALSE') THEN
509:
510: htp.p('
512: else
513:
514: htp.p('
510: htp.p('
514: htp.p('
515:
516: end if;
517:
518: htp.formHidden(cname=>'p_application_id', cvalue=>l_application_id);
519: htp.formHidden(cname=>'p_find_criteria', cvalue=>p_find_criteria);
520:
521: -- Application Name
522: htp.tableRowOpen;
523: htp.tableData(cvalue=>wf_core.translate('ICX_APPLICATION'),
518: htp.formHidden(cname=>'p_application_id', cvalue=>l_application_id);
519: htp.formHidden(cname=>'p_find_criteria', cvalue=>p_find_criteria);
520:
521: -- Application Name
522: htp.tableRowOpen;
523: htp.tableData(cvalue=>wf_core.translate('ICX_APPLICATION'),
524: calign=>'right');
525:
526: -- add LOV here: Note:bottom is name of frame.
519: htp.formHidden(cname=>'p_find_criteria', cvalue=>p_find_criteria);
520:
521: -- Application Name
522: htp.tableRowOpen;
523: htp.tableData(cvalue=>wf_core.translate('ICX_APPLICATION'),
524: calign=>'right');
525:
526: -- add LOV here: Note:bottom is name of frame.
527: -- Note: The REPLACE function replaces all the space characters with
534: '&p_current_value=top.opener.document.ICX_EDIT_QUESTION.p_application_short_name.value'||
535: '&p_dest_display_field=top.opener.document.ICX_EDIT_QUESTION.p_application_short_name.value',
536: ' ', '%20')||''''||',400,500)';
537:
538: htp.tableData(htf.formText(cname=>'p_application_short_name', csize=>'25',
539: cvalue=>l_application_short_name, cmaxlength=>'50')||
540: ''||
541: '');
540: ''||
541: '');
543:
544: htp.tablerowclose;
545:
546:
547: -- Question Code
548: htp.tableRowOpen;
544: htp.tablerowclose;
545:
546:
547: -- Question Code
548: htp.tableRowOpen;
549: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
550: calign=>'right');
551:
552: IF (P_INSERT = 'FALSE') THEN
545:
546:
547: -- Question Code
548: htp.tableRowOpen;
549: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
550: calign=>'right');
551:
552: IF (P_INSERT = 'FALSE') THEN
553:
550: calign=>'right');
551:
552: IF (P_INSERT = 'FALSE') THEN
553:
554: htp.formHidden(cname=>'p_question_code', cvalue=>l_question_code);
555:
556: htp.tableData(cvalue=>''||l_question_code||'',
557: calign=>'left');
558:
552: IF (P_INSERT = 'FALSE') THEN
553:
554: htp.formHidden(cname=>'p_question_code', cvalue=>l_question_code);
555:
556: htp.tableData(cvalue=>''||l_question_code||'',
557: calign=>'left');
558:
559: ELSE
560:
557: calign=>'left');
558:
559: ELSE
560:
561: htp.tableData(htf.formText(cname=>'p_question_code', csize=>'25',
562: cvalue=>l_question_code, cmaxlength=>'30'));
563:
564: END IF;
565:
562: cvalue=>l_question_code, cmaxlength=>'30'));
563:
564: END IF;
565:
566: htp.tableRowClose;
567:
568: -- question
569: htp.tableRowOpen;
570: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
565:
566: htp.tableRowClose;
567:
568: -- question
569: htp.tableRowOpen;
570: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
571: calign=>'right', cattributes=>'VALIGN="TOP"');
572:
573: htp.p ('
566: htp.tableRowClose;
567:
568: -- question
569: htp.tableRowOpen;
570: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
571: calign=>'right', cattributes=>'VALIGN="TOP"');
572:
573: htp.p ('
569: htp.tableRowOpen;
570: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
571: calign=>'right', cattributes=>'VALIGN="TOP"');
572:
573: htp.p ('
571: calign=>'right', cattributes=>'VALIGN="TOP"');
572:
573: htp.p ('
575: htp.formTextareaOpen(cname=>'p_question', nrows=>'8',
576: ncolumns=>'50',
577: cattributes=>'WRAP="SOFT"');
578:
579: htp.p (l_question);
580:
581: htp.formTextareaClose;
582:
583: htp.p ('
577: cattributes=>'WRAP="SOFT"');
578:
579: htp.p (l_question);
580:
581: htp.formTextareaClose;
582:
583: htp.p ('
579: htp.p (l_question);
580:
581: htp.formTextareaClose;
582:
583: htp.p ('');
584:
585: htp.tableRowClose;
586:
587: htp.tableclose;
581: htp.formTextareaClose;
582:
583: htp.p ('');
584:
585: htp.tableRowClose;
586:
587: htp.tableclose;
588:
589: htp.br;
583: htp.p ('');
584:
585: htp.tableRowClose;
586:
587: htp.tableclose;
588:
589: htp.br;
590:
591: htp.tableopen(calign=>'CENTER');
585: htp.tableRowClose;
586:
587: htp.tableclose;
588:
589: htp.br;
590:
591: htp.tableopen(calign=>'CENTER');
592:
593: --Submit Button
587: htp.tableclose;
588:
589: htp.br;
590:
591: htp.tableopen(calign=>'CENTER');
592:
593: --Submit Button
594:
595: htp.tableRowOpen;
591: htp.tableopen(calign=>'CENTER');
592:
593: --Submit Button
594:
595: htp.tableRowOpen;
596:
597: l_url := 'javascript:document.ICX_EDIT_QUESTION.submit()';
598: l_icon := 'FNDJLFOK.gif';
599: l_text := wf_core.translate ('WFMON_OK');
598: l_icon := 'FNDJLFOK.gif';
599: l_text := wf_core.translate ('WFMON_OK');
600: l_onmouseover := wf_core.translate ('WFMON_OK');
601:
602: htp.p('
602: htp.p('
609: l_icon := 'FNDJLFCN.gif';
610: l_text := wf_core.translate ('CANCEL');
611: l_onmouseover := wf_core.translate ('CANCEL');
612:
613: htp.p('
613: htp.p('
615: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
616:
617: htp.p('');
618:
619: htp.tableRowClose;
620:
621: htp.tableclose;
622:
623: htp.formClose;
617: htp.p('');
618:
619: htp.tableRowClose;
620:
621: htp.tableclose;
622:
623: htp.formClose;
624:
625: wfa_sec.Footer;
619: htp.tableRowClose;
620:
621: htp.tableclose;
622:
623: htp.formClose;
624:
625: wfa_sec.Footer;
626: htp.htmlClose;
627:
622:
623: htp.formClose;
624:
625: wfa_sec.Footer;
626: htp.htmlClose;
627:
628:
629: exception
630: when others then
827: -- Check current user has admin authority
828: wfa_sec.GetSession(username);
829:
830: -- Set page title
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');
828: wfa_sec.GetSession(username);
829:
830: -- Set page title
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;
829:
830: -- Set page title
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);
830: -- Set page title
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;
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:
840: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
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:
840: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
841: htp.tableOpen(calign=>'CENTER');
842: htp.tableRowOpen;
836: htp.headClose;
837: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_CONFIRMTITLE'), FALSE);
838: htp.br;
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') || ': ' ||
837: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_CONFIRMTITLE'), FALSE);
838: htp.br;
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||'');
838: htp.br;
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;
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;
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;
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
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;
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'||
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||
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';
857: l_text := wf_core.translate ('WFMON_OK');
858: l_onmouseover := wf_core.translate ('WFMON_OK');
859:
860: htp.p('
858: l_onmouseover := wf_core.translate ('WFMON_OK');
859:
860: htp.p('
865: l_icon := 'FNDJLFCN.gif';
866: l_text := wf_core.translate ('CANCEL');
867: l_onmouseover := wf_core.translate ('CANCEL');
868:
869: htp.p('
867: l_onmouseover := wf_core.translate ('CANCEL');
868:
869: htp.p('
869: htp.p('
870: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
871: htp.p('');
872:
873: htp.tableRowClose;
874: htp.tableclose;
875: htp.formClose;
876: wfa_sec.Footer;
877: htp.htmlClose;
878:
871: htp.p('');
872:
873: htp.tableRowClose;
874: htp.tableclose;
875: htp.formClose;
876: wfa_sec.Footer;
877: htp.htmlClose;
878:
879: exception
873: htp.tableRowClose;
874: htp.tableclose;
875: htp.formClose;
876: wfa_sec.Footer;
877: htp.htmlClose;
878:
879: exception
880: when others then
881: rollback;
1052: -- Check current user has admin authority
1053: wfa_sec.GetSession(username);
1054:
1055: -- Set page title
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');
1053: wfa_sec.GetSession(username);
1054:
1055: -- Set page title
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;
1054:
1055: -- Set page title
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);
1055: -- Set page title
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;
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:
1065: -- Column headers
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:
1065: -- Column headers
1066: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
1067: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1062: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_FUNCTIONS_TITLE'), FALSE);
1063: htp.br;
1064:
1065: -- Column headers
1066: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
1067: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1068:
1069: htp.tableHeader(cvalue=>''||
1070: wf_core.translate('ICX_QUESTION')||'',
1063: htp.br;
1064:
1065: -- Column headers
1066: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
1067: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1068:
1069: htp.tableHeader(cvalue=>''||
1070: wf_core.translate('ICX_QUESTION')||'',
1071: calign=>'Center');
1065: -- Column headers
1066: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
1067: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1068:
1069: htp.tableHeader(cvalue=>''||
1070: wf_core.translate('ICX_QUESTION')||'',
1071: calign=>'Center');
1072: htp.tableHeader(cvalue=>''||
1073: wf_core.translate('ICX_FUNCTION')||'',
1068:
1069: htp.tableHeader(cvalue=>''||
1070: wf_core.translate('ICX_QUESTION')||'',
1071: calign=>'Center');
1072: htp.tableHeader(cvalue=>''||
1073: wf_core.translate('ICX_FUNCTION')||'',
1074: calign=>'Center');
1075: htp.tableHeader(cvalue=>''||
1076: wf_core.translate('ICX_USER_FUNCTION')||'',
1071: calign=>'Center');
1072: htp.tableHeader(cvalue=>''||
1073: wf_core.translate('ICX_FUNCTION')||'',
1074: calign=>'Center');
1075: htp.tableHeader(cvalue=>''||
1076: wf_core.translate('ICX_USER_FUNCTION')||'',
1077: calign=>'Center');
1078: htp.tableHeader(cvalue=>''||
1079: wf_core.translate('DELETE')||'',
1074: calign=>'Center');
1075: htp.tableHeader(cvalue=>''||
1076: wf_core.translate('ICX_USER_FUNCTION')||'',
1077: calign=>'Center');
1078: htp.tableHeader(cvalue=>''||
1079: wf_core.translate('DELETE')||'',
1080: calign=>'Center');
1081: htp.tableRowClose;
1082: htp.tableRowOpen;
1077: calign=>'Center');
1078: htp.tableHeader(cvalue=>''||
1079: wf_core.translate('DELETE')||'',
1080: calign=>'Center');
1081: htp.tableRowClose;
1082: htp.tableRowOpen;
1083: htp.tableRowClose;
1084:
1085: -- Show all nodes
1078: htp.tableHeader(cvalue=>''||
1079: wf_core.translate('DELETE')||'',
1080: calign=>'Center');
1081: htp.tableRowClose;
1082: htp.tableRowOpen;
1083: htp.tableRowClose;
1084:
1085: -- Show all nodes
1086: for functions in function_cursor loop
1079: wf_core.translate('DELETE')||'',
1080: calign=>'Center');
1081: htp.tableRowClose;
1082: htp.tableRowOpen;
1083: htp.tableRowClose;
1084:
1085: -- Show all nodes
1086: for functions in function_cursor loop
1087:
1084:
1085: -- Show all nodes
1086: for functions in function_cursor loop
1087:
1088: htp.tableRowOpen(null, 'TOP');
1089:
1090: htp.tableData(p_question_code, 'left');
1091:
1092: htp.tableData(htf.anchor2(
1086: for functions in function_cursor loop
1087:
1088: htp.tableRowOpen(null, 'TOP');
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'||
1088: htp.tableRowOpen(null, 'TOP');
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||
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');
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)||
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),
1111: 'center', cattributes=>'valign="MIDDLE"');
1112:
1113: end loop;
1114:
1115: htp.tableclose;
1116:
1117: htp.br;
1118:
1119: htp.tableopen(calign=>'CENTER');
1113: end loop;
1114:
1115: htp.tableclose;
1116:
1117: htp.br;
1118:
1119: htp.tableopen(calign=>'CENTER');
1120:
1121: --Add new node Button
1115: htp.tableclose;
1116:
1117: htp.br;
1118:
1119: htp.tableopen(calign=>'CENTER');
1120:
1121: --Add new node Button
1122: htp.tableRowOpen;
1123:
1118:
1119: htp.tableopen(calign=>'CENTER');
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'||
1128: l_icon := 'FNDADD11.gif';
1129: l_text := wf_core.translate ('WFDM_CREATE');
1130: l_onmouseover := wf_core.translate ('WFDM_CREATE');
1131:
1132: htp.p('
1132: htp.p('
1139: l_icon := 'FNDJLFCN.gif';
1140: l_text := wf_core.translate ('ICX_RETURN_TO_QUESTIONS');
1141: l_onmouseover := wf_core.translate ('ICX_RETURN_TO_QUESTIONS');
1142:
1143: htp.p('
1143: htp.p('
1145: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
1146:
1147: htp.p('');
1148:
1149: htp.tableRowClose;
1150:
1151: htp.tableclose;
1152:
1153: wfa_sec.Footer;
1147: htp.p('');
1148:
1149: htp.tableRowClose;
1150:
1151: htp.tableclose;
1152:
1153: wfa_sec.Footer;
1154: htp.htmlClose;
1155:
1150:
1151: htp.tableclose;
1152:
1153: wfa_sec.Footer;
1154: htp.htmlClose;
1155:
1156: exception
1157: when others then
1158: wf_core.context('icx_questions_admin', 'DISPLAY_FUNCTIONS');
1210:
1211: end if;
1212:
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;
1211: end if;
1212:
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;
1212:
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:
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;
1222:
1223: -- Page header
1224: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions', wf_core.translate('ICX_EDIT_FUNCTION_TITLE'), TRUE);
1225:
1225:
1226: -- Print the error message if there is one
1227: if (P_ERROR_MESSAGE IS NOT NULL) THEN
1228:
1229: htp.br;
1230: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');
1231: htp.br;
1232:
1233: end if;
1226: -- Print the error message if there is one
1227: if (P_ERROR_MESSAGE IS NOT NULL) THEN
1228:
1229: htp.br;
1230: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');
1231: htp.br;
1232:
1233: end if;
1234:
1227: if (P_ERROR_MESSAGE IS NOT NULL) THEN
1228:
1229: htp.br;
1230: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');
1231: htp.br;
1232:
1233: end if;
1234:
1235: htp.tableopen(calign=>'CENTER');
1231: htp.br;
1232:
1233: end if;
1234:
1235: htp.tableopen(calign=>'CENTER');
1236:
1237: if (P_INSERT = 'FALSE') THEN
1238:
1239: htp.p('
1235: htp.tableopen(calign=>'CENTER');
1236:
1237: if (P_INSERT = 'FALSE') THEN
1238:
1239: htp.p('
1241: else
1242:
1243: htp.p('
1239: htp.p('
1243: htp.p('
1244:
1245: end if;
1246:
1247: htp.formHidden(cname=>'p_function_id', cvalue=>p_function_id);
1248: htp.formHidden(cname=>'p_old_function_name', cvalue=>p_function_name);
1249: htp.formHidden(cname=>'p_find_criteria', cvalue=>p_find_criteria);
1250:
1251: -- Question Code
1252: htp.tableRowOpen;
1245: end if;
1246:
1247: htp.formHidden(cname=>'p_function_id', cvalue=>p_function_id);
1248: htp.formHidden(cname=>'p_old_function_name', cvalue=>p_function_name);
1249: htp.formHidden(cname=>'p_find_criteria', cvalue=>p_find_criteria);
1250:
1251: -- Question Code
1252: htp.tableRowOpen;
1253: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
1248: htp.formHidden(cname=>'p_old_function_name', cvalue=>p_function_name);
1249: htp.formHidden(cname=>'p_find_criteria', cvalue=>p_find_criteria);
1250:
1251: -- Question Code
1252: htp.tableRowOpen;
1253: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
1254: calign=>'right');
1255:
1256: htp.formHidden(cname=>'p_question_code', cvalue=>p_question_code);
1249: htp.formHidden(cname=>'p_find_criteria', cvalue=>p_find_criteria);
1250:
1251: -- Question Code
1252: htp.tableRowOpen;
1253: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
1254: calign=>'right');
1255:
1256: htp.formHidden(cname=>'p_question_code', cvalue=>p_question_code);
1257:
1252: htp.tableRowOpen;
1253: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
1254: calign=>'right');
1255:
1256: htp.formHidden(cname=>'p_question_code', cvalue=>p_question_code);
1257:
1258: htp.tableData(cvalue=>''||p_question_code||'',
1259: calign=>'left');
1260:
1254: calign=>'right');
1255:
1256: htp.formHidden(cname=>'p_question_code', cvalue=>p_question_code);
1257:
1258: htp.tableData(cvalue=>''||p_question_code||'',
1259: calign=>'left');
1260:
1261:
1262: htp.tableRowClose;
1258: htp.tableData(cvalue=>''||p_question_code||'',
1259: calign=>'left');
1260:
1261:
1262: htp.tableRowClose;
1263:
1264: -- Function Name
1265: htp.tableRowOpen;
1266: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION'),
1261:
1262: htp.tableRowClose;
1263:
1264: -- Function Name
1265: htp.tableRowOpen;
1266: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION'),
1267: calign=>'right');
1268:
1269: -- add LOV here: Note:bottom is name of frame.
1262: htp.tableRowClose;
1263:
1264: -- Function Name
1265: htp.tableRowOpen;
1266: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION'),
1267: calign=>'right');
1268:
1269: -- add LOV here: Note:bottom is name of frame.
1270: -- Note: The REPLACE function replaces all the space characters with
1278: '&p_dest_display_field=top.opener.document.ICX_EDIT_FUNCTION.p_function_name.value',
1279: ' ', '%20')||''''||',400,500)';
1280:
1281:
1282: htp.tableData(htf.formText(cname=>'p_function_name', csize=>'25',
1283: cvalue=>l_function_name, cmaxlength=>'50')||
1284: ''||
1285: '');
1284: ''||
1285: '');
1287:
1288: htp.tablerowclose;
1289:
1290: -- Function Desciption
1291: htp.tableRowOpen;
1292: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION_DESCRIPTION'),
1287:
1288: htp.tablerowclose;
1289:
1290: -- Function Desciption
1291: htp.tableRowOpen;
1292: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION_DESCRIPTION'),
1293: calign=>'right');
1294:
1295: htp.tableData(htf.formText(cname=>'p_user_function_name', csize=>'40',
1288: htp.tablerowclose;
1289:
1290: -- Function Desciption
1291: htp.tableRowOpen;
1292: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION_DESCRIPTION'),
1293: calign=>'right');
1294:
1295: htp.tableData(htf.formText(cname=>'p_user_function_name', csize=>'40',
1296: cvalue=>l_user_function_name, cmaxlength=>'240'));
1291: htp.tableRowOpen;
1292: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION_DESCRIPTION'),
1293: calign=>'right');
1294:
1295: htp.tableData(htf.formText(cname=>'p_user_function_name', csize=>'40',
1296: cvalue=>l_user_function_name, cmaxlength=>'240'));
1297:
1298: htp.tableRowClose;
1299:
1294:
1295: htp.tableData(htf.formText(cname=>'p_user_function_name', csize=>'40',
1296: cvalue=>l_user_function_name, cmaxlength=>'240'));
1297:
1298: htp.tableRowClose;
1299:
1300: htp.tableclose;
1301:
1302: htp.br;
1296: cvalue=>l_user_function_name, cmaxlength=>'240'));
1297:
1298: htp.tableRowClose;
1299:
1300: htp.tableclose;
1301:
1302: htp.br;
1303:
1304: htp.tableopen(calign=>'CENTER');
1298: htp.tableRowClose;
1299:
1300: htp.tableclose;
1301:
1302: htp.br;
1303:
1304: htp.tableopen(calign=>'CENTER');
1305:
1306: --Submit Button
1300: htp.tableclose;
1301:
1302: htp.br;
1303:
1304: htp.tableopen(calign=>'CENTER');
1305:
1306: --Submit Button
1307:
1308: htp.tableRowOpen;
1304: htp.tableopen(calign=>'CENTER');
1305:
1306: --Submit Button
1307:
1308: htp.tableRowOpen;
1309:
1310: l_url := 'javascript:document.ICX_EDIT_FUNCTION.submit()';
1311: l_icon := 'FNDJLFOK.gif';
1312: l_text := wf_core.translate ('WFMON_OK');
1311: l_icon := 'FNDJLFOK.gif';
1312: l_text := wf_core.translate ('WFMON_OK');
1313: l_onmouseover := wf_core.translate ('WFMON_OK');
1314:
1315: htp.p('
1315: htp.p('
1324: l_icon := 'FNDJLFCN.gif';
1325: l_text := wf_core.translate ('CANCEL');
1326: l_onmouseover := wf_core.translate ('CANCEL');
1327:
1328: htp.p('
1328: htp.p('
1330: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
1331:
1332: htp.p('');
1333:
1334: htp.tableRowClose;
1335:
1336: htp.tableclose;
1337:
1338: htp.formClose;
1332: htp.p('');
1333:
1334: htp.tableRowClose;
1335:
1336: htp.tableclose;
1337:
1338: htp.formClose;
1339:
1340: wfa_sec.Footer;
1334: htp.tableRowClose;
1335:
1336: htp.tableclose;
1337:
1338: htp.formClose;
1339:
1340: wfa_sec.Footer;
1341: htp.htmlClose;
1342:
1337:
1338: htp.formClose;
1339:
1340: wfa_sec.Footer;
1341: htp.htmlClose;
1342:
1343:
1344: exception
1345: when others then