740: WHERE ORGANIZATION_ID = p_org_id;
741:
742: CURSOR l_shipping_params ( p_org_id IN NUMBER ) IS
743: SELECT COUNT(organization_id)
744: FROM wsh_shipping_parameters
745: WHERE ORGANIZATION_ID = p_org_id;
746:
747: CURSOR l_planning_params ( p_org_id IN NUMBER ) IS
748: SELECT COUNT(organization_id)
858:
859: /*-----------------------------------
860: ---- Shipping Parameters -------
861: -----------------------------------*/
862: Init_Vars('WSH_SHIPPING_PARAMETERS');
863: Open l_shipping_params ( g_organization_id );
864: Fetch l_shipping_params Into l_new_org_count;
865: Close l_shipping_params;
866: