61: htp.headClose;
62:
63: icx_admin_sig.toolbar(language_code => v_language_code,
64: disp_find => 'icx_store_catg_templates.find_categories');
65: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
66: fnd_message.set_token('NAME_OF_REGION_TOKEN',
67: ak_query_pkg.g_regions_table(0).name);
68: htp.br;
69: htp.tableOpen('BORDER=0');
62:
63: icx_admin_sig.toolbar(language_code => v_language_code,
64: disp_find => 'icx_store_catg_templates.find_categories');
65: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
66: fnd_message.set_token('NAME_OF_REGION_TOKEN',
67: ak_query_pkg.g_regions_table(0).name);
68: htp.br;
69: htp.tableOpen('BORDER=0');
70: htp.tableRowOpen;
67: ak_query_pkg.g_regions_table(0).name);
68: htp.br;
69: htp.tableOpen('BORDER=0');
70: htp.tableRowOpen;
71: htp.tableData(cvalue => ''||fnd_message.get||'
72: ',cattributes => 'VALIGN="MIDDLE"');
73: htp.tableClose;
74: htp.br;
75: icx_admin_sig.footer;
77: -- Set the mime type to spread sheet for automatic spawning
78: owa_util.mime_header('application/msexcel');
79:
80: -- Print the first three instruction lines
81: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE1');
82: htp.p(FND_MESSAGE.GET);
83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
78: owa_util.mime_header('application/msexcel');
79:
80: -- Print the first three instruction lines
81: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE1');
82: htp.p(FND_MESSAGE.GET);
83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
79:
80: -- Print the first three instruction lines
81: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE1');
82: htp.p(FND_MESSAGE.GET);
83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
87: htp.p(FND_MESSAGE.GET);
80: -- Print the first three instruction lines
81: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE1');
82: htp.p(FND_MESSAGE.GET);
83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
87: htp.p(FND_MESSAGE.GET);
88: htp.p;
81: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE1');
82: htp.p(FND_MESSAGE.GET);
83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
87: htp.p(FND_MESSAGE.GET);
88: htp.p;
89:
82: htp.p(FND_MESSAGE.GET);
83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
87: htp.p(FND_MESSAGE.GET);
88: htp.p;
89:
90: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
87: htp.p(FND_MESSAGE.GET);
88: htp.p;
89:
90: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
91: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'