35: v_attr_code varchar2(80);
36:
37: begin
38:
39: v_resp_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
40: if v_resp_id is not NULL then
41:
42: open RespExclAttrs(v_resp_id,178,v_attribute_code);
43: fetch RespExclAttrs into v_attr_code;
80: v_lang varchar2(5);
81:
82: begin
83: -- set lang code
84: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
85:
86: -- icx_admin_sig.openHeader;
87: -- icx_admin_sig.closeHeader;
88:
362:
363: begin
364:
365: l_col := 0;
366: v_req_overwrite_flag := icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG);
367:
368: ICX_REQ_NAVIGATION.chk_vendor_on(v_vendor_on_flag);
369:
370: -- old background
479: --
480:
481: begin
482:
483: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
484: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
485: -- icx_util.getprompts(601, 'ICX_SHOPPING_CART_LINES_R', c_title, c_prompts);
486: icx_util.getprompts(601, 'ICX_LOV', c_title, c_prompts);
487:
865: begin
866:
867: v_vendor_LOV_flag := 'N';
868: v_location_LOV_flag := 'N';
869: v_req_overwrite_flag := icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG);
870: if v_req_overwrite_flag = 'Y' then
871: v_location_LOV_flag := 'Y';
872: end if;
873:
1134: l_pos in out number ) is
1135: ------------------------------------------------------------
1136: i number := 0;
1137: where_clause varchar2(240);
1138: v_language varchar2(30) := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1139: dbutton varchar2(5000);
1140: y_table icx_util.char240_table;
1141: l_requestor_id number;
1142: l_requestor_name varchar2(240);
1301:
1302: if ( ak_query_pkg.g_items_table(i).update_flag = 'Y' and
1303: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN') then
1304:
1305: where_clause :='';--' = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1306:
1307: htp.p('
1491: if ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1492: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
1493:
1494:
1495: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'Y' and
1496: ak_query_pkg.g_items_table(i).update_flag = 'Y') or
1497: ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
1498: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG'
1499: ) then
1493:
1494:
1495: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'Y' and
1496: ak_query_pkg.g_items_table(i).update_flag = 'Y') or
1497: ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
1498: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG'
1499: ) then
1500:
1501:
1494:
1495: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'Y' and
1496: ak_query_pkg.g_items_table(i).update_flag = 'Y') or
1497: ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
1498: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG'
1499: ) then
1500:
1501:
1502: htp.p('
1506: || ak_query_pkg.g_items_table(i).attribute_value_length || ' VALUE="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '"';
1507:
1508: l_pos := l_pos + 1;
1509:
1510: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
1511: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG') and
1512: ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'N' or
1513: ak_query_pkg.g_items_table(i).update_flag = 'N') then
1514:
1507:
1508: l_pos := l_pos + 1;
1509:
1510: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
1511: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG') and
1512: ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'N' or
1513: ak_query_pkg.g_items_table(i).update_flag = 'N') then
1514:
1515: display_text := display_text || ' onBlur=''this.value ="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '"''>';
1508: l_pos := l_pos + 1;
1509:
1510: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
1511: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG') and
1512: ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG) = 'N' or
1513: ak_query_pkg.g_items_table(i).update_flag = 'N') then
1514:
1515: display_text := display_text || ' onBlur=''this.value ="' || replace(y_table(ak_query_pkg.g_items_table(i).value_id),'"','"') || '"''>';
1516: htp.p(display_text || '
1576:
1577:
1578: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1579:
1580: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
1581: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG'
1582: ) and
1583: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
1584: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1577:
1578: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_REQUESTOR' then
1579:
1580: if ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
1581: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG'
1582: ) and
1583: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
1584: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1585: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
1583: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
1584: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
1585: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
1586:
1587: where_clause := 'WEB_USER_ID = ' || icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1588:
1589: htp.p('
1607: c_frame_name => 'my_order1',
1608: c_where_clause => where_clause));
1609: htp.p('
1608: c_where_clause => where_clause));
1609: htp.p('');
1610:
1611: elsif ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ALL' OR
1612: icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'ORG') and
1613: (ak_query_pkg.g_items_table(i).node_display_flag ='Y' and
1614: ak_query_pkg.g_items_table(i).item_style = 'HIDDEN') then
1615:
1616: htp.p('
1619: l_pos := l_pos + 1;
1620:
1621:
1622:
1623: elsif (ak_query_pkg.g_items_table(i).node_display_flag = 'Y') and ( icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_REQUESTOR) = 'NO' or
1624: ak_query_pkg.g_items_table(i).update_flag = 'N' ) then
1625:
1626: htp.p('
1801: and cart_line_id = v_cart_line_id
1802: and nvl(org_id,-9999) = nvl(v_org_id,-9999);
1803:
1804: begin
1805: if icx_sec.validatesession then
1806:
1807: l_cart_id := icx_call.decrypt2(cartId);
1808: l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1809:
1804: begin
1805: if icx_sec.validatesession then
1806:
1807: l_cart_id := icx_call.decrypt2(cartId);
1808: l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
1809:
1810: l_cart_line_number := NULL;
1811: open get_line_number(l_cart_id,cartLineId);
1812: fetch get_line_number into l_cart_line_number;
1994: and cart_line_id = v_cart_line_id;
1995:
1996:
1997: begin
1998: if icx_sec.validatesession then
1999:
2000: l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
2001: l_cart_id := icx_call.decrypt2(cartId);
2002:
1996:
1997: begin
1998: if icx_sec.validatesession then
1999:
2000: l_org_id := icx_sec.getId(icx_sec.PV_ORG_ID);
2001: l_cart_id := icx_call.decrypt2(cartId);
2002:
2003:
2004: l_cart_line_number := NULL;
2068:
2069:
2070: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
2071: P_PARENT_REGION_CODE => v_lines_region,
2072: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
2073: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
2074: P_WHERE_CLAUSE => v_where_clause,
2075: P_RETURN_PARENTS => 'F',
2076: P_RETURN_CHILDREN => 'F',
2069:
2070: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
2071: P_PARENT_REGION_CODE => v_lines_region,
2072: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
2073: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
2074: P_WHERE_CLAUSE => v_where_clause,
2075: P_RETURN_PARENTS => 'F',
2076: P_RETURN_CHILDREN => 'F',
2077: P_WHERE_BINDS => where_clause_binds);
2085: htp.p('');
2086:
2087: l_pos := l_pos + 3;
2088:
2089: v_req_overwrite_flag := icx_sec.getID(icx_sec.PV_USER_REQ_OVERRIDE_LOC_FLAG);
2090: ICX_REQ_NAVIGATION.chk_vendor_on(v_vendor_on_flag);
2091:
2092: for i in ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST loop
2093:
2222: begin
2223:
2224:
2225:
2226: if (icx_sec.validatesession()) then
2227:
2228: v_index := 1;
2229:
2230: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2226: if (icx_sec.validatesession()) then
2227:
2228: v_index := 1;
2229:
2230: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2231:
2232: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2233: --decrypt parameters
2234: v_org := icx_call.decrypt2(n_org);
2228: v_index := 1;
2229:
2230: shopper_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
2231:
2232: v_lang := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
2233: --decrypt parameters
2234: v_org := icx_call.decrypt2(n_org);
2235: if n_emergency is not null then
2236: v_emergency := icx_call.decrypt2(n_emergency);
2250: icx_util.LOVScript;
2251:
2252:
2253: --debug
2254: l_session_id := to_number(icx_sec.getID(icx_sec.PV_SESSION_ID));
2255: --insert into debug_timings values (1000, l_session_id,
2256: -- to_char(sysdate, 'HH24:MI:SS'), 'drawCartErrors started.');
2257: --debug
2258:
2279:
2280: -- Cart Lines Related Object Navigator
2281: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
2282: P_PARENT_REGION_CODE => v_lines_region,
2283: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
2284: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
2285: P_RETURN_PARENTS => 'F',
2286: P_RETURN_CHILDREN => 'F');
2287:
2280: -- Cart Lines Related Object Navigator
2281: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,
2282: P_PARENT_REGION_CODE => v_lines_region,
2283: P_RESPONSIBILITY_ID => icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID),
2284: P_USER_ID => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
2285: P_RETURN_PARENTS => 'F',
2286: P_RETURN_CHILDREN => 'F');
2287:
2288: cart_line_actions(n_org);
2331:
2332: htp.p('