[Home] [Help]
670: l_money_precision number;
671:
672: cursor get_current_total(v_cart_id number) is
673: select sum(quantity * unit_price) total_price
674: from icx_shopping_cart_lines
675: where cart_id = v_cart_id;
676:
677: begin
678: l_total_price := 0;
806: l_pad number;
807:
808: cursor check_cart_line_exists(v_cart_id number,v_line_id varchar2,v_org_id number) is
809: select cart_line_id
810: from icx_shopping_cart_lines
811: where cart_id = v_cart_id
812: and line_id = v_line_id
813: and nvl(org_id, -9999) = nvl(v_org_id,-9999);
814:
825:
826:
827: cursor get_max_line_number(v_cart_id number) is
828: select max(cart_line_number)
829: from icx_shopping_cart_lines
830: where cart_id = v_cart_id;
831:
832: l_emp_id number;
833: l_account_id NUMBER := NULL;
903:
904: commit;
905: /* release semaphore */
906: --changed by alex for attachment
907: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;
908: --new code:
909: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
910:
911: insert into icx_shopping_cart_lines(cart_line_id,cart_id,cart_line_number,creation_date,created_by,quantity,line_id,item_id,item_revision,unit_of_measure,
907: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;
908: --new code:
909: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
910:
911: insert into icx_shopping_cart_lines(cart_line_id,cart_id,cart_line_number,creation_date,created_by,quantity,line_id,item_id,item_revision,unit_of_measure,
912: unit_price,category_id,line_type_id,item_description,destination_organization_id,deliver_to_location_id,deliver_to_location,
913: suggested_buyer_id,suggested_vendor_name,suggested_vendor_site,
914: need_by_date,suggested_vendor_contact,
915: suggested_vendor_item_num,item_number,last_update_date,last_updated_by,org_id,custom_defaulted, autosource_doc_header_id, autosource_doc_line_num)
935: else
936:
937: l_qty := to_number(Quantity(i));
938:
939: update icx_shopping_cart_lines
940: set quantity = quantity + l_qty
941: where cart_id = l_cart_id
942: and cart_line_id = l_cart_line_id
943: and nvl(org_id, -9999) = nvl(l_org_id,-9999);