[Home] [Help]
1130:
1131: CURSOR check_cart_line_exists(v_cart_id number,v_sequence_num number,
1132: v_org_id number, v_express_name varchar2) IS
1133: SELECT cart_line_id
1134: FROM icx_shopping_cart_lines
1135: WHERE cart_id = v_cart_id
1136: AND line_id = v_sequence_num
1137: AND express_name = v_express_name
1138: AND NVL(org_id, -9999) = NVL(v_org_id,-9999);
1195: END IF;
1196:
1197: /* Select the max of the cart_line_number for ordering */
1198: SELECT max(cart_line_number) + 1 into v_cart_line_number
1199: FROM icx_shopping_cart_lines
1200: WHERE cart_id = l_cart_id;
1201:
1202: IF v_cart_line_number IS NULL THEN
1203: /* This is the first one */
1228:
1229: l_line_id := v_sequence_num(i);
1230:
1231: --changed by alex for attachment
1232: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id
1233: -- from dual;
1234: --new code:
1235: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id
1236: from dual;
1243: d_location_code,
1244: d_org_id,
1245: d_org_code);
1246:
1247: INSERT INTO icx_shopping_cart_lines
1248: (cart_line_id,
1249: cart_id,
1250: creation_date,
1251: created_by,
1280: autosource_doc_line_num
1281: -- ,deliver_to_requestor,
1282: -- deliver_to_requestor_id
1283: )
1284: SELECT /* into icx_shopping_cart_lines */
1285: l_cart_line_id,
1286: l_cart_id,
1287: sysdate,
1288: l_shopper_id,
1399: AND prl.source_type_code = 'VENDOR'
1400: AND prl.item_id is null
1401: AND prl.express_name = v_express_name
1402: AND prl.sequence_num = to_number(l_line_id);
1403: /* end of insert into icx_shopping_cart_lines */
1404:
1405: -- Get the default accounts and update distributions
1406: icx_req_acct2.get_default_account(l_cart_id,l_cart_line_id,
1407: l_emp_id,l_org_id,l_account_id,l_account_num);
1411: v_cart_line_number := v_cart_line_number + 1;
1412:
1413: ELSE
1414:
1415: UPDATE icx_shopping_cart_lines
1416: SET quantity = quantity + l_qty,
1417: last_update_date = sysdate,
1418: last_updated_by = l_shopper_id
1419: WHERE cart_id = l_cart_id
1438:
1439: /* get the order total; do this after custom defaults as it clould
1440: modify the price or quantity */
1441: SELECT SUM(quantity * unit_price) INTO l_order_total
1442: FROM icx_shopping_cart_lines
1443: WHERE cart_id = l_cart_id;
1444:
1445: total_page(l_rows_added,l_rows_updated, l_qty_added, l_qty_updated,
1446: l_order_total, l_dest_org_id, v_express_name,