APPS.POS_ASN dependencies on POS_ASN_SHOP_CART_HEADERS

Line 1119: from pos_asn_shop_cart_headers

1115: CURRENCY_CONVERSION_TYPE ,
1116: CURRENCY_CONVERSION_RATE ,
1117: CURRENCY_CONVERSION_DATE ,
1118: 'Y'
1119: from pos_asn_shop_cart_headers
1120: where session_id = l_session_id;
1121:
1122: END create_rcv_header;
1123:

Line 1375: delete from pos_asn_shop_cart_headers where session_id = l_session_id;

1371: call_wip_api;
1372:
1373: buyer_notify;
1374:
1375: delete from pos_asn_shop_cart_headers where session_id = l_session_id;
1376: delete from pos_asn_shop_cart_details where session_id = l_session_id;
1377:
1378: -- The pre-processor has already created the header record, also we do not want the
1379: -- pre-processor to be run again, so delete the header in the interface. If there is

Line 1472: delete from pos_asn_shop_cart_headers where session_id = l_session_id;

1468: from pos_asn_shop_cart_details
1469: where session_id = l_session_id;
1470:
1471: IF d_count = 0 THEN
1472: delete from pos_asn_shop_cart_headers where session_id = l_session_id;
1473: END IF;
1474:
1475: END IF;
1476:

Line 1609: update pos_asn_shop_cart_headers set

1605: header_error := true;
1606: receipt_date_error := true;
1607: end;
1608:
1609: update pos_asn_shop_cart_headers set
1610: asn_type = 'NEW',
1611: shipment_num = pos_asn_shipment_num,
1612: bill_of_lading = pos_bill_of_lading,
1613: waybill_airbill_num = pos_waybill_airbill_num,