DBA Data[Home] [Help]

APPS.ICX_REQ_CATEGORIES dependencies on ICX_UTIL

Line 23: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.openTemplate(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');

19: htp.headOpen;
20: htp.headClose;
21:
22: if (v_first_time_flag = 'Y') then
23: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.openTemplate(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
24: else
25: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
26: end if;
27:

Line 25: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');

21:
22: if (v_first_time_flag = 'Y') then
23: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.openTemplate(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
24: else
25: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.addChildren(''' || icx_util.replace_quotes(nodeId) || ''',document.GetChildren.nodeId,document.GetChildren.nodeIndex)"');
26: end if;
27:
28: htp.formOpen(curl =>'ICX_REQ_CATEGORIES.GetCategoryChildren',
29: cmethod => 'POST',

Line 93: y_table icx_util.char240_table;

89: from mtl_default_sets_view
90: WHERE functional_area_id = 2;
91:
92:
93: y_table icx_util.char240_table;
94: where_clause varchar2(2000);
95:
96: v_node_id varchar2(240);
97: v_name varchar2(240);

Line 257: y_table icx_util.char240_table;

253: nodeId in varchar2 default null,
254: nodeIndex in varchar2 default null) is
255: ------------------------------------------------------------
256:
257: y_table icx_util.char240_table;
258: where_clause varchar2(2000);
259:
260: v_p_where number;
261: -- childrenString varchar2(2000);

Line 706: icx_util.add_error(l_err_mesg);

702: VALUE_ERROR then
703: l_err_num := SQLCODE;
704: l_error_message := SQLERRM;
705: select substr(l_error_message,12,512) into l_err_mesg from dual;
706: icx_util.add_error(l_err_mesg);
707: icx_util.error_page_print;
708:
709: when OTHERS then
710: l_err_num := SQLCODE;

Line 707: icx_util.error_page_print;

703: l_err_num := SQLCODE;
704: l_error_message := SQLERRM;
705: select substr(l_error_message,12,512) into l_err_mesg from dual;
706: icx_util.add_error(l_err_mesg);
707: icx_util.error_page_print;
708:
709: when OTHERS then
710: l_err_num := SQLCODE;
711: l_error_message := SQLERRM;

Line 714: icx_util.add_error(l_err_mesg);

710: l_err_num := SQLCODE;
711: l_error_message := SQLERRM;
712:
713: select substr(l_error_message,12,512) into l_err_mesg from dual;
714: icx_util.add_error(l_err_mesg);
715: icx_util.error_page_print;
716:
717: end;
718:

Line 715: icx_util.error_page_print;

711: l_error_message := SQLERRM;
712:
713: select substr(l_error_message,12,512) into l_err_mesg from dual;
714: icx_util.add_error(l_err_mesg);
715: icx_util.error_page_print;
716:
717: end;
718:
719:

Line 794: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,

790: p_row_count => p_total_rows);
791: htp.p('');
792: htp.p('');
793: FND_MESSAGE.SET_NAME('ICX','ICX_ADD_TO_ORDER');
794: icx_util.DynamicButton(P_ButtonText => FND_MESSAGE.GET,
795: P_ImageFileName => 'FNDBNEW.gif',
796: P_OnMouseOverText => FND_MESSAGE.GET,
797: P_HyperTextCall => 'javascript:parent.frames[0].su
798: bmit()',

Line 816: c_prompts icx_util.g_prompts_table;

812: ------------------------------------------------------------
813:
814: sess_web_user number(15);
815: c_title varchar2(80) := '';
816: c_prompts icx_util.g_prompts_table;
817: v_lang varchar2(30);
818: where_clause varchar2(2000);
819: total_rows number;
820: temp_start number;

Line 837: y_table icx_util.char240_table;

833: n binary_integer :=0;
834: m binary_integer :=0;
835: v_qty_flag boolean := false;
836:
837: y_table icx_util.char240_table;
838:
839: v_cat_id number;
840: v_org number;
841: counter number := 0;

Line 873: -- icx_util.getPrompts(178,'ICX_CATALOG_ITEMS',c_title,c_prompts);

869: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
870: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
871: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
872:
873: -- icx_util.getPrompts(178,'ICX_CATALOG_ITEMS',c_title,c_prompts);
874: icx_util.getPrompts(601,'ICX_PO_SUPPL_CATALOG_ITEMS_R',c_title,c_prompts);
875: icx_util.error_page_setup;
876:
877:

Line 874: icx_util.getPrompts(601,'ICX_PO_SUPPL_CATALOG_ITEMS_R',c_title,c_prompts);

870: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
871: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
872:
873: -- icx_util.getPrompts(178,'ICX_CATALOG_ITEMS',c_title,c_prompts);
874: icx_util.getPrompts(601,'ICX_PO_SUPPL_CATALOG_ITEMS_R',c_title,c_prompts);
875: icx_util.error_page_setup;
876:
877:
878: --decrypt2 p_where

Line 875: icx_util.error_page_setup;

871: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
872:
873: -- icx_util.getPrompts(178,'ICX_CATALOG_ITEMS',c_title,c_prompts);
874: icx_util.getPrompts(601,'ICX_PO_SUPPL_CATALOG_ITEMS_R',c_title,c_prompts);
875: icx_util.error_page_setup;
876:
877:
878: --decrypt2 p_where
879: if p_where is not null then

Line 891: icx_util.copyright;

887: --If no catalog is selected then display a blank right frmae
888: if (v_cat_id = '-1') then
889: htp.htmlOpen;
890: htp.headOpen;
891: icx_util.copyright;
892: htp.bodyOpen('','BGCOLOR="#CCFFCC" onLoad="parent.parent.parent.winOpen(''nav'', ''catalog'')"');
893: htp.bodyClose;
894: htp.headClose;
895: htp.htmlClose;

Line 953: icx_util.copyright;

949:
950: --print javascript functions
951: htp.htmlOpen;
952: htp.headOpen;
953: icx_util.copyright;
954: js.scriptOpen;
955:
956: htp.p('function submit() {
957: document.catalog_items.cartId.value = parent.parent.parent.cartId;

Line 999: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_DATA_MULTIROW') );

995: htp.formHidden('p_row_count',total_rows,'cols="60" rows="10"');
996:
997: l_pos := l_pos + 9;
998:
999: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_DATA_MULTIROW') );
1000: htp.p('');
1001: --print the table column headings
1002: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1003:

Line 1000: htp.p('');

996:
997: l_pos := l_pos + 9;
998:
999: htp.tableOpen('border=5','','','','bgcolor=#' || icx_util.get_color('TABLE_DATA_MULTIROW') );
1000: htp.p('');
1001: --print the table column headings
1002: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1003:
1004: if (ak_query_pkg.g_items_table(i).value_id is not null

Line 1043: -- icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;

1039: end loop;
1040: htp.tableRowClose;
1041:
1042: --get one row of the result and find the catalog name
1043: -- icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(ak_query_pkg.g_results_table.first), y_table) ;
1044:
1045: v_qty_flag := true;
1046:
1047: htp.br; htp.br;

Line 1052: temp_table(0) := '';

1048:
1049: counter := 0;
1050: -- for j in p_start_row-1 .. end_row-1 loop
1051: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop
1052: temp_table(0) := '';
1053:
1054: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;
1055:
1056: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop

Line 1054: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;

1050: -- for j in p_start_row-1 .. end_row-1 loop
1051: for j in ak_query_pkg.g_results_table.FIRST .. ak_query_pkg.g_results_table.LAST loop
1052: temp_table(0) := '';
1053:
1054: icx_util.transfer_Row_To_Column( ak_query_pkg.g_results_table(j), y_table) ;
1055:
1056: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
1057:
1058: --print quantity input text box and up button if v_qty_flag is set

Line 1160: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');

1156: --close the table row
1157: temp_table(0) := temp_table(0) || htf.tableRowClose;
1158: if v_qty_flag then
1159: --print the down button
1160: display_text := htf.tableRowOpen( cattributes => 'BGColor="#'||icx_util.get_color('TABLE_DATA_MULTIROW')||'"');
1161: display_text := display_text || ' 1163: || '/FNDISPND.gif BORDER=0>';
1164: display_text := display_text || '';