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.
[Home] [Help]
APPS.ICX_REQ_TEMPLATES dependencies on ICX_SEC
Line 57: v_return_template := icx_sec.getID(icx_sec.PV_USER_REQ_TEMPLATE);
53:
54: begin
55:
56: -- get default template
57: v_return_template := icx_sec.getID(icx_sec.PV_USER_REQ_TEMPLATE);
58:
59: v_test := 0;
60:
61: if v_emergency = 'YES' then
Line 150: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
146: htp.comment(where_clause);
147:
148: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
149: P_PARENT_REGION_CODE => 'ICX_RELATED_TEMPLATES_DISPLAY',
150: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
151: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
152: P_WHERE_CLAUSE => where_clause,
153: P_RETURN_PARENTS => 'T',
154: P_RETURN_CHILDREN => 'F',
Line 151: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
147:
148: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
149: P_PARENT_REGION_CODE => 'ICX_RELATED_TEMPLATES_DISPLAY',
150: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
151: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
152: P_WHERE_CLAUSE => where_clause,
153: P_RETURN_PARENTS => 'T',
154: P_RETURN_CHILDREN => 'F',
155: p_WHERE_BINDS => where_clause_binds );
Line 230: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
226: htp.comment(where_clause);
227:
228: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
229: P_PARENT_REGION_CODE => 'ICX_REQ_TEMPLATES',
230: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
231: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
232: P_WHERE_CLAUSE => where_clause,
233: P_RETURN_PARENTS => 'T',
234: P_RETURN_CHILDREN => 'F',
Line 231: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
227:
228: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
229: P_PARENT_REGION_CODE => 'ICX_REQ_TEMPLATES',
230: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
231: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
232: P_WHERE_CLAUSE => where_clause,
233: P_RETURN_PARENTS => 'T',
234: P_RETURN_CHILDREN => 'F',
235: P_WHERE_BINDS => where_clause_binds);
Line 325: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
321: begin
322:
323:
324: -- get lang code
325: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
326:
327: --get dcd name
328: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
329:
Line 422: if (icx_sec.validatesession()) then
418: begin
419:
420:
421: -- Check if session is valid
422: if (icx_sec.validatesession()) then
423:
424: v_index := 1;
425:
426: --decrypt2 p_where
Line 532: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
528: v_index := v_index + 1;
529: -- Query childrens.
530: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
531: P_PARENT_REGION_CODE => 'ICX_RELATED_TEMPLATES_DISPLAY',
532: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
533: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
534: P_WHERE_CLAUSE => where_clause,
535: P_RETURN_PARENTS => 'T',
536: P_RETURN_CHILDREN => 'F',
Line 533: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
529: -- Query childrens.
530: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
531: P_PARENT_REGION_CODE => 'ICX_RELATED_TEMPLATES_DISPLAY',
532: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
533: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
534: P_WHERE_CLAUSE => where_clause,
535: P_RETURN_PARENTS => 'T',
536: P_RETURN_CHILDREN => 'F',
537: p_WHERE_BINDS => where_clause_binds);
Line 617: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
613:
614: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
615:
616: -- get lang code
617: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
618:
619:
620: -- We need to split into 2 frames
621:
Line 661: IF icx_sec.validateSession THEN
657: c_query_size number;
658:
659: begin
660:
661: IF icx_sec.validateSession THEN
662:
663: SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
664:
665: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
Line 665: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
661: IF icx_sec.validateSession THEN
662:
663: SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
664:
665: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
666: htp.p('
');
667:
668: htp.p('');
669: htp.p('');
Line 751: IF icx_sec.validateSession() THEN
747:
748: BEGIN
749:
750:
751: IF icx_sec.validateSession() THEN
752:
753: v_index := 1;
754:
755: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
Line 755: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
751: IF icx_sec.validateSession() THEN
752:
753: v_index := 1;
754:
755: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
756: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
757: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
758:
759:
Line 756: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
752:
753: v_index := 1;
754:
755: sess_web_user := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
756: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
757: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
758:
759:
760: -- icx_util.getPrompts(178,'ICX_ITEMS_TEMPLATE',c_title,c_prompts);
Line 823: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
819: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
820: P_PARENT_REGION_CODE => 'ICX_PO_TEMPLATE_ITEMS_R',
821: P_WHERE_CLAUSE => where_clause,
822: p_WHERE_BINDS => where_clause_binds,
823: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
824: P_USER_ID => sess_web_user,
825: P_RETURN_PARENTS => 'T',
826: P_RETURN_CHILDREN => 'F',
827: P_RANGE_LOW => p_start_row,
Line 1171: IF icx_sec.validateSession THEN
1167: l_segments fnd_flex_ext.SegmentArray;
1168:
1169: BEGIN
1170:
1171: IF icx_sec.validateSession THEN
1172:
1173: icx_util.error_page_setup;
1174:
1175: l_cart_id := to_number(icx_call.decrypt2(cartId));
Line 1180: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1176: l_emergency := icx_call.decrypt2(p_emergency);
1177: l_rows_added := 0;
1178: l_rows_updated := 0;
1179: l_num_rows := Quantity.COUNT;
1180: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1181: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1182:
1183: IF p_where IS NOT NULL THEN
1184: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where), params);
Line 1181: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1177: l_rows_added := 0;
1178: l_rows_updated := 0;
1179: l_num_rows := Quantity.COUNT;
1180: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1181: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1182:
1183: IF p_where IS NOT NULL THEN
1184: icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where), params);
1185: v_org := params(2);
Line 1238: v_requestor_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1234: --new code:
1235: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id
1236: from dual;
1237: /* get contact id for deliver_to_requestor */
1238: v_requestor_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1239:
1240: ICX_REQ_NAVIGATION.shopper_info(v_requestor_id,
1241: v_requestor_name,
1242: d_location_id,