APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on OE_ORDER_SOURCES

Line 5371: FROM OE_ORDER_SOURCES

5367:
5368:
5369: CURSOR c_get_source_id( p_client_code IN VARCHAR2) IS
5370: SELECT order_source_id
5371: FROM OE_ORDER_SOURCES
5372: WHERE name = p_client_code;
5373: --
5374: l_header_id NUMBER;
5375: l_debug_on BOOLEAN;

Line 5430: -- LSP PROJECT: Populate order_source_id from oe_order_sources

5426: x_header_rec.transactional_curr_code := p_om_header_rec.currency_code;
5427:
5428: x_header_rec.sold_from_org_id := p_om_header_rec.org_id;
5429: --
5430: -- LSP PROJECT: Populate order_source_id from oe_order_sources
5431: IF ( p_del_interface_rec.client_code IS NOT NULL ) THEN
5432: --{
5433: OPEN c_get_source_id(p_del_interface_rec.client_code);
5434: FETCH c_get_source_id INTO x_header_rec.order_source_id;