eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_REQ_CATEGORIES dependencies on ICX_SEC

Line 64: v_resp_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

60: v_attr_code varchar2(80);
61:
62: begin
63:
64: v_resp_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
65: if v_resp_id is not NULL then
66:
67: open RespExclAttrs(v_resp_id,178,v_attribute_code);
68: fetch RespExclAttrs into v_attr_code;

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

116: where_clause := 'relationship_type = ''TOP'' AND CATEGORY_SET_ID =' || v_category_set_id;
117: -- Query childrens.
118: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
119: P_PARENT_REGION_CODE => 'ICX_RELATED_CATEGORIES_DISPLAY',
120: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
121: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
122: P_WHERE_CLAUSE => where_clause,
123: P_RETURN_PARENTS => 'T',
124: P_RETURN_CHILDREN => 'F');

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

117: -- Query childrens.
118: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
119: P_PARENT_REGION_CODE => 'ICX_RELATED_CATEGORIES_DISPLAY',
120: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
121: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
122: P_WHERE_CLAUSE => where_clause,
123: P_RETURN_PARENTS => 'T',
124: P_RETURN_CHILDREN => 'F');
125:

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

157: else -- No hierchy setup use regular categories
158:
159: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
160: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
161: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
162: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
163: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',
164:
165: P_RETURN_PARENTS => 'T',

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

158:
159: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
160: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
161: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
162: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
163: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',
164:
165: P_RETURN_PARENTS => 'T',
166: P_RETURN_CHILDREN => 'F');

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

209:
210: -- dbms_session.set_sql_trace(TRUE);
211:
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:

Line 296: if (icx_sec.validatesession('ICX_REQS')) then

292:
293: -- dbms_session.set_sql_trace(TRUE);
294:
295: -- Check if session is valid
296: if (icx_sec.validatesession('ICX_REQS')) then
297:
298: --decrypt2 p_where
299: if p_where is not null then
300: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where), params);

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

332: where_clause := where_clause || ' relationship_type = ''CHILD''';
333: -- Query childrens.
334: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
335: P_PARENT_REGION_CODE => 'ICX_RELATED_CATEGORIES_DISPLAY',
336: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
337: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
338: P_WHERE_CLAUSE => where_clause,
339: P_RETURN_PARENTS => 'T',
340: P_RETURN_CHILDREN => 'F');

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

333: -- Query childrens.
334: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
335: P_PARENT_REGION_CODE => 'ICX_RELATED_CATEGORIES_DISPLAY',
336: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
337: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
338: P_WHERE_CLAUSE => where_clause,
339: P_RETURN_PARENTS => 'T',
340: P_RETURN_CHILDREN => 'F');
341:

Line 561: if icx_sec.validatesession then

557: l_segments fnd_flex_ext.SegmentArray;
558:
559: begin
560:
561: if icx_sec.validatesession then
562:
563: l_rows_added := 0;
564: l_rows_updated := 0;
565: l_num_rows := Quantity.COUNT;

Line 566: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

562:
563: l_rows_added := 0;
564: l_rows_updated := 0;
565: l_num_rows := Quantity.COUNT;
566: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
567: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
568: if p_where is not NULL then
569: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where),params);
570: l_org_id := params(2);

Line 567: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);

563: l_rows_added := 0;
564: l_rows_updated := 0;
565: l_num_rows := Quantity.COUNT;
566: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
567: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
568: if p_where is not NULL then
569: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where),params);
570: l_org_id := params(2);
571: end if;

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

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:
736:
737: -- We need to split into 2 frames
738:

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

774: begin
775:
776: SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
777:
778: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
779: htp.p('');
780:
781: htp.p('');
782: htp.p('
');

Line 867: if icx_sec.validateSession('ICX_REQS') then

863: begin
864:
865: -- dbms_session.set_sql_trace(TRUE);
866:
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');

Line 869: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

865: -- dbms_session.set_sql_trace(TRUE);
866:
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);

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

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

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

920:
921: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
922: P_PARENT_REGION_CODE => 'ICX_PO_SUPPL_CATALOG_ITEMS_R',
923: p_where_clause => where_clause,
924: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
925: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
926: P_RETURN_PARENTS => 'T',
927: P_RETURN_CHILDREN => 'F',
928: P_RANGE_LOW => p_start_row,

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

921: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
922: P_PARENT_REGION_CODE => 'ICX_PO_SUPPL_CATALOG_ITEMS_R',
923: p_where_clause => where_clause,
924: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
925: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
926: P_RETURN_PARENTS => 'T',
927: P_RETURN_CHILDREN => 'F',
928: P_RANGE_LOW => p_start_row,
929: P_RANGE_HIGH => end_row);