DBA Data[Home] [Help]

APPS.ICX_CATG dependencies on ICX_UTIL

Line 15: y_table icx_util.char240_table;

11:
12: l_where_clause VARCHAR2(2000) := NULL;
13: l_region_code VARCHAR2(50):= NULL;
14: l_total_rows NUMBER := 0;
15: y_table icx_util.char240_table;
16:
17: l_field_sep VARCHAR2(10) := icx_store_batch_utils.g_field_sep;
18: l_line_sep VARCHAR2(10) := icx_store_batch_utils.g_line_sep;
19:

Line 29: icx_util.error_page_setup;

25:
26: IF icx_sec.validateSession THEN
27:
28: -- Initialize the error page
29: icx_util.error_page_setup;
30:
31: l_date_format := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
32:
33: v_dcd_name := owa_util.get_cgi_env('SCRIPT_NAME');

Line 56: icx_util.copyright;

52: -- Do not spwan the spread sheet
53: -- This will not happen
54: htp.htmlOpen;
55: htp.headOpen;
56: icx_util.copyright;
57: js.scriptOpen;
58: icx_admin_sig.help_win_script(v_help_url, v_language_code);
59: js.scriptClose;
60: htp.title(ak_query_pkg.g_regions_table(0).name);

Line 106: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);

102: htp.p(l_line);
103:
104: -- FOR r IN p_start_row -1..v_end_row - 1 LOOP
105: FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
106: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);
107:
108: l_line := NULL;
109: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
110: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'

Line 131: icx_util.add_error(substr(SQLERRM, 12, 512));

127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: -- htp.p('Error in xls: ' || substr(SQLERRM, 1, 512));
131: icx_util.add_error(substr(SQLERRM, 12, 512));
132: icx_util.error_page_print;
133: END xls;
134:
135: END icx_catg;

Line 132: icx_util.error_page_print;

128: EXCEPTION
129: WHEN OTHERS THEN
130: -- htp.p('Error in xls: ' || substr(SQLERRM, 1, 512));
131: icx_util.add_error(substr(SQLERRM, 12, 512));
132: icx_util.error_page_print;
133: END xls;
134:
135: END icx_catg;