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_SEARCH dependencies on ICX_SEC

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

70: v_attr_code varchar2(80);
71:
72: begin
73:
74: v_resp_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
75: if v_resp_id is not NULL then
76:
77: open RespExclAttrs(v_resp_id,178,v_attribute_code);
78: fetch RespExclAttrs into v_attr_code;

Line 168: l_language_code varchar2(30) := icx_sec.getID(icx_sec.pv_language_code);

164: p_LOV_mode in varchar2 default 'N',
165: p_default_title in varchar2 default 'Y',
166: p_values in number default null) is
167: -------------------------------------------------------------------
168: l_language_code varchar2(30) := icx_sec.getID(icx_sec.pv_language_code);
169: l_responsibility_id number := icx_sec.getID(icx_sec.pv_responsibility_id);
170:
171: l_message varchar2(240);
172: l_page_title varchar2(30);

Line 169: l_responsibility_id number := icx_sec.getID(icx_sec.pv_responsibility_id);

165: p_default_title in varchar2 default 'Y',
166: p_values in number default null) is
167: -------------------------------------------------------------------
168: l_language_code varchar2(30) := icx_sec.getID(icx_sec.pv_language_code);
169: l_responsibility_id number := icx_sec.getID(icx_sec.pv_responsibility_id);
170:
171: l_message varchar2(240);
172: l_page_title varchar2(30);
173:

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

354: if 175 = 178 then
355:
356: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
357: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
358: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
359: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
360: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',
361:
362: P_RETURN_PARENTS => 'T',

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

355:
356: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 178,
357: P_PARENT_REGION_CODE => 'ICX_REQ_CATEGORIES',
358: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
359: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
360: P_WHERE_CLAUSE => ' FUNCTIONAL_AREA_ID = 2',
361:
362: P_RETURN_PARENTS => 'T',
363: P_RETURN_CHILDREN => 'F');

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

444:
445: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
446:
447: -- get lang code
448: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
449:
450:
451: -- We need to split into 2 frames
452:

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

493: begin
494:
495: SELECT QUERY_SET INTO c_query_size FROM ICX_PARAMETERS;
496:
497: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
498: htp.p('');
499:
500: htp.p('');
501: htp.p('
');

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

560: -- dbms_session.set_sql_trace(TRUE);
561:
562:
563: --Check if session is valid
564: if (icx_sec.validatesession('ICX_REQS')) then
565: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
566:
567: l_paramX := paramX;
568: v_lines_url := 'ICX_REQ_SEARCH.itemsearch_display?searchX=';

Line 565: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

561:
562:
563: --Check if session is valid
564: if (icx_sec.validatesession('ICX_REQS')) then
565: l_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
566:
567: l_paramX := paramX;
568: v_lines_url := 'ICX_REQ_SEARCH.itemsearch_display?searchX=';
569: if paramX is not null then

Line 839: if icx_sec.validatesession then

835: l_segments fnd_flex_ext.SegmentArray;
836:
837: begin
838:
839: if icx_sec.validatesession then
840:
841: l_num_rows := Quantity.COUNT;
842: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
843: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);

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

838:
839: if icx_sec.validatesession then
840:
841: l_num_rows := Quantity.COUNT;
842: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
843: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
844: -- if p_where is not NULL then
845: -- icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where),params);
846: -- l_org_id := params(2);

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

839: if icx_sec.validatesession then
840:
841: l_num_rows := Quantity.COUNT;
842: l_shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
843: -- l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
844: -- if p_where is not NULL then
845: -- icx_on_utilities.unpack_parameters(icx_call.decrypt2(p_where),params);
846: -- l_org_id := params(2);
847: -- end if;

Line 1033: v_num_table icx_sec.g_num_tbl_type;

1029: v_line_id_ind number;
1030: v_item_url varchar2(150);
1031: v_supplier_url varchar2(150);
1032: v_return_status varchar2(20);
1033: v_num_table icx_sec.g_num_tbl_type;
1034: counter number := 0;
1035: v_quantity_length number :=10;
1036: v_temp varchar2(240);
1037: v_qty_flag boolean := false;

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

1080:
1081: begin
1082: -- dbms_session.set_sql_trace(TRUE);
1083:
1084: if icx_sec.validateSession('ICX_REQS') then
1085:
1086: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1087: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1088: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');

Line 1086: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

1082: -- dbms_session.set_sql_trace(TRUE);
1083:
1084: if icx_sec.validateSession('ICX_REQS') then
1085:
1086: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1087: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1088: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
1089:
1090: employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);

Line 1087: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

1083:
1084: if icx_sec.validateSession('ICX_REQS') then
1085:
1086: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1087: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1088: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
1089:
1090: employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1091:

Line 1090: employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);

1086: c_language := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1087: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1088: v_dcdName := owa_util.get_cgi_env('SCRIPT_NAME');
1089:
1090: employee_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1091:
1092: --Get the org id from shopper_id
1093: icx_req_navigation.shopper_info(employee_id, shopper_name, v_location_id, v_location_code, v_org_id, v_org_code);
1094:

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

1197: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
1198: P_PARENT_REGION_CODE => 'ICX_PO_SUPPL_CATALOG_ITEMS_R',
1199: P_WHERE_CLAUSE => l_where_clause,
1200: P_WHERE_BINDS => where_clause_binds,
1201: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1202: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1203: P_RETURN_PARENTS => 'T',
1204: P_RETURN_CHILDREN => 'F',
1205: P_RANGE_LOW => p_start_row,

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

1198: P_PARENT_REGION_CODE => 'ICX_PO_SUPPL_CATALOG_ITEMS_R',
1199: P_WHERE_CLAUSE => l_where_clause,
1200: P_WHERE_BINDS => where_clause_binds,
1201: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1202: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1203: P_RETURN_PARENTS => 'T',
1204: P_RETURN_CHILDREN => 'F',
1205: P_RANGE_LOW => p_start_row,
1206: P_RANGE_HIGH => end_row );

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

1210: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
1211: P_PARENT_REGION_CODE => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
1212: P_WHERE_CLAUSE => l_where_clause,
1213: P_WHERE_BINDS => where_clause_binds,
1214: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1215: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1216: P_RETURN_PARENTS => 'T',
1217: P_RETURN_CHILDREN => 'F',
1218: P_RANGE_LOW => p_start_row,

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

1211: P_PARENT_REGION_CODE => 'ICX_PO_SUPPL_SEARCH_ITEMS_R',
1212: P_WHERE_CLAUSE => l_where_clause,
1213: P_WHERE_BINDS => where_clause_binds,
1214: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
1215: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
1216: P_RETURN_PARENTS => 'T',
1217: P_RETURN_CHILDREN => 'F',
1218: P_RANGE_LOW => p_start_row,
1219: P_RANGE_HIGH => end_row );