APPS.ICX_CATG dependencies on ICX_CATG

Line 1: PACKAGE BODY icx_catg AS

1: PACKAGE BODY icx_catg AS
2: /* $Header: ICXSTDCB.pls 115.2 99/07/17 03:26:58 porting ship $ */
3:
4: ----------------------------------------------------
5: PROCEDURE xls (p_where IN VARCHAR2 )

Line 38: l_region_code := 'ICX_CATG_DETLS_LOAD_R';

34: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
35: v_help_url := '/OA_DOC/' || v_language_code || '/awc' || '/icxitems.htm';
36:
37: l_where_clause := icx_call.decrypt2(p_where);
38: l_region_code := 'ICX_CATG_DETLS_LOAD_R';
39:
40: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
41: P_PARENT_REGION_CODE => l_region_code,
42: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

Line 81: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE1');

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);

Line 83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');

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);

Line 86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');

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

Line 135: END icx_catg;

131: icx_util.add_error(substr(SQLERRM, 12, 512));
132: icx_util.error_page_print;
133: END xls;
134:
135: END icx_catg;