DBA Data[Home] [Help]

APPS.ICX_REQ_SPECIAL_ORD dependencies on ICX_SEC

Line 46: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

42: v_lang varchar2(5);
43:
44: begin
45: -- get lang code
46: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
47:
48:
49: htp.p('');
50:

Line 138: IF (icx_sec.validatesession('ICX_REQS')) THEN

134:
135: BEGIN
136:
137: -- Check if session is valid
138: IF (icx_sec.validatesession('ICX_REQS')) THEN
139: -- Decrypt parameters
140: v_org := icx_call.decrypt2(n_org);
141:
142: -- Get prompts

Line 147: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

143: -- icx_util.getPrompts(178,'ICX_ONE_TIME',c_title,c_prompts);
144: icx_util.getPrompts(601,'ICX_ONE_TIME',c_title,c_prompts);
145:
146: -- Get language
147: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
148:
149: -- Get the execution environment
150: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
151:

Line 158: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

154:
155: -- (MC) Use exec_query instead of execute_query to improve performance
156: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
157: P_PARENT_REGION_CODE => 'ICX_REQ_SPECIAL_ORDER',
158: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
159: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
160: P_RETURN_PARENTS => 'F',
161: P_RETURN_CHILDREN => 'F');
162:

Line 159: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

155: -- (MC) Use exec_query instead of execute_query to improve performance
156: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
157: P_PARENT_REGION_CODE => 'ICX_REQ_SPECIAL_ORDER',
158: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
159: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
160: P_RETURN_PARENTS => 'F',
161: P_RETURN_CHILDREN => 'F');
162:
163:

Line 427: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),

423: -- No Hierarchy setup; show regular categories
424:
425: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
426: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
427: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
428: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
429: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',
430:
431: P_RETURN_PARENTS => 'T',

Line 428: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

424:
425: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
426: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
427: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
428: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
429: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',
430:
431: P_RETURN_PARENTS => 'T',
432: P_RETURN_CHILDREN => 'F');

Line 597: IF (icx_sec.validatesession('ICX_REQS')) THEN

593: WHERE unit_of_measure = v_uom;
594:
595: BEGIN
596:
597: IF (icx_sec.validatesession('ICX_REQS')) THEN
598:
599: icx_util.error_page_setup;
600:
601: /* Uncomment for debugging -- Debug code