72: end loop;
73:
74: /*
75: for i in 1..l_parameters.count loop
76: htp.p(i||' = '||l_parameters(i));htp.nl;
77: end loop;
78: */
79:
80: l_function_code := l_parameters(1);
148: l_total_rows := ak_query_pkg.g_regions_table(0).total_result_count;
149:
150: if l_total_rows = 0 then
151:
152: htp.htmlOpen;
153: htp.headOpen;
154: icx_util.copyright;
155: js.scriptOpen;
156: icx_admin_sig.help_win_script(l_help_url, l_language_code);
149:
150: if l_total_rows = 0 then
151:
152: htp.htmlOpen;
153: htp.headOpen;
154: icx_util.copyright;
155: js.scriptOpen;
156: icx_admin_sig.help_win_script(l_help_url, l_language_code);
157: js.scriptClose;
154: icx_util.copyright;
155: js.scriptOpen;
156: icx_admin_sig.help_win_script(l_help_url, l_language_code);
157: js.scriptClose;
158: htp.title(ak_query_pkg.g_regions_table(0).name);
159: htp.headClose;
160:
161: icx_admin_sig.toolbar(language_code => l_language_code,
162: disp_find => l_find_proc);
155: js.scriptOpen;
156: icx_admin_sig.help_win_script(l_help_url, l_language_code);
157: js.scriptClose;
158: htp.title(ak_query_pkg.g_regions_table(0).name);
159: htp.headClose;
160:
161: icx_admin_sig.toolbar(language_code => l_language_code,
162: disp_find => l_find_proc);
163:
162: disp_find => l_find_proc);
163:
164: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
165: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
166: htp.br;
167: htp.tableOpen('BORDER=0');
168: htp.tableRowOpen;
169: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
170:
163:
164: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
165: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
166: htp.br;
167: htp.tableOpen('BORDER=0');
168: htp.tableRowOpen;
169: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
170:
171: htp.p('
164: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
165: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
166: htp.br;
167: htp.tableOpen('BORDER=0');
168: htp.tableRowOpen;
169: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
170:
171: htp.p('
165: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
166: htp.br;
167: htp.tableOpen('BORDER=0');
168: htp.tableRowOpen;
169: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
170:
171: htp.p('
167: htp.tableOpen('BORDER=0');
168: htp.tableRowOpen;
169: htp.tableData(cvalue => ''||fnd_message.get||'',cattributes => 'VALIGN="MIDDLE"');
170:
171: htp.p('
174: P_OnMouseOverText => l_new_prompt,
175: P_HyperTextCall => l_new_proc,
176: P_LanguageCode => l_language_code,
177: P_JavaScriptFlag => FALSE);
178: htp.p('
175: P_HyperTextCall => l_new_proc,
176: P_LanguageCode => l_language_code,
177: P_JavaScriptFlag => FALSE);
178: htp.p('');
179: htp.tableClose;
180: htp.br;
181: icx_admin_sig.footer;
182:
183: elsif l_total_rows = 1 then
176: P_LanguageCode => l_language_code,
177: P_JavaScriptFlag => FALSE);
178: htp.p('');
179: htp.tableClose;
180: htp.br;
181: icx_admin_sig.footer;
182:
183: elsif l_total_rows = 1 then
184:
206: l_dummy := dbms_sql.execute(l_call);
207: dbms_sql.close_cursor(l_call);
208:
209: else
210: htp.htmlOpen;
211: htp.headOpen;
212: icx_util.copyright;
213: js.scriptOpen;
214: icx_admin_sig.help_win_script(l_help_url, l_language_code);
207: dbms_sql.close_cursor(l_call);
208:
209: else
210: htp.htmlOpen;
211: htp.headOpen;
212: icx_util.copyright;
213: js.scriptOpen;
214: icx_admin_sig.help_win_script(l_help_url, l_language_code);
215:
213: js.scriptOpen;
214: icx_admin_sig.help_win_script(l_help_url, l_language_code);
215:
216: fnd_message.set_name('ICX', 'ICX_DELETE');
217: htp.p('function delete_function(delete_name, X) {
218: if (confirm("'||icx_util.replace_quotes(fnd_message.get)||' "+delete_name+"?")) {
219: parent.location="'||l_delete_proc||'?X=" + X
220: }
221: }');
220: }
221: }');
222:
223: js.scriptClose;
224: htp.title(ak_query_pkg.g_regions_table(0).name);
225: htp.headClose;
226:
227: icx_admin_sig.toolbar(language_code => l_language_code,
228: disp_find => l_find_proc);
221: }');
222:
223: js.scriptClose;
224: htp.title(ak_query_pkg.g_regions_table(0).name);
225: htp.headClose;
226:
227: icx_admin_sig.toolbar(language_code => l_language_code,
228: disp_find => l_find_proc);
229:
230: if l_end_row > l_total_rows then
231: l_end_row := l_total_rows;
232: end if;
233:
234: htp.formOpen('');
235:
236: htp.tableOpen('BORDER=0');
237: htp.tableRowOpen;
238: htp.tableData(cvalue => ''||ak_query_pkg.g_regions_table(0).name||'',cattributes => 'VALIGN="MIDDLE"');
232: end if;
233:
234: htp.formOpen('');
235:
236: htp.tableOpen('BORDER=0');
237: htp.tableRowOpen;
238: htp.tableData(cvalue => ''||ak_query_pkg.g_regions_table(0).name||'',cattributes => 'VALIGN="MIDDLE"');
239:
240: htp.p('
233:
234: htp.formOpen('');
235:
236: htp.tableOpen('BORDER=0');
237: htp.tableRowOpen;
238: htp.tableData(cvalue => ''||ak_query_pkg.g_regions_table(0).name||'',cattributes => 'VALIGN="MIDDLE"');
239:
240: htp.p('
234: htp.formOpen('');
235:
236: htp.tableOpen('BORDER=0');
237: htp.tableRowOpen;
238: htp.tableData(cvalue => ''||ak_query_pkg.g_regions_table(0).name||'',cattributes => 'VALIGN="MIDDLE"');
239:
240: htp.p('
236: htp.tableOpen('BORDER=0');
237: htp.tableRowOpen;
238: htp.tableData(cvalue => ''||ak_query_pkg.g_regions_table(0).name||'',cattributes => 'VALIGN="MIDDLE"');
239:
240: htp.p('
243: P_OnMouseOverText => l_new_prompt,
244: P_HyperTextCall => l_new_proc,
245: P_LanguageCode => l_language_code,
246: P_JavaScriptFlag => FALSE);
247: htp.p('
244: P_HyperTextCall => l_new_proc,
245: P_LanguageCode => l_language_code,
246: P_JavaScriptFlag => FALSE);
247: htp.p('');
248: htp.tableRowClose;
249: htp.tableClose;
250: htp.br;
251:
252: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);
245: P_LanguageCode => l_language_code,
246: P_JavaScriptFlag => FALSE);
247: htp.p('');
248: htp.tableRowClose;
249: htp.tableClose;
250: htp.br;
251:
252: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);
253:
246: P_JavaScriptFlag => FALSE);
247: htp.p('');
248: htp.tableRowClose;
249: htp.tableClose;
250: htp.br;
251:
252: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);
253:
254: l_count := 0;
261: end loop;
262: l_count := l_count + 1;
263: end loop;
264:
265: htp.tableOpen('BORDER=4');
266: htp.p('
262: l_count := l_count + 1;
267: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
274: l_link_value_id := ak_query_pkg.g_items_table(i).value_id;
275: end if;
288: for i in 1..l_count loop
296: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
299: then
304: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
307: then
309: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
315: end if;
317: end loop; -- items
320: htf.img('/OA_MEDIA/'||l_language_code||'/FNDIDELR.gif','CENTER','','','border=no width=17 height=16'),'','onMouseOver="return true"'));
324: htp.tableClose;
344: end;
348: htp.p('function add_to_right() {
407: right_regions_table := ak_query_pkg.g_regions_table;
410:
413: -- customized hidden field --
416: -- pass on the where_clause --
417: htp.formHidden('inherit_where', p_left_where);
420: htp.formHidden('left_list', 'None');
422:
423: -- flag to indicate if the submit is an add or removal --
424: htp.formHidden('left_right_flag', '');
426: htp.tableOpen('BORDER=0','','','','cellpadding=8 cellspacing=0');
433: then
439: else
444: end loop;
445: end if;
446:
447:
449: htp.p('
450: htp.p('
451: htp.br;
452:
462: if p_primary_key_size = 2
468: else
472: htp.p('
474: end if;
475:
476: htp.formSelectClose;
478: htp.p('');
263: end loop;
264:
265: htp.tableOpen('BORDER=4');
266: htp.p('');
267: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
268: if ak_query_pkg.g_items_table(i).secured_column = 'F'
269: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
270: then
Line 271: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
268: if ak_query_pkg.g_items_table(i).secured_column = 'F'
269: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
270: then
271: htp.tableData(ak_query_pkg.g_items_table(i).attribute_label_long);
272: if l_link_attribute = ak_query_pkg.g_items_table(i).attribute_code
273: then
274: l_link_value_id := ak_query_pkg.g_items_table(i).value_id;
275: end if;
Line 278: htp.tableData('');
275: end if;
276: end if;
277: end loop;
278: htp.tableData('');
279: htp.tableRowClose;
280:
281: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
282:
Line 279: htp.tableRowClose;
276: end if;
277: end loop;
278: htp.tableData('');
279: htp.tableRowClose;
280:
281: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
282:
283: for r in 0..ak_query_pkg.g_results_table.COUNT-1 loop
Line 292: htp.tableRowOpen;
289: l_X := l_X||l_values_table(l_key_value_ids(i))||'*';
290: end loop;
291:
292: htp.tableRowOpen;
293: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
294:
295: if ak_query_pkg.g_items_table(i).secured_column = 'F'
296: and ak_query_pkg.g_items_table(i).node_display_flag = 'Y'
Line 300: htp.tableData(htf.anchor(l_update_proc||'?X='||icx_call.encrypt2(l_X||'*]'),l_values_table(l_link_value_id),'','onMouseOver="return true"'));
297: then
298: if ak_query_pkg.g_items_table(i).attribute_code = l_link_attribute
299: then
300: htp.tableData(htf.anchor(l_update_proc||'?X='||icx_call.encrypt2(l_X||'*]'),l_values_table(l_link_value_id),'','onMouseOver="return true"'));
301: elsif ak_query_pkg.g_items_table(i).value_id is null
302: then
303: htp.tableData('');
304: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
Line 303: htp.tableData('');
300: htp.tableData(htf.anchor(l_update_proc||'?X='||icx_call.encrypt2(l_X||'*]'),l_values_table(l_link_value_id),'','onMouseOver="return true"'));
301: elsif ak_query_pkg.g_items_table(i).value_id is null
302: then
303: htp.tableData('');
304: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
305: and (l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'T'
306: or l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'Y')
307: then
Line 308: htp.tableData('','CENTER');
305: and (l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'T'
306: or l_values_table(ak_query_pkg.g_items_table(i).value_id) = 'Y')
307: then
308: htp.tableData('','CENTER');
309: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
310: then
311: htp.tableData('');
312: else
Line 311: htp.tableData('');
308: htp.tableData('','CENTER');
309: elsif ak_query_pkg.g_items_table(i).item_style = 'CHECKBOX'
310: then
311: htp.tableData('');
312: else
313: htp.tableData(l_values_table(ak_query_pkg.g_items_table(i).value_id));
314: end if;
315: end if;
Line 313: htp.tableData(l_values_table(ak_query_pkg.g_items_table(i).value_id));
310: then
311: htp.tableData('');
312: else
313: htp.tableData(l_values_table(ak_query_pkg.g_items_table(i).value_id));
314: end if;
315: end if;
316:
317: end loop; -- items
Line 319: htp.tableData(htf.anchor('javascript:delete_function('''||icx_util.replace_onMouseOver_quotes(l_values_table(l_link_value_id))||''','''||icx_call.encrypt2(l_X)||''')',
316:
317: end loop; -- items
318: l_X := 'DISPLAY'||'*'||l_X||p_hidden||'*'||p_start_row||'*'||l_end_row||'*'||l_encrypted_where||'**]';
319: htp.tableData(htf.anchor('javascript:delete_function('''||icx_util.replace_onMouseOver_quotes(l_values_table(l_link_value_id))||''','''||icx_call.encrypt2(l_X)||''')',
320: htf.img('/OA_MEDIA/'||l_language_code||'/FNDIDELR.gif','CENTER','','','border=no width=17 height=16'),'','onMouseOver="return true"'));
321: htp.tableRowClose;
322: end loop; -- Results
323:
Line 321: htp.tableRowClose;
318: l_X := 'DISPLAY'||'*'||l_X||p_hidden||'*'||p_start_row||'*'||l_end_row||'*'||l_encrypted_where||'**]';
319: htp.tableData(htf.anchor('javascript:delete_function('''||icx_util.replace_onMouseOver_quotes(l_values_table(l_link_value_id))||''','''||icx_call.encrypt2(l_X)||''')',
320: htf.img('/OA_MEDIA/'||l_language_code||'/FNDIDELR.gif','CENTER','','','border=no width=17 height=16'),'','onMouseOver="return true"'));
321: htp.tableRowClose;
322: end loop; -- Results
323:
324: htp.tableClose;
325:
Line 324: htp.tableClose;
321: htp.tableRowClose;
322: end loop; -- Results
323:
324: htp.tableClose;
325:
326: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);
327:
328: htp.formClose;
Line 328: htp.formClose;
325:
326: icx_on_utilities2.displaySetIcons(l_language_code,l_list_proc,p_start_row,l_end_row,l_encrypted_where,l_query_size,l_total_rows,TRUE,'',p_hidden);
327:
328: htp.formClose;
329: icx_admin_sig.footer;
330:
331: end if;
332:
Line 348: htp.p('function add_to_right() {
345:
346: procedure LISTScript is
347: begin
348: htp.p('function add_to_right() {
349: document.LISTform.left_right_flag.value = "Y"
350: document.LISTform.submit();
351: }');
352: htp.p('function remove_to_left() {
Line 352: htp.p('function remove_to_left() {
349: document.LISTform.left_right_flag.value = "Y"
350: document.LISTform.submit();
351: }');
352: htp.p('function remove_to_left() {
353: document.LISTform.left_right_flag.value = "N"
354: document.LISTform.submit();
355: }');
356:
Line 411: htp.formOpen(p_modify_url, 'POST', '','','NAME ="LISTform"');
408: right_items_table := ak_query_pkg.g_items_table;
409: right_results_table := ak_query_pkg.g_results_table;
410:
411: htp.formOpen(p_modify_url, 'POST', '','','NAME ="LISTform"');
412:
413: -- customized hidden field --
414: htp.formHidden(p_hidden_name, p_hidden_value);
415:
Line 414: htp.formHidden(p_hidden_name, p_hidden_value);
411: htp.formOpen(p_modify_url, 'POST', '','','NAME ="LISTform"');
412:
413: -- customized hidden field --
414: htp.formHidden(p_hidden_name, p_hidden_value);
415:
416: -- pass on the where_clause --
417: htp.formHidden('inherit_where', p_left_where);
418:
Line 417: htp.formHidden('inherit_where', p_left_where);
414: htp.formHidden(p_hidden_name, p_hidden_value);
415:
416: -- pass on the where_clause --
417: htp.formHidden('inherit_where', p_left_where);
418:
419: -- dummy left_list, and right_list fields to avoid errors on submitting --
420: htp.formHidden('left_list', 'None');
421: htp.formHidden('right_list', 'None');
Line 420: htp.formHidden('left_list', 'None');
417: htp.formHidden('inherit_where', p_left_where);
418:
419: -- dummy left_list, and right_list fields to avoid errors on submitting --
420: htp.formHidden('left_list', 'None');
421: htp.formHidden('right_list', 'None');
422:
423: -- flag to indicate if the submit is an add or removal --
424: htp.formHidden('left_right_flag', '');
Line 421: htp.formHidden('right_list', 'None');
418:
419: -- dummy left_list, and right_list fields to avoid errors on submitting --
420: htp.formHidden('left_list', 'None');
421: htp.formHidden('right_list', 'None');
422:
423: -- flag to indicate if the submit is an add or removal --
424: htp.formHidden('left_right_flag', '');
425:
Line 424: htp.formHidden('left_right_flag', '');
421: htp.formHidden('right_list', 'None');
422:
423: -- flag to indicate if the submit is an add or removal --
424: htp.formHidden('left_right_flag', '');
425:
426: htp.tableOpen('BORDER=0','','','','cellpadding=8 cellspacing=0');
427: htp.tableRowOpen;
428: htp.p('');
Line 426: htp.tableOpen('BORDER=0','','','','cellpadding=8 cellspacing=0');
423: -- flag to indicate if the submit is an add or removal --
424: htp.formHidden('left_right_flag', '');
425:
426: htp.tableOpen('BORDER=0','','','','cellpadding=8 cellspacing=0');
427: htp.tableRowOpen;
428: htp.p('');
429:
430: htp.formSelectOpen('left_list','',10,'MULTIPLE');
Line 427: htp.tableRowOpen;
424: htp.formHidden('left_right_flag', '');
425:
426: htp.tableOpen('BORDER=0','','','','cellpadding=8 cellspacing=0');
427: htp.tableRowOpen;
428: htp.p(''); ');
429:
430: htp.formSelectOpen('left_list','',10,'MULTIPLE');
431:
Line 428: htp.p('
');
425:
426: htp.tableOpen('BORDER=0','','','','cellpadding=8 cellspacing=0');
427: htp.tableRowOpen;
428: htp.p('');
429:
430: htp.formSelectOpen('left_list','',10,'MULTIPLE');
431:
432: if p_primary_key_size = 2
Line 430: htp.formSelectOpen('left_list','',10,'MULTIPLE');
427: htp.tableRowOpen;
428: htp.p(''); ');
429:
430: htp.formSelectOpen('left_list','',10,'MULTIPLE');
431:
432: if p_primary_key_size = 2
433: then
434: -- when primary key consists of 2 columns --
Line 437: htp.p('
434: -- when primary key consists of 2 columns --
435: for i in 0..left_results_table.count-1 loop
436:
437: htp.p('438: end loop;
439: else
440: -- when primary key consistes of only 1 column --
441: for i in 0..left_results_table.count-1 loop
Line 443: htp.p('
440: -- when primary key consistes of only 1 column --
441: for i in 0..left_results_table.count-1 loop
442:
443: htp.p('444: end loop;
445: end if;
446:
447:
Line 448: htp.formSelectClose;
445: end if;
446:
447:
448: htp.formSelectClose;
449: htp.p('
450: htp.p(''); ');
451: htp.br;
452:
Line 449: htp.p('
446:
447:
448: htp.formSelectClose;
449: htp.p('
450: htp.p(''); ');
451: htp.br;
452:
453: htp.br;
Line 450: htp.p('
'); ');
447:
448: htp.formSelectClose;
449: htp.p('
450: htp.p(''); ');
451: htp.br;
452:
453: htp.br;
454: htp.p('
Line 451: htp.br;
448: htp.formSelectClose;
449: htp.p('
450: htp.p(''); ');
451: htp.br;
452:
453: htp.br;
454: htp.p('
455: htp.p(''); ');
Line 453: htp.br;
450: htp.p(''); ');
451: htp.br;
452:
453: htp.br;
454: htp.p('
455: htp.p(''); ');
456: htp.formSelectOpen('right_list','',10,'MULTIPLE');
457:
Line 454: htp.p('
'); ');
451: htp.br;
452:
453: htp.br;
454: htp.p('
455: htp.p(''); ');
456: htp.formSelectOpen('right_list','',10,'MULTIPLE');
457:
458:
Line 455: htp.p('
'); ');
452:
453: htp.br;
454: htp.p('
455: htp.p(''); ');
456: htp.formSelectOpen('right_list','',10,'MULTIPLE');
457:
458:
459: -- construct the list item value according to --
Line 456: htp.formSelectOpen('right_list','',10,'MULTIPLE');
453: htp.br;
454: htp.p('
455: htp.p(''); ');
456: htp.formSelectOpen('right_list','',10,'MULTIPLE');
457:
458:
459: -- construct the list item value according to --
460: -- the primary key size --
Line 466: htp.p('
463: then
464: -- when primary key consists of 2 columns --
465: for i in 0..right_results_table.count-1 loop
466: htp.p('467: end loop;
468: else
469: -- when primary key consistes of only 1 column --
470: for i in 0..right_results_table.count-1 loop
Line 472: htp.p('
469: -- when primary key consistes of only 1 column --
470: for i in 0..right_results_table.count-1 loop
471:
472: htp.p('473: end loop;
474: end if;
475:
476: htp.formSelectClose;
Line 476: htp.formSelectClose;
479: htp.tableRowClose;
480: htp.tableClose;
Line 478: htp.p('
475:
476: htp.formSelectClose;
477:
478: htp.p('');
479: htp.tableRowClose;
480: htp.tableClose;
481:
482: htp.formClose;
Line 479: htp.tableRowClose;
476: htp.formSelectClose;
477:
478: htp.p('');
479: htp.tableRowClose;
480: htp.tableClose;
481:
482: htp.formClose;
483:
Line 480: htp.tableClose;
477:
478: htp.p('');
479: htp.tableRowClose;
480: htp.tableClose;
481:
482: htp.formClose;
483:
484: end selectList;
Line 482: htp.formClose;
479: htp.tableRowClose;
480: htp.tableClose;
481:
482: htp.formClose;
483:
484: end selectList;
485:
486: end icx_admin_utils;