APPS.POS_ASN_SEARCH_PKG dependencies on POS_ASN_SHOP_CART_HEADERS

Line 199: from POS_ASN_SHOP_CART_HEADERS ct,

195: into l_supplier_site_id,
196: l_supplier_site,
197: l_ship_to_loc_id,
198: l_ship_to_location
199: from POS_ASN_SHOP_CART_HEADERS ct,
200: PO_VENDOR_SITES vs,
201: HR_LOCATIONS hrl
202: where ct.session_id = l_session_id
203: and ct.vendor_site_id = vs.vendor_site_id

Line 671: from pos_asn_shop_cart_headers

667: select ship_to_organization_id,
668: ship_to_location_id
669: into l_first_org_id,
670: l_first_loc_id
671: from pos_asn_shop_cart_headers
672: where session_id = l_session_id;
673: exception
674: when others then
675: null;

Line 723: from pos_asn_shop_cart_headers

719: -- if no, create a new ASN header.
720:
721: select count(1)
722: into l_header_count
723: from pos_asn_shop_cart_headers
724: where session_id = l_session_id;
725:
726: if l_header_count = 0 and pos_select.count > 0 then
727:

Line 743: insert into pos_asn_shop_cart_headers

739: po_headers poh
740: where poh.po_header_id = poll.po_header_id
741: and poll.line_location_id = l_po_shipment_id;
742:
743: insert into pos_asn_shop_cart_headers
744: (
745: SESSION_ID,
746: SHIP_TO_ORGANIZATION_ID,
747: SHIP_TO_LOCATION_ID,