378: x_valid := TRUE;
379:
380: SELECT nvl(count(freight_code),0)
381: INTO l_dummy
382: FROM org_freight
383: WHERE organization_id = p_inventory_org_id
384: AND nvl(disable_date, sysdate +1 ) > sysdate
385: AND freight_code = p_ship_via_lookup_code;
386:
2324: PROCEDURE Check_Site_Ship_Via(p_ship_via_lookup_code IN VARCHAR2,
2325: p_org_id IN NUMBER,
2326: x_valid OUT NOCOPY BOOLEAN
2327: ) IS
2328: l_dummy org_freight.freight_code%TYPE;
2329:
2330: BEGIN
2331: x_valid := TRUE;
2332:
2331: x_valid := TRUE;
2332:
2333: SELECT FRT.freight_code
2334: INTO l_dummy
2335: FROM org_freight FRT, financials_system_params_all FIN
2336: WHERE FRT.organization_id = FIN.inventory_organization_id
2337: AND FIN.org_id = p_org_id
2338: AND nvl(FRT.disable_date, sysdate +1 ) > sysdate
2339: AND FRT.freight_code = p_ship_via_lookup_code;