APPS.POS_ASN_SEARCH_PKG dependencies on POS_ASN_SHOP_CART_DETAILS

Line 183: from POS_ASN_SHOP_CART_DETAILS

179: -- Check if the shopping cart is empty
180:
181: select decode(count(1), 0, 'Y', 'N')
182: into l_empty_cart
183: from POS_ASN_SHOP_CART_DETAILS
184: where session_id = l_session_id;
185:
186: if l_empty_cart = 'N' then
187:

Line 577: from pos_asn_shop_cart_details

573: htp.p('');
574:
575: select count(1)
576: into l_num_shipments
577: from pos_asn_shop_cart_details
578: where session_id = l_session_id;
579:
580: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
581: p_parent_region_code=>'POS_ASN_RESULT_R',

Line 776: from pos_asn_shop_cart_details

772: FOR l_counter IN 1..pos_select.count LOOP
773:
774: select nvl(max(asn_line_id), 0) + 1
775: into l_asn_line_id
776: from pos_asn_shop_cart_details
777: where session_id = l_session_id;
778:
779: l_po_shipment_id := to_number(pos_po_shipment_id(to_number(pos_select(l_counter))));
780:

Line 794: insert into pos_asn_shop_cart_details

790: po_lines pol
791: where poll.line_location_id = l_po_shipment_id
792: and poll.po_line_id = pol.po_line_id;
793:
794: insert into pos_asn_shop_cart_details
795: (
796: SESSION_ID,
797: ASN_LINE_ID,
798: PO_LINE_LOCATION_ID,

Line 1302: from POS_ASN_SHOP_CART_DETAILS

1298: end if;
1299:
1300: select decode(count(1), 0, 'Y', 'N')
1301: into l_empty_cart
1302: from POS_ASN_SHOP_CART_DETAILS
1303: where session_id = l_session_id;
1304:
1305: ak_query_pkg.exec_query(p_parent_region_appl_id=>178,
1306: p_parent_region_code=>'POS_ASN_RESULT_R',

Line 1360: from pos_asn_shop_cart_details

1356: l_shipment_id := to_number(get_result_value(l_result_index, 1));
1357:
1358: select count(1)
1359: into l_in_cart
1360: from pos_asn_shop_cart_details
1361: where session_id = l_session_id
1362: and po_line_location_id = l_shipment_id;
1363:
1364: if l_in_cart = 0 then