eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
5: 6: procedure main is 7: 8: l_title varchar2(80); 9: l_prompts icx_util.g_prompts_table; 10: 11: begin 12: if icx_sec.validateSession then 13: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);
9: l_prompts icx_util.g_prompts_table; 10: 11: begin 12: if icx_sec.validateSession then 13: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts); 14: 15: htp.htmlOpen; 16: htp.headOpen; 17: icx_util.copyright;
13: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts); 14: 15: htp.htmlOpen; 16: htp.headOpen; 17: icx_util.copyright; 18: htp.title(l_title); 19: htp.headClose; 20: 21: htp.p('
58: l_agent varchar2(100) := owa_util.get_cgi_env('SCRIPT_NAME'); 59: l_language varchar2(30); 60: i number; 61: l_title varchar2(80); 62: l_prompts icx_util.g_prompts_table; 63: lov_title varchar2(80); 64: lov_prompts icx_util.g_prompts_table; 65: err_num number; 66: err_mesg varchar2(512);
60: i number; 61: l_title varchar2(80); 62: l_prompts icx_util.g_prompts_table; 63: lov_title varchar2(80); 64: lov_prompts icx_util.g_prompts_table; 65: err_num number; 66: err_mesg varchar2(512); 67: temp_text varchar2(2000); 68: temp_cat_set_id number;
71: temp_relation varchar2(80); 72: 73: begin 74: if icx_sec.validateSession then 75: icx_util.error_page_setup; 76: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 77: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts); 78: icx_util.getPrompts(178,'ICX_LOV',lov_title,lov_prompts); 79:
73: begin 74: if icx_sec.validateSession then 75: icx_util.error_page_setup; 76: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 77: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts); 78: icx_util.getPrompts(178,'ICX_LOV',lov_title,lov_prompts); 79: 80: htp.htmlOpen; 81: htp.headOpen;
74: if icx_sec.validateSession then 75: icx_util.error_page_setup; 76: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 77: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts); 78: icx_util.getPrompts(178,'ICX_LOV',lov_title,lov_prompts); 79: 80: htp.htmlOpen; 81: htp.headOpen; 82: icx_util.copyright;
78: icx_util.getPrompts(178,'ICX_LOV',lov_title,lov_prompts); 79: 80: htp.htmlOpen; 81: htp.headOpen; 82: icx_util.copyright; 83: 84: htp.title(l_title); 85: 86: js.scriptOpen;
84: htp.title(l_title); 85: 86: js.scriptOpen; 87: icx_admin_sig.help_win_script('/OA_HTML/'||l_language||'/ICXHLMCH.htm'); 88: icx_util.LOVScript; 89: js.null_alert; 90: js.equal_alert; 91: 92: htp.p('function autoquery() {
128: }'); 129: 130: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_BEFORE'); 131: htp.p('function pre_rel_cat_LOV() { 132: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 133: var l_where = "CATEGORY_SET_ID=" + document.Category.ICX_CATEGORY_SET_ID.options[document.Category.ICX_CATEGORY_SET_ID.selectedIndex].value 134: LOV(''178'',''ICX_RELATED_CATEGORY'',''601'',''ICX_RELATED_CATEGORIES_R'',''Category'',''header'','''',l_where) 135: } 136: }');
140: 141: 142: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL'); 143: htp.p('function cat_submit() { 144: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(4))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 145: if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {'); 146: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL'); 147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {'); 148: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT');
143: htp.p('function cat_submit() { 144: if (!null_alert(document.Category.ICX_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(4))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 145: if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {'); 146: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL'); 147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {'); 148: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT'); 149: htp.p(' if (!equal_alert(document.Category.ICX_CATEGORY.value,document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 150: document.Category.submit() 151: }
145: if (document.Category.ICX_RELATION.options[document.Category.ICX_RELATION.selectedIndex].value != "TOP") {'); 146: FND_MESSAGE.SET_NAME('ICX','ICX_NOT_NULL'); 147: htp.p(' if (!null_alert(document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(l_prompts(7))||' '||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) {'); 148: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_PARENT'); 149: htp.p(' if (!equal_alert(document.Category.ICX_CATEGORY.value,document.Category.ICX_RELATED_CATEGORY.value,"'||icx_util.replace_quotes(FND_MESSAGE.Get)||'")) { 150: document.Category.submit() 151: } 152: } 153: } else {
191: -- Category text field 192: htp.formHidden('ICX_CATEGORY_ID',p_category_id); 193: htp.tableData(l_prompts(4),'RIGHT'); 194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"')); 195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''|| 196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"')); 197: htp.tableRowClose; 198: 199: -- Relation poplist
192: htp.formHidden('ICX_CATEGORY_ID',p_category_id); 193: htp.tableData(l_prompts(4),'RIGHT'); 194: htp.tableData(htf.formText('ICX_CATEGORY',30,81,p_category,'onchange="cat_changed()"')); 195: htp.tableData(htf.anchor('javascript:pre_cat_LOV()',htf.img('/OA_MEDIA/'||l_language||'/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''|| 196: icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"')); 197: htp.tableRowClose; 198: 199: -- Relation poplist 200: htp.tableRowOpen;
213: htp.formHidden('ICX_RELATED_CATEGORY_ID'); 214: htp.tableData(l_prompts(7),'RIGHT'); 215: htp.tableData(htf.formText('ICX_RELATED_CATEGORY',30,81,'','onchange="document.Category.ICX_RELATED_CATEGORY_ID.value = ''''"')); 216: htp.tableData(htf.anchor('javascript:pre_rel_cat_LOV()',htf.img('/OA_MEDIA/'||l_language|| 217: '/FNDILOV.gif','CENTER',icx_util.replace_alt_quotes(lov_title),'','BORDER=0 WIDTH=23 HEIGHT=21'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(lov_title)||''';return true"')); 218: htp.tableRowClose; 219: htp.tableClose; 220: 221:
221: 222: -- Write submit and clear buttons 223: htp.tableOpen; 224: htp.tableRowOpen; 225: icx_util.DynamicButton(l_prompts(8),'FNDBSBMT.gif',l_prompts(8),'javascript:cat_submit()',l_language,FALSE); 226: if (instr(c_browser, 'MSIE') = 0) then 227: icx_util.DynamicButton(l_prompts(9),'FNDBCLR.gif',l_prompts(9),'javascript:document.Category.reset()',l_language,FALSE); 228: end if; 229: htp.tableRowClose;
223: htp.tableOpen; 224: htp.tableRowOpen; 225: icx_util.DynamicButton(l_prompts(8),'FNDBSBMT.gif',l_prompts(8),'javascript:cat_submit()',l_language,FALSE); 226: if (instr(c_browser, 'MSIE') = 0) then 227: icx_util.DynamicButton(l_prompts(9),'FNDBCLR.gif',l_prompts(9),'javascript:document.Category.reset()',l_language,FALSE); 228: end if; 229: htp.tableRowClose; 230: htp.tableClose; 231:
249: when others then 250: err_num := SQLCODE; 251: temp_text := SQLERRM; 252: select substr(temp_text,12,512) into err_mesg from dual; 253: icx_util.add_error(err_mesg); 254: icx_admin_sig.error_screen(l_title,l_language); 255: 256: end; -- cat_head 257:
267: l_agent varchar2(100) := owa_util.get_cgi_env('SCRIPT_NAME'); 268: l_responsibility_id number := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID); 269: l_user_id number := icx_sec.getID(icx_sec.PV_WEB_USER_ID); 270: l_title varchar2(80); 271: l_prompts icx_util.g_prompts_table; 272: err_num number; 273: err_mesg varchar2(512); 274: temp_text varchar2(2000); 275: l_language varchar2(30);
272: err_num number; 273: err_mesg varchar2(512); 274: temp_text varchar2(2000); 275: l_language varchar2(30); 276: l_result_row_table icx_util.char240_table; 277: l_total_rows number; 278: l_end_row number; 279: l_query_size number; 280: l_where varchar2(2000);
289: temp_relation_item number; 290: 291: begin 292: if icx_sec.validateSession then 293: icx_util.error_page_setup; 294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 295: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_DISP_R',l_title,l_prompts); 296: 297: htp.htmlOpen;
291: begin 292: if icx_sec.validateSession then 293: icx_util.error_page_setup; 294: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE); 295: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_DISP_R',l_title,l_prompts); 296: 297: htp.htmlOpen; 298: htp.headOpen; 299: icx_util.copyright;
295: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_DISP_R',l_title,l_prompts); 296: 297: htp.htmlOpen; 298: htp.headOpen; 299: icx_util.copyright; 300: js.scriptOpen; 301: 302: -- Javascript function to handle CD buttons 303: htp.p('function rows(start_num, end_num) {
308: 309: -- javascript function to confirm delete of relationship 310: FND_MESSAGE.Set_name('ICX','ICX_DELETE'); 311: htp.p('function delete_relation(cat, related_cat, cat_set_id, cat_id, related_cat_id) { 312: if (confirm("'||icx_util.replace_quotes(FND_MESSAGE.Get)||': " + cat + " - " + related_cat)) { 313: open('''||l_agent||'/ICX_CAT.cat_delete?icx_category_set_id='' + cat_set_id + ''&icx_category_id='' + cat_id + ''&icx_related_category_id='' + related_cat_id,''tail'') 314: } 315: }'); 316:
431: 432: 433: -- display table header 434: htp.tableOpen('BORDER=1'); 435: htp.p(''); 436: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop 437: if ak_query_pkg.g_items_table(k).secured_column = 'F' and 438: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then 439: htp.tableData(htf.strong(ak_query_pkg.g_items_table(k).attribute_label_long),'LEFT'); Line 448: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 444: end if; -- CD Buttons and table header 445: 446: 447: -- load data for current row into temp pl/sql table 448: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 449: 450: 451: -- display one row of data 452: htp.p(''); Line 452: htp.p(''); 448: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 449: 450: 451: -- display one row of data 452: htp.p(''); 453: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop 454: if ak_query_pkg.g_items_table(k).secured_column = 'F' and 455: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then 456: Line 498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id|| 494: temp_related_cat_id := l_result_row_table(ak_query_pkg.g_items_table(k).value_id); 495: end if; 496: 497: end loop; 498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id|| 499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))|| 500: ''';return true"')); 501: 502: htp.tableRowClose; Line 499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))|| 495: end if; 496: 497: end loop; 498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id|| 499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))|| 500: ''';return true"')); 501: 502: htp.tableRowClose; 503: Line 555: icx_util.add_error(err_mesg); 551: when others then 552: err_num := SQLCODE; 553: temp_text := SQLERRM; 554: select substr(temp_text,12,512) into err_mesg from dual; 555: icx_util.add_error(err_mesg); 556: icx_admin_sig.error_screen(l_title,l_language); 557: 558: end cat_tail; 559: Line 577: icx_util.error_page_setup; 573: 574: 575: begin 576: if icx_sec.validateSession then 577: icx_util.error_page_setup; 578: 579: -- insert top relation for this category if needed 580: if icx_relation = 'TOP' then 581: Line 664: icx_util.error_page_setup; 660: 661: 662: begin 663: if icx_sec.validateSession then 664: icx_util.error_page_setup; 665: 666: 667: -- delete relation 668:
444: end if; -- CD Buttons and table header 445: 446: 447: -- load data for current row into temp pl/sql table 448: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 449: 450: 451: -- display one row of data 452: htp.p('
448: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(i-1), l_result_row_table); 449: 450: 451: -- display one row of data 452: htp.p(''); 453: for k in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop 454: if ak_query_pkg.g_items_table(k).secured_column = 'F' and 455: ak_query_pkg.g_items_table(k).node_display_flag = 'Y' then 456: Line 498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id|| 494: temp_related_cat_id := l_result_row_table(ak_query_pkg.g_items_table(k).value_id); 495: end if; 496: 497: end loop; 498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id|| 499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))|| 500: ''';return true"')); 501: 502: htp.tableRowClose; Line 499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))|| 495: end if; 496: 497: end loop; 498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id|| 499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))|| 500: ''';return true"')); 501: 502: htp.tableRowClose; 503: Line 555: icx_util.add_error(err_mesg); 551: when others then 552: err_num := SQLCODE; 553: temp_text := SQLERRM; 554: select substr(temp_text,12,512) into err_mesg from dual; 555: icx_util.add_error(err_mesg); 556: icx_admin_sig.error_screen(l_title,l_language); 557: 558: end cat_tail; 559: Line 577: icx_util.error_page_setup; 573: 574: 575: begin 576: if icx_sec.validateSession then 577: icx_util.error_page_setup; 578: 579: -- insert top relation for this category if needed 580: if icx_relation = 'TOP' then 581: Line 664: icx_util.error_page_setup; 660: 661: 662: begin 663: if icx_sec.validateSession then 664: icx_util.error_page_setup; 665: 666: 667: -- delete relation 668:
494: temp_related_cat_id := l_result_row_table(ak_query_pkg.g_items_table(k).value_id); 495: end if; 496: 497: end loop; 498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id|| 499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))|| 500: ''';return true"')); 501: 502: htp.tableRowClose;
495: end if; 496: 497: end loop; 498: htp.tableData(htf.anchor('javascript:delete_relation('''||icx_util.replace_quotes(temp_cat)||''','''||icx_util.replace_quotes(temp_related_cat)||''','''||temp_cat_set_id||''','''||temp_cat_id||''','''||temp_related_cat_id|| 499: ''')',htf.img('/OA_MEDIA/'||l_language||'/FNDIDELR.gif','CENTER',icx_util.replace_alt_quotes(l_prompts(6)),'','BORDER=0 WIDTH=16 HEIGHT=17'),'','onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_prompts(6))|| 500: ''';return true"')); 501: 502: htp.tableRowClose; 503:
551: when others then 552: err_num := SQLCODE; 553: temp_text := SQLERRM; 554: select substr(temp_text,12,512) into err_mesg from dual; 555: icx_util.add_error(err_mesg); 556: icx_admin_sig.error_screen(l_title,l_language); 557: 558: end cat_tail; 559:
573: 574: 575: begin 576: if icx_sec.validateSession then 577: icx_util.error_page_setup; 578: 579: -- insert top relation for this category if needed 580: if icx_relation = 'TOP' then 581:
660: 661: 662: begin 663: if icx_sec.validateSession then 664: icx_util.error_page_setup; 665: 666: 667: -- delete relation 668:
[Home] [Help]