DBA Data[Home] [Help]

APPS.ICX_REQ_CATEGORIES dependencies on OWA_UTIL

Line 103: v_dcdName varchar2(240) := owa_util.get_cgi_env('SCRIPT_NAME');

99: v_children_loaded varchar2(100);
100: p_where varchar2(240);
101: counter number;
102: i number;
103: v_dcdName varchar2(240) := owa_util.get_cgi_env('SCRIPT_NAME');
104: v_category_set_id number;
105: v_validate_flag varchar2(1);
106:
107: begin

Line 216: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');

212: -- get lang code
213: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
214:
215: --get dcd name
216: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
217:
218: htp.htmlOpen;
219: htp.headOpen;
220: htp.headClose;

Line 271: v_dcdName varchar2(240) := owa_util.get_cgi_env('SCRIPT_NAME');

267: v_no_of_children number;
268: v_org number;
269: params icx_on_utilities.v80_table;
270:
271: v_dcdName varchar2(240) := owa_util.get_cgi_env('SCRIPT_NAME');
272: v_first_time_flag varchar2(1);
273:
274: cursor cat_set is
275: select category_set_id,

Line 409: v_dcdName varchar2(1000) := owa_util.get_cgi_env('SCRIPT_NAME');

405: l_href1 varchar2(2000);
406: l_href2 varchar2(2000);
407: next_start_row number;
408: next_end_row number;
409: v_dcdName varchar2(1000) := owa_util.get_cgi_env('SCRIPT_NAME');
410:
411: cursor get_current_total(v_cart_id number) is
412: select sum(quantity * unit_price) total_price
413: from icx_shopping_cart_lines

Line 731: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');

727: v_lang varchar2(5);
728:
729: begin
730:
731: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
732:
733: -- get lang code
734: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
735:

Line 871: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');

867: if icx_sec.validateSession('ICX_REQS') then
868:
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;