APPS.ICX_REQ_CATEGORIES dependencies on ICX_SHOPPING_CART_LINES

Line 413: from icx_shopping_cart_lines

409: v_dcdName varchar2(1000) := owa_util.get_cgi_env('SCRIPT_NAME');
410:
411: cursor get_current_total(v_cart_id number) is
412: select sum(quantity * unit_price) total_price
413: from icx_shopping_cart_lines
414: where cart_id = v_cart_id;
415:
416: begin
417:

Line 524: from icx_shopping_cart_lines

520: l_cat_name varchar2(1000);
521:
522: cursor check_cart_line_exists(v_cart_id number,v_line_id varchar2,v_org_id number) is
523: select cart_line_id
524: from icx_shopping_cart_lines
525: where cart_id = v_cart_id
526: and line_id = v_line_id
527: and nvl(org_id, -9999) = nvl(v_org_id,-9999);
528:

Line 542: from icx_shopping_cart_lines

538: -- and nvl(org_id,-9999) = nvl(v_org_id,-9999);
539:
540: cursor get_max_line_number(v_cart_id number) is
541: select max(cart_line_number)
542: from icx_shopping_cart_lines
543: where cart_id = v_cart_id;
544:
545: l_need_by_date date;
546: l_deliver_to_location_id number;

Line 631: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;

627: commit;
628: /* close semaphore */
629:
630: --changed by alex for attachment
631: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;
632: --new code:
633: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
634:
635: 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,

Line 635: 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,

631: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;
632: --new code:
633: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
634:
635: 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,
636: unit_price,category_id,line_type_id,item_description,destination_organization_id,deliver_to_location_id,deliver_to_location,
637: suggested_buyer_id,suggested_vendor_name,suggested_vendor_site,
638: need_by_date,suggested_vendor_contact,
639: suggested_vendor_item_num,item_number,last_update_date,last_updated_by,org_id,custom_defaulted, autosource_doc_header_id, autosource_doc_line_num)

Line 670: update icx_shopping_cart_lines

666:
667: else
668:
669:
670: update icx_shopping_cart_lines
671: set quantity = quantity + l_qty
672: where cart_id = l_cart_id
673: and cart_line_id = l_cart_line_id
674: and nvl(org_id, -9999) = nvl(l_org_id,-9999);