');
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 );
|