41: document.WF_PREF.p_dm_home.value = x + '':''+ y;
42: }'
43: );
44:
45: htp.p(' ');
46:
47: htp.p('');
48:
49: EXCEPTION
43: );
44:
45: htp.p(' ');
46:
47: htp.p('');
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: Wf_Core.Context('wf_pref',
86: document.WF_PREF.submit();
87: }'
88: );
89:
90: htp.p(' ');
91:
92: htp.p('');
93:
94: EXCEPTION
88: );
89:
90: htp.p(' ');
91:
92: htp.p('');
93:
94: EXCEPTION
95: WHEN OTHERS THEN
96: Wf_Core.Context('wf_pref',
188: AND installed_flag = 'Y';
189:
190: END IF;
191:
192: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
193: htp.p('3');
194: htp.p(TO_CHAR(l_row_count));
195: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
196: htp.p('50');
189:
190: END IF;
191:
192: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
193: htp.p('3');
194: htp.p(TO_CHAR(l_row_count));
195: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
196: htp.p('50');
197: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
190: END IF;
191:
192: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
193: htp.p('3');
194: htp.p(TO_CHAR(l_row_count));
195: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
196: htp.p('50');
197: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
198: htp.p('50');
191:
192: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
193: htp.p('3');
194: htp.p(TO_CHAR(l_row_count));
195: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
196: htp.p('50');
197: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
198: htp.p('50');
199: htp.p('CODE');
192: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
193: htp.p('3');
194: htp.p(TO_CHAR(l_row_count));
195: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
196: htp.p('50');
197: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
198: htp.p('50');
199: htp.p('CODE');
200: htp.p('0');
193: htp.p('3');
194: htp.p(TO_CHAR(l_row_count));
195: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
196: htp.p('50');
197: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
198: htp.p('50');
199: htp.p('CODE');
200: htp.p('0');
201:
194: htp.p(TO_CHAR(l_row_count));
195: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
196: htp.p('50');
197: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
198: htp.p('50');
199: htp.p('CODE');
200: htp.p('0');
201:
202: IF (p_titles_only = 'N') THEN
195: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
196: htp.p('50');
197: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
198: htp.p('50');
199: htp.p('CODE');
200: htp.p('0');
201:
202: IF (p_titles_only = 'N') THEN
203:
196: htp.p('50');
197: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
198: htp.p('50');
199: htp.p('CODE');
200: htp.p('0');
201:
202: IF (p_titles_only = 'N') THEN
203:
204: OPEN c_lang_lov (p_find_criteria||'%');
213: l_language, l_territory, l_code;
214:
215: EXIT WHEN c_lang_lov%NOTFOUND;
216:
217: htp.p (l_language);
218: htp.p (l_territory);
219: htp.p (l_code);
220:
221: END LOOP;
214:
215: EXIT WHEN c_lang_lov%NOTFOUND;
216:
217: htp.p (l_language);
218: htp.p (l_territory);
219: htp.p (l_code);
220:
221: END LOOP;
222:
215: EXIT WHEN c_lang_lov%NOTFOUND;
216:
217: htp.p (l_language);
218: htp.p (l_territory);
219: htp.p (l_code);
220:
221: END LOOP;
222:
223: END IF;
268: AND installed_flag = 'Y';
269:
270: END IF;
271:
272: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
273: htp.p('3');
274: htp.p(TO_CHAR(l_row_count));
275: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
276: htp.p('50');
269:
270: END IF;
271:
272: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
273: htp.p('3');
274: htp.p(TO_CHAR(l_row_count));
275: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
276: htp.p('50');
277: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
270: END IF;
271:
272: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
273: htp.p('3');
274: htp.p(TO_CHAR(l_row_count));
275: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
276: htp.p('50');
277: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
278: htp.p('50');
271:
272: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
273: htp.p('3');
274: htp.p(TO_CHAR(l_row_count));
275: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
276: htp.p('50');
277: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
278: htp.p('50');
279: htp.p('Code');
272: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
273: htp.p('3');
274: htp.p(TO_CHAR(l_row_count));
275: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
276: htp.p('50');
277: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
278: htp.p('50');
279: htp.p('Code');
280: htp.p('0');
273: htp.p('3');
274: htp.p(TO_CHAR(l_row_count));
275: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
276: htp.p('50');
277: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
278: htp.p('50');
279: htp.p('Code');
280: htp.p('0');
281:
274: htp.p(TO_CHAR(l_row_count));
275: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
276: htp.p('50');
277: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
278: htp.p('50');
279: htp.p('Code');
280: htp.p('0');
281:
282: IF (p_titles_only = 'N') THEN
275: htp.p(wf_core.translate('WFPREF_TERRITORY_PROMPT'));
276: htp.p('50');
277: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
278: htp.p('50');
279: htp.p('Code');
280: htp.p('0');
281:
282: IF (p_titles_only = 'N') THEN
283:
276: htp.p('50');
277: htp.p(wf_core.translate('WFPREF_LANGUAGE_PROMPT'));
278: htp.p('50');
279: htp.p('Code');
280: htp.p('0');
281:
282: IF (p_titles_only = 'N') THEN
283:
284: OPEN c_Terr_lov (p_find_criteria||'%');
293: l_territory, l_language, l_code;
294:
295: EXIT WHEN c_Terr_lov%NOTFOUND;
296:
297: htp.p (l_territory);
298: htp.p (l_language);
299: htp.p (l_code);
300:
301: END LOOP;
294:
295: EXIT WHEN c_Terr_lov%NOTFOUND;
296:
297: htp.p (l_territory);
298: htp.p (l_language);
299: htp.p (l_code);
300:
301: END LOOP;
302:
295: EXIT WHEN c_Terr_lov%NOTFOUND;
296:
297: htp.p (l_territory);
298: htp.p (l_language);
299: htp.p (l_code);
300:
301: END LOOP;
302:
303: END IF;
346: WHERE node_name like p_find_criteria||'%';
347:
348: END IF;
349:
350: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
351: htp.p('3');
352: htp.p(TO_CHAR(l_row_count));
353: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
354: htp.p('40');
347:
348: END IF;
349:
350: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
351: htp.p('3');
352: htp.p(TO_CHAR(l_row_count));
353: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
354: htp.p('40');
355: htp.p(wf_core.translate('DESCRIPTION'));
348: END IF;
349:
350: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
351: htp.p('3');
352: htp.p(TO_CHAR(l_row_count));
353: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
354: htp.p('40');
355: htp.p(wf_core.translate('DESCRIPTION'));
356: htp.p('60');
349:
350: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
351: htp.p('3');
352: htp.p(TO_CHAR(l_row_count));
353: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
354: htp.p('40');
355: htp.p(wf_core.translate('DESCRIPTION'));
356: htp.p('60');
357: htp.p('NODE_ID');
350: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
351: htp.p('3');
352: htp.p(TO_CHAR(l_row_count));
353: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
354: htp.p('40');
355: htp.p(wf_core.translate('DESCRIPTION'));
356: htp.p('60');
357: htp.p('NODE_ID');
358: htp.p('0');
351: htp.p('3');
352: htp.p(TO_CHAR(l_row_count));
353: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
354: htp.p('40');
355: htp.p(wf_core.translate('DESCRIPTION'));
356: htp.p('60');
357: htp.p('NODE_ID');
358: htp.p('0');
359:
352: htp.p(TO_CHAR(l_row_count));
353: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
354: htp.p('40');
355: htp.p(wf_core.translate('DESCRIPTION'));
356: htp.p('60');
357: htp.p('NODE_ID');
358: htp.p('0');
359:
360: IF (p_titles_only = 'N') THEN
353: htp.p(wf_core.translate('WFPREF_DMHOME_PROMPT'));
354: htp.p('40');
355: htp.p(wf_core.translate('DESCRIPTION'));
356: htp.p('60');
357: htp.p('NODE_ID');
358: htp.p('0');
359:
360: IF (p_titles_only = 'N') THEN
361:
354: htp.p('40');
355: htp.p(wf_core.translate('DESCRIPTION'));
356: htp.p('60');
357: htp.p('NODE_ID');
358: htp.p('0');
359:
360: IF (p_titles_only = 'N') THEN
361:
362: OPEN c_dm_lov (p_find_criteria||'%');
371: l_node_id, l_node_name,l_node_desc;
372:
373: EXIT WHEN c_dm_lov%NOTFOUND;
374:
375: htp.p (l_node_name);
376: htp.p (l_node_desc);
377: htp.p (TO_CHAR(l_node_id));
378:
379: END LOOP;
372:
373: EXIT WHEN c_dm_lov%NOTFOUND;
374:
375: htp.p (l_node_name);
376: htp.p (l_node_desc);
377: htp.p (TO_CHAR(l_node_id));
378:
379: END LOOP;
380:
373: EXIT WHEN c_dm_lov%NOTFOUND;
374:
375: htp.p (l_node_name);
376: htp.p (l_node_desc);
377: htp.p (TO_CHAR(l_node_id));
378:
379: END LOOP;
380:
381: END IF;